… in innobackupex). He also included this helpful script to generate all of those statements for steps 7 and 10 in two scripts: mysql -N -B <<'EOF' > discard-ddl.sql SELECT CONCAT(‘ALTER TABLE `’, table_name, ‘` DISCARD… TABLE_SCHEMA=’orig’ AND ENGINE=’InnoDB’; EOF mysql -N -B <<'EOF' > import-ddl.sql SELECT CONCAT(‘ALTER TABLE `’, table_name, ‘` IMPORT TABLESPACE…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… s4 are also lagging behind). s2> select count(*) from t; +———-+ | count(*) | +———-+ | 2 | +———-+ # s1 is behind s1> select count(*) from t; +———-+ | count(*) | +———-+ | 0…; mysql> change master to master_port=10002; mysql> start slave; # And then check the number of records from the t table s1> select… mysqlbinlog? There is a solution of course, but very poor in my opinion: look for the binlog file/position of the…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… just running the query in a suboptimal form. Q: Doesn’t the primary key solution for random selection only work when the… was more efficient in this case to force MySQL to scan the `title` table first, grouping by kind_id in index order. This… the Percona Live MySQL Conference and Expo in Santa Clara, California starting March 31, 2014. Watch more webinars from Percona in the future!
Post: Choosing a MySQL HA Solution - MySQL Webinar: June 5
May 28, 2013 By 1 Comment
Selecting the most appropriate solution for a MySQL HA infrastructure is as much a business and philosophical decision … a webinar entitled, Choosing a MySQL HA Solution, in which we’ll explore the topic of MySQL HA from each of these perspectives… deployment. This webinar will be both technical and non-technical in nature, beginning with a discussion of some general HA principles…
Comment: INSERT INTO ... SELECT Performance with Innodb tables.
May 22, 2013 By 22 Comments
…mathew: Wrong, it’s still the same in 5.5. Here is the related output from show engine … InnoDB 334 mysql tables in use 4, locked 4 3264 lock struct(s), heap size 440760, 799203 row lock(s) MySQL thread id 38, OS thread handle 0x2b3c1c776940, query id 16838101 localhost root Copying to tmp table create table t as SELECT…
Comment: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
Can different filters be combined? For example, all the select queries in mysql.user from a particular user.
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… fixed #1104977 (Raghavendra D Prabhu). Clustercheck script would hang in case the MySQL server on a node is hung. As a consequence… would fail if the tmpdir was specified more than once in the MySQL configuration file (my.cnf). Bugs fixed #1160047 and #1086978… D Prabhu). In case CREATE TABLE AS SELECT statement was running in parallel with the DDL statement on the selected table, in some cases first…
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
… GA release in the MySQL 4.0 series, and for the first and only time in a MySQL version you could buy MySQL in a box… MySQL 5.6.2 is nonGA. 2012 marks the first year the annual conference is organized by Percona, with technical content selected by an independent committee. The conference is refocused back on MySQL and the needs of the MySQL community covering other…
Post: What I'm looking forward to at Percona Live (MySQL Users Conference)
April 4, 2013 By 1 Comment
… stay attuned to the new companies, products and other developments in the MySQL ecosystem – both to drive Percona’s direction as well…. If you’re shopping for MySQL technology and services, then you’ll see the largest selection of MySQL Ecosystem vendors at the show. If you’re doing business associated with MySQL, you’ll have…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
…: MySQL transactions started with START TRANSACTION READ ONLY MySQL transactions created by a non-locking SELECT statement in the autocommit mode. The relevant optimization in MySQL… read-only optimization in MySQL 5.6 does not kick in. The default sysbench POINT_SELECT mode benchmark does PK lookup SELECT queries wrapped into…
