…MySQL, here are some example queries and the corresponding number of concurrency tickets used for each: mysql…mysql-user=root –mysql-socket=/var/lib/mysql/mysql.sock run Applicable my.cnf…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…-87 with the following my.cnf configuration: [mysqld] datadir=/data/mysql socket=/var/run/mysqld…insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover skip… is very similar, due to high concurrency response time in the first case …
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 141 Comments
…INSERTS: 1,000 2. UPDATES: 200 3. SELECTS: 1 million Since this is a predominantly SELECTed table, I went for MYISAM. My my.cnf… [mysqld] long_query_time=5 skip-bdb skip-innodb skip-locking query_cache_limit=1M…_slow_queries=/var/log/mysql-slow.log sql-mode=TRADITIONAL concurrent_insert=2 low_priority…
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…=300 key_buffer_size = 500M concurrent_insert=2 myisam_sort_buffer_size = … #Replication-skip replicate-ignore-table=mysql.gsd_runs replicate-ignore-table=mysql.gsd_monitor…
