… drops to 33% after the first snapshot so keeping a large number of snapshots running is simply not an option. With… work best with InnoDB, with MyISAM you’ll have to start the snapshot while holding a “flush tables with read lock” and… ray flip a bit on a drive, instead of crashing InnoDB, it will be caught by ZFS and the data will…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… replicate a specific database, a set of databases, or specific tables; you can also configure the slave to replicate everything EXCEPT… problem before it occurs. For example, if you see a large number of long-running queries in the output of SHOW… get the server up with –skip-grant-tables and insert a few rows into an InnoDB table, but trying to run a simple…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…. If you add multiple multi-column indexes the difference with InnoDB will be even more notable. Also it allows multiple clustering… (versions 3.x and 4.x). It really shines on large tables and index scan like queries.
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… 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…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… several hundred. This really will open a large window where rows won’t be able … are maintained in separate tables and there also exists a users_groups table to define the relationship between …were really bad in standalone Innodb, you might consider relaxing the fsync: set innodb_flush_log_at_…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
…queries, making it ideal for companies with large data sets and mission-critical applications that…rebuild-indexes. This allows parallel processing of individual tables when rebuilding the index. Percona XtraBackup has…command line client. Support for InnoDB 5.0 and InnoDB 5.1 builtin has been removed…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…(as 2.1.10) then retire. 2.2 is largely backward-compatible with 2.1, but some tools were…and how. There’s still one noticeable omission: pt-table-sync. It’s still unclear if or how …configurable. Also, we removed –lock-wait-timeout which set innodb_lock_wait_timeout because that now conflicts, or is…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 141 Comments
… index ranges are scanned. There are also clustered keys in Innodb which combine index access with data access, saving you IO…% or rows or less full table scan may be faster. Avoid joins to large tables Joining of large data sets using nested loops is very expensive. Try to avoid it. Joins to smaller tables is…
Post: When Does InnoDB Update Table Statistics? (And When It Can Bite)
October 6, 2011 By 7 Comments
…InnoDB plugin’s manual: Metadata commands like SHOW INDEX, SHOW TABLE STATUS and SHOW [FULL] TABLES (or their corresponding queries from INFORMATION_SCHEMA.TABLES… an application constantly executes SHOW [FULL] TABLES or SHOW TABLE STATUS on many a large tables, this can affect your server especially…
Post: Reasons for run-away main Innodb Tablespace
June 10, 2010 By 2 Comments
So you’re running MySQL With innodb_file_per_table option but your ibdata1 file which holds main (or system) … (can be changed via innodb_ibuf_max_size option) which can be significant size for systems with large amount of memory. Finally… handle it. Note ALTER TABLE will not require excessive amount of undo space even for very large tables as it internally commits every…
