…-3915). Bug fixed #1172090. OpenSSL libraries were not found in 32-bit builds due to a typo. Bug fixed #1175447. Query to… maximum counter values being limited to 32-bit signed integers. Fixed so that these values can be 64-bit unsigned integers now. Bug fixed…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 4 Comments
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
… maximum counter values being limited to 32-bit signed integers. Fixed so that these values can be 64-bit unsigned integers now. Bug fixed…
Post: Testing the Micron P320h
April 16, 2013 By 7 Comments
… both very strong and very steady, coming in at a bit over 1730MiB/sec with a standard deviation of a bit less than 13MiB/sec. When we calculate in the fact … read reaches peak capacity somewhere between 32 and 64 threads, and synchronous write tops out somewhere between 64 and 128 threads. The latency…
Post: Integers in PHP, running with scissors, and portability
March 27, 2007 By 34 Comments
…’s on 32-bit platforms only! PHP int size is platform-dependent, and it seems to be 8 bytes on our 64-bit boxes… happy. Unfortunately, my final goal was to have support for 64-bit document IDs… Let’s do a small time travel. Integer… there’s no native 64-bit integer type in PHP. Let me remind that built-in “int” might be 64-bit, but then again…
Comment: Integers in PHP, running with scissors, and portability
April 6, 2007 By 34 Comments
… if you try to have your code working on both 32 and 64 bit machines in parallel. In PHP, the variable size of… the crc32 function which may give you different results on 32 and 64 bit machines if you do not reformat its results with… big int values serialized on 64 bit systems on 32 bit systems. Imagine using a mixed environment with 32 and 64 bit servers that need to share…
Post: PHP vs. BIGINT vs. float conversion caveat
January 10, 2008 By 27 Comments
… PHP (gulp). For example, sometimes 32-bit identifiers are not enough and you have to use BIGINT 64-bit ids; e.g. if you… about the mess that 64-bit integers are in PHP. But if the numbers you use do not cover 64-bit range fully, floats… are in fact doubles, i.e. double-precision 64-bit numbers. They have 52 bits for mantissa, and integer values up to 2…
Post: The #1 mistake hosting providers make for MySQL servers
July 25, 2008 By 30 Comments
… install 32-bit GNU/Linux operating systems on 64-bit hardware. This is a serious mistake. You have to tell them to install a 64-bit… 8GB of RAM, and forgot to tell them 64-bit OS, and they actually listed 32-bit explicitly on the quote — useless! I would… looks pretty silly to me. 64-bit hardware and operating systems aren’t new anymore. In fact, 32-bit is hard to find in…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… 10.04.2 LTS (lucid) Kernel | 2.6.32-31-server Architecture | CPU = 64-bit, OS = 64-bit # Processor ################################################## Processors | physical = 2, cores = 12, virtual… logical volume slightly below 1TB. Investigating this I found that 32-bit xfs inodes (which are used by default) have to live…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… things. One thing is that I’m looking at a 64-bit OS, which is important to know. I also know I… is a 64-bit CPU. From this and what I saw earlier I can see whether someone installed a 32-bit OS on 64-bit hardware…’ command) whether /usr/libexec/mysqld is a 64-bit build, if I’m on a 64-bit OS. Examining MySQL configuration Then I’ll…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…) images are available in 32 and 64 bit varieties. Due to memory requirements, the InnoDB versions are only available on 64 bit instances. MySQL will… Name Arch Notesami-20b74949 shard-query-infobright-demo-64bit x86_64 ICE 3.5.2pl1. Requires m1.large or larger ami…-definition-cache=16384 table-open-cache=128 thread-cache-size=32 thread-stack=256K tmp-table-size=64M transaction-isolation=READ…
