Mysql for Oracle Dba
Don’t Assume – Per Session Buffers
MySQL has a number of global buffers, i.e. your SGA. There are also a number of per session/thread buffers that combined with other memory usage constitutes an unbounded PGA. One of the most common errors in mis-configured MySQL environments is the setting of the 4 primary per session buffers thinking they are global buffers.
Read moreDon’t Assume – Transactions
MySQL by default is a NON transactional database. For the hobbyist (See The Hobbyist and the Professional ), startup entrepreneur and website developer this may not appear foreign, however to the seasoned Oracle DBA who has only used Oracle the concept is very foreign.
Read moreDon’t Assume – Common Terminology
In Oracle the default transaction isolation is READ_COMMITTED. In MySQL the default is REPEATABLE_READ. Because MySQL also has READ_COMMITTED I have seen in more then one production MySQL environment a transaction isolation of READ_COMMITTED.
Read moreDon’t Assume – Session Scope
MySQL system variables and status variables have two scopes. These are GLOBAL and SESSION which are self explanatory. This is important to realize when altering system variables dynamically. The following example does not produce the expected results.
Read moreDon’t Assume Series – MySQL for the Oracle DBA
As part of my MySQLCamp for the Oracle DBA series of talks to help the Oracle DBA understand, use and appreciate MySQL I have also developed a series of short interesting posts I have termed “Don’t Assume”.
Read moreLearning MySQL as an Oracle DBA
Updated I have an entire section now devoted to various MySQL for the Oracle DBA Resources . You will find additional information here. This week I presented two one day free seminars, “MySQL DBA Bootcamp for the Oracle DBA ” in New York and San Francisco.
Read more