… 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 operating system. If… medium-high-end system with 8GB of RAM, and forgot to tell them 64-bit OS, and they actually listed 32-bit explicitly on… looks pretty silly to me. 64-bit hardware and operating systems aren’t new anymore. In fact, 32-bit is hard to find in server…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… 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… good idea what hardware and operating system I’m working with. System performance Next I investigate what the system is doing, in terms of performance. There are two key commands for this on most operating systems (there are…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
… System Summary Report ############################## Platform | Linux Release | Ubuntu 10.04.2 LTS (lucid) Kernel | 2.6.32-31-server Architecture | CPU = 64-bit, OS = 64-bit… threads and total size of 256G. While the number of operations per second was slightly lower, the difference was still 15…
Comment: Integers in PHP, running with scissors, and portability
April 6, 2007 By 32 Comments
… Excel and that code happily used pack, unpack and bit shift operations all over the place without caring about int size, e… 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… also had issues on 64bit systems in the past, e.g. cracklib did not work on 64 bit some time ago because it…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…32 and 64 bit varieties. Due to memory requirements, the InnoDB versions are only available on 64 bit instances. … should be an even data distribution in the system. To get an even distribution, the test … storage for hash joins and other background operations. This will have a direct impact in …
Post: MySQL, AIX5L and malloc()
November 3, 2008 By 11 Comments
… reason, you decided to run MySQL database on AIX 5L operating system. You compiled it successfully, configured and.. unluckily database didn’t…*256MB ) which is maximum value for 32-bit compiled applications. But how to deal with 64-bit systems? It’s quite easy, but you have to remember about setting OBJECT_MODE to 64 for both, self…
Comment: MySQL Server Memory Usage
September 27, 2011 By 18 Comments
… the SAME box. The specs are: Operating System: Debian GNU/Linux 5.0 Lenny/Stable (64 bit) Dual Processor Quad Core Xeon 2 x…
Post: Evaluating IO subsystem performance for MySQL Needs
March 5, 2008 By 23 Comments
…important for log writes, which are synchronous IO operation database performance which typically have rather close …-threads=64 –file-test-mode=rndwr cleanup sysbench v0.4.8: multi-threaded system evaluation benchmark…has. We have even a bit more than 8x because 64 outstanding requests allow RAID …
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
… not surprising as logical operation of opening file is rather fast on local file system – one can open… second time) . Whenever innodb_open_files_limit was 64 (virtually all misses ) or 16384 (all hits) …data dictionary. More complicated tables can take a bit more. So innodb_open_files does not …
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…. After that, a segment always reserves whole 64 page extents. Thus, the answer to the question…checkpointing one of little known aspects of Innodb operations while I see it causing problems every so…pages would require a bit more work. Now it is allocated permanently in the system tablespace when …
