… entity-relationship diagrams. It’s also designed to help …id`), KEY `parent_id` (`parent_id`), CONSTRAINT `child_B_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `parent` (`parent_id…mysql -u msandbox_ro -p msandbox -meta schemaspy.meta.xml -o /var/www/schemaspy/ The -o directive tells SchemaSpy where…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
…id=”attachment_13396″ align=”alignright” width=”247″] Percona Server for MySQL version 5.1.69-…was chosen from the distribution’s repository instead of Percona’s which could lead to package…1167109. Fixed the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
…id=”attachment_13396″ align=”alignright” width=”247″] Percona Server for MySQL version 5.5.31-30.3[/…in the 5.5 series. All of Percona’s software is open-source and free, all … #1171941. Fixed the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
…results. For instance, if there’s a gap of id‘s between 47000 and 50000 with no … you’re referring to is this example: WHERE (k1.keyword, k2.keyword, k3.keyword) = (‘espionage’, ‘nuclear…id. It was more efficient in this case to force MySQL to scan the `title` table first, grouping by kind_id…
Comment: INSERT INTO ... SELECT Performance with Innodb tables.
May 22, 2013 By 22 Comments
… 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… d on (cai.client_id = d.client_id) inner join label_to_device ld on (ld.device_id = d.id) where ld.trash = ‘f’ and…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… #1 mysql> change master to master_auto_position = 1; mysql> start slave; and let’s create a new table on the master: mysql> create table test.t (id int not null… nice to be able to mix servers where gtid_mode is ON with servers where gtid_mode is OFF. This would greatly…
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
… 4432877 K bytes of memory Hope that’s ok; if not, decrease some variables …use the following information to find out where mysqld died. If you see no …(0): is an invalid pointer Connection ID (thread ID): 3 Status: NOT_KILLED You may… mysqld from pid file /var/lib/mysql/srv-d2-mysql02.pid ended in…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… effect on standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication? It’s actually much worse… INTO users_groups (user_id, group_id) VALUES (100, 1); UPDATE groups SET last_joined=NOW(), last_user_id=100 WHERE id=1; COMMIT; How…
Post: Percona Live MySQL Conference 2013 wrap-up
April 29, 2013 By Leave a Comment
…MySQL Conference & Expo 2013 was April 22-25 in Santa Clara, California. This was Percona’s … points to MySQL gravitational tug of war” on the 451 Research website. [caption id=”attachment_15008″ align…MySQL users, vendors, and technologies. This was the first of what I hope are many such events where…
Post: What I'm looking forward to at Percona Live (MySQL Users Conference)
April 4, 2013 By 1 Comment
…catch up. [caption id="" align="alignright" width="336"] Registration signs from the 2003 MySQL Users Conference and Expo… and other developments in the MySQL ecosystem – both to drive Percona’s direction as well as to give…many of the other shows I speak at where all I get is an awkward silence which…
