Optimize your Database
Mark Ghosh 
Thanks for visiting! If you're new here, you may want to subscribe to our RSS feed. This blog posts regular Wordpress news, updates of themes, plugins, ideas, hacks, quick fixes and everything about blogging, especially about Wordpress. Go ahead, subscribe to our feed! You can also receive updates from this blog via email.
What a difference a simple cleanup and optimization makes! If you are using PhpMyAdmin, follow these simple steps (after safely backing up your data).
Click on the database you are working with on the left hand side frame (not the table, the database name)
On the right hand column your tables should be listed. Scroll down till you see the “Check all” link.
Click on that link, make sure all database tables are checked and then from the dropdown next to it, carefully select “Optimize table”.
This should perform an analysis, repair and an optimization of your database. Most problems will be solved with this. In rare cases you might have to rebuild indices, but thats a huge topic, too dangerous to perform without looking at individual cases and thus I will not preach it here. (My database corruption was one of those rare cases) Please backup your data before any database manipulation and I will not be resposible for any mistakes or loss of data.
PS: Another fairly certain method of fixing your database/tables with PhpMyAdmin is to export your data, delete your existing tables and then re-import. PhpMyAdmin performs certain optimization tasks on the data that are very beneficial.
(7 votes, average: 4.29 out of 5)
Loading ...
Comments RSS
Powered by 
Designed by 
So, any advice on how to go about upgrading a MySQL 3.23.47 server to a newer (4.x) version? I’ve been wanting to to that for a long time, but the last time I looked into it, I seem to recall that it looked complicated. And I’m lazy.
[...] nema - PTGate ::
Weblog Tools Collection » Optimize your Database
http://weblogtoolscollection.c.....r-database Optimização de bases de dados MySQL
This en [...]
[...] ress blog (or blogs) you may find that your mysql servers response falls off a bit Mark at Weblog Tools Collection has a handy tip to spiff up your databases. [...]
[...] April 6th, 2005 Optimize Your Database Weblog Tools Collection has a tip for optimizing your WordPress data [...]
Mark, how often do you optimize your database? Also, what tool are you using to get the above graph?
This graph is created by a tool called rrdtool that I custom scripted to record and graph various system parameters of my server. What you see there is a weekly graph of processor usage calculated from uptime results.
rrdtool, eh? Plan on releasing it?
[...] zed my tables!
Taking the suggestion at Weblog Tools Collection, I optimized all 120 some tables, so perform [...]
[...] klog” — Zootropo temprano por la mañana
¿Queda alguien que no sepa que cada cierto tiempo es conveniente optimizar tu base de datos?
[...]
[...] aning clutter Filed under: Geekspeak, Website, WordPress — @ 12:08 pm I saw this post over at WLTC and just executed the optimization on mine an [...]
[...]
davidbisset.com
Optimize Your Database With PhpMyAdmin I’ve noticed minor speed improvements to large mySQL websites when [...]
[...] 8217;ll be looking at (mostly this is a note to myself). One-Click Backup of WP Database Optimize your database Have a icon showing the local weather. Her [...]
[...] og says he saw a large decrease in MySQL activity when he went and optimized his database. Optimize your Database The easy way to do this is with phpMyAdmin [...]
[...] og says he saw a large decrease in MySQL activity when he went and optimized his database. Optimize your Database The easy way to do this is with phpMyAdmin [...]
[...] ur projects. It’s a fast-forward button for your compiler. (tags: Code Programing) Weblog Tools Collection » Optimize your Database (tags: Database) [...]
[...] find phpMyAdmin. For more information: phpMyAdmin: This is the homepage for phpMyAdmin. WordPress Optimize Your Database: an interesting post describing why [...]
[...] Like any other database, over time the MySQL database that powers your blog can get a bit rough around the edges and would benefit from a spring clean. The graph below shows the improvement WeblogToolsCollection obtained from optimising their databases: [...]
[...] Sedangkan optimisasi table-table databasenya sendiri bisa menggunakan PhpMyadmin, khususnya fitur Optimize Table. Ada artikel menarik tentang ini di sini. [...]
Thank You so much for this - it works like a dream.
[...] wordpress用久了，数æ®åº“æ¸é•¿ï¼Œè¿™æ—¶å€™è¯¥è€ƒè™‘优化一下数æ®æ®äº†ã€‚ Fix Database：安装之åŽï¼Œåœ¨åŽå°æœ‰ä¼šFix Database的按钮，会查找wordpress里é¢è¡¨å˜åœ¨çš„错误，比如没有结æŸçš„地方。用之å‰è¯·å¤‡ä»½ä½ çš„æ•°æ®åº“。 Database Tuning:作者是德国人，页é¢æ˜¯ç»è¿‡google翻译的。原页é¢åœ¨è¿™é‡Œï¼Œå¯æƒœåŽå°æ˜¯å¾·æ–‡çš„。å¯ä»¥ä¿®å¤å’Œä¼˜åŒ–æ•°æ®åº“。 wp-dbmanager：功能强大，拥有很多phpadminçš„åŠŸèƒ½ï¼Œæ¸…ç©ºè¡¨ï¼Œåˆ é™¤è¡¨ï¼Œè¿è¡ŒSQL Query ，备份和æ¢å¤æ•°æ®åº“。作者建议一个月优化一次数æ®åº“。 WP-PHPadmin：看åå—久知é“äº†ï¼Œè®©ä½ åœ¨åŽå°è¿è¡ŒPHPadmin。 这里也æ到如何在PHPadmin里é¢ä¼˜åŒ–æ•°æ®åº“。或者该考虑é‡å†™WordPress了。 [...]
thanks - this worked great!
[...] Optimize your database [...]
[...] Optimize your database [...]
[...] Optimize your database [...]
[...] the heck on earth I was getting duplicate primary key fields in the database, Rob also pointed me tothis articlee to fix it. Works like a [...]
[...] the heck on earth I was getting duplicate primary key fields in the database, Rob also pointed me tothis articlee to fix it. Works like a [...]
[...] Optimise your MySQL database tables. [...]