Mysql 5 InnoDB
Setting my.ini file configuration into innodb-heavy-load
SET AUTOCOMMIT=0;
START TRANSACTION;
insert ignore into table row1,row2,etc
update ignore set coloum1=value where condition
COMMIT;
SET AUTOCOMMIT=1;
fastest query before select query
FLUSH STATUS;
RESET QUERY CACHE;
SET GLOBAL query_cache_size=100000000;
SET GLOBAL sort_buffer_size=100000000;
SET AUTOCOMMIT=0;
START TRANSACTION;
insert ignore into table row1,row2,etc
update ignore set coloum1=value where condition
COMMIT;
SET AUTOCOMMIT=1;
fastest query before select query
FLUSH STATUS;
RESET QUERY CACHE;
SET GLOBAL query_cache_size=100000000;
SET GLOBAL sort_buffer_size=100000000;
<< Beranda