The following warnings occurred:
Warning [2] Undefined array key "lockoutexpiry" - Line: 94 - File: C:\sites\kwikcontent\supportforum\global.php PHP 8.1.28 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\global.php 94 errorHandler->error
C:\sites\kwikcontent\supportforum\printthread.php 16 require_once
Warning [2] Undefined array key "lockoutexpiry" - Line: 573 - File: C:\sites\kwikcontent\supportforum\global.php PHP 8.1.28 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\global.php 573 errorHandler->error
C:\sites\kwikcontent\supportforum\printthread.php 16 require_once
Warning [2] Undefined variable $can_access_moderationqueue - Line: 752 - File: C:\sites\kwikcontent\supportforum\global.php PHP 8.1.28 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\global.php 752 errorHandler->error
C:\sites\kwikcontent\supportforum\printthread.php 16 require_once
Warning [2] Undefined array key "avatartype" - Line: 892 - File: C:\sites\kwikcontent\supportforum\global.php PHP 8.1.28 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\global.php 892 errorHandler->error
C:\sites\kwikcontent\supportforum\printthread.php 16 require_once
Warning [2] Undefined array key "avatartype" - Line: 892 - File: C:\sites\kwikcontent\supportforum\global.php PHP 8.1.28 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\global.php 892 errorHandler->error
C:\sites\kwikcontent\supportforum\printthread.php 16 require_once
Warning [2] Undefined variable $unreadreports - Line: 25 - File: C:\sites\kwikcontent\supportforum\global.php(959) : eval()'d code PHP 8.1.28 (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\printthread.php 16 require_once
Warning [2] Undefined array key "style" - Line: 1024 - File: C:\sites\kwikcontent\supportforum\global.php PHP 8.1.28 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\global.php 1024 errorHandler->error
C:\sites\kwikcontent\supportforum\printthread.php 16 require_once
Warning [2] Undefined property: MyLanguage::$lang_select_default - Line: 5308 - File: C:\sites\kwikcontent\supportforum\inc\functions.php PHP 8.1.28 (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\printthread.php 16 require_once
Warning [2] Undefined array key "showimages" - Line: 160 - File: C:\sites\kwikcontent\supportforum\printthread.php PHP 8.1.28 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: C:\sites\kwikcontent\supportforum\printthread.php PHP 8.1.28 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\printthread.php 165 errorHandler->error
Warning [2] Undefined array key "showimages" - Line: 160 - File: C:\sites\kwikcontent\supportforum\printthread.php PHP 8.1.28 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: C:\sites\kwikcontent\supportforum\printthread.php PHP 8.1.28 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\printthread.php 165 errorHandler->error
Warning [2] Undefined array key "showimages" - Line: 160 - File: C:\sites\kwikcontent\supportforum\printthread.php PHP 8.1.28 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: C:\sites\kwikcontent\supportforum\printthread.php PHP 8.1.28 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\printthread.php 165 errorHandler->error
Warning [2] Undefined array key "showimages" - Line: 160 - File: C:\sites\kwikcontent\supportforum\printthread.php PHP 8.1.28 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: C:\sites\kwikcontent\supportforum\printthread.php PHP 8.1.28 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\printthread.php 165 errorHandler->error
Warning [2] Undefined array key "showimages" - Line: 160 - File: C:\sites\kwikcontent\supportforum\printthread.php PHP 8.1.28 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: C:\sites\kwikcontent\supportforum\printthread.php PHP 8.1.28 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\printthread.php 165 errorHandler->error
Warning [2] Undefined array key "showimages" - Line: 160 - File: C:\sites\kwikcontent\supportforum\printthread.php PHP 8.1.28 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: C:\sites\kwikcontent\supportforum\printthread.php PHP 8.1.28 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\printthread.php 165 errorHandler->error
Warning [2] Undefined array key "showimages" - Line: 160 - File: C:\sites\kwikcontent\supportforum\printthread.php PHP 8.1.28 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: C:\sites\kwikcontent\supportforum\printthread.php PHP 8.1.28 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\printthread.php 165 errorHandler->error
Warning [2] Undefined array key "showimages" - Line: 160 - File: C:\sites\kwikcontent\supportforum\printthread.php PHP 8.1.28 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: C:\sites\kwikcontent\supportforum\printthread.php PHP 8.1.28 (WINNT)
File Line Function
C:\sites\kwikcontent\supportforum\printthread.php 165 errorHandler->error



Kwikcontent Support Forum
heavy mysql load? - Printable Version

+- Kwikcontent Support Forum (http://kwikcontent.com/supportforum)
+-- Forum: Kwikcontent (http://kwikcontent.com/supportforum/forumdisplay.php?fid=3)
+--- Forum: System Support (http://kwikcontent.com/supportforum/forumdisplay.php?fid=5)
+--- Thread: heavy mysql load? (/showthread.php?tid=35)



heavy mysql load? - findout - 02-03-2008

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


- Kwikcontent - 02-04-2008

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.


- findout - 02-04-2008

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


- findout - 02-05-2008

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


- Kwikcontent - 02-06-2008

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?


- findout - 02-07-2008

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


- Kwikcontent - 02-07-2008

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.


- tradedemon - 02-08-2008

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...