… the InnoDB tests, a 64GB buffer pool was used. O_DIRECT was used so, there was no caching of data at the filesystem level. The InnoDB indexes were built using ALTER TABLE fast…=myisam tmpdir=/dev/shm innodb_undo_logs=32 innodb_old_blocks_time=0 table_open_cache=2048 table_definition_cache=16384 innodb_flush_method=O…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
… directFS filesystem on Fusion-io devices. This feature implementation is considered BETA quality. Percona Server has introduced innodb_read_views_memory and innodb… that could cause a memory leak if query cache was used together with InnoDB. Bug fixed #1170103. Fixed the RPM packaging regression…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… LVM but… since it is a copy on write filesystem, the snapshots are free, no performance penalty. You … ready for the task. Snapshots work best with InnoDB, with MyISAM you’ll have to start the …maybe it is related to better raid controller write cache use. Even the fairly slow gzip-1 mode …
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… same 2.2TB Virident FlashMAX II as the cache storage device. EXT4 is the filesystem, and CentOS 6.4 the operating system…: #####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…
Comment: 5.0.83-build17 Percona binaries
August 6, 2009 By 19 Comments
… here: http://thunk.org/tytso/blog/2009/02/20/aligning-filesystems-to-an-ssds-erase-block-size/) 5) Set the drive…. innodb_log_group_home_dir=/var/lib/mysqlnonssd/ innodb_log_arch_dir=/var/lib/mysqlnonssd/ 8) Make sure you bypass the OS caches innodb… filepertable. Especially if you find your tables fragment a lot. innodb_file_per_table=1 I’m sure other people can…
Post: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
… MyISAM and Innodb tables on ext3 filesystem. Here is what I found: The fragmentation we speak in this article is filesystem fragmentation or… (table_cache=64) and set innodb_buffer_pool_size=8G innodb_flush_logs_at_trx_commit=2 innodb_log_file_size=256M innodb_flush_method…. Note: As I checked later contrary to my expectation this filesystem was created without dir_index option which should add significant…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…innodb_change_bufferingblogpercona.commanual innodb_checksumsblogpercona.commanual innodb_commit_concurrencyblogpercona.commanual innodb_concurrency_ticketsblogpercona.commanual innodb_data_file_pathblogpercona.commanual Innodb_data_fsyncsblogpercona.commanual innodb…
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
…_DIRECT query_cache_size=0 query_cache_type=0 MySQL 5.6.5 Configuration innodb_file_per_table=1 innodb_file_format=barracuda innodb_log_file_size=512M innodb_log… RAID5 volume, the disks are 5.4K RPM disks. The filesystem used is XFS, and the OS installed is Centos 6…
Post: The tool I've been waiting for years
March 18, 2008 By 10 Comments
… is causing cache pressure and what needs to be worked on. Scanning all files on filesystem and checking which are cached obviously does… one would need to implement cache content tracking for storage engines which cache everything in their own cache memory – Innodb, Falcon, Maria. Having information…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…; lvs These commands show me what filesystems are mounted, how much space … Aborted_clients | 205174 | | Aborted_connects | 29 | | Binlog_cache_disk_use | 0 | | Binlog_cache_use | 9630066 | | Bytes_received | 38563413074 |… InnoDB tables whose .frm files exist but have been dropped from InnoDB, for…
