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: Joining many tables in MySQL - optimizer_search_depth
April 23, 2012 By 6 Comments
… ago, when I was just hired at MySQL. The assumptions about what are typical MySQL may have been true then in 2004…, that’s why the choice of higher search depth was left to the user who knows what they are doing. We… the potential pitfalls with the change to plan pruning in MySQL 5.6. Ideally, the server should analyze the query and…
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: Eventual Consistency in MySQL
November 18, 2011 By 8 Comments
…), (333,444); mysql> INSERT INTO Bar (ID,X,Y) VALUES (21,333,444); mysql> SET FOREIGN_KEY_CHECKS=0; mysql> INSERT INTO Bar… AN ORPHAN mysql> SELECT Bar_ibfk_1.ID AS `test.Bar.ID` FROM test.Bar AS Bar_ibfk_1 LEFT OUTER JOIN… them at any time: $ cat generate_foreign_key_checks.sql | mysql -N | mysql -E *************************** 1. row *************************** test.Bar.ID: 42 DIY RI…
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 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: MySQL Consulting - Being on your own
February 20, 2007 By 7 Comments
… a year have passed since me and Vadim have left MySQL to do MySQL Consulting on our own. Bunch of people have been… market is now great for MySQL Consulting. The number of MySQL users is growing rapidly thanks for MySQL Marketing and Sales departments and… – it is very hard to find people with good enough MySQL knowledge. MySQL themselves are searching for them, Google is searching for…
