…!. MyISAM may be good for raw performance, but there are limitations which MyISAM imposes that are difficult to work with. MyISAM… basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_log_file_size=4G innodb_file_per_table innodb_stats_on_metadata=off innodb_file…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… limited to 32-bit signed integers. Fixed so that these values can be 64-bit unsigned integers now. Bug fixed #714925. mysql… 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: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
… align=”alignright” width=”247″] Percona Server for MySQL version 5.6.11-60.3[/caption]… Under very rare circumstances, deleting a zero-size bitmap file at the right moment would make server… mutex for the log reads needlessly, potentially limiting performance on write-intensive workloads. Bug fixed #…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… optimization in MySQL 5.6 virtually eliminates contention on the mutex protecting the list of transactions, its applicability is quite limited. Namely… 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
… interleave the allocation of memory for the MySQL process using the numactl utility, drop the file cache and pre-allocate the innodb… S3. Why? The push to S3 was especially puzzling since MySQL was not involved. The server was running with nearly 7GB… 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: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… constantly referring to the amazing MySQL manual, especially the option and variable reference table. But…_shutdownblogpercona.commanual innodb_file_formatblogpercona.commanual innodb_file_format_checkblogpercona.commanual innodb_file_format_maxblogpercona.commanual innodb_file_per_tableblogpercona….
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…_LONG_SIZE | 10000 | 100 | | PERFORMANCE_SCHEMA_MAX_RWLOCK_INSTANCES | 1000000 | 1724 | | PERFORMANCE_SCHEMA_MAX_TABLE_HANDLES | 100000 | 2223 | | INNODB_LOG_FILE_SIZE | 5242880 | 50331648 | | BASEDIR | /mnt/nfs/dist/5.5.30 | /mnt/nfs/dist/5.6.10 | | BACK_LOG | 50 | 80 | | OPEN_FILES_LIMIT… is disabled by default in MySQL 5.6 Welcome to much faster information_schema queries! innodb_log_file_size – default has been increased…
Post: Choosing proper innodb_log_file_size
July 3, 2006 By 12 Comments
… size of innodb_log_file_size is important for MySQL Performance. However setting it too large will increase recovery time, so in case of MySQL… reduce “undo” phase is size your transactions appropriately – so updates/inserts/deletes can be sized to affect limited number of rows. Good thing…
Post: Review of MySQL 5.6 Defaults Changes
October 8, 2012 By 10 Comments
… 2000 ? innodb_file_per_table =1 Great! We found it is better choice in 95%+ of installations innodb_log_file_size = 48M This… which would mean limit disabled. Very few users actually need DOS prevention this variable strives to provide as MySQL is typically protected by Firewall to begin with. open_files_limit = 5000 strangely enough this is…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
… too big, and now we again hit the limit set by innodb_log_file_size. The 15-minute average result for this test…. And checkpoint age is back to 3000MB and again limited by innodb_log_file_size. The 15-minute average result is 37509.73… innodb_log_file_size. To prove it, I took Percona Server based on 5.5.8 and ran it in MySQL mode (that…
