… memory. For the hot test, the data fits in the buffer pool and has been loaded by the cold test already. The… than InnoDB. Like the queries in Flight #3 that are faster using MyISAM, Q4.3 examines very little data. It seems that InnoDB…/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_log_file_size=4G innodb…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… in turn, load that data into and pollute the buffer pool. Note that this can be somewhat mitigated using innodb_old_blocks_time, but that is outside the scope of this post. Similarly, reloading the data will be… create orig_old Load the schema into the target database: mysql orig_old < /tmp/orig.schema.sql Ensure innodb_import_table_from…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… production database servers and will perform the backups. The write load is not excessive so a single server can easily handle… many scripts ready for the task. Snapshots work best with InnoDB, with MyISAM you’ll have to start the snapshot while… on a drive, instead of crashing InnoDB, it will be caught by ZFS and the data will be read from the other…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…ve seen situations where even under just a moderate load on the host system, DRBD can end up …the intermediate server, thus resulting in less binary log data being sent down to the lower-level slaves. …-grant-tables and insert a few rows into an InnoDB table, but trying to run a simple mysqlslap just…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
To recover a dropped or corrupt table with Percona Data Recovery Tool for InnoDB you need two things: media with records(ibdata1… revision of the recovery tool bzr branch lp:percona-data-recovery-tool-for-innodb 1. Compile the dictionary parsers make dict_parsers…_id> 4. Load dumps of the dictionary tables into some MySQL server. Use LOAD DATA INFILE constraints_parser generates mysql>LOAD DATA INFILE ‘/path/to…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… is the basic approach: data = fetchCache(key) if (data) { return data } data = callExpensiveFunction(params) storeCache(data, key) return data Memcached is a very popular …) MySQL Select showed 27% increase over InnoDB fetch (~.09 ms/op) This replaced $cache->load() with $db->query(“SELECT * FROM…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…=3306 innodb_status_file=0 innodb_data_file_path=ibdata1:100M:autoextend innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_log_buffer_size = 16M innodb…_type=OFF performance_schema=0 warmup To warmup server and load data and indices to the buffer pool we use following queries…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 9, 2013 By 32 Comments
Thanks Vadim, I did the test on 5.6 and load data infile concurrently results for two threads is 20 times slower… compression as we are facing more and more big data challenges where innoDB and TokuDB will have to be compare with LevelDB…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… 10M ids(after load of data size of datadir ~10GB). We used this dataset to check server behavior when data fully fits buffer… innodb_log_buffer_size=128M innodb_max_dirty_pages_pct=80 innodb_file_format=barracuda innodb_file_per_table innodb_read_io_threads = 8 innodb_write…_partitions=8 innodb_buffer_pool_instances=1 innodb_adaptive_flushing_method=keep_average innodb_flush_neighbor_pages=none command line to load 10x dataset…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool dumps can be produced and loaded… the tablespaces. Optimization has been implemented and XtraBackup now avoids loading non-relevant tablespaces when partial backup is being taken which… as well. Bug fixed #1169509. innobackupex wasn’t handling the innodb_data_file_path option which could cause backup to fail. Bug…
