… works if you have used the exact same name (in this case, parent_id) in the…Anomalies – Identifies possible relationships between columns/tables based on names, tables without indexes, columns flagged ‘nullable’ … you use and how do they compare with SchemaSpy? Feel free to answer via the comments. …
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… had an effect on performance of the benchmark. There was some discussion in the comments and I promised … amounts of data are examined. Conclusion In some cases MyISAM is faster than InnoDB, but usually only … InnoDB tests, a 64GB buffer pool was used. O_DIRECT was used so, there was no caching of …
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… by most (not all) DBAs. Duplicate Index Detection I commented about this on my last webinar, but did not have time to… as you may know, we can use the second index not only for filtering on both columns, but also for filtering by… there that use MySQL, for which we at Percona tend to find redundant indexes. And second, because in some cases, we may…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
… not enough to understand why that is the case. Maybe someone more knowledgeable in MySQL internals can… file for the plugin to work (plus one commented line for switching between file and socket for output… has been an important missing feature on the server, which has made using MySQL in PCI or SOX …
Post: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
… off in the Drizzle code base. However… for those using MySQL, Percona Server, MariaDB or any other of the…, and then it’s something else (as in that case you don’t get your 80×24 terminal UI in…B’. If you noticed that if you have a long comment on each field you reduce the number of different ENUM …
Comment: Virident vCache vs. FlashCache: Part 1
May 17, 2013 By 3 Comments
… have a Samsung 830 in the laptop I’m using to write this comment on. It’s pretty fast. But it’s still… card is about 3x faster. By using a FlashCache/vCache approach with this sort of use case, I’m effectively allowing my database… even heard of the STEC caching solution prior to your comment. Maybe another Perconian will have some insight here.
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
… them saying something like, “12 full-time engineers are working on MySQL server.” The MySQL Certification program was announced. MySQL 4… MySQL Management. Monty is working on the Maria storage engine to replace Innodb for a number of use cases. The first “open core… you attending MySQL Conference over last 10 years. Please leave comment and share your experiences! Thank you. Additionally, I’d like…
Post: Open Source, the MySQL market (and TokuDB in particular)
May 10, 2013 By 13 Comments
…” in this case is really just a marketing tool. Well, I admit there are companies that also use the “Open…and community around your product. Growing public knowledge: discussions on blogs, forums, social networks. Well, of course, some or… here is my personal position, but I welcome your comments…
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
…(25) DEFAULT NULL, `l_shipmode` char(10) DEFAULT NULL, `l_comment` varchar(44) DEFAULT NULL, PRIMARY KEY (`l_orderkey`,`l_linenumber… are joining two tables on a PK column such that both tables are read in PK order. One use case that I can… run reporting queries that need to join on lookup tables which tend to be small mostly. What use cases can you think of?
Post: mk-query-digest, query comments and the query cache
… is unique and the query cache will use additional resources for no effective benefit. Luckily …The queries differ only by comments. In the best case scenario where comments are stripped we would expect …at runtime: mysql> set global query_cache_strip_comments=’ON‘; Query OK, 0 rows affected (0.00 sec…