…it occurs. For example, if you see a large number of long-running queries in the …libexec/mysqld: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ …-tables and insert a few rows into an InnoDB table, but trying to run a simple …
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… and a followup by Dimitri Kravchuk, we have received a large number of questions on why the benchmark results in both…_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 innodb_read_io_threads = 8 innodb_write…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
…user queries, making it ideal for companies with large data sets and mission-critical applications that …MySQL command line client. Support for InnoDB 5.0 and InnoDB 5.1 builtin has been removed … fixed #1168513. Percona XtraBackup would leave xbtemp temp files behind due to a typo. Bug fixed #1172016…
Comment: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…innodb_lru_scan_depth to a value similar to innodb_io_capacity. They should have made LRU page flushing a function of innodb…_free_block they are trying to do it. I filed a few bugs for this and I hope most… is hard to know what goes on behind the large wall between us and them. http://bugs.mysql.com/…
Comment: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…innodb_lru_scan_depth to a value similar to innodb_io_capacity. They should have made LRU page flushing a function of innodb…_free_block they are trying to do it. I filed a few bugs for this and I hope most… is hard to know what goes on behind the large wall between us and them. http://bugs.mysql.com/…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…to /dev/null, and only have a log file for debugging purposes. Streaming logs from stdin …-query command-line option, we set the option innodb_fake_changes to prevent INSERTs, UPDATEs, and …connection reuse. This is necessary when running a large stream of queries. Benchmarks We benchmarked with …
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… 2.1.10) then retire. 2.2 is largely backward-compatible with 2.1, but some tools…. Also, we removed –lock-wait-timeout which set innodb_lock_wait_timeout because that now conflicts, or… other tools: –user, –host, –port, –password, –socket, –defaults-file. So now the command line is what you …
Post: Real-Life Use Case for "Barracuda" InnoDB File Format
April 23, 2008 By 11 Comments
… using new InnoDB file format but in this post I’d like to share some real-life example how compression in InnoDB plugin could be useful for large warehousing tasks. One of our clients had… to try to convert customer’s data to Barracuda file format using new InnoDB plugin recently released by Oracle. First thing I…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… state disks for storing ib_log* files; I know that innodb writes files in the log file group in a round robin fashion. I… file in a log file group. My questions are: What is always being written to the first file in the log file group? HT: InnoDB… for all major database brands. Q37: We have a fairly large Innodb table (150GB) that is showing poor performance for full table…
Post: Choosing proper innodb_log_file_size
July 3, 2006 By 12 Comments
… of writes to Innodb tables decent size of innodb_log_file_size is important for MySQL Performance. However setting it too large will increase… happens on recovery and why large innodb_log_file_size slows down recovery. During startup after crash Innodb scans log files to find log records…
