… so that we can see the full write speed of the disk for throughput. INNODB uses fuzzy…? HT: ha_innodb.cc in 5.1: static MYSQL_SYSVAR_ULONG(thread_concurrency, srv_thread_concurrency, PLUGIN… if you’re performing INSERT with multiple values? We build up INSERTS on our clients and insert values 50 or…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…##################################################### Total | 23.59G … Locator Size Speed Form Factor Type Type Detail ========= ======== ================= … MySQL configurations, I didn’t try out different MySQL… incredible performance boost – up to 33x in…data being modified, inserts are done to …
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 11 Comments
… from your MySQL database. When you do, the limitations on the core counts and effective CPU speeds can … quite severe stalls as I/O requests stack up and other things block against them. If you … design, you can make certain workloads, such as insert-heavy, work better in the Amazon cloud platform. …
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…be much larger than table itself) The index build speed is however not only reason I can’t … are probably similar problems in INSERT IGNORE and ON DUPLICATE KEY UPDATE cases. Now In MySQL 5.1+ it is… why large stripes are better and why battery backed up cache is so important. I also usually speak …
Post: Preprocessing Data
August 8, 2011 By 3 Comments
… on the database server. You decide to set up four seperate tables for each graph and schedule … these new tables. You have now improved the speed of the main page of the website as …want to consider preprocessing your data: On Insert This is when you insert data into the database. Your application …
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
…Solr and Sphinx, do indexes stay up to date with changes (inserts, updates and deletes)? That’s a… you add new data to the MySQL database or else periodically batch-insert data that has changed since…memory database, you can get a lot of speed improvement because you’re searching data without touching…
Comment: Benchmarks of new innodb_flush_neighbor_pages
July 3, 2012 By 8 Comments
… scaling inserts so I dont know if it will help for Selects and Updates http://mysqlopt.blogspot.com/2012/06/mysql-how-to-scale-inserts.html [Quote] “However, you can reach better through put (inserts per second) with less… of cache to disk not ram for mysql like varnish for http webserver should speed up mysql since its already technically on the disk…
Post: Conflict Avoidance with auto_increment_increment and auto_increment_offset
January 12, 2011 By 2 Comments
… lot of people are running MySQL Master-Master replication pairs in Active-Passive mode for purpose …these options help to avoid some conflicts – if you have insert in table with auto_increment column you will almost for…logs but having it in the database too allows to speed up process in many cases.
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
… memcache you end up reducing number of reads from database dramatically but writes still have to happen at full speed. It also… not have to do it for the same table as inserts go to. The trick you can use here is standard “shadow table” trick – use two tables insert into one and process and truncate another. MySQL offers atomic RENAME TABLE call which can…
Post: PROCEDURE ANALYSE
March 23, 2009 By 9 Comments
… and speeds up processing in most cases ? These and similar tasks are often done by bunch of SQL queries while really MySQL has…’) NOT NULL Here is how this table was originally defined: mysql> desc node; +———-+——————+——+—–+———+—————-+ | Field | Type | Null | Key | Default | Extra | +———-+——————+——+—–+———+—————-+ | nid | int… ENUM though as we know new types can appear by inserts we can’t do it. In other drupal installation though…
