June 19, 2013

Post: MySQL 5.5 and MySQL 5.6 default variable values differences

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 …

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

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

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

… 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…

Post: Connecting orphaned .ibd files

in the log: InnoDB: Error: tablespace id is 10 in the data dictionary InnoDB: but in fileTYPE: 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…

Post: How Percona diagnoses MySQL server stalls

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 …

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

… 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…

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

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

Post: Make your file system error resilient

…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 …

Post: Replication checksums in MySQL 5.6

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

Post: Is there room for more MySQL IO Optimization?

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