… the MySQL manual. You can configure the slave to only replicate a specific database, a set of databases, or specific tables; you… problem before it occurs. For example, if you see a large number of long-running queries in the output of SHOW…: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under strace, I…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
…33% after the first snapshot so keeping a large number of snapshots running is simply not an option…to start the snapshot while holding a “flush tables with read lock” and the flush operation will… on Linux is a very interesting solution for MySQL backup servers. All backup solutions have an impact…
Post: 5 Percona Toolkit Tools for MySQL That Could Save Your Day: April 3 Webinar
March 22, 2013 By Leave a Comment
…-change, to run ALTER TABLE statements on large tables without downtime You can reserve your spot for this free MySQL webinar now. If you… on “5 Percona Toolkit Tools for MySQL That Could Save Your Day”Percona Toolkit for MySQL is a must-have set of… few seconds How to run ALTER TABLE on your largest tables without downtime REGISTER NOW for this MySQL webinar DOWNLOAD Percona Toolkit for MySQL
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… a six-hour tutorial about Percona XtraDB Cluster (PXC) for MySQL. I actually had more material than I covered (by design… replication feedback mechanism, unlike anything you find in standard async MySQL replication. It is my belief that the lack of understanding… a large replication queue without flow control if they are blocked by the underlying SST method, i.e., by FLUSH TABLES WITH…
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…=120 –max-requests=0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-selects=1 –oltp…=120 –max-requests=0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-selects=9 –oltp…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication… hundred. This really will open a large window where rows won’t be …are maintained in separate tables and there also exists a users_groups table to define the relationship …
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
…, making it ideal for companies with large data sets and mission-critical applications …-indexes. This allows parallel processing of individual tables when rebuilding the index. Percona XtraBackup … Perl’s DBD::MySQL package for server communication instead of spawning the MySQL command line client…
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 one… standard (http) connection. pt-stalk and pt-mysql-summary have built-in MySQL options No more “pt-stalk — -h db1 …
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 141 Comments
… of few large tables, which is completely disk bound can be very slow. One of the reasons elevating this problem in MySQL is…% 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: ALTER TABLE: Creating Index by Sort and Buffer Pool Size
June 27, 2012 By 4 Comments
…. I used 10mil row table which would look as following in terms of data and index size: mysql> show table status like “sbtest… now see with 6GB buffer pool which is large enough to fit complete table with index (but is a bit too small… Away: If you’re having large tables and need to run ALTER TABLE which rebuilds the table or OPTIMIZE TABLE do not forget to enable…
