May 23, 2012

Comment: How much memory Innodb locks really take ?

…/InnoDB. Do you think you can show a program where row-locks are used by one user to lock records for…

Comment: Testing Fusion-io ioDrive - now with driver 3.1

… testing with a couple of MySQL servers with ioDrive2 cards (two in each) with the 3.1.1 driver. Thanks!

Comment: Benchmarking single-row insert performance on Amazon EC2

… makes the insertions easy. Basically you fill in 100 million rows, then start a new partition and fill that in. During…, you didn’t graph the performance on the first 100M rows). The minimum performance troughs occur just as the partition switches… started, today the challenge would be to index 10B rows, not 1B rows. And it’s still a good challenge. The URL…

Post: Benchmarking single-row insert performance on Amazon EC2

… partitioning scheme such that every partition would hold 100 million rows. Table Structure The table structure of the table with no… see that the insert rate is pretty much constant remaining between ~25k to ~26k INSERTs Per Second. But on the other…, because it varies between ~6.5k to ~12.5k INSERTs per second, with noticeable spikes after every 100 million rows inserted. I…

Comment: Multi Column indexes vs Index Merge

…merge (intersect). Below are two explains that I … where | +—-+————-+————-+————-+————————————————————–+——————–+———+———————————-+——+————————————————–+ 4 rows

Post: Load management Techniques for MySQL

… case throttling by having relatively short queries and introducing “sleeps” between them can be a good idea. It also often helps…

Comment: Why MySQL could be slow with large tables ?

i have 90GB db, my selects are pretty slow with tables over 500,000 rows. guess i will have to partition as i used up the maximum 40 indexes and its not speeding things up. i think max rows per table should be 50-100k rows

Comment: SHOW INNODB STATUS walk through

… described every 15 seconds instead it doesn’t create any row at all. How can that be, what have i overlooked…

Post: Testing Fusion-io ioDrive2 Duo

… 2.4TB card and it is visible to OS as two devices (1.2TB each), which can be connected together via software RAID. So I tested in two modes: single drive, and software RAID-0 over two drives. I should note that to…

Comment: How to load large files safely into InnoDB with LOAD DATA INFILE

…’re using different replication strategies. I can well imagine that row-based replication will indeed transfer the data, whereas statement-based…