… stay in the buffer_pool.) If I recall correctly, any INSERT/DELETE/etc always opens all partitions, even before thinking about… would argue that single-row queries (SELECT, INSERT, DELETE, UPDATE) are similar in speed between PARTITIONed or non-PARTITIONed. When PARTITIONed, first…
Comment: Predicting how long data load would take
December 1, 2007 By 14 Comments
… down of the insertion speed completely. It will happen sooner or later. My question is that is this type of insertion speed drammtic slow… found the insertion speed slow down at about 1GB table size. I use JDBC to insert 50,000 records with one insertion. the insertion time is 3 second. when it reach Number 100 insertion, the insertion time eventually…
Post: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
… bound. As you can see from MyISAM results (above) the insert speeds does not degrade that badly until going from 1000 to… overhead for this server configuration. Going to 10000 tables however insert speed dropped 20 times. This could be because ext3 does not… see insert speed starts slower but degrades less, even though drop from 1000 to 10000 tables is dramatic as well. The read speed…
Comment: Using MyISAM in production
June 3, 2008 By 36 Comments
…. Yes, but say for example, MyISAM default insert speed is great, but InnoDB default insert speed is poor. (I have seen your InnoDB optimization…
Comment: Benchmarking single-row insert performance on Amazon EC2
October 13, 2012 By 17 Comments
… improvements when talking about the insert benchmark that I performed. In many parts of this benchmark, insert speed is limited by how quick… not going to help with that. But overall I think, insert performance should see any improvement when done using SSDs. I…
Comment: MySQL Server Memory Usage
May 27, 2009 By 21 Comments
Hello, I’m running MySQL 5.1.33 for Solaris 8. The insert speed is about 2300 rows/sec at 240Kb/s. Is it the normal speed or par below the standard? I’m quite a newbie hence the question.
Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1
November 7, 2007 By 117 Comments
Hi, I measured the performance of InnoDB vs MyISAM for insertion queries for up to 100 threads (see presentation “Measuring MySQL… short records (less than 200 bytes) MyISAM outpreforms InnoDB for insertion speed. For the recird sizes between 1KB and 10MB MyISAM is…
Comment: Unused indexes by single query
September 14, 2008 By 14 Comments
… performance testing to find out how much benefit (disc space, insert speeds etc) dropping it would provide. It probably isn’t as…
Comment: MySQL File System Fragmentation Benchmarks
March 22, 2008 By 28 Comments
Simetrical, I just checked and it was not used… I thought it was set by default already on CentOS4 box. So yes lack of dir_index should be one of the things which impacted insert speed.
Comment: Choosing innodb_buffer_pool_size
November 4, 2007 By 39 Comments
… they are more compact (use much less space) and the insert speed is higher (in my case)
