…skip_log_warningsblogpercona.commanual skip_name_resolveblogpercona.commanual skip_networkingblogpercona.commanual skip_partitionblogpercona.commanual skip_safemallocblogpercona.commanual skip_show_databaseblogpercona.commanual skip_slave_startblogpercona.commanual skip_sslblogpercona.commanual skip…
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. … with clients. Oh, and did I mention that not enabling skip_name_resolve actually leaves you open to DoS attacks, if your servers… 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: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…=/var/db/mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql.sock consult 28852… important than what’s included. For example, the absence of skip-name-resolve is easy to miss, as is the absence of innodb…_disk_tmp_tables, I’ll paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | +———————+———–+ | max_heap_table_size | 268435456…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’G *************************** 1. row *************************** Name: ontime_fact …-buffer-size=512K read-rnd-buffer-size=1M skip-host-cache skip-name-resolve sort-buffer-size=512K sql-mode=STRICT_TRANS_…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
…: [client] socket=/var/lib/mysql/mysql.sock [mysqld] core basedir=/usr/local/mysql user=root socket=/var/lib/mysql/mysql.sock skip-grant-tables server_id…_capacity=500 max_connections=3000 query_cache_size=0 skip-name-resolve table_cache=10000 [mysql] socket=/tmp/mysql.sock (post edited by Fred Linhoss)
Post: Sharing an auto_increment value across multiple MySQL tables
October 4, 2010 By 9 Comments
… same availability zone. Ping times are ~0.5ms between nodes. –skip-name resolve is enabled on the server. There is some skew from…
Comment: Is DNS the Achilles heel in your MySQL installation?
May 31, 2008 By 16 Comments
Baron, You could explain why DOS attacks are happening 
Indeed –skip-name-resolve should be the option you turn on for almost any… effects of host name resolve magnifies because of various bugs with host-cache in different MySQL versions which could cause more resolves when needed…’ve seen some operating systems building MySQL with tcp wrappers – in this case reverse lookup happens even if you have –skip-name-resolve enabled.
Comment: Is DNS the Achilles heel in your MySQL installation?
August 19, 2008 By 16 Comments
>Is there a way to verify that skip_name_resolve is set? One way is to grant access to a user using a domain name, restart mysql and look in the error log ex: 080819 14:29:06 [Warning] ‘user’ entry ‘vbskin@cpvps%’ ignored in –skip-name-resolve mode.
Post: Fix of InnoDB/XtraDB scalability of rollback segment
January 18, 2009 By 9 Comments
…rsegments=16 max_connections=3000 query_cache_size=0 skip-name-resolve table_cache=2048 sysbench parameters /data/vadim/benchwork/…auto –mysql-host localhost –mysql-port 3306 –mysql-socket /data/vadim/benchwork/var/mysql_benchwork.sock –mysql-user user –mysql-password –mysql-db sbtest –mysql-…
Comment: What to tune in MySQL Server after installation
December 15, 2009 By 118 Comments
… format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package) old_passwords=1 skip-locking key_buffer = 384M… #skip-innodb skip-name-resolve # Try number of CPU’s*2 for thread_concurrency thread_concurrency = 16 set-variable=max_connections=2000 [mysql.server] user=mysql…
