… errors that is relatively easy to diagnose, if you pay close attention to the error message. Often an error has a…). Now, MySQL includes a little perror utility to translate this into something a human can understand: $ perror 28 OS error code 28: No space left on device That’s the key to understanding what really happened. MySQL created a…
Comment: MariaDB 5.3 is released as GA!
March 7, 2012 By 17 Comments
… would say MariaDB is seriously underrepresented on places like planet mysql. (Ie possibly real MariaDB usage must be higher than what… Oracle is closing MySQL source code.) Personally I don’t see the problem distros have with the MySQL model. Contrary to common belief MySQL maintenance… that distros would only want to patch security issues whereas MySQL also fixes non-security bugs like server crash, wrong result…
Post: MySQL opening .frm even when table is in table definition cache
November 21, 2011 By 8 Comments
…, it lives in sql/sql_view.cc as mysql_frm_type(). What this code snippet does is: open the FRM read 10… didn’t look closely) An example of how this is used is that in the DROP TABLE code path, MySQL uses this magic… the table. The main consequence of this bit of code is that MySQL may cause unnecessary disk IO for information it already…
Post: 7 Reasons why MySQL Quality will never be the same
December 10, 2008 By 15 Comments
… of what serious bugs are. Large Team, Tricky Code During MySQL 3.23 and MySQL 4.0 team the small tight knit team… personally reviewing all the code and knew all the code well to know all the side effects etc. Now MySQL Development is done… included default MySQL. Why is not this part of stock MySQL 5.1 ? I guess because MySQL 5.1 release was closed for any…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
I am constantly referring to the amazing MySQL manual, especially the option and variable reference table. But just …
Post: MySQL Limitations Part 4: One thread per connection
October 27, 2010 By 14 Comments
… post is about the way MySQL handles connections, allocating one thread per connection to the server. MySQL is a single process with… by default, so that a connection isn’t really closed when it’s closed; it’s kind of like a connection pool… partially implemented is a pool of threads, which was originally coded for MySQL 6.0, but is available now in MariaDB. Unfortunately…
Post: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
… for MySQL Server code and various small static buffers. This is memory which you can consider used when you just start MySQL Server… this is as much close to impossible to be impractical. Here is why: List of rarely considered MySQL Server Memory Requirements Thread… in the given table which is held until table is closed. Federated Storage Engine. This may have unbound memory requirements retriving…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… list 1. Be Pluggable Unlike many OpenSource projects MySQL was single chunk of code and for years the only way you could… on MySQL because subqueries optimizer weakness. I’m saying about XA which were released in MySQL 5.0 without consistent work with MySQL close… inside who can figure things out and even patch MySQL if needed. So MySQL went to chase Enterprise market and develop enterprise…
Post: MySQL Prepared Statements
August 2, 2006 By 19 Comments
… to normal API for some statements Newer and sometimes buggy code. I had a lot of problems with PHP prepared statements… multiple connections. Do not forget to close prepared statements – Many memory leaks reported in MySQL Server turned out to be prepare statements or cursors which were forgotten to be closed. Watch Com_stmt…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… all kinds of schema diagrams and code listings, but the truth is …mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…see that something is disconnecting ungracefully (without closing the connection properly). This is happening…
