…IO vs Disk question. If you look at Disk Based databases all data accesses are …CPU bound, while to understand if MySQL goes through more rows than it…INSERT you will need to fetch clustered index page at least to do …so can result in multiple outstanding requests to the disk. Though this does not…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 139 Comments
… and table structure. Now if you data fully on disk (both data and index) you would need 2…with large data sets. In MySQL single query runs as single thread (with exeption of MySQL Cluster) and MySQL issues … so. Use multiple servers to host portions of data set. Store portion of data you’re going …
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
… do not sync data to disk. Similarly, MySQL replication is an asynchronous process and although it is fairly fast at transferring data between the… Cluster is an integrated sharding environment, if you are planning for a growth that will need sharding (splitting the database over multiple…
Post: MongoDB Approach to Availability
April 30, 2010 By 2 Comments
… MySQL Cluster, especially in newer versions which implement “sharding”. Same as commit to NDB Storage engine does not normally mean commit to disk… getLastError() to ensure data is propagated to the slave. So you can see it as a hybrid between MySQL Cluster and innodb_flush… their votes and hold no data. The other different is there is only one master rather than multiple. This is because doing…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…cluster For best performance, there should be an even data distribution in the system. To get an even distribution, the test data…disk: 42GB (with indexes) # du -sh * 203M ibdata1 128M ib_logfile0 128M ib_logfile1 988K mysql…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
… reserves different extents from the clustered index. Q4: Does Innodb …of Innodb scalability with multiple threads and multiple concurrent transactions ? HT: …the disk for throughput. INNODB uses fuzzy checkpointing to commit data to disk….cc in 5.1: static MYSQL_SYSVAR_ULONG(thread_concurrency, srv…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
…nice monitoring tools available to see disk utilization latencies queues etc. There … clusters for availability purposes and they look to do the same with MySQL…more reliable, same as server with multiple power supplies ECC memory kill-… switching to that backup – no data copy will be required which …
Comment: Thoughts on MySQL Replication
July 9, 2006 By 18 Comments
… overly highly available. It is possible to do some clustering with updating multiple nodes but it would reduce performance. Other thing – technically… once have a chance. Speaking about NDB cluster – yes it has data on the disk in MySQL 5.1 – I however have not benchmarked…
Post: Introducing our Percona Live speakers
May 10, 2011 By 4 Comments
… disks and show graphs of the impact the vibration has on the disk…not what to think about replication. Data replication is one of the …MySQL to find the top N most important rows per group of rows, distributed across a cluster…and filesorts and multiple queries and all sorts of things in MySQL — and …
Post: MySQL MyISAM Active Active Clustering - looking for trouble ?
March 15, 2007 By 4 Comments
…available Oli is saying you can use MySQL with Active Active Clustering and MyISAM tables if you follow…be the problem is your data is so large you can’t afford multiple copies ? Well in this case you’re risking more in terms of downtime while repairing large tables. Disk…
