dasini.net – Diary of a MySQL expert

I regularly meet with MySQL customers and I’m still a little surprised to see critical applications running on “not really” recent versions (to put it mildly) 🙂

The good news is that obviously old versions of MySQL are sufficiently stable and powerful to run the modern business. However, even if I understand that it is sometimes appropriate to freeze all layers of an architecture, it is often a shame not to take advantage of the latest improvements from a performance, stability, security point of view and obviously for the new features that the latest GA provides :

Sometime DBAs have to deal with problematic queries and cannot tackle the problem at the source (problematic queries from ORMs, third party apps,… or source unknown…).
MySQL 5.7 provides a pre and post parse query rewrite APIs where users can write their own plug-ins.
With the post-parse query plugin, you can rewrite problematic queries without the need to make application changes, add hints, modify join order…

MySQL 5.7 is GA and has over than 150 new features. One of them is a Native JSON Data Type and JSON Functions: “Allows for efficient and flexible storage, search and manipulation of schema-less data. Enhancements include a new internal binary format, support for easy integration within SQL, and index management on the JSON Documents using generated columns”.

  Packt Publishing started a Free Learning Campaign by providing a free ebook everyday till 6th March 2015. How ? Follow this link: http://bit.ly/1DoRno5 Olivier DASINICloud Solutions Architect at Oracle MySQL Geek, author, blogger and speaker I’m an insatiable hunger of learning. —– Blog: www.dasini.net/blog/en/ Twitter: https://twitter.com/freshdaz SlideShare: www.slideshare.net/freshdaz Youtube: https://www.youtube.com/channel/UC12TulyJsJZHoCmby3Nm3WQ —– dasini.net/blog/en

I’m a big fan of the MySQL command line tool ie the default text client modestly named: mysql. I use it everyday because you can do almost everything with it (DML, DDL, DCL, administrative tasks,…).

It has many options including generate xml or html output.

$ mysql –help | grep “\–html”
-H, –html Produce HTML output.

MySQL Tech Day @Paris

We’re happy to announce you that MySQL Tech Day will take place in Paris on Oct 10, 2013 in Oracle main office. It’ll be a full day event giving you an occasion to listen directly from Oracle developers about most of the improvements made recently within MySQL 5.6 and 5.7 development.

One of my colleague asked me : « Is an ALTER TABLE with many specifications is faster than 1 ALTER TABLE by specification ? »

The answers seems quite intuitive, anyway figures are better than a long speech…

Context :

MySQL Community Server 5.5.22

InnoDB table with 8 539 238 rows.

17 columns with INT, CHAR, VARCHAR, TEXT, DATETIME, … fields