Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
6
Impact
~2k people reached

  • 0 posts edited
  • 0 helpful flags
  • 1 vote cast
Jan
8
awarded  Popular Question
Nov
29
awarded  Autobiographer
May
5
awarded  Tumbleweed
Mar
23
awarded  Scholar
Mar
23
awarded  Supporter
Mar
23
accepted Good/Better config for MySQL on an EC2 Large Instance
Mar
21
comment Good/Better config for MySQL on an EC2 Large Instance
Ha! Not questioning so much as wanting to better understand. I have learned a bit as well. Things are moving a lot smoother, though I think my overall demand is quite low on the server as MySQL is only using around 5% of the system memory.
Mar
21
comment Good/Better config for MySQL on an EC2 Large Instance
You stated that you use O_DIRECT for the flush method, however I read in the documentation that if the data and logs are on a SAN that it can degrade select performance by a factor of 3. dev.mysql.com/doc/refman/4.1/en/… . Do you think I should use the default instead?
Mar
21
comment Good/Better config for MySQL on an EC2 Large Instance
What will the impact be of the innodb_flush_log_at_trx_commit = 2 setting? I know disabling flushing will increase performance but remove the 'D' from ACID. I will have to look up what a 2 does.
Mar
21
comment Good/Better config for MySQL on an EC2 Large Instance
Dangerously? Yikes! I will implement some of these settings today. Thank you for the thorough writeup.
Mar
21
comment Good/Better config for MySQL on an EC2 Large Instance
Thank you. I know I need to do testing, but this is for a project in development right now. The base settings are causing a lot of slowdown when entering products into Magento, so for the sake of the data entry team I need to get it somewhere I plan to fully benchmark the system once it is complete.
Mar
18
awarded  Student
Mar
18
asked Good/Better config for MySQL on an EC2 Large Instance