June 20, 2013

Post: MySQL Query Patterns, Optimized - Webinar questions followup

June 3, 2013 By 2 Comments

…the tuple syntax to look up values against multiple columns in a compound index, then the order would matter, and it would have to match the order of columns in the…

Filed Under: Insight for Developers, MySQL, MySQL Webinars Tagged With: , , ,

Post: Implementing SchemaSpy in your MySQL environment

June 4, 2013 By 2 Comments

…to leave you with the impression that this is the only component of the tool.  There are additional tabs: Tables – Names, number of children, parents, count of columns…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: ,

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

…column to the table which was an integer PK, and in another attempt, I tried just making the “value” column the PK, but neither of those worked. Also, trying to…the speed of InnoDB FTS compare to its MyISAM counterpart, and what kinds of tricks can we use to make it go faster? Stay tuned to find out…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: Shard-Query EC2 images available

May 11, 2011 By 2 Comments

…Query for yourself. Spin up the desired number of EC2 instances using on of the the AMI images. You should spin a number of…in the list of columns to show (click show/hide to change the columns) That the “public dns” field is selected SSH to the public DNS entry of the node on the list of…

Filed Under: MySQL

Post: Multi Column indexes vs Index Merge

September 19, 2009 By 31 Comments

…to estimate number of rows it will find using both indexes and as they are about the same it picks smaller index. The query…of doing full table scan or doing the Union (instead of intersection) on values it gets from the single table. I have reverted table to have i1 and i2 as independent columns in…

Filed Under: Insight for DBAs, MySQL Tagged With:

Post: Quick comparison of MyISAM, Infobright, and MonetDB

September 29, 2009 By 30 Comments

…tables with many columns (the same one Peter wrote about recently). The client’s performance is suffering in part because of the number of columns, which is over 200. The queries…I had to go to the mailing lists to find the correct COPY syntax — it wasn’t that listed in the…

Filed Under: MySQL Tagged With: , , ,

Post: Full Text Search Webinar Questions Followup

August 24, 2012 By 5 Comments

…to retrieve the same number of rows on each benchmark (I noticed 100 rows on SQL and 20 on Sphinx). Also Sphinx does the…in sync, will the out-of-sync rows not be found? No, only the documents included in the Sphinx Search indexes will be returned by Sphinx Search queries…

Filed Under: Events and Announcements, Insight for Developers, MySQL

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

…I check some of the other I_S tables, I do find that the number of rows in I_S.innodb_ft_index_table is changing, so it’s pretty clear that I do…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: How to debug long-running transactions in MySQL

March 8, 2011 By 6 Comments

…I find out the TCP port for that connection. I then sniff TCP traffic for a while, use mk-query-digest to convert this into a query…the ID in SHOW PROCESSLIST, and look in the Host column; there you’ll see a hostname followed by a port number. That is the port number of the…

Filed Under: Insight for DBAs, MySQL

Post: Using CHAR keys for joins, how much is the overhead ?

June 18, 2007 By 18 Comments

…I would expect us to see different ratio. The query I use here is constructed to stress out join code while avoid sending data to the client Do not try to find…

Filed Under: Insight for Developers Tagged With: , , ,
« Older Posts