…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…
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… of host name resolve magnifies because of various bugs with host-cache in different MySQL versions which could cause more resolves when needed… – in this case reverse lookup happens even if you have –skip-name-resolve enabled.
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… DNS lookups per authentication attempt, you just need to set skip_name_resolve in your my.cnf file and restart MySQL. But before…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… important than what’s included. For example, the absence of skip-name-resolve is easy to miss, as is the absence of innodb…, I go through it line by line, like this: +———————————–+———————-+———————-+ | Variable_name | Value | Value | +———————————–+———————-+———————-+ | Aborted_clients | 205174 | 6 | Here we can see…
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: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… mysql> show table status like ‘ontime_fact’G *************************** 1. row *************************** Name: ontime_fact Engine: InnoDB Version: 10 Row_format: Compact Rows… read-buffer-size=512K read-rnd-buffer-size=1M skip-host-cache skip-name-resolve sort-buffer-size=512K sql-mode=STRICT_TRANS_TABLES…
Post: Fix of InnoDB/XtraDB scalability of rollback segment
January 18, 2009 By 9 Comments
…_extra_rsegments=16 max_connections=3000 query_cache_size=0 skip-name-resolve table_cache=2048 sysbench parameters /data/vadim/benchwork/benchmarks/sysbench… oltp –oltp-test-mode complex –oltp-sp-name –oltp-read-only off –oltp-skip-trx off –oltp-range-size –oltp-point-selects…-delay-min 0 –oltp-user-delay-max 0 –oltp-table-name sbtest –oltp-table-size 10000000 –oltp-dist-type uniform –oltp…
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.
Comment: MySQL Server Memory Usage
December 20, 2012 By 21 Comments
…-increment-increment = 3 #auto-increment-offset = 1 #log-slave-updates skip_name_resolve #master-host = 192.168.0.203 #master-user = replication #master…_at_trx_commit=0 sync_binlog=0 slave-skip-errors = 1062 back_log = 75 # skip-innodb max_connections = 600 #thread_stack= 150M…
Comment: What to tune in MySQL Server after installation
April 8, 2011 By 118 Comments
… Reading from net — I have already added the skip-name-resolve, skip-host-cache, and skip-locking option to my.cnf. As a added measure…
