Databases
MySQL Security Essentials Presentation
Today at the RMOUG Training Days 2012 event I gave an introduction presentation on MySQL Security Essentials covering the following topics: MySQL Security defaults MySQL Security Improvements OS Security User Privileges Data Integrity Installation Practices Auditing Options Better Security Further References Download slides for MySQL Security Essentials .
Read moreExciting upcoming MySQL events
At the IOUC leaders’ summit in San Francisco this week, key leaders from Oracle, Java and MySQL user groups world wide have been meeting. This has included the key Oracle MySQL resources from the community, marketing and product teams.
Read moreWhy is searching the manual so hard
As a consultant I often use the MySQL Reference Manual to provide additional information for clients. I am very happy to recognize the quality of the content in the MySQL documentation, but why is the searching of the manual so, so bad?
Read moreThe most important MySQL Reference Manual page
In my opinion, The Server Option and Variable Reference at http://dev.mysql.com/doc/refman/5.5/en/mysqld-option-tables.html rates as my most important page. This is a consolidated index that enables a drill down to the Server Command Options, System Variables, Startup and replication specifics, as well as important information on default values and differences between versions including point releases.
Read moreBinary Log Replayer
When using the replication slave stream, or mysql command line client and mysqlbinlog output from a binary/relay log, all statements are executed in a single thread as quickly as possible.
Read moreSpeaking in Denver
Following a heavy schedule in the last month speaking in Tokyo , Beijing, Manila and Auckland it is nice to be on home soil for upcoming speaking. I will be in Denver, Colorado for RMOUG 2012 from February 14-16, 2012 where I will be speaking about the essentials of MySQL security.
Read moreDo you have a MySQL horror story to share?
I am looking for a few more unique examples to add to the final chapter of my upcoming book on MySQL Backup & Recovery . If you would like to share your fun experience, receive a mention and a free copy please let me know via comment.
Read moreNoSQL from a RDBMS company
Oracle has announced an open source product for the NoSQL space, the Oracle NoSQL Database . Unlike other popular products including Redis, MongoDB, Cassandra, Voldermort and many others, Oracle has set a benchmark on the features that are truly necessary for highly available data systems.
Read moreOracle Open World Presentations
<p> At <a href="http://orancle.com/openworld">Oracle Open World 2011</a> there has been a large number of MySQL presentations. You can download the slides of my two presentations at <a href="http://effectivemysql.com/downloads/ExplainingTheMySQLEXPLAIN-OOW-2011.pdf">Explaining the MySQL Explain</a> and <a href="http://effectivemysql.
Read moreThe Effective MySQL Book Series
Announced on Sunday at Oracle Open World 2011 is the release of the Effective MySQL book series starting with the “Optimizing SQL Statements” title. The goal of the Effective MySQL series is a highly practical, concise and topic specific reference providing applicable knowledge to use on each page.
Read moreSpeaking at Insight Out in Tokyo
I will be joining a stellar class of speakers at the Insight Out DB Showcase in Tokyo from Oct 19-21, 2011. This event covers several RDBMS technologies including MySQL. My topics are:
Read moreReasons to use MySQL 5.5 Presentation
I recently gave a presentation at the New York Effective MySQL Meetup on the new features of, and some of the compelling reasons to upgrade to MySQL 5.5. There are also a number of new MySQL variables that can have a dramatic effect on performance in a highly transactional environment, innodb_buffer_pool_instances and innodb_purge_threads are just two to consider.
Read moreUtilizing multiple indexes per MySQL table join
Historically it was considered that MySQL will generally use only one index per referenced table in a SQL query. In MySQL 5.0 the introduction of merge indexes enabled for certain conditions the possibility to utilize two indexes however this could result in worst performance then creating a better index.
Read moreExtra: Using Index
Many people consider this information in the MySQL Query Execution Plan (QEP) to indicate that the referenced table is using an index. It actually means that ONLY the index is used.
Read more