… that are faster using MyISAM, Q4.3 examines very little data. It seems that InnoDB performs better when a larger number…_DIRECT key_buffer_size=10G # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 innodb_stats_persistent innodb_stats_auto_update=off [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var…
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
… write the full status output into innodb_status.
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…data_file_pathblogpercona.commanual Innodb_data_fsyncsblogpercona.commanual innodb_data_home_dirblogpercona.commanual Innodb_data_pending_fsyncsblogpercona.commanual Innodb_data_pending_readsblogpercona.commanual Innodb_data…storage_engineblogpercona.commanual symbolic_linksblogpercona.commanual sync…
Post: Percona XtraBackup 1.6
April 12, 2011 By 15 Comments
… #606981 – Streaming InnoDB files with tar4ibd could lead to filesystem hangs when InnoDB was configured to access data files with the O_DIRECT… – The script innobackupex-1.5.1 was renamed to innobackupex. Symbolic link innobackupex-1.5.1 was created for backupward compatibility. (Vadim…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…-073b6e68 shard-query-demo-data-flatfiles 30GB ext3 EBS This is an ext3 volume which contains the flat files for the demos…`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT=’Data from BTS ontime flight data. Data for Origin and Destination airport data.’; CREATE TABLE `dim_date` ( `Year…-resolve sort-buffer-size=512K sql-mode=STRICT_TRANS_TABLES symbolic-links table-definition-cache=16384 table-open-cache=128 thread-cache…
Comment: MySQL: Data Storage or Data Processing
September 8, 2011 By 9 Comments
If you are using innodb By the use of two parameter 1. innodb_data_home_dir = 2. innodb_data_file_path = Documentation of same can be available at mysql. For MyISAM, can take help of symbolic link
