… the patch is. First you should determine how your current MySQL installation was built, so you can have the new binary to… to have the patched MySQL installed in the system. Locate where the original mysqld binary is with: (garfield:~/work/mysql-5.0.51a…] Log slow queries to this log file. Defaults logging to hostname-slow.log file. Must be enabled to activate other slow…
Post: Is DNS the Achilles heel in your MySQL installation?
May 31, 2008 By 16 Comments
… need to restrict MySQL users based on hostnames? If you don’t, you should probably disable this feature of MySQL‘s authentication system….cnf file and restart MySQL. But before you do that, run the following command: mysql> SELECT user, host FROM mysql.user -> WHERE host… disable DNS resolution. For more information on how and why MySQL does both a forward and reverse DNS lookup on authentication…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…am constantly referring to the amazing MySQL manual, especially the option and variable reference table. But just….commanual Com_insertblogpercona.commanual Com_insert_selectblogpercona.commanual Com_install_pluginblogpercona.commanual Com_killblogpercona.commanual Com_loadblogpercona.commanual Com_…
Post: High availability for MySQL on Amazon EC2 – Part 2 - Setting up the initial instances
June 29, 2010 By 9 Comments
…-31-38-04-E5-E4:~# hostname hamysql We don’t really need to set /etc/hostname since it is overwritten when the… ] 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
… box is different). For example, [percona@db1 ~]$ uname -a Linux hostname.domain 2.6.18-92.el5 #1 SMP Tue Apr… 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: Create 3 nodes XtraDB Cluster in 3 minutes
January 12, 2012 By 1 Comment
… use m1.xlarge size). You put hostnames of the instances into ec2hosts.txt file and run install.nodes.sh script. You also….pem in my case). For my box installing and starting 3 nodes took exactly time install.nodes.sh … real 2m51.257s In…
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… Current date: Thu Dec 29 07:09:32 2011 # Hostname: somehost.net # Files: slow-query.log.1 # Overall:…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 12 Comments
… global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is /usr/local/mysql/data) or… disks #tmpdir = /tmp/ #log-update = /path-to-dedicated-directory/hostname tmpdir =/mysql_tmp/:/tmp/ # Uncomment the following if you are using BDB…
Comment: Is DNS the Achilles heel in your MySQL installation?
May 31, 2008 By 16 Comments
… on for almost any production installation. If you do it early before having to deal with hostname based grants it is very… magnifies because of various bugs with host-cache in different MySQL versions which could cause more resolves when needed as well… I should mention – I’ve seen some operating systems building MySQL with tcp wrappers – in this case reverse lookup happens even…
