… we decided to benchmark it in different workloads. This time I tested only READ queries, similar to ones in benchmark InnoDB vs… get from svn repository: svn co https://sysbench.svn.sourceforge.net/svnroot/sysbench The used LUA script for sysbench http://www…_id`,`state_id`,`city`) ) In this benchmark we used only read (SELECT) queries with different typical data access patterns: primary key…
Post: MySQL and Sun - Oportunity for smaller companies ?
March 26, 2008 By 10 Comments
…handful of other people and at least Monty would read all replies and correct if there are any omissions….get a fix from mailing list anyway within similar time frame. Over years things have changed both from pricing…will steer a lot of large fish in MySQL nets, it is also great news for us, smaller …
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
…tried iiBench, which you can take there https://launchpad.net/mysql-patch/mytools What makes fractal indexes so …bound case TokuDB outperforms InnoDB 1.4-2.5x times, but CPU-bound is not so good. I …gain, as to update we need to read data, and in this case – read previous comment. – The version we …
Post: Sell-an-Elephant-to-your-Boss-HOWTO
August 28, 2012 By 3 Comments
… the website loads in 2s or in 5s, let him read this. In the end you have to come up with… such server and still due to queueing response time would be unstable during peak times. For every 60 new customers, “Ana Lysis… the problem is fixed, the net result is still a significant waste of money, it’s time to go ahead and get…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 3
October 19, 2009 By 25 Comments
… it can play. More details can be read about here: http://1978th.net/tokyotyrant/ http://1978th.net/tokyocabinet/ So if we can get… I increased the threads from 64 to 128. As time permits I should revisit this and look at increased datasets…
Post: xtrabackup-0.5, bugfixes, incremental backup introduction
April 7, 2009 By 6 Comments
… is LSN of last checkpoint operations. Now next time when you want only copy changed pages you…it in scripts. More about incremental you can read on our draft page http://www.percona….report bug to Launchpad bug system: https://launchpad.net/percona-xtrabackup/+filebug. The documentation is available …
Post: PHP Large result sets and summary tables.
July 6, 2007 By 8 Comments
… cleared until you fetch whole result set if you’re reading from tables directly (if you do not have “using temporary… is when you run mysql_query , mysql_fetch_row simply reads data from memory and so most applications do not care… can be fixed by increasing net_write_timeout variable on the server so it gives you more time But is this the…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 17 Comments
… cost of querying this database will be 10 times higher with this partitioning, however since you’ll…partition and starting a new one. (If I read your graph correctly, you didn’t graph the… python version that Mark wrote http://bazaar.launchpad.net/~mdcallag/mysql-patch/mytools/annotate/head%3A/bench…
Post: Percona Server 5.1.49-rel12.0
September 15, 2010 By 6 Comments
… the Facebook-MySQL tree – https://launchpad.net/mysqlatfacebook . Of particular note is better integration…Oleg Tsarev) response_time_distribution – Counts queries with very short execution times and groups them by time interval. … be delayed if an old consistent read view exists that could see the …
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
… idle – they are used by default thread stack, net buffer etc. If transaction is started some more … need temporary tables as much as read_buffer_size, sort_buffer_size, read_rnd_buffer_size, tmp_table_size … sets from remove queries. Blobs may require 3x time of memory. This is important if you’re …
