[…] 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 […]
[…] 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. […]
[…] wordpress用久了,数æ®åº“æ¸é•¿ï¼Œè¿™æ—¶å€™è¯¥è€ƒè™‘优化一下数æ®æ®äº†ã€‚ Fix Database:安装之åŽï¼Œåœ¨åŽå°æœ‰ä¼šFix Database的按钮,会查找wordpress里é¢è¡¨å˜åœ¨çš„错误,比如没有结æŸçš„地方。用之å‰è¯·å¤‡ä»½ä½ çš„æ•°æ®åº“。 Database Tuning:作者是德国人,页é¢æ˜¯ç»è¿‡google翻译的。原页é¢åœ¨è¿™é‡Œï¼Œå¯æƒœåŽå°æ˜¯å¾·æ–‡çš„。å¯ä»¥ä¿®å¤å’Œä¼˜åŒ–æ•°æ®åº“。 wp-dbmanager:功能强大,拥有很多phpadminçš„åŠŸèƒ½ï¼Œæ¸…ç©ºè¡¨ï¼Œåˆ é™¤è¡¨ï¼Œè¿è¡ŒSQL Query ,备份和æ¢å¤æ•°æ®åº“。作者建议一个月优化一次数æ®åº“。 WP-PHPadmin:看åå—久知é“äº†ï¼Œè®©ä½ åœ¨åŽå°è¿è¡ŒPHPadmin。 这里也æ到如何在PHPadmin里é¢ä¼˜åŒ–æ•°æ®åº“。或者该考虑é‡å†™WordPress了。 […]
[…] 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. […]
[…] 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. […]
[…] tweak here and a little tweak there but nothing really helped. Tonight I was looking again and found this and I’m like, “You’ve got to be kidding me!” It made perfect sense […]
[…] mache dies nur immer mal, wenn es mir in den Sinn kommt. Deshalb habe ich nur Gefühlswerte. Bei Weblog Tools Collection ist dazu ein wenig mehr nach zu […]
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.
Mark, how often do you optimize your database? Also, what tool are you using to get the above graph?
I 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.
Dougal, im still in the 3 point releases and have not upgraded.
rrdtool, eh? Plan on releasing it?
Thank You so much for this – it works like a dream.
thanks – this worked great!
very useful info, i am tryng to optimize my database right now =)
Thanks! I cut 2+ MB off of my database using your instructions!