… naming issue that could lead to unresolved package dependencies when installing Percona Server 5.1. Bug fixed #893860. The log tracker… #1167109. Fixed the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack on… to 32-bit signed integers. Fixed so that these values can be 64-bit unsigned integers now. Bug fixed #714925. mysql_set…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
Post: Upgrading MySQL
January 5, 2010 By 24 Comments
… larger leap in minor version – Upgrade of MySQL 5.0.30 to 5.0.32 is generally likely to expose less issues… used application rather than your site which exists in single installation – Wordpress, vBulletin etc. With such software, if you’re not… tool will run SELECT queries on both new and old MySQL installations and check result set, explain plan and execution time, reporting…
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… more memory — and they will gladly install 8 or 16GB of memory for you, but MySQL can’t use it because it… to tell them 64-bit OS, and they actually listed 32-bit explicitly on the quote — useless! I would estimate about…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…of MySQL 5.0 and 5.1 installations that would upgrade or are in the process of upgrading to MySQL … | 1 | 46.78110075 | ALTER TABLE test add column c char(32) default ‘dummy_text’ | +———-+————-+————————————————————-+ 1 row in set (0….
Post: Percona Server on the Nexus 7: Your own MySQL Database Server on an Android Tablet
February 28, 2013 By 11 Comments
… Linux installation, with a difference that this is an ARMv7 architecture, so we won’t be able to download regular 32 or…. So we install build environment apt-get install build-essential cmake libncurses5-dev bison libaio-dev download Percona Server MySQL source code wget… -j2 make install and if everything goes as expect we will have binaries in /usr/local/mysql, which we start mysql> show variables…
Post: High availability for MySQL on Amazon EC2 – Part 2 - Setting up the initial instances
June 29, 2010 By 9 Comments
….compute-1.internal.57802 > domU-12-31-39-07-C8-32.compute-1.internal.694: UDP, length 211 20:38:36… ] Install MySQL For the sake of simplicity, we will just install the MySQL version in the Ubuntu repository by doing: root@hamysql:~# apt-get install mysql-server-5.1 The package install MySQL has…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… and what I saw earlier I can see whether someone installed a 32-bit OS on 64-bit hardware, which is important… can check whether MegaCli is installed, and use it to get information about the physical drives installed; then I can find out…’s a /var/lib/mysql and an /etc/my.cnf, and the server is installed in /customsoftware/mysql with a different my.cnf…
Post: Can't Create Thread: Errno 11 (A Tale of Two Ulimits)
February 4, 2013 By 12 Comments
…’s just a standard default installation. If we do a fresh reboot of the machine, allow MySQL to start up as a…’ll just install the fresh RPMs and restart mysqld. Or perhaps we had some other cause to restart the MySQL server; the… MySQL server restart…. As it turns out, we do. On kernel 2.6.32 and later (and luckily for us, 2.6.32…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… atomically, not just for new connections as in MySQL. This is very helpful for measurement as otherwise … that are logged using the general query log. Installing pt-query-digest tool (as well as other …49M vsz # Current date: Thu Dec 29 07:09:32 2011 # Hostname: somehost.net # Files: slow-query.log.1…
Comment: Choosing innodb_buffer_pool_size
December 5, 2011 By 39 Comments
Prem: Sounds like you have a 32-bit version of mysql installed likely because you have a 32-bit Linux. MySQL can not use more than 2G of ram on 32 bit platform. The 1173M plus the other buffers you have (or defaults) and its overhead are not letting you go much higher.
