… 13:21:19 [Note] – ‘(null)’ resolves to ‘::’; 120619 13:21:19 [Note] Server socket created on IP: ’0.0.0.0′. 120619…=oltp –db-driver=mysql –mysql-engine-trx=yes –mysql-table-engine=innodb –mysql-host=127.0.0.1 –mysql-port=3307 –mysql-user=sbtest –mysql-password=sbpass –oltp…=oltp –db-driver=mysql –mysql-engine-trx=yes –mysql-table-engine=innodb –mysql-host=127.0.0.1 –mysql-port=3307 –mysql-user=sbtest –mysql-password=sbpass –oltp…
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
… list all IP addresses it assigned, usually together with a host name. While there, you could also assign a permanent IP address (still… percona-server resolving dependencies… looking for inter-conflicts… Targets (4): libaio-0.3.109-6 libmysqlclient-5.5.30-1 mysql-clients… mysqld Connect using the mysql client: [root@alarmpi ~]# /usr/bin/mysql Welcome to the MySQL monitor. Commands end with ; or \g. [...] mysql> SHOW ENGINES…
Post: Is DNS the Achilles heel in your MySQL installation?
May 31, 2008 By 16 Comments
…resolve in your my.cnf file and restart MySQL. But before you do that, run the following command: mysql> SELECT user, host FROM mysql…
Comment: 10+ Ways to Crash or Overload MySQL
November 14, 2007 By 20 Comments
… skip_name_resolve, none of that code is called at all. * If a host doesn’t have a valid PTR (ip to host mapping), nothing is ever counted. As you probably know, I’ve been trying to get MySQL to overhaul… hosts for a long time now. My host cache patches are a good start to this: http://jcole.us/patches/mysql/5.0/host…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… avaialble data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’G… shown in the EC2 console. That the “private ip” field is selected in the list of columns…=512K read-rnd-buffer-size=1M skip-host-cache skip-name-resolve sort-buffer-size=512K sql-mode…
Post: Are PHP persistent connections evil ?
November 12, 2006 By 32 Comments
… connections active between Host “Apache” and Host “MySQL“: Port 3306 as connection in TCP/IP protocol is identified by pair of IP addresses and pair… is of course to use multiple IPs on your MySQL server (you’re probably using Intranet range IPs anyway). So one way or… queries running at the same time which may never self-resolve as users will get extremely poor response time and will…
Comment: Is DNS the Achilles heel in your MySQL installation?
June 1, 2008 By 16 Comments
Gregory, If there are not –skip-name-resolve MySQL will always resolve host name even if your grant tables only happen to contain IP addresses.
