…!. MyISAM may be good for raw performance, but there are limitations which MyISAM imposes that are difficult to work with. MyISAM…_pool_size=64G innodb_log_file_size=4G innodb_file_per_table innodb_stats_on_metadata=off innodb_file_format=barracuda innodb_log_buffer_size=32M… table_open_cache_instances=8 sort_buffer_size=128k read_rnd_buffer_size=8M join_buffer_size=8M default_tmp_storage_engine=myisam…
Comment: ZFS on Linux and MySQL
June 4, 2013 By 17 Comments
… is this: “limit ARC size to 4GB” ZFS needs a significant portion of ram to work with. I agree that limiting ARC to small amount of ram prevents double caching by the file system vs the InnoDB caching. However, limited ARC size also limits ZFS file…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
… fixed #1185686. Under very rare circumstances, deleting a zero-size bitmap file at the right moment would make server stop with an… the log system mutex for the log reads needlessly, potentially limiting performance on write-intensive workloads. Bug fixed #1171699. Incorrect schema…, and USER_STATISTICS) led to the maximum counter values being limited to 32-bit signed integers. Fixed so that these values…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… limiting performance on write-intensive workloads. Bug fixed #1171699. Missing path separator between the directory and file name components in a bitmap file… fixed #1186690. Under very rare circumstances, deleting a zero-size bitmap file at the right moment would make server stop with an…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… mutex protecting the list of transactions, its applicability is quite limited. Namely, it requires the list of transactions to be either…_data_file_path=ibdata1:100M:autoextend innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_log_buffer_size = 16M innodb_buffer_pool_size = 52G innodb_log_file_size = 2000M innodb_log_files_in_group = 2 innodb_file_per_table = true…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… basically controls how important is the file cache for Linux. Basically, with InnoDB, since the file cache is not important we add… for the MySQL process using the numactl utility, drop the file cache and pre-allocate the innodb buffer pool with the… a split operation to create files of 5GB since the backup size is about 28GB and the file upload size limit is 5GB. So, about…
Post: Choosing proper innodb_log_file_size
July 3, 2006 By 12 Comments
… doing significant amount of writes to Innodb tables decent size of innodb_log_file_size is important for MySQL Performance. However setting it… reduce “undo” phase is size your transactions appropriately – so updates/inserts/deletes can be sized to affect limited number of rows. Good thing… with 1GB log files and 2GB and see if there is any performance benefit. After certain size increasing log file size do not dramatically…
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
… its size and it can take significant amount of memory in some edge cases. Percona patches though provide innodb_dict_size_limit to… difference whatever limit of open files was, which is not surprising as logical operation of opening file is rather fast on local file system… hardware log file size workload and even when crash happen (how many unflushed changes we had) Repeating test with innodb_open_files=16384…
Post: TMP_TABLE_SIZE and MAX_HEAP_TABLE_SIZE
January 19, 2007 By 17 Comments
… to an on-disk table. The size limit is determined by the value of the tmp_table_size system variable. * MEMORY tables are…_table_size used to do. tmp_table_size retains to (give a hint about a) limit of the on-disk temporary table size. The limit…, config files, tons of books and articles on the web – you will have users expecting old behavior for years. The size restriction…
Post: Limiting InnoDB Data Dictionary
February 11, 2009 By 13 Comments
…/files/patches/innodb_dict_size_limit_standalone.patch. Currently patch is on testing stage, but later will be included into our releases. To limit memory we introduce new variable innodb_dict_size_limit (in bytes). Some internals: There is…_cache, memory consumed by data dictionary may exceed innodb_dict_size_limit, as we can’t delete any table entry from it…
