… it better to disable them. The MySQL Settings are probably what is the most interesting: MySQL 5.0 Tuning in /etc/my.cnf (included in FDA) [mysqld] sql-mode = IGNORE_SPACE transaction-isolation = READ-COMMITTED max_allowed_packet = 1M max_connections…
Post: Configuring MySQL For High Number of Connections per Second
January 6, 2012 By 23 Comments
… during a connection and ideas for improvement, see this post by Domas]), With MySQL 5.5 default back_log of 50 and 2000 connections created per second it will take just 0.025 seconds to… call. The maximum value on Linux is directed by tcp_max_syn_backlog sysctl parameter unless syncookies are enabled. The simple…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
… Server. That gave 8GB in total size for log files (MySQL 5.5.8 has a 4GB limit). In additional to increasing log…_pages = 0 innodb_write_io_threads=8 innodb_read_io_threads=8 innodb_io_capacity=500 max_connections=3000 query_cache_size=0 skip-name-resolve table_cache=10000 [mysql] socket=/tmp/mysql.sock (post edited by…
Post: mysql-proxy, urgh performance and scalability ?
June 9, 2009 By 44 Comments
… tested for couple connections, here are results (in transactions per second, more is better) ThreadsMySQL-5.0.77MySQL-proxy+MySQL-5.0.77 1 660.02… 1 thread). MySQL per-request statistics: min: 1.31ms avg: 1.51ms max: 5.30ms approx. 95 percentile: 1.56ms Proxy+MySQL per-request statistics: min: 2.04ms avg: 2.86ms max: 6.44ms…
Post: Storing MySQL Binary logs on NFS Volume
July 30, 2010 By 19 Comments
… –db-driver=mysql –mysql-user=root –mysql-db=sbsmall –init-rng=1 –max-requests=100000000 –max-time=600 –oltp-…it mainly was because of contention issues in MySQL 5.0 rather than any NAS issues. This number …0 and innodb_flush_log_at_trx_commit=2 I noted however if I enable replication – connect…
Post: Too many connections? No problem!
March 23, 2010 By 28 Comments
…’s the trick: [percona@sandbox msb_5_0_87]$ gdb -p $(cat data/mysql_sandbox5087.pid) \ -ex “set max_connections=5000″ -batch [Thread debugging using... clear the current input statement. mysql [localhost] {msandbox} ((none)) > select @@global.max_connections; +————————–+ | @@global.max_connections | +————————–+ | 5000 | +————————–+ 1 row in set (0.00 sec) Credit for…
Post: Investigating MySQL Replication Latency in Percona XtraDB Cluster
March 3, 2013 By 13 Comments
… in the end of the post) which connects to one node in the cluster, performs… –mysql-user=root –mysql-password=”" –oltp-table-size=1000000 –num-threads=32 –init-rng=on –max-requests=0 –max…XtraDB Cluster related configuration # PXC Settings for Version: ‘5.5.29-55-log’ socket: ‘/var/run/mysqld/…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… running on a Percona Server 5.0.92-87 with the following my.cnf configuration: [mysqld] datadir=/data/mysql socket=/var/run/mysqld… back_log = 50 max_connections = 2500 max_connect_errors = 10 table_cache = 2048 max_allowed_packet = 16M binlog_cache_size = 16M max_heap_table_size = 64M…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…connections as in MySQL. This is very helpful for measurement as otherwise we might not catch some long running connections…0.1160 1.4% 5 0.0232 1.00 0.00 SELECT film # 9 0xCFC0642B5BBD9AC7 0.0987 1.2% 50 0.0020 1.00 0…
Post: Impact of logging on MySQL’s performance
February 10, 2009 By 8 Comments
… striped disks). Software It was used MySQL 5.0.75-percona-b11 on CentOS release 4.7 MySQL setting There were two cases considered… to execute; logging every query; MySQL was run with default settings except following: [mysqld] user=root max_connections=3000 innodb_log_file_size… connections No logging, NOTPM Logging all queries, NOTPM Ratio all_logging /no_logging 1 9512 8943 0.94 20 27675 25869 0.93…
