Skip to main content

Timeline for Magento DB Optimization

Current License: CC BY-SA 3.0

10 events
when toggle format what by license comment
May 29, 2015 at 11:26 vote accept Vinícius
May 27, 2015 at 13:17 answer added brentwpeterson timeline score: 0
May 8, 2015 at 18:17 comment added user2857 thats the question, what exactly you are trying to optimize then??? please find RDS instance name/size, storage size, IOPS, etc. have you tried to run mysqltuner.pl to see whats going on? please add these to your question.
May 8, 2015 at 13:04 comment added Vinícius @ADM edited the post with the biggest tables. I'm afraid I won't be able to give you exact specs about the DB (since I don't have direct access to the client's account), though we're running 2 RDS instances for reading and 1 for writing.
May 8, 2015 at 13:02 history edited Vinícius CC BY-SA 3.0
added 114 characters in body
May 8, 2015 at 13:01 comment added Vinícius @AmitBera there is one store with two views (desktop/mobile).
May 7, 2015 at 19:28 comment added user2857 this is pretty fascinating story - but - what is your db instance specs??? by the way 31/20 GB in DB size looks unusually VERY big to me, can you also post your biggest tables?
May 7, 2015 at 16:56 comment added Amit Bera how many store in your system?
May 7, 2015 at 16:43 review First posts
May 7, 2015 at 19:46
May 7, 2015 at 16:41 history asked Vinícius CC BY-SA 3.0