I’m going to deliver MySQL Training next week (May 21-24) in London. This is … some places left if you want to sign up. You will also get a signed copy of High Performance MySQL 3rd edition…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 9, 2012 By 28 Comments
… this statement about replication? I’ve observed things differently in MySQL 5.5 (vanilla version). “The big LOAD DATA INFILE clogs… session’s binary log in general. But if it’s left on, the replication logic only replicates that “command” across the…
Post: How to diagnose errors in the MySQL error log
March 26, 2012 By 4 Comments
… questions about how to understand the nature of errors in MySQL‘s error log. Now, there is a lot of complexity… all of that mess is this bit: (Errcode: 28). Now, MySQL includes a little perror utility to translate this into something… code 28: No space left on device That’s the key to understanding what really happened. MySQL created a temporary table, using…
Comment: Finding your MySQL High-Availability solution – Replication
April 11, 2012 By 6 Comments
… as an DBA where my company had 15-20GB of mysql database, we need performance to increase 500%. currently we are… free mysql version thats comes under centos linux, we are had enough resource left, RAM, CPU in server. My question is: Does mysql…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 37 Comments
… MYSQL, upgrade MySQL, 10x start/stop MySQL, upgrade MySQL, downgrade MySQL, upgrade MySQL, install a security fix for something, 20x start/stop MySQL, upgrade MySQL, … . Restarting and changing MySQL… uninstalling anything else. Imagine that someone left system in such shape, you prepared for downtime, stopped MySQL and… error – text editor has…
Post: MySQL Configuration Wizard Updated
January 26, 2012 By 5 Comments
… sanity/safety options to prevent common problems MySQL users run into because of too-permissive MySQL behaviors. These are the kinds of… that Drizzle fixes — and should be fixed by default in MySQL — but never will be because they might break applications that… — they’re things like an integrated feedback form at the left of the page and so on. What’s next? Well…
Post: MySQL opening .frm even when table is in table definition cache
November 21, 2011 By 8 Comments
… ignore the upper limit on number of storage engines for MySQL and understanding the relationship between the range of numbers for… this means for on-disk compatibility of data directories is left as an exercise for the reader. This code is called… InnoDB itself and in the table_definition_cache). Further reading: MySQL Forge Internals document on the FRM file format Stewart’s…
Post: Friends of Percona Get 20% Off at the MySQL Conference!
February 24, 2011 By 5 Comments
…% off of registration at the MySQL conference in April: mys11pkb. If you click the image to the left, or this special link… and Fixing MySQL Performance Problems (Monday Tutorial) Percona Server: secret features MySQL and SSD: Usage Patterns Achieving PCI Compliance with MySQL The Aspersa… Performance Optimization (Monday Tutorial) Using MySQL 5.5 Performance Schema Performance Best Practices for MySQL NoSQL with MySQL Using Sphinx Beyond Full Text…
Post: Three ways that the poor man's profiler can hurt MySQL
December 2, 2011 By 19 Comments
… profiler has become a key tool in helping us analyze MySQL when customers are having trouble. We have our own implementation… I’ve heard reports from others. The server can be left in an unstable state. Sometimes when GDB detaches, the process… they can be. Of course, I’m really waiting for MySQL 5.6 and the improved Performance Schema that will be…
Post: Should MySQL update the default innodb_log_file_size?
November 21, 2011 By 37 Comments
Now that InnoDB is the default storage engine in MySQL, is it time to update the default configuration for the … settings that simply can’t be left at their historical defaults for a production installation. MySQL 5.5 increased the default buffer…
