…) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 CREATE TABLE `child_A` ( `id` int(10…_1` FOREIGN KEY (`parent_id`) REFERENCES `parent` (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 Notice that in the case of child… implicit constraints that you might have missed and can then write into your metadata file. Donate – This is free software and…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
… now allocated calling calloc() directly instead of using InnoDB heap allocation. This may improve write performance for high levels of concurrency. Bug… if a bitmap file I/O error occurs after an INNODB_CHANGED_PAGES query started returning data to indicate an incomplete result set. Bug fixed #1185040. The INNODB_CHANGED_PAGES table couldn’t be queried if the log…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… of production database servers and will perform the backups. The write load is not excessive so a single server can easily… many scripts ready for the task. Snapshots work best with InnoDB, with MyISAM you’ll have to start the snapshot while… ray flip a bit on a drive, instead of crashing InnoDB, it will be caught by ZFS and the data will…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
… atomic write support for directFS filesystem on Fusion-io devices. This feature implementation is considered BETA quality. Percona Server has introduced innodb_read_views_memory and innodb_descriptors_memory status variables in the Extended Show Engine InnoDB Status to improve InnoDB memory usage…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… mutex for the log reads needlessly, potentially limiting performance on write-intensive workloads. Bug fixed #1171699. Missing path separator between the… if a bitmap file I/O error occurs after an INNODB_CHANGED_PAGES query started returning data to indicate an incomplete… if changed page tracking is enabled. Bug fixed #1184517. The INNODB_CHANGED_PAGES table couldn’t be queried if the log…
Comment: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… due to random IO caused by the COW (Copy on Write). SSD’s solved the issue for us, plus we still… no cost difference. ZFS provides built in checksumming and double write buffering, so make sure these are turned off in InnoDB.
Comment: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
@JDempster: I could give the SSD to xfs also with Flashcache and the like. Don’t forget all these jbods have a raid controller write cache in front of them. I also did the Innodb tuning. @Nils: no fuse, direct kernel support. Look here: http://zfsonlinux.org/
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…_group = 2 innodb_log_block_size=4096 #####plugin options innodb_read_io_threads = 16 innodb_write_io_threads = 4 innodb_io_capacity = 4000 innodb_use_native_aio=0 #not innodb options (fixed…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… sets of experiments. First, the baseline configuration plus: innodb_read_io_threads = 16 innodb_write_io_threads = 16 We call this configuration B…: #####fixed innodb options innodb_file_format = barracuda innodb_buffer_pool_size = 4G innodb_file_per_table = true innodb_data_file_path = ibdata1:100M innodb_flush_method…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… how important is the file cache for Linux. Basically, with InnoDB, since the file cache is not important we add “vm…, drop the file cache and pre-allocate the innodb buffer pool with the innodb_buffer_pool_populate option. That solves most of… (~150MB/s) but doing very little physical writes. The writes were cached and the write cache was causing the problem. It happened that…
