…MySQL…skip_grant_tablesblogpercona.commanual skip_host_cacheblogpercona.commanual skip_lockingblogpercona.commanual skip_log_warningsblogpercona.commanual skip_name_resolveblogpercona.commanual skip_networkingblogpercona.commanual skip_partitionblogpercona.commanual skip…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…skip-host-cache skip-name-resolve sort-buffer-size=512K sql-mode=STRICT_TRANS_TABLES symbolic-links table-definition-cache=16384 table-open-cache=128 thread-cache-size=32 thread-stack=256K tmp-table-size=64M transaction-isolation=READ-COMMITTED user=mysql…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…”we are a SaaS hosted application for data mining…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…clients | 205174 | | Aborted_connects | 29 | | Binlog_cache_disk_use | 0 | | Binlog_cache_use | 9630066 | | Bytes_received | …
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… also would note effects of host name resolve magnifies because of various bugs with host-cache in different MySQL versions which could cause more resolves when needed as well as the fact this cache size neither…
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…’ve been trying to get MySQL to overhaul how it handles hosts for a long time now. My host cache patches are a good start to this: http://jcole.us/patches/mysql/5.0/host_cache…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 12 Comments
… specific programs # The MySQL server [mysqld] port = 3306 socket = /tmp/mysql.sock bind-address=10.234.94.71 skip-locking key_buffer_size = 2000M max_allowed_packet = 32M # table_cache=20M # open… in our manual) – # the syntax is: # # CHANGE MASTER TO MASTER_HOST=, MASTER_PORT=, # MASTER_USER=, MASTER_PASSWORD= ; # # where you replace , , by…
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/…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-table-…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…’, ’20′ ‘Com_show_slave_hosts‘, ’61′ ‘Com_show_slave_status’,…mysql.sock pid-file=/var/run/mysql/mysql.pid datadir=/db/disk2/mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql…cache_size=10M # Might be increased thread_cache_size=40 table_cache=512 # Default 64 was used before. skip…
Comment: MySQL VIEW as performance troublemaker
May 6, 2010 By 53 Comments
mysql view are good, but certain care is required – 1. tables … you do it before dumping data in the tables) 2. skip any where clause, or group by clause 3. drop off… multiple views, based on the column required 4. increase sql cache / memory (hosting providers … ahem ahem!) 5. do not mix views with…
