….25 EC2 Compute Units each) 1690 GB of instance storage 64-bit platform I/O Performance: High API name: m2.4xlarge As…
Post: Percona welcomes Drizzle 7.1
April 10, 2012 By Leave a Comment
… Drizzle manual. Note: For Drizzle 7.1.33-stable, only 64-bit packages were built for RedHat/Centos.
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… 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: Integers in PHP, running with scissors, and portability
March 27, 2007 By 32 Comments
… 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 32 Comments
… try to have your code working on both 32 and 64 bit machines in parallel. In PHP, the variable size of the… function which may give you different results on 32 and 64 bit machines if you do not reformat its results with dechex… 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…
Post: PHP vs. BIGINT vs. float conversion caveat
January 10, 2008 By 25 Comments
… (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
… 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… of RAM, and forgot to tell them 64-bit OS, and they actually listed 32-bit explicitly on the quote — useless! I would… pretty silly to me. 64-bit hardware and operating systems aren’t new anymore. In fact, 32-bit is hard to find in…
Comment: PHP vs. BIGINT vs. float conversion caveat
January 11, 2008 By 25 Comments
… (gulp). For example, sometimes 32-bit identifiers are not enough and you have to use BIGINT 64-bit ids; e.g. if you… 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…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
… LTS (lucid) Kernel | 2.6.32-31-server Architecture | CPU = 64-bit, OS = 64-bit # Processor ################################################## Processors | physical = 2, cores = 12, virtual = 24, hyperthreading…-thread performance by 5-10%. Sequential write results were a bit more interesting. With WT (write-through) cache enabled, performance was…
Comment: Limiting InnoDB Data Dictionary
February 12, 2009 By 13 Comments
… ILP or SILP) model for 64 bit handling (http://en.wikipedia.org/wiki/64-bit) In fact, the whole 64 bit support on Windows in compiler and SDK and reference compiler on this platform (MSVC) has been LLP on 64 bit (long…
