June 19, 2013

Post: MySQL 5.5 and MySQL 5.6 default variable values differences

February 21, 2013 By 8 Comments

…data/dpe0 | /mnt/data/sandboxes/msb_5_6_10/data/dpe0 | | TABLE_DEFINITION_CACHE | 400 | 1400 | | PORT | 5530 | 5610 | | QUERY_CACHE_TYPE…the component of purging fine tuning in MySQL 5.6 innodb_file_per_table is now ON…have been running innodb_file_per_table=1 for most of workloads for years now. The …

Filed Under: Insight for DBAs, MySQL Tagged With: , , ,

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

…data, the first thing we notice is that there are a lot of “new” InnoDB tablespace files in our database directory: -rw-rw—-. 1 mysql mysql 8632 Feb 20 15:54 dir_test_innodb.frm -rw-rw—-. 1 mysql mysql…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: How to Monitor MySQL with Percona's Nagios Plugins

February 22, 2012 By 11 Comments

… a pretty extensive list of suggestions for what to monitor in MySQL. Those are only suggestions; any…types of common problems, too. Missing PID file. A variety of problems can delete MySQL‘s PID file,… instances of MySQL on the same files in the data directory, and refusing to shut down MySQL so that…

Filed Under: Insight for DBAs, MySQL

Post: Connecting orphaned .ibd files

May 13, 2011 By 19 Comments

…in the log: InnoDB: Error: tablespace id is 10 in the data dictionary InnoDB: but in file…TYPE: 0 SPACE: 15 PAGE_NO: 4 2 rows in set (0.00 sec) In…/* in < MySQL-4.0.14 space id the page belongs to (== 0) but in later …: 12 is already used in InnoDB dictionary for table test/t2 In this case you need…

Filed Under: MySQL

Post: How Percona diagnoses MySQL server stalls

March 3, 2011 By 6 Comments

…types of data, including different angles on the same data. No single tool, no matter how powerful, is an answer for every problem. For… Return key and start browsing the files. The tool is keystroke-driven, Vim-…many things that can cause a stall in MySQL, and they usually begin microscopically and …

Filed Under: Insight for DBAs, MySQL

Post: High availability for MySQL on Amazon EC2 – Part 4 - The instance restart script

August 19, 2010 By 6 Comments

… on the /etc/ha.d/ha.cf file and then restart the heartbeat service. In order for this to work properly, we just… $PK -C $CERT $AMI_HA_MYSQL -n 1 -g $HA_SECURITY_GROUP -f $USER_DATA_SCRIPT -t $INSTANCE_TYPE -z $INSTANCE_ZONE -k… $PK -C $CERT $AMI_HA_MYSQL -n 1 -g $HA_SECURITY_GROUP -f $USER_DATA_SCRIPT -t $INSTANCE_TYPE -z $INSTANCE_ZONE -k…

Filed Under: Insight for DBAs, MySQL Tagged With:

Post: MySQL opening .frm even when table is in table definition cache

November 21, 2011 By 8 Comments

…type(). In MySQL 5.1, for some reason yet unknown to humans, it lives in sql/sql_view.cc as mysql_frm_type…for MySQL and understanding the relationship between the range of numbers for dynamic assignment and what this means for on-disk compatibility of data…

Filed Under: MySQL

Post: Make your file system error resilient

August 24, 2011 By 8 Comments

…state: clean Errors behavior: Continue Filesystem OS type: Linux Inode count: 226918400 Block count: …minor error in filesystem data structures which may be affects one file will take out whole file system… probably not needed for partition you store MySQL data on, as chances are MySQL server is only …

Filed Under: Hardware and Storage, Insight for DBAs, MySQL

Post: Replication checksums in MySQL 5.6

February 15, 2013 By 3 Comments

… writing checksums for binary log events: master [localhost…file (as editing such a file …data_len: 103, event_type: 2 ERROR: Could not read entry at offset 283: Error in…mysql-bin.000001′ at 2896.’ Conclusion You should not assume that replication checksums in MySQL 5.6 will ensure data integrity in…

Filed Under: MySQL Tagged With: , , ,

Post: Is there room for more MySQL IO Optimization?

January 3, 2013 By 11 Comments

…data_reads | 38277 | | Innodb_data_reads | 25895 | | Innodb_data_reads | 31363 | | Innodb_data_reads | 170816 | | Innodb_data_reads | 207432 | | Innodb_data_reads | 156896 | | Innodb_data…in MySQL IO as I think we should be getting very close numbers for buffered and unbuffered IO for…

Filed Under: Insight for DBAs, MySQL Tagged With: , ,
« Older Posts
Newer Posts »