… -days 365000 -nodes -keyout key.pem -out cert.pem Generating a 2048 bit RSA private key …………..+++ ……………………………………………………….+++ writing new private key to ‘key.pem’ —– You are about to be asked to enter information that will be incorporated into your certificate request…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… will need SECONDARY KEY (hid,mid,id) ). Also please note the transaction produces 4 INSERTs and workload is very write intensive. So…_auto_inc=on –max-time=18000 –report-interval=10 –max-requests=0 –num-threads=32 –rand-type=pareto run and InnoDB…_size=4096 #####plugin options innodb_read_io_threads = 16 innodb_write_io_threads = 4 innodb_io_capacity = 4000 innodb_use_native…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…the first post: single SELECT queries doing PRIMARY KEY lookups (aka QPS sysbench mode); same MySQL …table = true innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_io_capacity = 2000 …=uniform –forced-shutdown=1 –max-time=120 –max-requests=0 –percentile=99 –mysql-user=root –mysql-db=…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… plus: innodb_read_io_threads = 16 innodb_write_io_threads = 16 We call this configuration …pareto \ –forced-shutdown=1 –max-time=7200 –max-requests=0 –percentile=95 \ –mysql-user=root –mysql…192K tmp_table_size = 64M serverid = 101 key_buffer_size = 8M read_buffer_size = 1M…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… key_buffer_sizeblogpercona.commanual key_cache_age_thresholdblogpercona.commanual key_cache_block_sizeblogpercona.commanual key_cache_division_limitblogpercona.commanual Key_read_requestsblogpercona.commanual Key_readsblogpercona.commanual Key_write_requestsblogpercona.commanual Key…
Post: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
… like “key%”; +————————+———+ | Variable_name | Value | +————————+———+ | Key_blocks_not_flushed | 6516 | | Key_blocks_unused | 0 | | Key_blocks_used | 7248 | | Key_read_requests | 2051451 | | Key_reads | 198208 | | Key_write_requests | 469220 | | Key_writes…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…’ ‘Delayed_writes‘, ’0′ ‘Flush_commands’, ’5′ ‘Handler_commit’, ’19092941′ ‘Handler_delete’, ’0′ ‘Handler_discover’, ’0′ ‘Handler_read_first’, ’1100773′ ‘Handler_read_key…’, ’12524′ ‘Handler_write‘, ’292923929′ ‘Key_blocks_not_flushed’, ’0′ ‘Key_blocks_unused’, ’28987′ ‘Key_blocks_used’, ’1332′ ‘Key_read_requests‘, ’1552507′ ‘Key_reads’, ’1654′ ‘Key_write_requests‘, ’114303′ ‘Key_writes‘, ’1346′ ‘Max…
Comment: What to tune in MySQL Server after installation
September 5, 2008 By 118 Comments
… are the my server ‘SHOW STATUS’ output; Key_read_requests 9490927 Key_reads 72073 Key_write_requests 678314 Key_writes 430602 Open_tables 561 Open_files 278 Thanks…
Comment: Why MySQL could be slow with large tables ?
November 14, 2008 By 141 Comments
…_tables 5,274 Created_tmp_files 37 k Key_reads 4,226 Key_write_requests 380 k Key_writes 367 k Sort_merge_passes 18 k…
Post: What MySQL buffer cache hit rate should you target
June 29, 2006 By 5 Comments
… as – how busy were drives with concurrent requests, how random were these reads/writes, how good was OS or SAN cache hit…. For example if single query is issuing 100+ random IO requests which are not cached by OS or SAN this is… is done. In partuclar you should be looking at Key_reads and Key_writes for MyISAM tables (note this does not include row…
