… data, not the row data for the table when you use a secondary index. Check the buffer pool …_karma` int(11) NOT NULL default ’0′, `comment_approved` enum(’0′,’1′,’spam’) NOT NULL default ’1′, `comment_… enough to use that for a count, even if it is not a unique index. For instance: mysql> explain …
Post: PROCEDURE ANALYSE
March 23, 2009 By 9 Comments
…bunch of SQL queries while really MySQL has a native feature to perform this task – PROCEDURE ANALYSE … for an instant action but rather used as a base to make your own decision. For …to ENUM though as we know new types can appear by inserts we can’t do it. In other drupal installation though when…
Comment: How well does your table fits in innodb buffer pool ?
December 9, 2010 By 12 Comments
…when using this request on MariaDB 5.2.5 110515 …_connected=120 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_…usr/sbin/mysqld(mysql_parse(THD*, char*, unsigned int, char const**)+0x2c1) [0x7fd959b606e1] /usr/sbin/mysqld(dispatch_command(enum_server_command…
Post: Lost innodb tables, xfs and binary grep
November 9, 2010 By 12 Comments
… verify your backup can be used to restore the database! If not automatically… and how data was lost: MySQL had a dedicated partition on…enum columns only, where we knew a rather unique PK, well something like 837492636 so we needed a way to… pages, but when you only have that many pages to check it’…
Post: Idea: Couple of more string types
April 18, 2008 By 12 Comments
MySQL has a lot of string data types – CHAR, VARCHAR, BLOB, TEXT, ENUM and bunch of variants such as… compress the blobs when they are inserted and retrieved from the database – this would allow to avoid having … one is optimized so if BLOB is not used in any WHERE clause (HAVING, GROUP BY etc) …
