11
Nov 15

Time Series database : Simple installation and data integration with InfluxDB

Not translated yet …


19
Mar 14

Delete multiple database tables depending on conditions

Hello,

MySQLA short article today to give you a tips on how to delete table from multiple databases, based on criteria. Sometimes you have to delete lot of tables but you can’t drop the database(s). Here is the method to select all the tables you want to delete and delete them !

Continue reading →


23
Feb 14

Calculate percentile XX of data with MySQL

Hello,

MySQLToday we’re coming back to MySQL with a post talking about how to calculate percentile value using MySQL. We gonna see two methods that use the same logic but one uses two requests and the other one in only one request.

I want to warn you about performance issues that you could face regarding to the number of rows on which you want to calculate it.

If you don’t really know what is behind the percentile, go first check this link.

Continue reading →


12
Mar 13

Log all SQL requests

Hello,

MySQLIf for any reason you need to be able to save all MySQL requests executed on your MysQL server for a short time (adviced), here is a simple and fast way to log them into a single table and in a file.

Continue reading →


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 →