… VB6 to PhP/MySQL/Apache/InnoDB. Do you think you can show a program where row-locks are used by one…
Post: Testing Fusion-io ioDrive
May 3, 2012 By 1 Comment
… case. We can see some wave-like pattern with throughput 350-400 MiB/sec. Random reads, async: Interesting …for read-only workload to have such variety in throughput. It gets even more interesting when we go to read …=’cecece’;tc=’6a6a6a’;nc=’6a6a6a’;bc=’6a6a6a’;l=’y‘;fs=’16′;fsb=’13′;bw=’100′;ff=’4′;…
Comment: UNION vs UNION ALL Performance
May 2, 2012 By 13 Comments
… from tab_a union all select b col from tab_b union all select c col from tab_c union all select d col from tab… from tab_a union select distinct b col from tab_b union select distinct c col from tab_c union select distinct d col from tab… but the explain plan shows less cost for option 1. Can anybody tell me which option will be better.
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… for the suggestion. I don’t see anything suspicious in the /var/log/mysqld.log file which i believe is the error… down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files… InnoDB: Restoring possible half-written data pages from…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…disk seeks to answer a random query, assuming you can get each index query down to one disk seek.)…starting a new one. (If I read your graph correctly, you didn’t graph the performance on the first 100M…total of, say, 4 times bigger. So around 300M or 400M rows, I would expect Inno starts hitting disk…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…read_io_threads = 8 innodb_write_io_threads = 4 innodb_file…such that every partition would hold 100 million rows. Table Structure The table structure of the table with no…y-axis. The reason why I have chosen to show “millions of rows” on the x-axis so that we can…
Post: Testing Virident FlashMAX 1400
May 4, 2012 By 3 Comments
…, the result stabilizes at 550 MiB/sec level. Random read, async: Random read throughput is very close to perfect line, and it… distribution of response time, the results for random read synchronous IO. There we can see that 1450 MiB/sec is not quite…=’ffffff’;tlc=’cecece’;tc=’6a6a6a’;nc=’6a6a6a’;bc=’6a6a6a’;l=’y‘;fs=’16′;fsb=’13′;bw=’100′;ff=’4′;pc=’4889F0…
Post: Testing Intel SSD 520
May 1, 2012 By 7 Comments
…research in later charts. Now, random reads, still asynchronous It gives almost…drops. So there is more or less stable performance only …-75 percentiles. So there is no grow in throughput after 2 … question is how much MySQL can use. In his keynote Mark…nc=’6a6a6a’;bc=’6a6a6a’;l=’y‘;fs=’16′;fsb=’13′;bw…
Comment: Announcement of Percona XtraDB Cluster 5.5.20 GA release
May 1, 2012 By 10 Comments
…_storage_engine, query_cache_size, e.t.c…. Is it something built in or we just don’t need to define it for the… get paid support from percona, but at-least you can answer this one or provide a link to sample configuration. Your tool…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
May 16, 2012 By 94 Comments
….04 LTS) the pacemaker mysql plugin (ocf:heartbeat:mysql) doesn’t work, because since mysql 5.5 the statement “CHANGE MASTER…=” ” will make an error and stop this script. As I can see, Yves fixed this in his the last version on…
