…concurrency of 32 this corresponds to pretty significant load. sysbench –test=oltp –mysql-user=root –mysql…mysql-user=root –mysql-password=”" –oltp-table-size=1000000 –num-threads=1 –init-rng=on –max-requests=0 –max-time=300 run …. per-request…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
…MySQL 5.5.8). The problem with flushing neighborhood pages is that it makes an exact calculation of how many pages were handled…request from commenter I put also results with different innodb_io_capacity for MySQL 5.5.8. It is…innodb_thread_concurrency=0 innodb_flush_…=10000 [mysql] socket=/tmp/mysql…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
…number of IOs it can handle. Imagine for example data archive…MySQL Instance without getting in too much trouble with backups etc – because Sphinx is… SSD drive can do 10000 does it mean if …concurrency to utilize multiple hard drives and with 50 drives you would need at least 50 outstanding requests…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…requests‘, ’1552507′ ‘Key_reads’, ’1654′ ‘Key_write_requests…mysql/log log-slow-queries=/var/log/mysql/slow-queries.log max_connections=650 open_files_limit=6144 max_connect_errors=10000…concurrency=64 # Default is 8 wich is…
