… browser-displayable format. It lets you click through the hierarchy of database tables via child and parent table relationships as represented by both… name=”parent_id”>
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… sometimes better than another equivalent solution. If you‘re talking about using a temporary table to store an interim result set, and… the table, and populate the rows you want to choose (movies, in this case) with values known to be consecutive. Then you could… there? Yes, I think what you‘re referring to is what I covered as the Derived-Table Solution on slides 55-59…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
…-import those files to a running server. However, you need to have existing table structures in place. Fortunately, this can be done… that contains the schema you are interested in (/tmp/snapshot/2013-06-03_11-30/orig) Get the table structures: mysqldump –no… /var/lib/mysql/orig_old/* For each table, run: ALTER TABLE tblname IMPORT TABLESPACE Now, you have a old version of the schema…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
…. If you try to do something like this in MySQL 5.5, you will succeed without errors or warnings: mysql> ALTER TABLE test… Duplicates: 0 Warnings: 0 mysql> SHOW CREATE TABLE test\G *************************** 1. row *************************** Table: test Create Table: CREATE TABLE `test` ( `id` int(11) NOT NULL AUTO…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… means there is approximately 12GB of data in the largest table. You can find the individual SSB query definitions in my previous… the filesystem level. The InnoDB indexes were built using ALTER TABLE fast index creation (merge sort). For the MyISAM tests I… innodb_undo_logs=32 innodb_old_blocks_time=0 table_open_cache=2048 table_definition_cache=16384 innodb_flush_method=O_DIRECT…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… infrastructure). In essence, you‘re looking for two of everything. Q: Is it possible to replicate only some tables from master to… 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 to the…
Comment: Implementing SchemaSpy in your MySQL environment
June 5, 2013 By 2 Comments
Daniël, thank you for your feedback. * How do you define large schemas, and what do you mean by can’t cope? * Is this…, or certain features don’t work past N number of tables? In my experience, the schemas I have under SchemaSpy reach at max approximately 3,000 tables per schema and perhaps 10,000 tables per mysqld instance. SchemaSpy does take some…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… having to maintain servers under a specific replication topology. However you should keep in mind some limitations of the current implementation… slave; and let’s create a new table on the master: mysql> create table test.t (id int not null auto_increment… TABLES FROM test on both slaves shows that the table has been created everywhere. So once GTIDs are enabled on all servers, you…
Comment: How number of columns affects performance ?
May 25, 2013 By 12 Comments
… you think it would it be more efficient to have multiple ( 7-10 ) different tables and minimize the record count in each table… types of data and put them all in the same table. The only difference is the data type…all the rest…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… # And then check the number of records from the t table s1> select count(*) from t; +———-+ | count(*) | +———-+ | 2 | +———-+ Great! So …with the good old –start-position option! Even with GTIDs, you cannot totally forget old-style replication positioning. Conclusion Reconfiguring …
