…. As a result, if you’re going to build a big database in the Amazon cloud platform, bigger than a single… and logical design, you can make certain workloads, such as insert-heavy, work better in the Amazon cloud platform. But this… balance. It requires tricks, such as partitioning so all the inserts go into one partition, whose indexes fit in memory. The…
Post: Performance Schema tables stats
May 2, 2011 By 2 Comments
… Wiki. If we look on performance overhead it appears rather big in read-only benchmark, and it is well explained in…_TIMER_FETCH: 84087466520 COUNT_INSERT: 4292 SUM_TIMER_INSERT: 1343751174852 MIN_TIMER_INSERT: 31913539 AVG_TIMER_INSERT: 313082268 MAX_TIMER_INSERT: 57121140547 COUNT_UPDATE: 8584…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…=innodb –mysql-db=test –oltp-table-name=md_cache_test_big –oltp-table-size=17600000 –mysql-user=msandbox –mysql-password=msandbox… mysqldump –defaults-file=my.sandbox.cnf test md_cache_test_big > /dev/null Baseline Run: When we run the tests individually… system. It is worth to note MySQL actually uses midpoint insertion for its buffer pool replacement policy . Unfortunately by default it…
Comment: Why MySQL could be slow with large tables ?
November 14, 2008 By 141 Comments
…,61 61,29% select 933k 1,447,66 27,20% insert 358k 555,08 10,43% update 30k 47,19 0… # clients (those using the mysqlclient10 compatibility package). old_passwords=1 big-tables [mysqld_safe] log-error=/var/log/mysqld.log pid… need to insert manually in my.cnf for best performance & low disk usage? – may i remove old_passwords=1 & big-tables? — Web…
Post: How to calculate a good InnoDB log file size
November 21, 2008 By 38 Comments
… workload, but they often don’t need to be as big as you might think, either. If this rule-of-thumb… have a more active write workload. Perhaps you’re inserting a lot of big rows or something. In this case you might… generally make recovery faster than you might expect with a big log. However, most of the time when I run this…
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
… page data. The next comes trial and error approach: mysql> insert into test2 select * from test; ERROR 2013 (HY000): Lost connection… we get about 50 rows per page so not a big surprise 30 rows was not enough – typically if page directory… use higher innodb_force_recovery modes to block purging activity, insert buffer merge or recovery from transactional logs all together. Though…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… and so much faster than Flash. SSD Drives would be big win for TableSpace files but these are much larger and… bugs opened about multi-core scalability (concurrent queries, autoincrement, concurrent inserts, instrumentation, etc.). Rather than treat each defect as an individual… the table has become fragmented? Or maybe you have not inserted in the ascending order of the primary key? I suggest…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… how it plays when we can see more benchmarks. The big problems I see so far with this feature are ease… small tables, everything can reside within a single extent. For big tables, a secondary index reserves different extents from the clustered… benefit if you’re performing INSERT with multiple values? We build up INSERTS on our clients and insert values 50 or so at…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… indexes built by sorting in case of ALTER TABLE (the big Gotcha for MyISAM tables). Are there any plans to be… other requirements, needs all auto-increment values in multiple value insert to be sequential. To be honest Heikki probably took a… code simple and same for all insert cases – in fact if the insert is single value insert or the number of values in…
Post: Using VIEW to reduce number of tables used
September 28, 2007 By 12 Comments
… approach works for SELECT, UPDATE, DELETE queries but not for INSERT: mysql> insert into post123 values(1,”aaa”,”bbb”); ERROR 1369 (HY000… so you could write triggers to perform insert inserts to base tables instead of views. BEFORE INSERT triggers would not help because the… only few places when insert happens so it should not be big problem. Technically if you can’t make inserts to the base…
