…my first post on MySQL transaction descriptors optimization …) configuration. No surprises here, the general pattern is consistent with what we saw previously. Note that the single… protecting the list of transactions, its applicability is quite limited. Namely, it requires the list of transactions to…
Post: Tokyo Tyrant - The Extras Part I : Is it Durable?
November 10, 2009 By 5 Comments
… transaction in TC is actually a global transaction and locks all write operations ( used for maintenance ). What is missing here is a scheduled… performance. So what can we do to Make Cabinet more durable?  Well the best option in my opinion is to steal… the function name and the calling period of a periodic command. Now while I did not see a drop in my benchmark…
Post: Enum Fields VS Varchar VS Int + Joined table: What is Faster?
January 24, 2008 By 30 Comments
… the result time is average from those 1000 runs. So, our first benchmark is simple: we need to get 5 names of cities… (0.10 sec) Because we refer state by name, which is unique,it is pre-read and query executed basically on single table querying state by ID. Next test was a result of my…
Post: Tools to use for MySQL Performance Review
May 31, 2008 By 3 Comments
… each other where that particular stuff is located on the web or what is exactly name of the command what does that. Initially I thought creating internal Percona Wiki page, but thought there is no… tools which came from the top of my head and I’m sure it is far from complete. We will extend it…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… doing, which might not be what is really being done. I want to look at it without polluting my brain with that. I… what‘s left out is often more important than what‘s included. For example, the absence of skip-name-resolve is easy to miss, as is… is happening 6 times every ten seconds. We need to figure out what is happening because it can indicate something else is wrong. This is…
Post: Realtime stats to pay attention to in Percona XtraDB Cluster and Galera
November 26, 2012 By 4 Comments
…! name The cluster’s name (first 5 characters). This is wsrep_cluster_name. P Either P for Primary or N for Non-primary. This is… queue is > 0. Instead brute force aborts are applying writesets rolling back locally open transactions. In fact, this is a sysbench test what is running full speed (these are VMs, so that’s not that particularly fast) on two of my three…
Post: Test Drive of Solid
September 22, 2006 By 5 Comments
…closer look on new transactional engine for MySQL. While my far goal is the performance and scalability testing before I wanted … – so it is hard to tell what is really happening. Test 3: Phantom rows: Table before test: select * from test2; +—-+——–+ | id | names | +—-+——–+ | 1 | Mysql…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…@localhost msb_ps_5_5_15]# time mysqldump –defaults-file=my.sandbox.cnf test md_cache_test_big > /dev/null Baseline… mysqldump is impacted too because we now have 2 threads competing for what is single hard drive on this test system. It is worth… now going inline with what you would expect. Lets see what is going on with buffer pool contents: INDEX_NAME DATA_SIZE_MB test…
Post: Recovering Linux software RAID, RAID5 Array
August 27, 2011 By 2 Comments
… and finally I had gotten the problems with my ReadyNAS Pro 6 which I was setting up/… exist ReadyNAS1:/# lvdisplay — Logical volume — LV Name /dev/c/c VG Name c LV UUID Rd66bT-qF3P-MgES-… resync is likely to cause these being read and when array will fail again. If this is what is happening …
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
… (refreshing) is usually expensive. A change data capture tool can be used to implement an efficient way of refreshing them. What is Change Data Capture (CDC)? As the name implies, CDC software captures the changes made…=1) unique server_id in the my.cnf log_slave_updates=1, if this is a MySQL slave transaction_isolation=READ-COMMITTED…
