Return to Question

	10	replaced http://dba.stackexchange.com/ with https://dba.stackexchange.com/ source \| link	edited Apr 13 '17 at 12:42 Community♦ 1
inline side-by-side side-by-side markdown How large should be mysql innodb_buffer_pool_size?How large should be mysql innodb_buffer_pool_size? How large should be mysql innodb_buffer_pool_size? How large should be mysql innodb_buffer_pool_size?

	9	replaced http://serverfault.com/ with https://serverfault.com/ source \| link	edited Apr 13 '17 at 12:13 Community♦ 1
inline side-by-side side-by-side markdown MySQL query, 2 similar servers, 2 minute difference in execution times MySQL query, 2 similar servers, 2 minute difference in execution times MySQL query, 2 similar servers, 2 minute difference in execution times MySQL query, 2 similar servers, 2 minute difference in execution times

	8	problem finally solved source \| link	edited Sep 3 '14 at 7:50 juantxorena 811 silver badge5 bronze badges
inline side-by-side side-by-side markdown SOLVED So, we finally tested this in prod, and it was the problem I commented on previously. I put the value of innodb_buffer_pool_size in 321M, which is the value recommended by the vendor of the SDK we use, even though according to the previous links it should be around 3G for a DB of this size and usage. I still have a doubt, though: the value of 321 was an invalid value (too small), so MySQL took another value. My suspicion is that it took the previous valid number, 321M in test, and 182M in prod, hence the speed differences. It's just out of curiosity, but I would like to know if this is right. Thank you all again for the help. SOLVED So, we finally tested this in prod, and it was the problem I commented on previously. I put the value of innodb_buffer_pool_size in 321M, which is the value recommended by the vendor of the SDK we use, even though according to the previous links it should be around 3G for a DB of this size and usage. I still have a doubt, though: the value of 321 was an invalid value (too small), so MySQL took another value. My suspicion is that it took the previous valid number, 321M in test, and 182M in prod, hence the speed differences. It's just out of curiosity, but I would like to know if this is right. Thank you all again for the help.

	7	update source \| link	edited Aug 25 '14 at 14:24 juantxorena 811 silver badge5 bronze badges


	6	added 56 characters in body source \| link	edited Aug 25 '14 at 9:55 juantxorena 811 silver badge5 bronze badges


	5	More information source \| link	edited Aug 25 '14 at 9:14 juantxorena 811 silver badge5 bronze badges


	4	More information source \| link	edited Aug 25 '14 at 9:00 juantxorena 811 silver badge5 bronze badges


	3	added 81 characters in body source \| link	edited Aug 23 '14 at 12:24 juantxorena 811 silver badge5 bronze badges


	2	Removed windows 2008 tag since the OS is not the real issue. Added windows tag since both servers use Windows \| link	edited Aug 22 '14 at 17:16 RolandoMySQLDBA 152k25 gold badges242 silver badges410 bronze badges


		Tweeted twitter.com/#!/StackDBAs/status/502858522905051136	occurred Aug 22 '14 at 16:43

		Post Migrated Here from serverfault.com	occurred Aug 22 '14 at 16:02

	1	source \| link	asked Aug 22 '14 at 14:13 juantxorena 811 silver badge5 bronze badges

Stack Exchange Network

current community

your communities

more stack exchange communities

Return to Question