… we should implement MySQL Version advisory in mk-audit tool. One obvious questions was to look at the end of life – it is often bad idea to run MySQL versions past end of life as even security bugs may not be fixed in these (though do not get paranoid, if you’re running MySQL…
Post: MySQL Releases first real Community Release
March 18, 2007 By 2 Comments
… for production servers, which is effectively rebuild of RedHat Enterprise Version. Community Version of MySQL has all chances to be as stable as… is of course if MySQL applies reasonable quality assurance to accepted code. What is about binaries ? MySQL 5.0.37 was rare exception of… End of Life ? One thing about community versions is they are expected to reach end of life faster, so you will need to upgrade to new MySQL…
Post: Looking for MySQL 4.0 Support post EOL ?
December 14, 2008 By 9 Comments
… just reminded MySQL 4.0 is reaching its end of life in about 2 weeks from now. When it becomes unsupported by MySQL via normal… to MySQL 3.23 and 4.0 Supporting MySQL 3.23 and MySQL 4.0 environment is indeed more expensive than current MySQL versions… care to remember all limitations of these versions correctly. For example remember to use set-variable in MySQL 3.23 or remembering…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… of data processing in MySQL, you’re going to end up heavily I/O bound. Listen to any of the talks at past MySQL… “I admit defeat and accept table scans as a fact of life.” Table scans can be better than the alternative, if the… approach scale well. Use The Best Technologies You Can MySQL is not the end-all and be-all. If you’re…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 37 Comments
…done thousands upgrades and downgrades in my life, the least number of problems come from RPM packages available… and do only what’s required of them – stop or start MySQL. No problems there. It’s now… can also be the case for any high-end/enterprise class equipment. Hardware vendors may release Linux…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… not too many tools out there that can make your life easy. However, there is one such tool, pt-query-digest… in the right way. But vanilla MySQL does have its limitations, it reports only a subset of stats, however if you compare… query execution plan used by MySQL. The end result might be that you end up limiting the number of results returned by the query…
Comment: Checking for a live database connection considered harmful
May 5, 2010 By 38 Comments
… see in one of the comments an example of a framework that permits configuration, which is good. And in MySQL, you are wrong; retry does not break the transaction. (It is true in versions of MySQL that reached end-of-life many years… to do in any sanely recent version of MySQL. Your point #3, that a lot of retries kills the app server, is missing…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 15 Comments
… 2339839999 1155959808 83 Linux Partition 3 does not end on cylinder boundary. The rest of the task is easy – you just have… size (logical/physical): 512B/512B Partition Table: msdos Number Start End Size Type File system Flags 1 2048s 19531775s 19529728s primary…. Now it may be interesting to see what are real life effects of misalignment, my benchmark results are in the second part.
Post: Countless storage engines
May 3, 2007 By 6 Comments
… under impression of count of storage engines were presented. In good old time when Oracle bought InnoDB, MySQL did one step – announced MySQL supports… 5.2 MySQL. PBXT Interesting engine, mainly because of way to store new records “never updates” and just write to the end of file… real situations, because theoretical ideas can be very far from life. Also nobody prohibits to add such index to other storage…
Post: Introducing new type of benchmark
February 25, 2012 By 16 Comments
…in sysbench; NewOrder transactions Per Minute in tpcc-mysql). However, like Mark Callaghan mentioned in comments, response…with no pause. That rarely happens in real life. There are no systems that are pushed to…the different part of day/week/month/year though). And what is important for an end user …
