4 ram slots 2 sticks,Platin Casino review.REGISTER NOW GET FREE 888 PESOS REWARDS!

J Howard
(@j-howard)

12 years, 9 months ago

Right, first things first. I have hardly any WordPress or MySQL experience.

The setup is; 1 HP Server running Ubuntu Server 11.10, hosting 1 WordPress site.

Installed physical RAM: 4GB
Swap size: 6GB

Over the past couple of days, we have experienced multiple server crashes. As a result, we now have a dedicated monitor showing HTOP. We have noticed that the server will bomb out, when all cores are being used, in addition to all of the physical RAM, and swap file. When behaving correctly, the RAM usage sits at around 1.7GB (4GB total installed.) When the server crashes, HTOP reports maxed out cores for all CPU’s,RAM and swap memory. At this point, the uptime figure freezes, and then it’s a trip to the server room to cold boot the machine. In order to simulate the crash, we tried a number of methods to max out the server again. It has come to pass, that when entering a significant of text within the live search box within our WordPress site pages (Dave’s WordPress Live Search plug-in used), the CPU, RAM and swap memory rocket upwards, before the server crashes again.

In Layman’s terms, is this a MySQL error? Are the tables being hammered, and they just can’t cope? The database size for our site is only around 40MB! Could the previous cold boots of the server have caused the tables to have become corrupted? Would repairing the tables, help?

As stated, I’ve come into this, I have no previous experience of WordPress, MySQL or administering Ubuntu Server. Can anyone help?!

Many thanks.

Viewing 3 replies - 1 through 3 (of 3 total)

s_ha_dum
(@apljdi)

12 years, 9 months ago

Are the tables being hammered, and they just can’t cope?

I don’t know anything about “Dave’s Livesearch” but yes, it sounds that way. I would definitely analyze how that plugin works– that is, look at the queries it generates. It is really easy to build a bad query, and can be very very difficult to get a good one that gets you the results you want. I know, I’ve locked up servers that way. But that may not be the case.

It is worth checking to see if your tables need to be repaired or optimized and if your MySQL server is running with default values it might be worth tuning it some.

Just guessing, but these problems interest me ??

Thread Starter J Howard
(@j-howard)

12 years, 9 months ago

Thanks very much for the reply. Nice to know that we’re on the right track. At the risk of sounding even more novice-like, how can I determine if the MySQL tables require checking? Is there an error-checking report, which will inform of the need to check/repair the table? Thanks again.

s_ha_dum
(@apljdi)

12 years, 9 months ago

If you have PhpMyAdmin: https://www.siteground.com/tutorials/phpmyadmin/phpmyadmin_operations.htm

If you have command line access: https://dev.mysql.com/doc/refman/5.0/en/check-table.html or https://dev.mysql.com/doc/refman/5.0/en/mysqlcheck.html or https://dev.mysql.com/doc/refman/5.0/en/myisamchk.html (NOTE: myisamchk has to be run with the server stopped)

Also take a look at this: https://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-installation/

You could turn on your slow query log too. You don’t want that on long term though. It in itself can be strain on the server, but it will help you spot time consuming queries.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘WordPress Live Search PlugIn – Causing Ubuntu Server To Crash?’ is closed to new replies.

WordPress Live Search PlugIn – Causing Ubuntu Server To Crash?

Topics

Topics with no replies

Non-support topics

Resolved topics

Unresolved topics

All topics