… mysql mysql 1073742171 Nov 2 15:15 /var/lib/mysqllogs/db1-bin-log.003229 -rw-rw—- 1 mysql mysql …, every time current binary log gets close to max_binlog_size in size, new binary log is created and, …size of binary log file from default 1GB (some systems have it set to 100MB in their default my.cnf…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…mysql and an /etc/my.cnf, and the server is installed in /customsoftware/mysql with a different my.cnf…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… Server 5.0.92-87 with the following my.cnf configuration: [mysqld] datadir=/data/mysql socket=/var/run/mysqld/mysqld.sock innodb_file… = 2048 max_allowed_packet = 16M binlog_cache_size = 16M max_heap_table_size = 64M thread_cache_size = 32 query_cache_size = 0 tmp_table_size = 64M key_buffer_size…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…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…size = 2M sort_buffer_size = 32k thread_cache = 16 query_cache_size = 0M thread_concurrency = 8 max_heap_table_size…unsafe_for_binlog = 1 innodb_max_…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…enterprise-log MySQL Enterprise Server (Commercial) my.cnf: [mysqld] server-id = 2 port = 3306 basedir = /usr/local/mysql datadir = /…size = 100 max_connections = 400 table_cache = 20000 open_files_limit = 40000 max_binlog_size = 500M max_allowed_packet = 20M tmp_table_size = 100M max_heap_table_size…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…enterprise-log MySQL Enterprise Server (Commercial) my.cnf: [mysqld] server-id = 2 port = 3306 basedir = /usr/local/mysql datadir = /…size = 100 max_connections = 400 table_cache = 20000 open_files_limit = 40000 max_binlog_size = 500M max_allowed_packet = 20M tmp_table_size = 100M max_heap_table_size…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…MySQL. # # You can copy this file to # /etc/my.cnf to set global options, # mysql-data-dir/my.cnf…size=1000M sort_buffer_size = 100M read_buffer_size = 100M read_rnd_buffer_size = 100M myisam_sort_buffer_size = 100M max_length_for_sort_data=2048 max…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
… My.cnf ========== freehold: [client] port=3323 socket=/tmp/mysqld_mdmp.sock character-sets-dir=/home/mysqld/sys/5.5.8/share/mysql/charsets… binlog_cache_size=1M binlog_format=MIXED log-slave-updates log-bin=mdmp_freehold_binlog sync_binlog=1 relay-log=mdmp_freehold_relaylog max_relay_log_size…
Comment: Solving RPM installation conflicts in CentOS 5 and CentOS 6
February 21, 2013 By 6 Comments
…@mysql1 ~]# vi /etc/my.cnf [mysqld] wsrep_provider=/usr/lib/libgalera_smm.so user=mysql wsrep_cluster_address=gcomm:// binlog_format=ROW wsrep_slave… that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 329809 K bytes of memory Hope that…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…size : 64 cache_alignment : 64 address sizes : 40 bits physical, 48 bits virtual power management: I tested MySQL…my.cnf is [mysqld] user=root binlog_cache_size=1M default_table_type=MYISAM ft_min_word_len=4 innodb_additional_mem_pool_size…
