… new table on the master: mysql> create table test.t (id int not null auto_increment primary key); Executing SHOW TABLES FROM test on both slaves shows that the table has…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… of everything. Q: Is it possible to replicate only some tables from master to slave, and if so, how? A: Yes. There… the MySQL manual. You can configure the slave to only replicate a specific database, a set of databases, or specific tables; you… the output of SHOW PROCESSLIST that might be a sign that trouble is brewing. Or if you watch your MySQL server’s…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
…_memory and innodb_descriptors_memory status variables in the Extended Show Engine InnoDB Status to improve InnoDB memory usage diagnostics. Bugs… from the MySQL 5.6 version, which removed MyISAM internal temporary table mutex contention. Bug fixed #1179978. Release notes for Percona Server for MySQL…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; # And then check the number of records from the t table s1> select count(*) from… to know the coordinates of the last event executed: s1> show slave status\G [...] Executed_Gtid_Set: 219be3a9-c3ae-11e2-b985-0800272864ba…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
…if the keywords were returned in a different order from what you specify in the query? The tuple …force MySQL to scan the `title` table first, grouping by kind_id in index order. This made the first table in…trying to determine the last episode of each TV show. Couldn’t you have used a SUBQUERY to …
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
…the snapshot while holding a “flush tables with read lock” and the …data that doesn’t compress well showed a compression ration of 1.70 … I allocated mirror pairs using drives from different controllers. That way, if a… is a very interesting solution for MySQL backup servers. All backup solutions …
Comment: INSERT INTO ... SELECT Performance with Innodb tables.
May 22, 2013 By 22 Comments
… the related output from show engine innodb status: —TRANSACTION BB0E42A, ACTIVE 3 sec fetching rows, thread declared inside InnoDB 334 mysql tables in use… lock(s) MySQL thread id 38, OS thread handle 0x2b3c1c776940, query id 16838101 localhost root Copying to tmp table create table t as…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… or SHOW CREATE TABLE crashes MySQL There is yet another source of information about the table structure – InnoDB dictionary. Let’s review tables from the dictionary and see what it can give us. We will need four of them: SYS_TABLES SYS_INDEXES…. `ID` is a table identifier. We will need the table id to find indexes of the table. mysql> select * from SYS_TABLES WHERE NAME=’sakila/actor…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…from MariaDB for the upstream bug #63144. CREATE TABLE or CREATE TABLE IF NOT EXISTS statements on an existing table…MySQL was missing help texts in the MySQL client because the help tables…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
….30-23.7.4 for MySQL on April 17, 2013. Binaries are available from the downloads area or from our software repositories. New… library will be available for download from our repositories. Benchmark showing the impact of memory allocators on MySQL performance can be found in… it will still replicate in case DROP TABLE statement is used on a temporary table. Bug fixed #1084702 (Seppo Jaakola). In case…
