…-35% to get that performance during LEB exhaustion. As for redundancy and stripping FIO cards, outside of a few hardware failures… stripe the data across two cards with no redundancy in the system, we used a percentage of the money we saved to… trying to get into the market? Yes. Are there applications where cheaper SSD solutions (IE, the mustang) will probably make better…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… | 205174 | | Aborted_connects | 29 | | Binlog_cache_disk_use | 0 | | Binlog_cache_use | 9630066 | | Bytes_received | 38563413074 | | Bytes_sent …the client is doing queries like “… WHERE client IN (SELECT id FROM clients…running mk-duplicate-key-checker to find redundant indexes, and so on. As with…
Comment: Find and remove duplicate indexes
June 21, 2012 By 9 Comments
… @xuancan thank you. Yes, there are some edge cases where a redundant key on PK is usefull. I’ve modified the post… “redundant” 
@rouchen that can be for several reasons. for example, if the composite index and the single column are both useful for the query, the optimizer may decide to use the “small” one. I’ve added…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 4 Comments
… the row format (-5) and where is our tablespace located (-f) The row format can be -4 (REDUNDANT) or -5 (COMPACT). From… as i INNER JOIN INNODB_SYS_TABLES as t USING(TABLE_ID) WHERE t.NAME=’salaries’; +———-+———+ | INDEX_ID | NAME | +———-+———+ | 26 | PRIMARY | | 27…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
… retried on the same node, or in the future, a redundant node. Work on problems of any size. Set processing is… a simple query with aggregation, a JOIN, and a WHERE clause that uses an IN clause: — INPUT SQL: select origin_airport_id…_date on ontime_fact.date_id = dim_date.date_id where dim_date.Year IN (2008,2009) group by 1; –PARALLEL…
Post: Minimizing Downtime from Lengthy AWS Outages
October 24, 2012 By 7 Comments
… as such. In order to have a fully redundant solution, you need to have working instances in… to operate independently, but there have been examples where issues in a single AZ impacted resources in… Region Replication The easiest approach would be to use native replication from a master to a slave…
Post: Realtime stats to pay attention to in Percona XtraDB Cluster and Galera
November 26, 2012 By 4 Comments
… wsrep_ready and wsrep_connected. These are somewhat redundant with the local_state value, so I may… I have seen production clusters having performance issues where I noticed that the Ops and Bytes went…of how many parallel replication threads you could use. In practice I haven’t found this …
Post: The Math of Automated Failover
September 18, 2012 By 9 Comments
…issue – which can be hardware configuration such as redundant network paths, STONITH, as well as things like… want to minimize it and this is indeed where “failover only once” and “failover only when it… we apply them to MySQL replication we can use these simplified principles – we only will failover …
Comment: Finding your MySQL High-Availability solution – The questions
October 17, 2009 By 36 Comments
… upgrades. Corrupt data is a reality unless your using something like ZFS to prevent if from ever happening…reliance on the SAN and it’s built in redundancy. You can count on anything failing in the …is the share nothing nature. It solves the problem where data gets corrupted on one node. There is …
Comment: Why you don't want to shard.
August 6, 2009 By 34 Comments
…, and the point is that there will be some situations where you still have to. There are people with working sets… having no redundancy. In my point about “too many writes” I explicitly mentioned slaves, which means I still want replication. Where you… of failure. * In the examples I provided, I would typically use replication as well.
