… to the INNODB_CHANGED_PAGES table would cause server to stop with an I/O error if a bitmap file in the…the User Statistics tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS, THREAD_STATISTICS, and USER_STATISTICS) led to the maximum counter values being limited to…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
…the schema you are interested in (/tmp/snapshot/2013-06-03_11-30/orig) Get the table…to generate all of those statements for steps 7 and 10 in two scripts: mysql -N -B <<'EOF' > discard-ddl.sql SELECT…
Comment: Implementing SchemaSpy in your MySQL environment
June 5, 2013 By 2 Comments
… the tool, or certain features don’t work past N number of tables? In my experience, the schemas I have under SchemaSpy reach at max approximately 3,000 tables per schema and perhaps 10,000 tables per… this schema into Workbench so I can’t comment as to how well it scales at this volume of tables.
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
… of your replication message is sent to other node in the cluster. The more nodes in your cluster, the more the bandwidth required for replication multiplies. Now… second. I’m running a sysbench test on one node and measuring the outbound (UP) bandwidth on that same node: # 2 nodes in the…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
…the same columns (in the same order) and the server will not complain. If we execute the same sentences in MySQL 5.6, the second…the table ‘test.test’. This is deprecated and will be disallowed in a future release. 1 row in set (0.00 sec) As the…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… of the benchmark. There was some discussion in the comments and I promised to…the database. The first test is described as the cold test, and the second as the hot test. The database software is restarted after the… data in the largest table. You can find the individual SSB query definitions in my …
Comment: MySQL Performance Forums
June 9, 2013 By 18 Comments
… running select query. A query runs for say 300 seconds and because the resultset is huge, it eventually starts creating a temp table on disk. Now during those 300 second, other ‘innocuous’ queries which perform small insert or updates into completely different table (unrelated to the select…
Comment: ZFS on Linux and MySQL
June 7, 2013 By 17 Comments
… to steal 20GB memory from the Innodb buffer pool to give it to the filesystem. I took a look at OmniOS but frankly it was the first time I read something about it. How different is it from Solaris in term of porting? @kyle…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… the slave, as described in the MySQL manual. You can configure the slave to only replicate a specific database, a set of databases, or specific tables…. Q: How do you monitor MySQL to determine when it’s not responsive? A: The easiest way to do this is to simply connect to it…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
…the User Statistics tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS, THREAD_STATISTICS, and USER_STATISTICS) led to the maximum counter values being limited to… to the INNODB_CHANGED_PAGES table would cause server to stop with an I/O error if a bitmap file in the…
