… is important to know. Add just a bit more data, or add a bit… note: bravo for Daniel figuring out how to make mk-query-digest parse …_read: 0 # administrator command: Quit; # User@Host: webuser[webuser] @ [10.14.82.196] #…– and that’s where improvements to the MySQL source code are necessary. But …
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 94 Comments
…to add nodes In order to setup the solution you’ll need my version of the MySQL resource agent, it is not yet pushed to… the master-slave “ms” declaration. This is how Pacemaker defines an asymmetrical resource having a …should not be on a host. I also added a few colocation rules to help spread the …
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…How to get CPU consumption per query ? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql…read operation per second which takes 4ms which adds up pretty well. We can also see what… 0 0 0 0 0 0 # String: # Databases # Hosts localhost # InnoDB trxID 3BBF3B55 (1/0%), 3BBF3B5A (1/…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 22 Comments
…mysql db=ontime_one password= port=5029 column=date_id mapper=hash gearman=127.0.0.1:7000 inlist=* between=* [shard1] host…The next queries show how performance is improved when Shard-Query adds parallelism when “subqueries… features which Shard-Query can use to add parallelism. Thus, in the scale up …
Post: Shard-Query adds parallelism to queries
November 15, 2010 By 16 Comments
… number of concurrent queries (or only one) to demonstrate how much improvement could be made to MySQL so that is could better utilize all… initially conceived as a utility to add parallelism to horizontally partitioned data sets by running queries against each host in parallel, with the added…
Post: High availability for MySQL on Amazon EC2 – Part 2 - Setting up the initial instances
June 29, 2010 By 9 Comments
…using m1.small type instances while normally, the mysql host would be much larger. Using another type is…:~$ ec2-add-group hamysql -d ‘nodes for HA MySQL solution’ GROUP hamysql nodes for HA MySQL solution From…based AMI Others have produce excellent article on how to create EBS based AMI, I will not …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…or hearing you say “we are a SaaS hosted application for data mining stock market transactions,” or…t know how to read these, there’s a full explanation in our book, High Performance MySQL 2nd Edition … a “garbage” query that just adds latency and makes the overall time to complete an action longer. …
Post: Is DNS the Achilles heel in your MySQL installation?
May 31, 2008 By 16 Comments
…to know that this is the problem, and diagnosing adds to…mysql> SELECT user, host FROM mysql.user -> WHERE host ‘localhost’ AND host RLIKE ‘[a-z]‘; +——+——–+ | user | host | +——+——–+ | foo | my.com | +——+——–+ Any users you see here need to…
Post: Moving Subtrees in Closure Table Hierarchies
February 14, 2011 By 7 Comments
…, I periodically get questions about how to solve certain problems. Here’s …to a new position in my tree. Right now, I’m reading the nodes of the subtree into my host…, you just have one descendant to add, joined to all the paths of its… in MySQL. But we can use MySQL‘s multi-table DELETE syntax, to …
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 10 Comments
…EBS volumes and MySQL, versus RDS machines. For reasons that won’t add anything to this discussion…want to write an overview of these two approaches to hosting MySQL in the Amazon cloud. In general, MySQL …to say you shouldn’t use the Amazon cloud to host your databases. You just need to know how…
