…MySQL honestly was never good at is giving good helpful error messages. Start with basics for example – The error message in case of syntax error gives…error messages. Incorrect information if file table.frm is perhaps my favorite one. How do you expect to decode from this message…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…how to read these, there’s a full explanation in our book, High Performance MySQL 2nd Edition (it’s not in…fails, then you know from the error code that the server is dead. …out which are the most likely to give the greatest gains. I use …or just get on an instant messaging chat and tell the customer “…
Post: More on dangers of the caches
September 23, 2010 By 5 Comments
…code which would allow to do it on application side so we did it on MySQL side instead. “SET GLOBAL max_connections=20″ to…to get in. It is a lot better than having it done on page basics when you randomly have some pages giving error messages. In…
Post: InnoDB memory allocation, ulimit, and OpenSUSE
August 23, 2010 By 7 Comments
…error message was an assert due to a failed malloc() in ut_malloc_low() in ut/ut0mem.c inside InnoDB source code…to have the largest possible innodb_buffer_pool_size. Do not forget to give…
