…, a secondary index reserves different extents from the clustered index. Q4: Does Innodb ever merges sequential pages together if they become almost… in MySQL 5.1 Q15: How frequently does Innodb fuzzy checkpointing is activated HT: InnoDB flushes about 128 dirty pages per flush. That…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… 1 (assuming a 20 node cluster): cd shard-query ./start_workers 80 I normally start (2 * TOTAL_CLUSTER_CORES) workers. That is…_DIRECT innodb-ibuf-active-contract=1 innodb-import-table-from-xtrabackup=1 innodb-io-capacity=1000 innodb-log-buffer-size=32M innodb-log-file-size=128M innodb…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
…an acceptable range. It opens the possibility for active master – active master setups. You can write on … gets disconnected from the cluster, in order to join to the cluster again, it has to … based on standard InnoDB 5.1 instead of InnoDB-plugin. Standard InnoDB is seriously behind InnoDB-plugin in …
Post: My Innodb Feature wishes
May 4, 2006 By 30 Comments
… blobs over 1M in their own segments. Clustering. I love Innodb‘s ability to cluster data by primary key it is so helpful… not to cluster by it instead of creating fake primary key and promoting real one to unique. Tablespaces. To call “innodb_file… bad I will list it. Basically Innodb has problems scaling both with large number of active threads and with large number of…
Page: Consulting for MySQL
July 31, 2006 By
… which matches your application needs using MySQL Replication, Active-Passive clustering, DRBD, MySQL Cluster, Load balancing and other tools. MySQL Replication … MySQL ? Need help with deadlocks, understanding how Innodb locking works or having Innodb performance issues ? We can help. Full Text …
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
… you can fail over in both directions. Aside from MySQL Cluster, which is more special-purpose, this is probably the best… the active master’s buffer pool with the following query: select table_schema, table_name, page_type, count(*) from information_schema.innodb…-digest to watch the traffic on the active master: mk-query-digest –processlist h=active \ –filter ‘$event->{arg} =~ m/^SELECT/i’ –execute…
Post: Recovering Innodb table Corruption
July 4, 2008 By 19 Comments
… on the simple one in this article – when page in clustered key index is corrupted. It is worse compared to having… simple Innodb Table Corruption. In more complex cases you may need to use higher innodb_force_recovery modes to block purging activity, insert…” for clustered index is corrupted this method will not work well – in this case you may wish to use Innodb Recovery Toolkit…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… which are very latency critical. Now what is about MySQL/Innodb specifics ? First, in MySQL if you’re looking for durable… Availability Some people are got used to using SAN based active-passive clusters for availability purposes and they look to do the… really had it) Even if you do not run any “Cluster” having SAN you can always “connect” the storage to another…
Post: Which adaptive should we use?
September 15, 2009 By 14 Comments
…of the many blocks are clustered. And to reduce the maximum of the modified ages InnoDB needs to flush …innodb_thread_concurrency = 0 innodb_ibuf_active_contract = 1
Comment: Finding your MySQL High-Availability solution – The questions
October 19, 2009 By 36 Comments
… is a lot with Heartbeat/DRBD and NDB cluster. @Gerry: I have seen cluster that have been up for more than a… in memory but… that about the same with InnoDB, at least the active dataset needs to be in the Buffer Pool. You…, NDB Cluster, a hash based sharding framework, is the easy and cheap solution. Maybe I have lucky, but the only InnoDB corruption…
