…(10) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 CREATE TABLE `child_A` ( `id` int…/xmlschema/2011/02/05/schemaspy.meta.xsd”> ….10, both with default settings using only the InnoDB storage engine. In my testing I discovered that innodb_old_blocks_time… more IO than MyISAM when the database is cold, but uses less CPU time when the database is hot. I am only… is faster than InnoDB when the database is cold, but the opposite is true when the database is hot. SSB Flight #3… ….sql Create the new target database: mysqladmin create orig_old Load the schema into the target database: mysql orig_old < /tmp/orig... _ddl FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='orig' AND ENGINE=’InnoDB’; EOF mysql -N -B <<'EOF' > import-ddl.sql SELECT… _ddl FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=’orig’ AND ENGINE=’InnoDB’; EOF For full disclosure, here are the versions I… … can configure the slave to only replicate a specific database, a set of databases, or specific tables; you can also configure the slave to replicate everything EXCEPT a specified set of databases and tables. With this method, every event is still written… on the same machine if you use the BLACKHOLE storage engine) in between the actual master and the slaves at the… … not supported inside transaction. 2. Updates involving non-transactional storage engines – It is not possible to mix non-transactional tables (such… if slave host is using different storage engine for the respective table on master databases. Also, if BINLOG_FORMAT is not consistent… …. Partnership with SAP was hot at this event and MaxDB database looked like it had a solid future. MySQL Cluster and… was placed on the storage engine API diminishing importance of the Innodb storage engine. The Falcon storage engine was announced as a potential…. The conference is extended to include a lot of other databases and technologies in NoSQL and BigData space – PostgreSQL, EnterpriseDB, Hadoop… … MySQL along with Sun Microsystems. Fears for the open source database‘s survival appear to have been misplaced as Oracle has… Evangelist, Amazon Web Services “Databases in the Cloud: Present and Future” Tomas Ulin, Vice President of MySQL Engineering, Oracle Keynote Topic: “Driving… Sabhaya, and Jim Cooley, HP Topic: “Using Percona Server as Database-as-a-Service on OpenStack” Breakout Sessions on MariaDB Monty… … not because it is “free” as in “a free cloud database account,” rather it’s because it is “free” as in… two examples: First, the PBXT storage engine from PrimeBase – even with an open source engine, the company eventually could not fund further… can find some grains of truth in the article “Dead database walking: MySQL’s creator on why the future belongs to… … incredible power of using databases! Thanks to this specific article by Peter Zaitsev my general understanding of DB engines and the desire… using MyISAM was because it was the default MySQL engine. So far my databases have been basic and small and for general… never went deep enough to make well informed decisions about engines and other optimizations. Getting very involved in e-commerce I… …, PRIMARY KEY (`NAME`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 `NAME` is a human readable table name in form database_name/table_name e…` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`TABLE_ID`,`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 So, `TABLE_ID` is our table…_NAME` varchar(255) DEFAULT NULL, PRIMARY KEY (`INDEX_ID`,`POS`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 Fields names explain their content. Index… Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
Post: Migrating between MySQL schemas with Percona Xtrabackup
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
Post: 10 years of MySQL User Conferences
Post: Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo
Post: Open Source, the MySQL market (and TokuDB in particular)
Comment: Should you move from MyISAM to Innodb ?
Post: How to recover table structure from InnoDB dictionary
Percona Webinars
Percona MySQL Training
Percona Careers
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
May 22, 2013 By Leave a Comment
June 10, 2013 By 2 Comments
June 7, 2013 By Leave a Comment
June 10, 2013 By 8 Comments
April 11, 2013 By 6 Comments
April 15, 2013 By 1 Comment
May 10, 2013 By 13 Comments
March 27, 2013 By 59 Comments
April 22, 2013 By 4 Comments