Julian Klewes

Optimize your SQL-Database

Tagged

Categorized
Dated 2 years ago






Times read: 199
Read today: 3
Read last: March 19, 2010

Optimize your SQL-Database

popup tail

It does what it says – it optimizes your sql-database (really hard!).
From time to time it makes sense to log into phpMyAdmin, click the desired database, select all tables and select “optimize” from the drop-down.

My Wordpress Database went down 4MB (from 20MB to 16MB), here are some figures after the optimization:

16 tables total
47.081 entries
MyISAM type
language: utf8_general_ci
size: 16,8 MB
overhead: 0 Bytes (was insanely high before the optimization)


People asked me to put up a donate button or something similar, so here it is: if you care to buy me a beer or Red Bull (I drink the Dutch equivalent called Spam Energy), feel free to donate, anything is appreciated!



h4x3d.com does not host any illegal content. Links/Files referred to are for educational purposes only.

Interact - Leave a comment

Engage in the conversion and leave a comment.
I would much love to hear from you. Please note however that comments are moderated by default. Advertising and rant is welcomed, yet often discarded...
See left/right for additional information













comment? jump to the form



archives | sitemap
contact | tos

Top

lorem

solarVPS.com - reliale enterprise hosting
you know the game, get in touch with me
3