Re: VERY slow InnoDB writes (in the teens/sec)
Posted by:
Rick James
Date: November 08, 2013 12:19PM
> innodb_buffer_pool_size = 16M
Change to, say, 1G
> innodb_flush_log_at_trx_commit = 1
Change to 2 -- speed versus security.
> upgraded ... to 5.6.14
From what? Were your tables previously MyISAM?
> remotely tries to insert several thousand rows of data in 1600 row batches
Good.
> Opened tables 26375
Ouch! Does no make sense. Anyway, increase this to, say 500:
> table_open_cache = 64
> It took 18 seconds to alter two columns
Is the table partitioned?
Subject
Views
Written By
Posted
5864
November 07, 2013 08:04AM
1924
November 07, 2013 08:26AM
Re: VERY slow InnoDB writes (in the teens/sec)
1805
November 08, 2013 12:19PM
1606
November 09, 2013 12:27AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.