… can consider it truly production-ready. I suppose I should state an obvious disclaimer here in that the aforementioned statements reflect… in a MySQL Cluster installation are going to be talking to the same set of data nodes on the back end, but…: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under strace, I…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
… snapshot of the transaction states to determine which transactions are seen in the view later. To this end, InnoDB scans trx_list… to the following kinds of transactions: MySQL transactions started with START TRANSACTION READ ONLY MySQL transactions created by a non-locking SELECT… perfect case for read-only optimization in MySQL 5.6 and as you can see MySQL 5.6 shines in this benchmark…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication…not safe to retry after the database state changes. retry deadlocks Now we start to… to do? Retrying automatically, or giving your end user a chance to retry manually are …
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
…, you need to interleave the allocation of memory for the MySQL process using the numactl utility, drop the file cache and… pretty bad for a cluster and we often ended up is strange, unexpected states. What was I missing? In order to figure… S3. Why? The push to S3 was especially puzzling since MySQL was not involved. The server was running with nearly 7GB…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… Locking behavior prior to MySQL 5.5.3 Metadata Locking behavior prior to MySQL 5.5.3 Prior to MySQL 5.5.3 a statement that opened a table only held meta data locks till the end of the… spent nearly all its time waiting in the “Opening tables” state. Now this behavior with respect to ALTER making the table…
Post: New Keynote Speakers and Sponsors and Applications Open for DotOrg Pavilion for Percona Live MySQL Conference and Expo
January 22, 2013 By Leave a Comment
… MySQL Conference and Expo keynote speakers: Matt Aslett of 451 Research will present the keynote “MySQL, YourSQL, NoSQL, NewSQL – the State of the MySQL… Pricing Ends January 22 Super Saver Prices for the Percona Live MySQL Conference and Expo are available now. Super Saver rates end today…
Post: How to convert MySQL's SHOW PROFILES into a real profile
February 20, 2012 By 12 Comments
…to demonstrate: mysql> SET profiling=1; mysql> pager cat > /dev/null mysql> SELECT …@query_id GROUP BY STATE ORDER BY Total_R DESC; +———————-+———-+——-+——-+————–+ | STATE | Total_R | Pct_… | 0.000002 | 0.00 | 2 | 0.0000010000 | | end | 0.000002 | 0.00 | 1 | 0….
Post: Initial Keynote Speakers for the Percona Live MySQL Conference & the MySQL Community Awards
January 18, 2013 By Leave a Comment
… speak on the state of the MySQL ecosystem in his welcome address to Percona Live MySQL Conference attendees. MySQL Community Awards The MySQL Community Awards…registration discounts for the Percona Live MySQL Conference & Expo by registering now. Super Saver pricing ends next week. I look forward to…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
…. Now, Valgrind does not need much introduction, especially to the MySQL server developers. The Valgrind Memcheck tool, which is synonymous with… counter values slightly smaller than they should be in the end. ==9090== Possible data race during write of size 8 at…_schema_table_state) (sql_show.cc:6238) ==9090== by 0x6A5E0C: JOIN::exec() (sql_select.cc:1863) ==9090== by 0x6A7D72: mysql_select(THD…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 38 Comments
… MySQL packages upgraded from 5.1 to 5.5. The former were not fully uninstalled, the latter were in half-configured state. Obviously binutils has nothing to do with MySQL, but it would not install anyway…, but this can also be the case for any high-end/enterprise class equipment. Hardware vendors may release Linux drivers on…
