Optimize your Database
If you like this post, please subscribe to our RSS feed to read our new posts every day.
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 ...
Visitors who read this post, also read:
Related posts from the past
- Corrupted MySql Database or recovering from a backup mess in Mysql
- Uninstall - Is There Such A Thing?
- WordPress Backup Week July 23-30
- AlumniLink - Alumni Text Database
- PHPBB is a pain
- WordPress Database Backup
- 10 Optimization Tips
- SpamKarma and WP Performance
- 2.3 to 2.5 Database Changes
- Install WordPress Locally - Part 2 Of 2
Comments RSS
Obviously Powered 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.
[Reply]
Dougal Campbell (27 comments.) — 04/6/2005 @ 1:38 pm[...] nema - PTGate ::
Weblog Tools Collection » Optimize your Database
http://weblogtoolscollection.c.....r-database Optimização de bases de dados MySQL
This en [...]
links@joaon.org! » Blog Archive » Weblog Tools Collection » Optimize your Database — 04/6/2005 @ 1:53 pm[...] 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. [...]
a Voice in the Wilderness » WordPress Database Spiffing — 04/6/2005 @ 7:56 pm[...] April 6th, 2005 Optimize Your Database Weblog Tools Collection has a tip for optimizing your WordPress data [...]
Optimize Your Database by Blogging Pro — 04/6/2005 @ 8:00 pmMark, how often do you optimize your database? Also, what tool are you using to get the above graph?
[Reply]
John (2 comments.) — 04/6/2005 @ 8:05 pmI have way too many and I am in the databases enough that I really cannot say with confidence. The reason for this fix was a full text index created for a plugin that I had mentioned previously (don’t want to bring it up again, not really consequential). However, knowing mysql, every couple of years is a good time table for the casual blogger. Databases such as yours will need much more frequent maintenance.
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.
[Reply]
Mark (118 comments.) — 04/6/2005 @ 8:17 pmDougal, im still in the 3 point releases and have not upgraded.
[Reply]
Mark (118 comments.) — 04/6/2005 @ 8:19 pmrrdtool, eh? Plan on releasing it?
[Reply]
Aaron (14 comments.) — 04/6/2005 @ 10:33 pm[...] zed my tables!
Taking the suggestion at Weblog Tools Collection, I optimized all 120 some tables, so perform [...]
Optimized my tables! - Elliott Back — 04/6/2005 @ 11:16 pm[...] klog” — Zootropo temprano por la mañana
¿Queda alguien que no sepa que cada cierto tiempo es conveniente optimizar tu base de datos?
[...]
Zootropo » Optimiza tu base de datos — 04/7/2005 @ 3:34 am[...] 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 [...]
the life of justin moore » cleaning clutter — 04/7/2005 @ 1:14 pm[...]
davidbisset.com
Optimize Your Database With PhpMyAdmin I’ve noticed minor speed improvements to large mySQL websites when [...]
davidbisset.com » Optimize Your Database With PhpMyAdmin — 04/7/2005 @ 6:41 pm[...] 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 [...]
The Boschmans Account » Blog Archive » WP Plugins to investigate : — 04/8/2005 @ 9:03 am[...] 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 [...]
Acme Technologies Zeitgeist » Optimize your Database — 04/8/2005 @ 9:27 pm[...] 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 [...]
Acme Technologies Zeitgeist » Optimize your MySQL Database — 04/8/2005 @ 9:41 pm[...] ur projects. It’s a fast-forward button for your compiler. (tags: Code Programing) Weblog Tools Collection » Optimize your Database (tags: Database) [...]
nf0’s Life » Blog Archive » links for 2005-04-07 — 04/22/2005 @ 2:20 pm[...] find phpMyAdmin. For more information: phpMyAdmin: This is the homepage for phpMyAdmin. WordPress Optimize Your Database: an interesting post describing why [...]
WebKeyDesign » Blog Archive » Optimize Your MySQL Databases — 06/20/2005 @ 11:40 am[...] 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: [...]
Guide To Optimizing WordPress Servers » Connected Internet — 12/23/2006 @ 10:42 pm[...] Sedangkan optimisasi table-table databasenya sendiri bisa menggunakan PhpMyadmin, khususnya fitur Optimize Table. Ada artikel menarik tentang ini di sini. [...]
RomiSatriaWahono.Net » Optimisasi Wordpress di Server Traffic Tinggi — 01/31/2007 @ 12:15 pmThank You so much for this - it works like a dream.
[Reply]
Blitz (1 comments.) — 02/20/2007 @ 7:51 pm[...] wordpress用久了，数æ®åº“æ¸é•¿ï¼Œè¿™æ—¶å€™è¯¥è€ƒè™‘优化一下数æ®æ®äº†ã€‚ Fix Database：安装之åŽï¼Œåœ¨åŽå°æœ‰ä¼šFix Database的按钮，会查找wordpress里é¢è¡¨å˜åœ¨çš„错误，比如没有结æŸçš„地方。用之å‰è¯·å¤‡ä»½ä½ çš„æ•°æ®åº“。 Database Tuning:作者是德国人，页é¢æ˜¯ç»è¿‡google翻译的。原页é¢åœ¨è¿™é‡Œï¼Œå¯æƒœåŽå°æ˜¯å¾·æ–‡çš„。å¯ä»¥ä¿®å¤å’Œä¼˜åŒ–æ•°æ®åº“。 wp-dbmanager：功能强大，拥有很多phpadminçš„åŠŸèƒ½ï¼Œæ¸…ç©ºè¡¨ï¼Œåˆ é™¤è¡¨ï¼Œè¿è¡ŒSQL Query ，备份和æ¢å¤æ•°æ®åº“。作者建议一个月优化一次数æ®åº“。 WP-PHPadmin：看åå—久知é“äº†ï¼Œè®©ä½ åœ¨åŽå°è¿è¡ŒPHPadmin。 这里也æ到如何在PHPadmin里é¢ä¼˜åŒ–æ•°æ®åº“。或者该考虑é‡å†™WordPress了。 [...]
狗车志 » 优化worpressçš„æ•°æ®åº“ — 03/27/2007 @ 9:48 amthanks - this worked great!
[Reply]
Matt Ellsworth (4 comments.) — 04/11/2007 @ 11:00 am[...] Optimize your database [...]
Why My Wordpress Site Is So Much Faster Than Yours by Elliott Back — 04/15/2007 @ 9:52 pm[...] Optimize your database [...]
Good List Of WordPress Optimisation Links | Connected Internet — 04/19/2007 @ 10:07 pm[...] Optimize your database [...]
Rick Retardo » Blog Archive » Good List Of WordPress Optimisation Links — 04/30/2007 @ 1:36 pm[...] 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 [...]
YuviSense: Kid in Tech » Blog Archive » Commenting Fixed — 05/25/2007 @ 12:58 pm[...] 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 [...]
STUFFLEUFAGUS » Blog Archive » YuviSense: Kid in Tech » Commenting Fixed — 05/25/2007 @ 1:05 pm[...] Optimise your MySQL database tables. [...]
HM2K.com » 10 wordpress performance optimisation tips — 05/16/2008 @ 8:41 am[...] Optimizador de tablas: un plugin que tampoco está disponible ya asique os dejo el enlace a las instrucciones para realizar una simple tarea de optimización que puede ayudar bastante en términos de carga de servidor. Puede usarse Wp-DBManager [en] como alternativa que amplia esta simple funcionalidad. [...]
Listado plugins Criterion 2008 » Criterion — 09/6/2008 @ 10:26 am