… it easier later on. You could also assign a permanent DNS name (like pi.yourdomain.com) by binding the reserved IP… 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: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
Post: Is DNS the Achilles heel in your MySQL installation?
May 31, 2008 By 16 Comments
Do you have skip_name_resolve set in your /etc/my.cnf? If not, consider it. DNS works fine, until it doesn… two DNS lookups per authentication attempt, you just need to set skip_name_resolve in your my.cnf file and restart MySQL. But before you do that, run the following command: mysql> SELECT user, host FROM mysql…
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…columns) That the “public dns” field is selected SSH to the public DNS entry of the node on…-buffer-size=1M skip-host-cache skip-name-resolve sort-buffer-size=512K sql-mode=STRICT_TRANS…
