Julian Klewes

Optimize your SQL-Database

This article was posted in SeptemberJanuary 18, 2008







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)

If you enjoyed this post, make sure you subscribe to my RSS feed!

share me please

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
advertise
advertise

Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat.

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