June 20, 2013

Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL

June 10, 2013 By 3 Comments

…, INDEX_STATISTICS, TABLE_STATISTICS, THREAD_STATISTICS, and USER_STATISTICS) led to the maximum counter values being limited to 32-bit signed integers… 64-bit unsigned integers now. Bug fixed #714925. mysql_set_permission was failing on Debian due to missing libdbd-mysql-perl package. Fixed…

Filed Under: MySQL, Percona Server, Percona Software Tagged With:

Post: Percona Server 5.6.11-60.3 first Release Candidate now available

June 3, 2013 By 3 Comments

… id=”attachment_13396″ align=”alignright” width=”247″] Percona Server for MySQL version 5.6.11-60.3[/caption] Percona is glad…, INDEX_STATISTICS, TABLE_STATISTICS, THREAD_STATISTICS, and USER_STATISTICS) led to the maximum counter values being limited to 32-bit signed integers. Fixed so that these values can be 64-bit unsigned integers now. Bug fixed #714925. Server…

Filed Under: MySQL, Percona Server, Percona Software Tagged With: ,

Post: Benchmarking Percona Server TokuDB vs InnoDB

May 7, 2013 By 32 Comments

… sbtest$I ( id BIGINT UNSIGNED NOT NULL, k INTEGER UNSIGNED DEFAULT ’0′ NOT NULL, c CHAR(120) …(60) DEFAULT ” NOT NULL, PRIMARY KEY (id) ) CREATE INDEX k on sbtest$I(k) and tables …myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables TokuDB-related…

Filed Under: Benchmarks, MySQL, Percona Server Tagged With: , , ,

Post: Common MySQL traps webinar questions followup

January 17, 2013 By 1 Comment

…the master, so they may benefit from different indexing Q: Is there a Percona recommendation for finding… the values will be stored internally as an integer and they will only need 1 byte per …Q: Are these recommendations true of all versions of MySQL? If not which versions? The recommendations I made…

Filed Under: MySQL

Post: Wow. My 6 year old MySQL Bug is finally fixed in MySQL 5.6

August 30, 2012 By 2 Comments

…while still being with MySQL) and running MySQL 4.1 I… | i | 4 | const | 81602 | Using where; Using index | +—-+————-+——-+——+—————+——+———+——-+——-+————————–+ 1 row in set, 1…for not overly large positive integers. Consider using strict mode…

Filed Under: Insight for DBAs, MySQL

Post: Why Index could refuse to work ?

September 8, 2006 By 15 Comments

…, even if MySQL is mentioning it in “possible keys” ? Should you try to force it ? mysql> explain select * from article force index (PRIMARY… may ask why MySQL can’t use index in this case, simply by converting number to the string and performing index lookup ? This… – you can refer to integer column as a string in most cases and MySQL will use the index, as for any string there…

Filed Under: Insight for DBAs Tagged With:

Post: Join performance of MyISAM and Innodb

May 29, 2006 By 6 Comments

… same integers so we can allow the same job to be done using different kinds of columns – primary key, integer indexed column and indexed char column. The query is also trivial – the point was to make sure it is not index covered… one row which matches the index, so there is no need for MySQL to request next row matching index Note: This applies to…

Filed Under: Benchmarks Tagged With: , ,

Post: Falcon Storage Engine Design Review

January 12, 2007 By 19 Comments

… unusual, which people do quite frequently with MySQL :) [+] Compact Indexes Compact Indexes are great. Huge indexes is where large portion of Innodb performance problems… compression methods, for example using only as many bytes for integer as it requires, not storing column value if it is…

Filed Under: Insight for DBAs Tagged With:

Comment: How to find wrong indexing with glance view

August 22, 2008 By 27 Comments

… (or should) test the queries. Of course integer indexes with high cardinality will beat string indexes – unless you need to search by partial… from that index without losing any performance. And there’s the problem of mysql choosing single column indexes where multi-column indexes are present…

Filed Under: Insight for DBAs Tagged With:

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

… name, address, and the like. We are using MySQL 5.5.30 and MySQL 5.6.10 with no configuration tuning other… of GEN_CLUST_INDEX causing me issues, I tried adding a second column to the table which was an integer PK, and…_min_token_size to 1, dropped/rebuilt the InnoDB index, and tried again. mysql: SELECT id, full_name, MATCH(full_name, details…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,
« Older Posts