Optimizer Mysql?

I am using wordpress open source for my site.
But now the database is large, It run slowly and some time down site.
Who can help me?

 

are you sure it's the database causing problem ? how big it is ? 2-3 gig ? you're gonna need a database expert , but first of all do take a backup out of your database

 

What makes you think its the database causing the problem?

 

1) Install WP super cache, it will cache the pages and offload a lot of mysql process.
2) I/O may be an issue try using sas HDD.

Source: from my personnel experience. I had a big wordpress website which database always caused problem. I solved by using sas in raid -0 which hard fast read speed for my website to work effortlessly.

 

WP is not good for big database. U should to moving into new CMS Joomla or Drupal ...

 

If talk about big database, maybe it's better you mention the size of database/ Or maybe number of post that can be handled by WP with good speed. I read so many people tell about this, but there is no exactly size of database.

Thanks

 

First of all you need to tell us the database size. In some cases, cache also helps as fusion_pro suggested.

 

In adition to all the REAL solutions such as cache, make sure you clear your SQL tables' overheads..

in PHPMyAdmin, you can do this simply by selecting your database, then select all tables, and choose 'Optimise Table' from the drop-down..

If not, do it manually (you'll need to know each of your table names)

OPTIMIZE TABLE `table1` , `table2` , `table3` , `table4` etc...

Jack

 

There will be no benefit of optimizing tables if data is not being delete frequently from a table (deletions are more often than insertion). Run the SHOW TABLE STATUS query to identify if there is any need to OPTIMIZE table or not

SHOW TABLE STATUS LIKE 'table_name';

Code (markup):

There is no benefit to OPTIMIZE table if you get 0 in output against Data_free.

 

Well, sure there might be no need for some tables, but as you say, for a blog or something, it's not likely that much info is deleted, so it'd be fine to just run it manually once in a while, in which case, it's not exactly a heavy process to run..

Jack

 

Hmm... May not be true for big tables. As OPTIMIZE TABLE uses REPAIR TABLE to reclaim the unused space.

 

I'd check you sql statements. Some will run faster than others. Also use indexes as a full table search will slow down your site immensely.