…Typically DRBD is run in combination with heartbeat or pacemaker or… having issues receiving packets from the other side, things …result in performance that’s worse than a single NIC.] The other two…query, but it’s always possible to build something more involved if that’s what you need. Q: What MySQL…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… are two cases covered in the first post: single SELECT queries doing PRIMARY KEY lookups (aka QPS sysbench mode); same MySQL queries executed inside… from the equation. We ran tests on Dell PowerEdge R720 box and varied cpu combinations with taskset. The following chart shows a results…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… D) which combined the parameter changes from tests B … varied between the two in the same …combine that with the fact that the best vCache performance results…=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=…_size = 1000 query_cache_size = 0 query_cache_type = 0…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…two major factors: The cost (in terms of execution time) of the query…is a combination of the ‘COMPUTE’…results mysql> select sum(total_lines) from dashboard_customer_sales ; +——————+ | sum(total_lines) | +——————+ | 155186550 | +——————+ 1 row in set (0.64 sec) mysql…
Post: How to find MySQL queries worth optimizing ?
September 11, 2012 By 6 Comments
… is “const” MySQL does not count it as access to two tables. In …results. What you can think about in this case is removing group by and aggregate functions. Then query would become “select * from…combined index. So what is the easy way to see if query is worth optimizing ? – see how many rows query…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
…MySQL storage engines. This set of benchmarks evaluates how well Infobright community edition (ICE) performs in combination with Shard-Query…results are the most striking. — Q4 SELECT Carrier, count(*) as c from…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… in many cases also don’t log the resulting errors. The best place to fix these …that needs to be monitored in two dimensions, which shouldn’t be combined: delay (Seconds_behind_master …query. The pmp-check-mysql-status is also very flexible and can be used to trigger an alert on almost anything from…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…mysql and it’s reading from /etc/my.cnf. I’ve seen a lot of cases where there’s a /var/lib/mysql…two…result looks like this: …Queries can be rewritten. Indexes and data types and table structures can be changed. Queries can be broken into pieces, combined…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
…compared to the combined size of the…results For the purpose of this benchmark, I have used TPC-H Query…query time is decreased from ~11min to under a minute. The query…TWO. It does not actually mean that queries with MRR are performing badly. The interesting thing is that though both MariaDB and MySQL…
Post: A workaround for the performance problems of TEMPTABLE views
May 19, 2010 By 7 Comments
… which contains a combination of integer values…a second or two. mysql> show create table t2\G *************************** …result: mysql> select * from v2 where c1 = 10; +——+———-+ | c1 | count(*) | +——+———-+ | 10 | 130 | +——+———-+ 1 row in set (1.66 sec) Even a query…
