…resolve in your my.cnf file and restart MySQL. But before you do that, run the following command: mysql> SELECT user, host FROM mysql.user -> WHERE host…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…say “we are a SaaS hosted application for data mining stock … clflush size : 64 cache_alignment : 64 address sizes : 38 bits physical, 48 …mysql and an /etc/my.cnf, and the server is installed in /customsoftware/mysql with a different my.cnf…example, the absence of skip-name-resolve is easy to miss, as…
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
…addresses it assigned, usually together with a host name. While there, you could also assign a permanent IP address…resolving dependencies… looking for inter-conflicts… Targets (4): libaio-0.3.109-6 libmysqlclient-5.5.30-1 mysql…, you can find it in /etc/mysql/my.cnf If you setup Percona Server to…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…” ‘/var/lib/mysql/’ ‘/etc/my.cnf‘ ’20758′ 2>…address): ‘(null)’; port: 3306 120619 13:21:19 [Note] – ‘(null)’ resolves to ’0.0.0.0′; 120619 13:21:19 [Note] – ‘(null)’ resolves…mysql –mysql-engine-trx=yes –mysql-table-engine=innodb –mysql-host=127.0.0.1 –mysql-port=3307 –mysql-user=sbtest –mysql…
