Want to make 100 bucks? I need some Linux and MYSQL help please

KingRoyal · 1st Jul 2013, 03:23 PM

Hey guys, our website on our dedicated server is terribly slow and it's due to the wp-cron.php file for wordpress AND some sleeping quiries. I want to pay someone 100 bucks to help fix it for me. Any takers?

seasoned · 1st Jul 2013, 03:31 PM

Originally Posted by KingMighty

Hey guys, our website on our dedicated server is terribly slow and it's due to the wp-cron.php file for wordpress AND some sleeping quiries. I want to pay someone 100 bucks to help fix it for me. Any takers?

That is often caused by poorly written queries, or ones that aren't processed.

Steve

KingRoyal · 1st Jul 2013, 03:35 PM

Hi Steve, I understand what you are saying, however its all wordpress related. According to the previous information it was shown as /home/****/public_html/wp-cron.php which caused the issues.

I can see many sleeping queries as well.

| 558 | ***_*** | localhost | ***_*** | Sleep | 1463 | | |
| 580 | ***_*** | localhost | ***_*** | Sleep | 1444 | | |
| 704 | ***_*** | localhost | ***_*** | Sleep | 1350 | | |
| 871 | ***_*** | localhost | ***_*** | Sleep | 1227 | | |
| 1294 | ***_*** | localhost | ***_*** | Sleep | 286 | | |
| 1466 | ***_*** | localhost | ***_*** | Sleep | 970 | | |
| 2403 | ***_*** | localhost | ***_*** | Sleep | 482 |

We only see 2 sleeping queries, but this would coincide with the script causing the issues using up your available resources.

Right now, the RAM is stable.

root@***_*** [~]# free -m
total used free shared buffers cached
Mem: 16008 2909 13099 0 954 942
-/+ buffers/cache: 1013 14995
Swap: 1952 0 1952

Let us know if you need further information or assistance.

1st Jul 2013, 03:23 PM	#1
KingRoyal Link Building Expert War Room Member Join Date: 2012 Posts: 605 Thanks: 130 Thanked 87 Times in 70 Posts	Want to make 100 bucks? I need some Linux and MYSQL help please Share on: Hey guys, our website on our dedicated server is terribly slow and it's due to the wp-cron.php file for wordpress AND some sleeping quiries. I want to pay someone 100 bucks to help fix it for me. Any takers?

1st Jul 2013, 03:35 PM	#3
KingRoyal Link Building Expert War Room Member Join Date: 2012 Posts: 605 Thanks: 130 Thanked 87 Times in 70 Posts	Re: Want to make 100 bucks? I need some Linux and MYSQL help please Share on: Hi Steve, I understand what you are saying, however its all wordpress related. According to the previous information it was shown as /home/**/public_html/wp-cron.php which caused the issues. I can see many sleeping queries as well. \| 558 \| _ \| localhost \| _ \| Sleep \| 1463 \| \| \| \| 580 \| _ \| localhost \| _ \| Sleep \| 1444 \| \| \| \| 704 \| _ \| localhost \| _ \| Sleep \| 1350 \| \| \| \| 871 \| _ \| localhost \| _ \| Sleep \| 1227 \| \| \| \| 1294 \| _ \| localhost \| _ \| Sleep \| 286 \| \| \| \| 1466 \| _ \| localhost \| _ \| Sleep \| 970 \| \| \| \| 2403 \| _ \| localhost \| _ \| Sleep \| 482 \| We only see 2 sleeping queries, but this would coincide with the script causing the issues using up your available resources. Right now, the RAM is stable. root@_** [~]# free -m total used free shared buffers cached Mem: 16008 2909 13099 0 954 942 -/+ buffers/cache: 1013 14995 Swap: 1952 0 1952 Let us know if you need further information or assistance.