… 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 27 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.
Comment: Feature Idea: Finding columns which query needs to access
November 18, 2006 By 16 Comments
…, does not make sense, why pass the statement as a string, you should have a SHOW command rather than this, etc… schema. third, it makes sense to pass it as a string. That way you can join to VIEW_DEFINITION and ROUTINE… ROUTINES columns More purposes: refactoring code (renaming identifiers etc) but then the parse_tree table would also need the exact string position…
Post: Handling big result sets
June 26, 2006 By 13 Comments
… from int to the string and client has to do reverse conversion. This takes time. Furthemore string data takes more space which also… because of binary protocol and so no data conversion to string as with standard protocol
Comment: Slow Query Log analyzes tools
January 30, 2007 By 84 Comments
… Include only queries which examined min_rows_examined rows or more -iu=include_user Include only queries which contain include_user… [multiple] -iq=include_query Include only queries which contain the string include_query (i.e. database or table name) [multiple] –filter-duplicates Output only unique query strings with additional statistics: max_query_time, max_rows_examined, execution…
Post: My Innodb Feature wishes
May 4, 2006 By 30 Comments
… first 700 bytes or something like that from any blob/string in the page. Which gives you the nice surprise of… to fit to the page if many columns are long strings. I would like to see it at least doing it… otherwise with raise of MultiCores Innodb will become unusable for more and more types of workloads What would your Innodb feature wishes…
Comment: Be careful when joining on CONCAT
October 17, 2007 By 16 Comments
… more thing about it – generally this choice of making Number a binary string is counter intuitive to me. The number is a string… other argument. Though I do not know may be this more intuitive solution would some ugly side effects.
