… load performance. It is so timely. I was trying to evaluate MySql performance to …this blog. I tuned on the paramerters like innodb_buffer_pool_size, large innodb_log_file_size…insert 50,000 records with one insertion. the insertion time is 3 second. when it reach Number 100 insertion, the insertion…
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
… Text Search solutions and compare their performance. Even if you missed the webinar,… when testing the InnoDB FT index, I made sure to increase innodb_buffer_pool_size … stay up to date with changes (inserts, updates and deletes)? That’s a … Solr, I was able to fine tune search and I still feel there…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
…buffer_size, innodb_buffer_pool_size, innodb_additional_memory_pool_size, innodb_log_buffer_…thread, however if table will perform complex operations such as full table…even larger – bulk inserts may allocate bulk_insert_buffer_size bytes …memory allocations which are not tuned as buffers. Watch for …
Post: MySQL and PostgreSQL SpecJAppServer benchmark results
July 25, 2007 By 13 Comments
…performance due to architecture optimizations. The other big issue is using MySQL 5.0.27 which has Innodb…not to mention specific tuning for Benchmark which could be performed on database engine… performance gains usually come from MySQL unique features – non transactional MyISAM, Multi Value inserts,…
Post: How multiple disks can benefit for single client workload ?
April 26, 2008 By 4 Comments
…Innodb storage engine to be more specific. Lets look at update queries (from replication thread for example). When update is performed…INSERT you will need to fetch clustered index page at least to do it. These reads are issues by Innodb…well. So as you might see tuning IO subsystem can indeed be fun …
Comment: Finding your MySQL High-Availability solution – The questions
October 19, 2009 By 36 Comments
…for good performance, data needs to be in memory but… that about the same with InnoDB, at …that you have implemented sharding. You have probably tune your schema in a way to reduce … forgot the insert buffer merge code. I have seen way more replication corruption issues than InnoDB corruption ones…
Comment: How Percona does a MySQL Performance Audit
November 25, 2008 By 17 Comments
… application. There’s only so much you can gain by tuning the server or upgrading the hardware.” I happened on such… where I was hired to “help out the DBA fix performance issues”, when eventually I went up to the developers and… low performance (one of the things they did was, on an InnoDB table, never to update row data, but instead DELETE+INSERT. The performance…
Post: Can having information public hurt consulting business ?
April 30, 2008 By 9 Comments
… effect because people find information on MySQL Performance Blog and use it instead of purchasing our … ready recipes, for example basic MySQL Configuration tuning. If the problem which you’re having …be complex, something like “Innodb uses row level locks, unless you’re doing insert in table with …
