Yesterday I ran into an old collegue that now runs quite a successful computer store chain and highly successful web store here in Australia. Long story short he was having some MySQL problems, so I offered to pass my eye over it. Now, given that they had some data corruption in stock levels not being correct (e.g. getting to an inventory count of -1), my first split second thought was inappropiate transaction management.
In thinking last night, what would I do as part of auditing an existing MySQL Installation and application quickly for reference and also to highlight issues etc, assuming I would have no access to any administrators or developers.
So what would you do? I made some preliminary notes, here’s the full account of what I did do.
$ mkdir /tmp/arabx $ cd /tmp/arabx # keep a quick copy of stuff $ script # Linux generals $ hostname $ uname -a $ uptime $ …[Read more]