… have no way to change. An example of this is a third-party product whose code you are unwilling or unable to… read these, there’s a full explanation in our book, High Performance MySQL 2nd Edition (it’s not in the first edition). From… a high-performance system is virtually every query.) If it’s not possible to use a patched binary, we can use MySQL Proxy…
Post: Upgrading MySQL
January 5, 2010 By 24 Comments
…many month projects. Why is that ? Performing MySQL upgrade two things should normally worry… work differently after change. For example you may get queries returning …. In case fixing code to run on different MySQL version is taking … bugs in MySQL history when issues would only happen at high load. …
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
… any more in MySQL 5.0 Baron has spotted it by incident when we were verifying some of examples for High Performance MySQL book. In the bug Heikki explains the code was probably removed in MySQL 5.0 during XA implementation though the code…
Post: How we work on High Performance MySQL Second Edition
November 12, 2007 By 12 Comments
… for authoring a book being involved in MySQL Support, MySQL Consulting, Documentation, MySQL Training while working for MySQL and now on his own. Finally… sides of things and Vadim is good with benchmarks examples and digging source code for answers. So this is exactly how we…
Post: MySQL Error Message Nonsenses
March 16, 2008 By 7 Comments
… of things. For example this may be Operating system specific error code to tell you why operation could not be performed (read error… storage engine interface Sun/MySQL spends some time to make things consistent. There should be general high level error codes which can be portable across storage engines – for example something with meaning of “Storage…
Page: Consulting for MySQL
July 31, 2006 By
… of MySQL. We’re ready to work with you on PHP code optimization, Server Side caching, load balancing and other issues. High Performance Application… ? Contact us and we can probably help. These are just examples.
Post: Rendundant Array of Inexpensive Servers
August 21, 2008 By 15 Comments
… example you may want to choose to keep single Cisco router because it has its own internal high…well. This is actually what makes your own code often the weakest link in availability. Depending on… Plus there may be system performance impact and (in particular if you use MySQL Replication for HA) the…
Post: Checking for a live database connection considered harmful
May 5, 2010 By 38 Comments
…in pseudo-code: function query_…Performance Overhead Checking whether the connection is active typically involves a call to the ‘ping’ or ‘statistics’ command at the MySQL… some highly …performance really starts to matter — and then it sticks out like a sore thumb. (Edit) Here’s another example…
Page: Presentations
May 3, 2006 By
… high performance for large databases. We look at performance properties of MySQL … to MySQL 5.0 Download Optimizing MySQL on Source Code Level MySQL Users …example. Focuses on Innodb but most things are relevant for any storage engine. Download MySQL/Innodb Performance: OS and Hardware MySQL…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
…architecture which was the reason for the high write performance of earlier versions. Traditional transactional … .frm file. One extreme example of this is PBXT recovery. When MySQL calls the engine “init… We went through quite a few iterations (MySQL code was also changing during the development of …
