Re: Show innodb engine status tuning db server
Posted by:
Frwa Onto
Date: October 07, 2013 09:06AM
Dear Rick,
Ok my knowledge the ibdata1 increase happen when I started to add quite a number of new indexes and nothing extra I did during that time.
In my application at anytime only
T1: UPDATE foo ... WHERE id = 123;
T2: UPDATE foo ... WHERE id = 987; in the transaction only one update foo .... where id=123 takes place so there is no chance for another update statement on the same table in 1 transaction I have checked that. I will go further and check for more indexes.
Subject
Views
Written By
Posted
2482
September 15, 2013 09:37AM
1042
September 16, 2013 07:14PM
1582
September 17, 2013 08:52AM
1023
September 18, 2013 07:21PM
1087
September 19, 2013 09:08AM
993
September 23, 2013 12:48PM
987
September 24, 2013 08:45PM
1221
September 24, 2013 10:01PM
915
September 26, 2013 11:29PM
1054
September 27, 2013 03:53AM
942
September 27, 2013 11:52PM
1008
September 28, 2013 12:39PM
959
September 29, 2013 08:40AM
960
October 01, 2013 01:43AM
978
October 01, 2013 10:14PM
896
October 01, 2013 10:35PM
922
October 02, 2013 07:43PM
1028
October 02, 2013 11:08PM
977
October 03, 2013 07:48PM
988
October 04, 2013 09:04PM
1065
October 06, 2013 01:43PM
Re: Show innodb engine status tuning db server
879
October 07, 2013 09:06AM
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.