MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: A very slow query on InnoDb 5.1.67
Posted by: Peter Brawley
Date: April 18, 2013 10:53PM

> Swapping is worse than having too small a buffer pool.

Indeed, but he "did "see an actual improvement in increasing the innodb_buffer_pool_size from 192M=>380M=>512M=>768M".

Willem, there are other suggestions in http://dev.mysql.com/doc/refman/5.1/en/innodb-buffer-pool.html.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
A very slow query on InnoDb 5.1.67
2885
Willem van Schevikhoven
April 17, 2013 01:51AM
Re: A very slow query on InnoDb 5.1.67
1153
Peter Brawley
April 17, 2013 09:53AM
Re: A very slow query on InnoDb 5.1.67
1720
Willem van Schevikhoven
April 17, 2013 02:24PM
Re: A very slow query on InnoDb 5.1.67
1201
Peter Brawley
April 17, 2013 04:48PM
Re: A very slow query on InnoDb 5.1.67
1971
Willem van Schevikhoven
April 18, 2013 01:25AM
Re: A very slow query on InnoDb 5.1.67
1237
Peter Brawley
April 18, 2013 10:25AM
Re: A very slow query on InnoDb 5.1.67
1294
Willem van Schevikhoven
April 18, 2013 10:51AM
Re: A very slow query on InnoDb 5.1.67
1310
Peter Brawley
April 18, 2013 11:36AM
Re: A very slow query on InnoDb 5.1.67
1135
Willem van Schevikhoven
April 18, 2013 12:03PM
Re: A very slow query on InnoDb 5.1.67
1224
Rick James
April 18, 2013 08:29PM
Re: A very slow query on InnoDb 5.1.67
1108
Peter Brawley
April 18, 2013 10:53PM
Re: A very slow query on InnoDb 5.1.67
1257
Willem van Schevikhoven
April 23, 2013 02:24AM
Re: A very slow query on InnoDb 5.1.67
1194
Rick James
April 23, 2013 08:17AM
Re: A very slow query on InnoDb 5.1.67
1155
Willem van Schevikhoven
April 26, 2013 07:06AM
Re: A very slow query on InnoDb 5.1.67
1650
Willem van Schevikhoven
April 27, 2013 08:32AM
Re: A very slow query on InnoDb 5.1.67
1645
Rick James
April 27, 2013 09:47PM
Re: A very slow query on InnoDb 5.1.67
1421
Willem van Schevikhoven
May 23, 2013 03:38AM
Re: A very slow query on InnoDb 5.1.67
998
Rick James
May 23, 2013 08:27AM
Re: A very slow query on InnoDb 5.1.67
1023
Peter Brawley
May 23, 2013 10:41AM
Re: A very slow query on InnoDb 5.1.67
933
Rick James
May 23, 2013 08:25PM
Re: A very slow query on InnoDb 5.1.67
1068
Willem van Schevikhoven
May 24, 2013 03:20AM
Re: A very slow query on InnoDb 5.1.67
1308
Willem van Schevikhoven
May 24, 2013 03:22AM
Re: A very slow query on InnoDb 5.1.67
1077
Peter Brawley
May 24, 2013 11:13AM
Re: A very slow query on InnoDb 5.1.67
1278
Willem van Schevikhoven
May 24, 2013 01:43PM
Re: A very slow query on InnoDb 5.1.67
977
Peter Brawley
May 24, 2013 02:03PM
Re: A very slow query on InnoDb 5.1.67
1052
Willem van Schevikhoven
May 24, 2013 10:43PM
Re: A very slow query on InnoDb 5.1.67
1043
Peter Brawley
May 26, 2013 09:40PM


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.