…INCREMENT | 8 | 64 | | MAX_CONNECT_ERRORS | 10 | 100 | | SORT_BUFFER_SIZE | 2097152 | 262144 | | LC_MESSAGES_DIR | /mnt/nfs/dist/mysql…buffer was very expensive. It can negatively impact some large sorts though …users. Considering the default innodb_auto_extend_increment is 64 starting with 64M might…
Post: Announcing Percona Server 5.1.66-14.2
January 15, 2013 By Leave a Comment
…and from the Percona Software Repositories). Based on MySQL 5.1.66, including all the bug … in a way which lead to a negative value being printed in the slow query log…with respect to AUTO_INCREMENT columns. Bug fixed #1039536 (Alexey Kopytov). In cases where indexes with AUTO_INCREMENT columns …
Post: The Optimization That (Often) Isn't: Index Merge Intersection
December 14, 2012 By 6 Comments
… that had single-column indexes on them, MySQL could sometimes make use of the multiple indexes… TABLE users ( user_id INT UNSIGNED NOT NULL AUTO_INCREMENT, parent_id INT NOT NULL DEFAULT 0, … more quickly may end up creating unintended negative consequences elsewhere. We could rewrite the query …
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
…key (NCPK – an auto_increment column) in nearly (emphasize nearly) every InnoDB table can have very serious and negative performance implications. Remember that…by people with traditional database background. > Things are different with MySQL. Good design will help dictate how many tables are …
Post: Can having information public hurt consulting business ?
April 30, 2008 By 9 Comments
… us but think it also have significant negative effect because people find information on MySQL Performance Blog and use it instead of… recipes. Besides experience you really need the constant practice. Doing MySQL Optimization I have to keep thousands of facts in my…’re doing insert in table with auto increment which uses table level auto increment locks unless you’re running MySQL 5.1 with…” To analyze…
Post: Announcing Percona Server 5.5.28-29.3
January 8, 2013 By 2 Comments
…and from the Percona Software Repositories). Based on MySQL 5.5.28, including all the bug …calculated in a way which lead to a negative value being printed in the slow query log…if the optimization is applicable with respect to AUTO_INCREMENT columns. Bug fixed #1039536 (Alexey Kopytov). Upstream bug …
Comment: Hacking to make ALTER TABLE online for certain changes
May 22, 2008 By 26 Comments
… an unsigned INT. MySQL uses twos complement for negative ints and knowing that a table doesn’t contain any negative values, it was…; mysql> ALTER TABLE Citytmp MODIFY ID INT UNSIGNED NOT NULL AUTO_INCREMENT; # cp /var/lib/mysql/world/Citytmp.frm /var/lib/mysql/world/City.frm mysql…
Post: Innodb row size limitation
April 7, 2011 By 12 Comments
… table structure: CREATE TABLE example ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, fname TEXT NOT NULL, fcomment TEXT, ftitle TEXT NOT NULL…) ) Engine=InnoDB; Now you insert some test data into it: mysql> INSERT INTO example -> VALUES ( ->Â Â NULL, ->Â Â ‘First… and you use MySQL‘s built in functions for handling this data. This approach, however, does have other negative impact, as it…
