…-brain situation. Typically DRBD is run in combination with heartbeat or pacemaker or something similar, … are executed on the intermediate server, thus resulting in less binary log data being sent …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
… the first post: single SELECT queries doing PRIMARY KEY lookups (aka QPS sysbench mode); same MySQL queries executed inside single-statement transactions (TPS… Dell PowerEdge R720 box and varied cpu combinations with taskset. The following chart shows a results comparison on a single-node (on…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
…-only server nor rewriting application queries. Furthermore, it can be combined with the read-only optimization in MySQL 5.6 to achieve even… this case MySQL 5.6 scalability goes back to the good old MySQL 5.5 times and we see identical results with both… in MySQL 5.6 are nice ways to improve scalability in highly concurrent workloads. We also have plans to combine them in…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… on result. In the best possible combination I got ~15k operations per second for MySQL 5.6.11. Conclusion: In CPU-bounds case MySQL… in MySQL 5.6. In IO-bound cases MySQL still has performance issues around mutexes and Percona Server shows much better results Configurations…=5000 table_open_cache=5000 table-definition-cache=1000 query_cache_size=0 query_cache_type=0 performance_schema=0 #56only loose…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… points and combine that with the fact that the best vCache performance results were …requests=0 –percentile=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-… 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
… available for querying: mysql> call flexviews.enable( -> flexviews.get_id(‘demo’,'dashboard_customer_sales’)); Query OK, 0… both views. Compared the refresh performance and query results. The view type does not usually* …latter. I also showed how you can combine both types of views together. The …
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
… with all MySQL storage engines. This set of benchmarks evaluates how well Infobright community edition (ICE) performs in combination with Shard-Query. Data… containing the 11 queries. This same SQL script was used in the Shard-Query tests. For the baseline, the results and response times…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 141 Comments
…-server partitioning to use combined memory and a lot…MySQL single query runs as single thread (with exeption of MySQL Cluster) and MySQL issues IO requests one by one for query…query into several, run in parallel and aggregate result sets. So if you’re dealing with large data sets and complex queries…
Post: How to find MySQL queries worth optimizing ?
September 11, 2012 By 6 Comments
…to examine 10Mil rows to produce result. What would be good scenario ? – query examining same amount of rows…found and returned up to the top level MySQL part for processing are counted the Rows_…combined index. So what is the easy way to see if query is worth optimizing ? – see how many rows query…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…and in many cases also don’t log the resulting errors. The best place to fix these problems … monitored in two dimensions, which shouldn’t be combined: delay (Seconds_behind_master or the delay indicated … server is alive and responds to a query. The pmp-check-mysql-status is also very flexible and …
