The following warnings occurred:
Warning [2] Undefined array key "lockoutexpiry" - Line: 94 - File: C:\sites\kwikcontent\supportforum\global.php PHP 8.1.27 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\global.php 94 errorHandler->error
C:\sites\kwikcontent\supportforum\showthread.php 28 require_once
Warning [2] Undefined array key "lockoutexpiry" - Line: 573 - File: C:\sites\kwikcontent\supportforum\global.php PHP 8.1.27 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\global.php 573 errorHandler->error
C:\sites\kwikcontent\supportforum\showthread.php 28 require_once
Warning [2] Undefined variable $can_access_moderationqueue - Line: 752 - File: C:\sites\kwikcontent\supportforum\global.php PHP 8.1.27 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\global.php 752 errorHandler->error
C:\sites\kwikcontent\supportforum\showthread.php 28 require_once
Warning [2] Undefined array key "avatartype" - Line: 892 - File: C:\sites\kwikcontent\supportforum\global.php PHP 8.1.27 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\global.php 892 errorHandler->error
C:\sites\kwikcontent\supportforum\showthread.php 28 require_once
Warning [2] Undefined array key "avatartype" - Line: 892 - File: C:\sites\kwikcontent\supportforum\global.php PHP 8.1.27 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\global.php 892 errorHandler->error
C:\sites\kwikcontent\supportforum\showthread.php 28 require_once
Warning [2] Undefined variable $unreadreports - Line: 25 - File: C:\sites\kwikcontent\supportforum\global.php(959) : eval()'d code PHP 8.1.27 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\global.php(959) : eval()'d code 25 errorHandler->error
C:\sites\kwikcontent\supportforum\global.php 959 eval
C:\sites\kwikcontent\supportforum\showthread.php 28 require_once
Warning [2] Undefined array key "style" - Line: 1024 - File: C:\sites\kwikcontent\supportforum\global.php PHP 8.1.27 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\global.php 1024 errorHandler->error
C:\sites\kwikcontent\supportforum\showthread.php 28 require_once
Warning [2] Undefined property: MyLanguage::$lang_select_default - Line: 5308 - File: C:\sites\kwikcontent\supportforum\inc\functions.php PHP 8.1.27 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\inc\functions.php 5308 errorHandler->error
C:\sites\kwikcontent\supportforum\global.php 1024 build_theme_select
C:\sites\kwikcontent\supportforum\showthread.php 28 require_once
Warning [2] Undefined array key "mybb" - Line: 2121 - File: C:\sites\kwikcontent\supportforum\inc\functions.php PHP 8.1.27 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\inc\functions.php 2121 errorHandler->error
C:\sites\kwikcontent\supportforum\inc\functions_indicators.php 41 my_set_array_cookie
C:\sites\kwikcontent\supportforum\showthread.php 669 mark_thread_read
Warning [2] Undefined array key "profilefield" - Line: 6 - File: C:\sites\kwikcontent\supportforum\inc\functions_post.php(484) : eval()'d code PHP 8.1.27 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\inc\functions_post.php(484) : eval()'d code 6 errorHandler->error
C:\sites\kwikcontent\supportforum\inc\functions_post.php 484 eval
C:\sites\kwikcontent\supportforum\showthread.php 1126 build_postbit
Warning [2] Undefined array key "showimages" - Line: 768 - File: C:\sites\kwikcontent\supportforum\inc\functions_post.php PHP 8.1.27 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\inc\functions_post.php 768 errorHandler->error
C:\sites\kwikcontent\supportforum\showthread.php 1126 build_postbit
Warning [2] Undefined array key "showvideos" - Line: 773 - File: C:\sites\kwikcontent\supportforum\inc\functions_post.php PHP 8.1.27 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\inc\functions_post.php 773 errorHandler->error
C:\sites\kwikcontent\supportforum\showthread.php 1126 build_postbit
Warning [2] Undefined array key "profilefield" - Line: 6 - File: C:\sites\kwikcontent\supportforum\inc\functions_post.php(484) : eval()'d code PHP 8.1.27 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\inc\functions_post.php(484) : eval()'d code 6 errorHandler->error
C:\sites\kwikcontent\supportforum\inc\functions_post.php 484 eval
C:\sites\kwikcontent\supportforum\showthread.php 1126 build_postbit
Warning [2] Undefined array key "showimages" - Line: 768 - File: C:\sites\kwikcontent\supportforum\inc\functions_post.php PHP 8.1.27 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\inc\functions_post.php 768 errorHandler->error
C:\sites\kwikcontent\supportforum\showthread.php 1126 build_postbit
Warning [2] Undefined array key "showvideos" - Line: 773 - File: C:\sites\kwikcontent\supportforum\inc\functions_post.php PHP 8.1.27 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\inc\functions_post.php 773 errorHandler->error
C:\sites\kwikcontent\supportforum\showthread.php 1126 build_postbit
Warning [2] Undefined array key "profilefield" - Line: 6 - File: C:\sites\kwikcontent\supportforum\inc\functions_post.php(484) : eval()'d code PHP 8.1.27 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\inc\functions_post.php(484) : eval()'d code 6 errorHandler->error
C:\sites\kwikcontent\supportforum\inc\functions_post.php 484 eval
C:\sites\kwikcontent\supportforum\showthread.php 1126 build_postbit
Warning [2] Undefined array key "showimages" - Line: 768 - File: C:\sites\kwikcontent\supportforum\inc\functions_post.php PHP 8.1.27 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\inc\functions_post.php 768 errorHandler->error
C:\sites\kwikcontent\supportforum\showthread.php 1126 build_postbit
Warning [2] Undefined array key "showvideos" - Line: 773 - File: C:\sites\kwikcontent\supportforum\inc\functions_post.php PHP 8.1.27 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\inc\functions_post.php 773 errorHandler->error
C:\sites\kwikcontent\supportforum\showthread.php 1126 build_postbit
Warning [2] Undefined array key "profilefield" - Line: 6 - File: C:\sites\kwikcontent\supportforum\inc\functions_post.php(484) : eval()'d code PHP 8.1.27 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\inc\functions_post.php(484) : eval()'d code 6 errorHandler->error
C:\sites\kwikcontent\supportforum\inc\functions_post.php 484 eval
C:\sites\kwikcontent\supportforum\showthread.php 1126 build_postbit
Warning [2] Undefined array key "showimages" - Line: 768 - File: C:\sites\kwikcontent\supportforum\inc\functions_post.php PHP 8.1.27 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\inc\functions_post.php 768 errorHandler->error
C:\sites\kwikcontent\supportforum\showthread.php 1126 build_postbit
Warning [2] Undefined array key "showvideos" - Line: 773 - File: C:\sites\kwikcontent\supportforum\inc\functions_post.php PHP 8.1.27 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\inc\functions_post.php 773 errorHandler->error
C:\sites\kwikcontent\supportforum\showthread.php 1126 build_postbit
Warning [2] Undefined array key "profilefield" - Line: 6 - File: C:\sites\kwikcontent\supportforum\inc\functions_post.php(484) : eval()'d code PHP 8.1.27 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\inc\functions_post.php(484) : eval()'d code 6 errorHandler->error
C:\sites\kwikcontent\supportforum\inc\functions_post.php 484 eval
C:\sites\kwikcontent\supportforum\showthread.php 1126 build_postbit
Warning [2] Undefined array key "showimages" - Line: 768 - File: C:\sites\kwikcontent\supportforum\inc\functions_post.php PHP 8.1.27 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\inc\functions_post.php 768 errorHandler->error
C:\sites\kwikcontent\supportforum\showthread.php 1126 build_postbit
Warning [2] Undefined array key "showvideos" - Line: 773 - File: C:\sites\kwikcontent\supportforum\inc\functions_post.php PHP 8.1.27 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\inc\functions_post.php 773 errorHandler->error
C:\sites\kwikcontent\supportforum\showthread.php 1126 build_postbit
Warning [2] Undefined array key "profilefield" - Line: 6 - File: C:\sites\kwikcontent\supportforum\inc\functions_post.php(484) : eval()'d code PHP 8.1.27 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\inc\functions_post.php(484) : eval()'d code 6 errorHandler->error
C:\sites\kwikcontent\supportforum\inc\functions_post.php 484 eval
C:\sites\kwikcontent\supportforum\showthread.php 1126 build_postbit
Warning [2] Undefined array key "showimages" - Line: 768 - File: C:\sites\kwikcontent\supportforum\inc\functions_post.php PHP 8.1.27 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\inc\functions_post.php 768 errorHandler->error
C:\sites\kwikcontent\supportforum\showthread.php 1126 build_postbit
Warning [2] Undefined array key "showvideos" - Line: 773 - File: C:\sites\kwikcontent\supportforum\inc\functions_post.php PHP 8.1.27 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\inc\functions_post.php 773 errorHandler->error
C:\sites\kwikcontent\supportforum\showthread.php 1126 build_postbit
Warning [2] Undefined array key "profilefield" - Line: 6 - File: C:\sites\kwikcontent\supportforum\inc\functions_post.php(484) : eval()'d code PHP 8.1.27 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\inc\functions_post.php(484) : eval()'d code 6 errorHandler->error
C:\sites\kwikcontent\supportforum\inc\functions_post.php 484 eval
C:\sites\kwikcontent\supportforum\showthread.php 1126 build_postbit
Warning [2] Undefined array key "showimages" - Line: 768 - File: C:\sites\kwikcontent\supportforum\inc\functions_post.php PHP 8.1.27 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\inc\functions_post.php 768 errorHandler->error
C:\sites\kwikcontent\supportforum\showthread.php 1126 build_postbit
Warning [2] Undefined array key "showvideos" - Line: 773 - File: C:\sites\kwikcontent\supportforum\inc\functions_post.php PHP 8.1.27 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\inc\functions_post.php 773 errorHandler->error
C:\sites\kwikcontent\supportforum\showthread.php 1126 build_postbit
Warning [2] Undefined array key "profilefield" - Line: 6 - File: C:\sites\kwikcontent\supportforum\inc\functions_post.php(484) : eval()'d code PHP 8.1.27 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\inc\functions_post.php(484) : eval()'d code 6 errorHandler->error
C:\sites\kwikcontent\supportforum\inc\functions_post.php 484 eval
C:\sites\kwikcontent\supportforum\showthread.php 1126 build_postbit
Warning [2] Undefined array key "showimages" - Line: 768 - File: C:\sites\kwikcontent\supportforum\inc\functions_post.php PHP 8.1.27 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\inc\functions_post.php 768 errorHandler->error
C:\sites\kwikcontent\supportforum\showthread.php 1126 build_postbit
Warning [2] Undefined array key "showvideos" - Line: 773 - File: C:\sites\kwikcontent\supportforum\inc\functions_post.php PHP 8.1.27 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\inc\functions_post.php 773 errorHandler->error
C:\sites\kwikcontent\supportforum\showthread.php 1126 build_postbit
Warning [2] Undefined array key "invisible" - Line: 1568 - File: C:\sites\kwikcontent\supportforum\showthread.php PHP 8.1.27 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\showthread.php 1568 errorHandler->error
Warning [2] Undefined variable $threadnotesbox - Line: 33 - File: C:\sites\kwikcontent\supportforum\showthread.php(1600) : eval()'d code PHP 8.1.27 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\showthread.php(1600) : eval()'d code 33 errorHandler->error
C:\sites\kwikcontent\supportforum\showthread.php 1600 eval
Warning [2] Undefined variable $search_thread - Line: 60 - File: C:\sites\kwikcontent\supportforum\showthread.php(1600) : eval()'d code PHP 8.1.27 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\showthread.php(1600) : eval()'d code 60 errorHandler->error
C:\sites\kwikcontent\supportforum\showthread.php 1600 eval
Warning [2] Undefined variable $addremovesubscription - Line: 82 - File: C:\sites\kwikcontent\supportforum\showthread.php(1600) : eval()'d code PHP 8.1.27 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\showthread.php(1600) : eval()'d code 82 errorHandler->error
C:\sites\kwikcontent\supportforum\showthread.php 1600 eval
Warning [2] Undefined variable $thread_deleted - Line: 104 - File: C:\sites\kwikcontent\supportforum\showthread.php(1600) : eval()'d code PHP 8.1.27 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\showthread.php(1600) : eval()'d code 104 errorHandler->error
C:\sites\kwikcontent\supportforum\showthread.php 1600 eval





Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
heavy mysql load?
#1
Hello-

I've received two notices from my webhost about using too much of the mysql dbase.

[INDENT]We suspended the domain xxxx.com because it is causing load in the server with many querying... Please remove this account from the server.[/INDENT]

Do you have a recommended heavy load mysql host?

Or do I just reduce the number of updates, like say 14 or 30 days, etc?

Thanks,

Adam
Reply
#2
That's seems very strange given it is pretty light weight. I'm not sure who you're hosting with, but my guess would be that just about anyone else would be okay.

Reducing the updates may help, but my thinking is that it is your site traffic causing the load... not the updates. You should see if your host can give you more specific details on the problem.
Reply
#3
Hello Jeff-

Thanks for the reply.

I have come to believe that the host is just a crock.

I have 3 hosts that host kwikcontent sites and this is the only one giving me a hassle about it.

I asked them if I could pay extra for the mysql usage (since "unlimited mysql databases" doesn't mean you can actually use them) and they replied that I could upgrade to a hosting package that costs 4x as much with the same "unlimited mysql databases."

So, as soon as I can, I will be changing hosts.

Thanks,

Adam
Reply
#4
Hello-

So now it's not the heavy mysql load, they are saying it's causing a heavy cpu load.

Would you recommend turning updates off? For the news updates, would that mean just putting it to "0"?

Thanks,

-Adam
Reply
#5
That's still odd. My first guess is that it's not coming from your Kwikcontent system, but I'll assume it is for now. Quick question - how many uniques/page impressions are you getting on this site daily?
Reply
#6
Hey Jeff-

Not very many actually, less than 30 a day for uniques.

I have several domains hosted with their servers and only 2 have caused problems.

I've just turned off updates on these two sites. Moving these sites can really be a chore.

Thanks,

Adam
Reply
#7
I think your host is mistaken. And I don't see how updates would cause an issue. The updates could cause a "surge" of CPU usage over the course of about a minute, but only while they are happening.

To put it in perspective. I have sites that literally see thousands of uniques daily that are handling the load with no problem whatsoever.
Reply
#8
Sorry to barge in here but i run my own suite of dedi boxes and I can tell you that the Kwikcontent mysql queries are not heavy load. Your host is talking rubbish...
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)