…substantial difference for the database and application performance. Over time msl patch grew with new…mysql-5.0.51a/ mysql-5.0.51a/bdb/ mysql-5.0.51a/bdb/Makefile.in mysql-5.0.51a/bdb/btree/ mysql…You should put double quotes around the entire string of comma-separated flags. Currently “microtimeâ…
Post: Handling big result sets
June 26, 2006 By 13 Comments
…(true); // Performing SQL query $query = ‘SELECT * FROM longf’; $result = mysql_query($query) or die(‘Query failed: ‘ . mysql_error()); // retrive result while ($line = mysql_fetch… data from MySQL prepared statements may also perform better, probably because of binary protocol and so no data conversion to string as with…
Post: Be careful when joining on CONCAT
October 16, 2007 By 16 Comments
The other day I had a case with an awful performance of a rather simple join. It was a join on… a look at MySQL manual and here’s a short quote about CONCAT: …If all arguments are non-binary strings, the result is a non-binary string. If the arguments include any binary strings, the result is a binary string. A…
Post: Where does HandlerSocket really save you time?
March 16, 2011 By Leave a Comment
… ease-of-use and blazing-fast performance. The performance comes from eliminating CPU consumption…..8690JOIN::optimize() 1771201.8317row_search_for_mysql 1711851.7703lex_one_token(void*,void*)…int) 65301.4980JOIN::prepare(…) 61751.4165Protocol::store_string_aux(…) 57481.3186create_ref_for_key(…)…
Post: Innodb usability and ease of use.
September 28, 2007 By 14 Comments
… product usability/ease of use, when it comes to settings, performance management etc. I could understand many things 5 years ago…,1,2 will be more explanatory. Furthermore MySQL even has infrastructure to support both string and integer values, which would allow to… have to be translated to “traditional”, “consecutive” and “interleaved” ? Using string values would make things much more friendly with my.cnf…
Comment: To UUID or not to UUID ?
April 15, 2008 By 28 Comments
…. Ideally, MySQL would have a UUID column type to store the values as binary rather than strings but convert to string anytime the… case-sensitive 22-byte UUID representation (VTIW7xOgReOGrL3vMRjm4Q, for example). The performance increase was enormous, and the overhead is much smaller (22…
Comment: Speeding up GROUP BY if you want aproximate results
March 7, 2008 By 24 Comments
… if you have auto populated string lookup table – this one tends to get short typical strings in lower values. I’…but probably better than Innodb row count estimate 
mysql> select avg(length(page)) from performance_log_080306; +——————-+ | avg(length(page)) | +——————-+ | 71….
Comment: MySQL Installation and upgrade scripts.
May 21, 2007 By 3 Comments
…, “check for upgrade” did not trigger table repairs (bad, varchar string comparison with trailing spaces might return different from expected results… upgrade” repairs, problems with merge tables, performance problems while table is updated by PK = empty string (actially is was an application side… present time I decided to upgrade to 5.0.36sp1 (MySQL Enperprise) it seems to be the most stable release, it…
Post: Looking at Redis
August 27, 2009 By 27 Comments
… Still with 100K+ operations a second this single core performance will be good enough for many applications. Also … as sets which allow to store sets of strings with support of various set operations. I kind … row updates which are hard to batch. With MySQL/Innodb I got server being able to handle …
Post: Using CHAR keys for joins, how much is the overhead ?
June 18, 2007 By 18 Comments
… with first simple MyISAM table and join query performed on INT fields: CREATE TABLE `intjoin` ( `i` int(… was expected this to shorten some internal buffers MySQL has to allocate for key comparison as … Finally I decided to check if using longer strings slows down things significantly and so I …
