… being limited to 32-bit signed integers. Fixed so that these values can be 64-bit unsigned integers now. Bug fixed #714925. mysql_set_permission was failing on Debian due to missing libdbd-mysql-perl package…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
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… available here and from the Percona Software Repositories). Based on MySQL 5.6.11, including all the bug fixes in it… 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…
Comment: PHP vs. BIGINT vs. float conversion caveat
January 11, 2008 By 27 Comments
…MySQL Performance Blog wrote an interesting post today on PHP vs. … the server ID into high bits of the ID. I had already written about the mess that 64-bit integers are in PHP. But if the numbers you use do not cover 64-bit range fully, floats might…
Comment: MySQL automatic data truncation can backfire
January 10, 2007 By 10 Comments
… 64bit php returns a 64 bit signed integer which wont wrap at the same position as a 32bit signed integer. I’ve solved my… is negative and then store all crc32 values as unsigned integers in mysql.
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
…test and creating 100.000 tables with single integer column. The process of creating tables took about…cache=64 and tried innodb_open_files=64 and 16384. Reading 100.000 tables first time after MySQL time…data dictionary. More complicated tables can take a bit more. So innodb_open_files does not …
Post: table_cache negative scalability
November 16, 2009 By 23 Comments
…have created 100.000 empty tables containing single integer column and no indexes and when ran SELECT *…frm option is used. With default table_cache=64 accessing all tables take 12 sec which is…bit worse than MySQL 5.0.85. So the problem is not fixed in MySQL 5.1, lets see how MySQL 5.4 behaves. MySQL…
Comment: Using CHAR keys for joins, how much is the overhead ?
June 19, 2007 By 18 Comments
…” join with short columns containing integers as a strings and LATIN1 was even a bit faster for unknown reason. … BIGINT was complete surprise for me and someone in MySQL may want to profile it in more details. … x86_64 platform so 64bit should not cause so much slow down. Innodb also is a bit slower …
