…MySQL server developers. The Valgrind Memcheck tool, which is synonymous with Valgrind itself, is relatively widely used for the MySQL… there we find a comment: /* A problem: we assume that mutex_reset_lock …_status_array(THD*, char const*, st_mysql_show_var*, enum_var_type, system_status_var*, char…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
Post: Enum Fields VS Varchar VS Int + Joined table: What is Faster?
January 24, 2008 By 27 Comments
… 1) Table with ENUM: CREATE TABLE cities_enum ( id int(10) unsigned NOT NULL auto_increment, state enum(‘Alabama’,'… MySQL to discard first 10000 records. 1) Results for ENUM: select SQL_NO_CACHE city from cities_enum …is other story. To avoid part of this problem we of course arrange state ids in …
Comment: Enum Fields VS Varchar VS Int + Joined table: What is Faster?
January 24, 2008 By 27 Comments
…! In our application, we’re mostly using ENUM‘s for these kind of problems (mostly because table size really is an issue… an application level. The problem we had with ENUM-fields; When we wanted to add a ‘type’ to an ENUM-field (or change the definition of the field in any way), MySQL often did a complete rewrite…
