… by detecting such cases and omitting the corresponding secondary keys from deferred key creation optimization. Bug fixed #1081016 (Alexey Kopytov). Percona Server… upstream bug #63144. CREATE TABLE or CREATE TABLE IF NOT EXISTS statements on an existing table could wait on a metadata lock instead…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… by detecting such cases and omitting the corresponding secondary keys from deferred key creation optimization. Bug fixed #1081016 (Alexey Kopytov). Percona Server… upstream bug #63144. CREATE TABLE or CREATE TABLE IF NOT EXISTS statements on an existing table could wait on a metadata lock instead…
Post: Percona XtraDB Cluster for MySQL and encrypted Galera replication
May 3, 2013 By 2 Comments
… cert.pem Generating a 2048 bit RSA private key …………..+++ ……………………………………………………….+++ writing new private key to ‘key.pem’ —– You are about to be asked to… 1 12:08 key.pem Note that we are creating a certificate with a very long expiration time. If you use the… take a [brief] outage. In my case, I have an existing non-SSL cluster, so to re-bootstrap, I simply: [root…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… all fields. It must exist for any InnoDB table. If explicitely defined its `NAME` is PRIMARY. If the primary key is not defined InnoDB will use a unique secondary index as the primary. If there is no… | COL_NAME | +———-+—–+———-+ | 1679 | 0 | actor_id | +———-+—–+———-+ Which means the primary key of the table is one field actor_id. Now we…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
…_incoming_address. Bug fixed #1082406 (Alex Yurchenko). Dropping a non-existing temporary table would be replicated when TOI was used in… mixed CHAR and VARCHAR columns would be used in foreign key definitions. Bug fixed #1100496 (Seppo Jaakola). Debian packages included the… foreign key constraint could lead to unresolved replication conflict and leave a slave hanging. Bug fixed #1130888 (Seppo Jaakola). If MySQL replication…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… of this system, or even that it exists, leads to unnecessary frustration with Galera and cluster … controls when flow control engages. Simply speaking, if the wsrep_local_recv_queue exceeds this … transactions, which translates into number of unique key lookups into the certification index, which is …
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…Innodb is a single row (well, the PRIMARY KEY index entry for that row). This means …These are maintained in separate tables and there also exists a users_groups table to define the relationship…redis and only flushing to the database periodically? if( $last_count % 100 == 0 ) { $db->do( “UPDATE …
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 8, 2013 By 32 Comments
…, the “insert on dup key update” statements do a point query to read the row. If the row exists, then the row is…. We could support x=x+value(x). Let me know if you would like to run this test.
Post: Getting annoyed with MyISAM multiple key caches.
May 1, 2009 By 11 Comments
… way to see the existing key caches, their mapping and stats. The only thing you can access is key cache parameters – via structured… make an error in key cache creation but it is not possible to later find out such key cache exists. This in my opinion violates fundamental design principle – if you can create something you…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
… varchar(10), KEY(C_Name), KEY(C_City), KEY(C_Region), KEY(C_Phone), KEY(C_MktSegment) ); DROP TABLE IF EXISTS part; CREATE TABLE IF NOT EXISTS part ( P_PartKey int primary key, P…
