slow and sluggish

[dbrooke]

My Specs:
CPANEL, VB5 Connect (5.2.3)


Hello, my version of VB5 is pretty slow on things like making a new post and logging in (which I think translates into database interaction?)... is there any standard operating procedures as far as troubleshooting this kind of thing?

Thanks!

Donovan

[dbrooke]

Just added a path and filename for error log and handling for "Log Database Errors to a File"... in the meantime.

Here are some errors that I am seeing quite often for PHP.. not sure if they are a problem (error_log):

PHP Warning:  Invalid argument supplied for foreach() in /home/cessnaowner/subdomains/forums/core/vb/library/node.php on line 2481

and

PHP Fatal error:  Uncaught exception 'vB5_Exception' with message 'Incorrect HTTP Method. Please use a POST request.' in /home/cessnaowner/subdomains/forums/includes/vb5/frontend/applicationlight.php:217
Stack trace:
#0 /home/cessnaowner/subdomains/forums/index.php(51): vB5_Frontend_ApplicationLight->execute()
#1 {main}
  thrown in /home/cessnaowner/subdomains/forums/includes/vb5/frontend/applicationlight.php on line 217

[Wayne Luke]

cPanel isn't really a spec... What version of PHP and MySQL are you using? What is slow? How many seconds does it take to perform these operations?

For the errors, the warning isn't a problem. Just a warning. Annoying but not a problem.

What was being done when the Fatal Error occurred? Do you have any third-party addons installed? They may need to be updated to use POST instead of GET. Should have resulted in a white screen on your site.

[saiff]

Warning: Invalid argument supplied for foreach() in .../vb/library/node.php on line 2481 

I have the same problem . but it appears only to registered user group

[Mark.B]

Warning: Invalid argument supplied for foreach() in .../vb/library/node.php on line 2481 

I have the same problem . but it appears only to registered user group

Please start your own thread, and in it please provide the information requested here:

http://www.vbulletin.com/forum/node/4005558

[dbrooke]

Hi Wayne:
Thanks for responding.

CPANEL: CENTOS 6.7 i686, WHM v.54
Apache: 2.4.23
MySQL: 5.5.48-cll
PHP: 5.6.24 (cli)

No third-party plugin's, but I did look at my php.ini.. I have these directives set:

Environment:
REQUEST_METHOD = GET

PHP Variables:
_SERVER["REQUEST_METHOD"] = GET
_ENV["REQUEST_METHOD"] = GET


Should all those be set to POST to get rid of that "Uncaught exception" Fatal Error?

I'll send a message to the Moderator to see exactly how long and what the delays are exactly.. but I believe they are when creating Topics and sending replies mostly.. literally 30 seconds sometimes. I'll get more info on that.

Thanks!
Donovan

[Wayne Luke]

You shouldn't have to change any PHP variables. Both GET and POST should be available to the server. We shouldn't call GET. That is why I need to know what was being attempted so we can fix the code.

When you look at your database in phpMyAdmin, does it say MYISAM or INNODB for the tables?

[dbrooke]

Innodb.

[Wayne Luke]

What are the sizes of your cache and cacheevents tables? If you empty them in the AdminCP under Maintenance, does the system speed up?

[dbrooke]

Hi Wayne,
Not sure where cache is located in order to decipher size... /core/cache shows very little in there. I went ahead and reset the cache in the admincp.

The reports I'm getting from the moderator so far are 34 seconds to post.

Sorry if my responses are delayed.. in the middle of another website build.. but I will always follow up.. need to get that forum running good!

Thanks,
Donovan

[dbrooke]

I did some quick tests on posting *topics*... they do indeed take 34 seconds to complete.

FYI, I received my email notice right away however... it looks like it makes the post right away... I'm guessing there is a 30 second timeout on some kind of function... which is why it is taking 30 seconds to complete???

Any ideas?

Donovan

[Mark.B]

cache and cacheevent are tables in your database...we need to know the size of these.

[dbrooke]

Ahh... this is the info box for the cache table: Information

5.5	MiB
16	KiB
5.5	MiB

Compact

latin1_swedish_ci

Sep 20, 2016 at 05:40 AM

[dbrooke]

One more note.. I have verified also that by opening two different browsers, the posts DO actually post instantly.. it's just the completion part of the browser that does the posting that takes 34 seconds.

Sincerely,
Donovan

[Wayne Luke]

I did some quick tests on posting *topics*... they do indeed take 34 seconds to complete.

FYI, I received my email notice right away however... it looks like it makes the post right away... I'm guessing there is a 30 second timeout on some kind of function... which is why it is taking 30 seconds to complete???

Any ideas?

Donovan

When you look at the network traffic dialog in your browser's developer tools and the console output in the same tools, where is the delay?

Same thing for your server access and error logs anything suspicious in them? What about your MySQL Slow Query log?