June 19, 2013

Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL

…-3915). Bug fixed #1172090. OpenSSL libraries were not found in 32-bit builds due to a typo. Bug fixed #1175447. Query to… 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.6.11-60.3 first Release Candidate now available

… 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… 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

…strong and very steady, coming in at a bit over 1730MiB/sec with a standard …peak capacity somewhere between 32 and 64 threads, and synchronous write tops out somewhere between 64 and 128 threads….over 3ms. How well does it perform with MySQL? Exact results vary, depending upon the usual factors …

Post: The #1 mistake hosting providers make for MySQL servers

… 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… gladly install 8 or 16GB of memory for you, but MySQL can’t use it because it runs in a single… 8GB of RAM, and forgot to tell them 64-bit OS, and they actually listed 32-bit explicitly on the quote — useless! I would…

Post: Aligning IO on a hard disk RAID – the Benchmarks

…2 LTS (lucid) Kernel | 2.6.32-31-server Architecture | CPU = 64-bit, OS = 64-bit # Processor ################################################## Processors | physical = 2, cores =… IO alignment, not different MySQL configurations, I didn’t try out different MySQL versions or settings. Moreover…

Post: How Percona does a MySQL Performance Audit

… 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… check what the MySQL version is, and I check (with the ‘file’ command) whether /usr/libexec/mysqld is a 64-bit build, if I’m on a 64-bit OS. Examining MySQL configuration Then I’ll look at…

Post: Shard-Query EC2 images available

… 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…=’Contains all avaialble data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’G *************************** 1…=128 thread-cache-size=32 thread-stack=256K tmp-table-size=64M transaction-isolation=READ-COMMITTED user=mysql wait-timeout=86400 To…

Post: MySQL, AIX5L and malloc()

… from the beginning.. For any reason, you decided to run MySQL database on AIX 5L operating system. You compiled it successfully…*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…

Post: TPC-H Run on MySQL 5.1 and 6.0

… which this box had. MySQL Also was very slow running some queries so we changed scripts a bit to kill extremely long… to 3 hours to give MySQL more time to complete the queries: Query MySQL 5.0.23 MySQL 6.0.4Ratio Query13784.453737… for query processing was not too bad, however with 16,32,64 cores it is just too bad.

Post: Percona Live London 2012: Percona XtraDB Cluster in a nutshell

… session. Two versions are available: PLUK 2012 Appliance (32-bit) PLUK 2012 Appliance (64-bit) How to test them: Open the downloaded file with…