Mysql

One of the ways to import data into MySQL is using the LOAD DATA INFILE. It is a faster method than recovering from a dump, as it’s raw data instead of SQL sentences. The import time depends on the table engine, for example, MyISAM can be 40 times faster than Innodb. Let’s benchmark this: Preparation I’m gonna make some benchmarking using MySQL 5.1.36 (64 bits MacOS X). I’ll need a big table, so I’ll take City from the World Database and create a huge table called “city_huge”: ...

After my awful Drunken-Blogging experiment, i’m gonna try to write a real post. This Thursday, Koke and me attended the MySQL Conference at London. Talks were customer oriented, that’s great for me as I’m used to a developer vision of MySQL, and i’ll have to talk to customers in training sessions. There was some things that everyone was repeating on every talk. Replication, backup, high availability and sacalbility. I’m sure that I’ll be asked about those things while training. ...