…: innodb_log_file_size = 64M (without the “B” in “MB” string) This works on my site on a Debian Squeeze system… that options at any time to 256M when I need more “power”. Not sure what the MySQLDB performance cracks like Baron… trouble if you are not going to choose 64M or more (but e.g instead of 32M x 4 = 128M innodb…
Post: Idea: Couple of more string types
April 18, 2008 By 12 Comments
… is quite inconvenient to deal with strings like that in MySQL. Either you store them as strings and waste space or you… as binary and deal with inconvenience of having not readable strings in the table OR adding UNHEX() everywhere – which also adds… client and compress bad. Though this is likely to require more significant changes in MySQL so I would not expect to…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… msl patch grew with new features to let people learn more details of query execution, normally hidden from everyone’s eyes… just assign an empty string “” to this option. Note: you should put double quotes around the entire string of comma-separated flags…,innodbâ€. Note: You should put double quotes around the entire string of comma-separated flags. Currently “microtime†is mandatory meaning…
Post: To pack or not to pack - MyISAM Key compression
May 13, 2006 By 3 Comments
… Innodb. In this article I’ll get in a bit more details about packed keys and performance implications it causes. First… understand performance implications of this approach. Note trailing spaces for strings are not stored in the index even if it is… of special hack 
The fact MyISAM will by default compress string keys but not integer keys is the biggest reason joins…
Comment: Why MySQL could be slow with large tables ?
March 12, 2007 By 139 Comments
… query, which takes 93 seconds ! SELECT TITLE FROM GRID WHERE STRING = ‘sport’; When I run the query below, it only takes…(*) FROM GRID WHERE STRING = ‘sport’; So while the where-clause is the same, the first query takes much more time. The slow… ? CREATE TABLE `GRID` ( `ID` bigint(20) NOT NULL auto_increment, `STRING` varchar(100) character set utf8 collate utf8_unicode_ci NOT…
Post: Innodb usability and ease of use.
September 28, 2007 By 14 Comments
… way would be of course to use some string values which are more self explanatory so at least you can’t mix… of 0,1,2 will be more explanatory. Furthermore MySQL even has infrastructure to support both string and integer values, which would…” and “interleaved” ? Using string values would make things much more friendly with my.cnf and “show variables” output being more obvious and self…
Post: Picking datatype for STATUS fields
August 9, 2008 By 24 Comments
… allowed values for such field anyway. For status fields with more than two values there are commonly following choices: VARCHAR(N… ENUM declaration – not according to their string values. So make sure to add values specify strings for ENUM in sorted way to… a discipline and have the table which has integer to string mapping or at least have constants with descriptive names defined…
Comment: Speeding up GROUP BY if you want aproximate results
March 7, 2008 By 24 Comments
Dale, the problem is String-operations are really slow. if you want to compare two strings all chars have to be the… very hard to compare two Strings. And if you want to compare 5million Strings this will be much more to do. Comparing integers…-bit integer which can be compared by the CPU directly, Strings have to be compared in the application, there’s no…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… 100% yes, 0% no # String: # Databases wp_blog_one (264/84%), wp_blog_tw… (36/11%)… 1 more # Hosts # InnoDB trxID 86B40B… 100% yes, 0% no # String: # Databases wp_blog_one (105/70%), wp_blog_tw… (34/22%)… 1 more # Hosts # InnoDB trxID 86B40F…_blog_one (105/70%), wp_blog_two (34/22%)… 1 more # Query_time distribution # 1us # 10us # 100us ################### # 1ms ################################################################ # 10ms # # 100ms # 1s…
Comment: PHP vs. BIGINT vs. float conversion caveat
January 11, 2008 By 25 Comments
…, I don’t see any strings there. Peter just made a typo. I explicitly mentioned conversion TO string, in bold. > in both… 754 section on 64-bit doubles (it’s a bit more trusted source than php.net/float by the way). Doubles… solution in some scenarios. It’s only the float to string conversion which suddenly, and unexpectedly, fails.
