June 18, 2013

Post: Analyzing air traffic performance with InfoBright and MonetDB

October 2, 2009 By 50 Comments

… bigger than original data. LucidDB Here it took time to find how to execute command from command line using included sqlline… am using c*1000/c2 here, because MonetDB seems using integer arithmetic and, with c/c2 I received just 1. So… if you want to compare or get info about air performance.

Filed Under: Benchmarks, MySQL Tagged With: , , ,

Post: To pack or not to pack - MyISAM Key compression

May 13, 2006 By 4 Comments

… bit of simplification but it should be enough to understand performance implications of this approach. Note trailing spaces for strings are… need to scan keyblock from the start uncompressing keys to find matching key value. This means the following will apply: Forward… times faster. With PACK_KEYS=1 we got join by integer key performing almost 5 times slower than it was – this is…

Filed Under: Insight for DBAs Tagged With: , ,

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

June 18, 2007 By 18 Comments

… avoid sending data to the client Do not try to find any good meaning for query or schema. For joins which… keys. The performance dropped down to 6.1 seconds which makes it over 2 times slower compared to integer based join. So how do I read these results ? CHAR keys are indeed slower for joins compared to integer keys Performance…

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

Post: To UUID or not to UUID ?

March 13, 2007 By 28 Comments

…the same point – be careful applying benchmarks you find in the Internet to your own case, it…are: I’ve created MyISAM tables containing just integer auto_increment primary key and containing char(36)… this little case we have about 200 times performance difference which is worth to consider Can UUID…

Filed Under: Insight for Developers Tagged With:

Post: Falcon Storage Engine Design Review

January 12, 2007 By 19 Comments

… are done specially for Falcon you might find those aspects positive. [-] No Spinlocks Falcon does … Huge indexes is where large portion of Innodb performance problems come however. We should however see how … for example using only as many bytes for integer as it requires, not storing column value …

Filed Under: Insight for DBAs Tagged With:

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

March 4, 2013 By 7 Comments

…will be exactly identical to the same query when performed against InnoDB data, OR that the results returned by…a second column to the table which was an integer PK, and in another attempt, I tried just making…MyISAM able to locate this record but InnoDB cannot find it at all? I suspect that the “B” …

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

Comment: How to find wrong indexing with glance view

August 23, 2008 By 27 Comments

… – gender, has_foto; enums – available, looking_for, location; integer – age 3) All queries fall into X IN …understand that mysql finds one set using an index, another set and then finds records which exist … If you’re smart enough and read mysql performance related articles then you’ll store all …

Filed Under: Insight for DBAs Tagged With:

Post: Common MySQL traps webinar questions followup

January 17, 2013 By 1 Comment

… indexing Q: Is there a Percona recommendation for finding Hot Spots in a high load application? Or …archived’), the values will be stored internally as an integer and they will only need 1 byte per value…or practices. Of course I’m biased but High Performance MySQL 3rd edition is a very good book. …

Filed Under: MySQL

Post: Quick comparison of MyISAM, Infobright, and MonetDB

September 29, 2009 By 30 Comments

… same one Peter wrote about recently). The client’s performance is suffering in part because of the number of…MonetDB for it). I created a table with 200 integer columns and loaded it with random numbers between 0… I had to go to the mailing lists to find the correct COPY syntax — it wasn’t that …

Filed Under: MySQL Tagged With: , , ,

Post: Edge-case behavior of INSERT...ODKU

October 27, 2012 By 6 Comments

…on a customer issue wherein they were observing database performance that dropped through the floor (to the point … was a single table with an auto-incrementing integer PK and a secondary UNIQUE KEY. The queries …, but then it checks the UNIQUE KEY and finds a violation, so instead it does an UPDATE. …

Filed Under: Insight for DBAs, Insight for Developers, MySQL
« Older Posts