… big numbers in PHP (gulp). For example, sometimes 32-bit identifiers are not enough and you have to use BIGINT 64-bit ids; e… However 32-bit FreeBSD with PHP 4.4.7 produces different results: s1=1.1258999068426E+15 s2=1125899906842625 The same 32-bit FreeBSD box with PHP… across systems and PHP versions. So if you’re handling large numbers stored as float (especially on 32-bit systems where 32-bit int overflow…
Post: Integers in PHP, running with scissors, and portability
March 27, 2007 By 34 Comments
…, and PHP decides to treat them as integers, you’re in trouble. Oh wait, no – that’s on 32-bit platforms only! PHP int size is platform-dependent, and it seems to be 8 bytes on our 64-bit boxes… of data from binary strings to PHP variables. What if you try to unpack unsigned 32-bit big endian integer (format code “N…
Comment: Integers in PHP, running with scissors, and portability
April 6, 2007 By 34 Comments
… problem in PHP if you try to have your code working on both 32 and 64 bit machines in parallel. In PHP, the variable… value (that’s 32 bits signed). PHP does not support unsigned integers.” You will also run into problems when doing bit shifting operations in… 64 bit systems on 32 bit systems. Imagine using a mixed environment with 32 and 64 bit servers that need to share their data. Some PHP…
Comment: Edge-case behavior of INSERT...ODKU
October 28, 2012 By 6 Comments
… running a 32-bit OS and thus 32-bit PHP. I had suitably large INT fields for autoinc in MySQL, but poor little PHP was putting them into signed 32-bit INTs…
Comment: PHP vs. BIGINT vs. float conversion caveat
January 11, 2008 By 27 Comments
… big numbers in PHP (gulp). For example, sometimes 32-bit identifiers are not enough and you have to use BIGINT 64-bit ids; e… the mess that 64-bit integers are in PHP. But if the numbers you use do not cover 64-bit range fully, floats might save the day. The trick is that PHP floats are in fact…
Comment: The #1 mistake hosting providers make for MySQL servers
July 25, 2008 By 30 Comments
Have you ever tried to build PHP 4 on RHEL 4 64bit? You will hit errors. This …, you can often find many 3rd party RPMS for 32 but not 64 bit. I suspect this is a key decision for… queries as possible. Also many how-tos are geared at 32 bit systems. For some of the larger dedicated providers (especially in…
Comment: MySQL Partitioning - can save you or kill you
July 31, 2012 By 45 Comments
… on fetching a RANDOM row: http://mysql.rjweb.org/doc.php/random SELECT … WHERE url = needs an index; else it will… of your issues. INT(255) is meaningless — INT is a 32-bit number regardless of the value you put after it. TEXT…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…. The Infobright Community Edition (ICE) 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 fail to start on a micro instance… config for 20 shards (adjust to your number of nodes) php genconfig 20 > shards.ini Running the test For best performance…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… can help performance (keeping data smaller) or can a bit slow it down. Plus there were bunch of micro … recently found and fixed: http://bugs.mysql.com/bug.php?id=29560 Concerning a switch to Oracle’s main …from 16GB, 2 two-year old HT’ed XEONs to 32 GB, 4x quad-core AMD Opterons. Yes it helped:-)….
