03
Mar 13

Switch from MyISAM to InnoDB engine in MySQL

MySQLHello,

If, I as do, you have MyISAM tables (default storage engine until 5.5.5) and you want to switch them to InnoDB,  because you plan to update to MySQL >= 5.5.5, you will be able to switch but be careful with indexes !

Continue reading →


09
Feb 13

Knowing MySQL databases’ and tables’ size using two requests

MySQLHello,

I guess that, as I do, you appreciate to know MySQL database’ and tables size. It is possible using simple requests based on the database information_schema

Continue reading →