tag:blogger.com,1999:blog-64805554348536763252026-10-05T03:17:53.195-06:00MySQL DBA - An Oracle DBA's JourneyMySQL blog focused on DBA topics, MySQL development and open source infrastructure environments.Anonymoushttp://www.blogger.com/profile/00291214843973166978noreply@blogger.comBlogger156125tag:blogger.com,1999:blog-6480555434853676325.post-19228754619446520032013-11-10T16:35:00.001-07:002013-11-10T16:39:47.186-07:00MySQL Ranked as #2 Relational DatabaseDB-Engines.com (http://db-engines.com/en/ranking/relational+dbms) ranks MySQL as the #2 most popular relational database after Oracle. MySQL is continuing to grow and gain market share. MySQL 5.6 and 5.7 show the database server is continuing to add significant new functionality in each release. MySQL is extremely fast and scalable. MySQL cluster can also perform well Anonymoushttp://www.blogger.com/profile/00291214843973166978noreply@blogger.com0tag:blogger.com,1999:blog-6480555434853676325.post-58398912324919358132013-04-07T12:45:00.000-06:002013-04-07T12:59:07.370-06:00Best Practices for Installing MySQL (MOCA)<!--[if !mso]>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
<![endif]--><!--[if gte mso 9]>
0
0
1
2580
14711
Hortonworks
122
34
17257
14.0
96
800x600
<![endif]-->
<!--[if gte mso 9]>
Normal
0
false
false
false
EN-US
JA
X-NONE
Anonymoushttp://www.blogger.com/profile/00291214843973166978noreply@blogger.com0tag:blogger.com,1999:blog-6480555434853676325.post-62011893494160919102012-07-27T06:07:00.002-06:002012-07-27T06:12:36.808-06:00VMWare VM - The Default Platform for MySQLThe MySQL Market Continues to Grow
I am continuing to see the continued growth of MySQL not only in the SMB market but in Fortune 500 accounts. I recently asked a large customer what their distribution of databases is and they responded with:
2000 Oracle databases
4000 SQL Server databases
6000 MySQL databases
MySQL the Internet Database Platform
Since taking over MySQL, Oracle Anonymoushttp://www.blogger.com/profile/00291214843973166978noreply@blogger.com0tag:blogger.com,1999:blog-6480555434853676325.post-84608223473687130852011-11-20T11:25:00.001-07:002011-11-20T11:31:48.085-07:00Virtualizing MySQL - The Next Big StepMySQL is continuing to be a big player in hosting and cloud companies. Two of MySQL's great features are how light weight it is and it's speed. This gives MySQL a lot of advantages over other database vendors. Yet it is also a disadvantage because the other larger database vendors have more infrastructure and tooling that can impact MySQL being chosen as a long term enterprise Anonymoushttp://www.blogger.com/profile/00291214843973166978noreply@blogger.com1tag:blogger.com,1999:blog-6480555434853676325.post-77292186909240749102011-10-03T10:28:00.000-06:002011-10-03T10:28:49.092-06:00MySQL at Oracle Open World 2011It's great to see so many presentations and activities surrounding MySQL at Oracle Open World this year. There are a lot of Dolphins around the conference which is great to see as well.
They MySQL reception Tuesday evening is going to be a great opportunity to get caught up with everyone.Anonymoushttp://www.blogger.com/profile/00291214843973166978noreply@blogger.com1tag:blogger.com,1999:blog-6480555434853676325.post-36970187772864302672011-09-23T07:09:00.000-06:002011-09-23T07:09:57.405-06:00Oracle Open World 2011 - Virtualization ActivitiesVirtualization is going to be one of the hottest topics at Oracle Open World 2011. Here is a link to track a number of the virtualization presentations.
http://www.oracle.com/openworld/oow11-focuson-virtualization-485282.pdfAnonymoushttp://www.blogger.com/profile/00291214843973166978noreply@blogger.com0tag:blogger.com,1999:blog-6480555434853676325.post-57281382338798779602011-04-20T12:17:00.001-06:002011-04-20T12:20:07.183-06:00Where the MySQL Users Conference Should Consider GoingThe MySQL Users Conference and the Oracle Collaborate Conference both finished last week. Since that time there has been a pretty significant bitstream discussing where the MySQL Users Conference should go and what is it's future. Here are a few insights and overviews of MySQL Users Conference:
http://tinyurl.com/3zr3kbw
http://tinyurl.com/3kl7x6p
http://tinyurl.com/y4x3qch
Anonymoushttp://www.blogger.com/profile/00291214843973166978noreply@blogger.com3tag:blogger.com,1999:blog-6480555434853676325.post-49560329871149341502011-02-10T01:18:00.001-07:002011-02-10T01:24:29.142-07:00MySQL Growing Faster in the CloudIt's been amazing to see the growth of MySQL in the cloud. I'm seeing more customers moving to cloud providers that are offering MySQL platforms running in Virtual Machines. It's interesting to see the way the cloud providers are configuring and delivering the platforms. Virtualization is going to continue to be the deployment method for the delivering of systems in the cloud.&Anonymoushttp://www.blogger.com/profile/00291214843973166978noreply@blogger.com1tag:blogger.com,1999:blog-6480555434853676325.post-91552763403745370542010-10-23T10:33:00.000-06:002010-10-23T10:33:14.095-06:00MySQL Most Popular Database and GrowingThe great thing about Open Source is that despite proprietary vendors best efforts, they can't control the market for open source. When I first joined MySQL AB years ago, industry analysts estimated there were over 12 million MySQL database servers running. Which is why MySQL has been considered the most popular database. Now conservative estimates are now at 80 million MySQL Anonymoushttp://www.blogger.com/profile/00291214843973166978noreply@blogger.com1tag:blogger.com,1999:blog-6480555434853676325.post-34780394637001708152010-09-19T09:07:00.002-06:002010-09-19T09:07:35.610-06:00MySQL Sunday at Oracle Open World 2010MySQL Sunday is an open series and looks like a great start to the Oracle Open World conference. Everyone is waiting to see if there are any announcements for MySQL at the conference from Oracle. I like that they are starting with Edward Scriven and closing with Marten Mickos. Hopefully there will be a lot of questions answered on stated directions and the MySQL 5.5 release and Anonymoushttp://www.blogger.com/profile/00291214843973166978noreply@blogger.com0tag:blogger.com,1999:blog-6480555434853676325.post-23852107836365888692010-08-19T07:55:00.001-06:002010-08-19T07:56:18.479-06:00MySQL at Oracle Open World - San Francisco 2010Everybody is very interested in understanding the Oracle message about MySQL. Oracle is responding with a "MySQL Sunday" and a number of excellent presentations throughout the week in San Francisco at Oracle Open World. My session on MySQL is:
Session S316920 - The Ultimate Bootstrap for MySQL on Windows
There are also a number of excellent old MySQLers and friends Anonymoushttp://www.blogger.com/profile/00291214843973166978noreply@blogger.com0tag:blogger.com,1999:blog-6480555434853676325.post-41946715362711540662010-07-21T17:39:00.000-06:002010-07-21T17:39:17.291-06:00MySQL and Open Source at Oracle Open WorldOracle Open World is fast approaching. I am definitely looking forward to the MySQL and open source activity at the upcoming Oracle Open World conference in San Francisco. I'm scheduled to deliver a presentation on implementing MySQL on Windows. I am also looking forward to Oracle's first Open World conference with MySQL under the Oracle family umbrella.Anonymoushttp://www.blogger.com/profile/00291214843973166978noreply@blogger.com1tag:blogger.com,1999:blog-6480555434853676325.post-11949245579609232662010-04-13T10:43:00.001-06:002010-04-15T07:49:06.761-06:00MYSQL 5.5 highlights and MySQL Cluster 7.1MySQL 5.5 Highlights - It's a lot faster!
InnoDB
Multiple Buffer Pool Instances
Multiple Rollback Segments
Extended change buffering and purge scheduling
Improved Log Sys and Flush List mutex
Improved locking
Improved statistics on InnoDB mutexes, rw-locks, threads and I/O operations.
Improved performance/scale with Win32, 64
Scales to 32 cores
Semi-synchronoous replication
PerformanceAnonymoushttp://www.blogger.com/profile/00291214843973166978noreply@blogger.com1tag:blogger.com,1999:blog-6480555434853676325.post-14723376251754611562010-04-13T08:43:00.018-06:002010-04-17T11:58:15.691-06:00MySQL Users Conference 2010
Since the Sun acquisition and the following announcement of the Oracle acquisition, the owner of MySQL have been fairly silent in terms of stated directions of MySQL. This has allowed a lot of FUD to be spread throughout the user community. At the MySQL users conference there are going to be some excellent keynotes helping customers get an update on MySQL technology.&Anonymoushttp://www.blogger.com/profile/00291214843973166978noreply@blogger.com0tag:blogger.com,1999:blog-6480555434853676325.post-40042068369112117282010-02-13T14:22:00.001-07:002010-02-13T14:26:03.797-07:00The Journey Continues ...I was a leader in the Oracle community who joined MySQL two years ago to learn more about the open source world. The two years at MySQL were fantastic. The extraordinary camaraderie, spirit and energy of the company was unbelievable. I worked with some fantastic people and made a number of life time friends.
On Monday I become a full time employee of Oracle, so I've come Anonymoushttp://www.blogger.com/profile/00291214843973166978noreply@blogger.com0tag:blogger.com,1999:blog-6480555434853676325.post-23837744469640460572010-02-08T08:07:00.000-07:002010-02-08T08:07:08.853-07:00Ken Jacobs a great advocate of the database user communitiesKen Jacobs has been a fantastic advocate of the Oracle and MySQL user communites. I met Ken on the board of the Independent Oracle Users Group (IOUG). While Ken was the board liasson on the IOUG board, he was always supporting the Oracle user groups and made very important contributions throughout his time on the board and afterwards. After serving time on the board, Ken was Anonymoushttp://www.blogger.com/profile/00291214843973166978noreply@blogger.com1tag:blogger.com,1999:blog-6480555434853676325.post-617038869800184512010-02-07T06:27:00.002-07:002010-02-07T06:31:17.799-07:00Oracle's Commitment to MySQL, MySQL Releases and Development CyclesThe last few weeks I am still being asked what is going on with Oracle and MySQL and where is MySQL with it's software releases. So I am going to include some URLs to hopefully answer some of your questions regarding MySQL.
Oracle's press release on December 14, 2009 regarding MySQL.http://www.oracle.com/us/corporate/press/042364
Summary list MySQL software releases. A more detailed list Anonymoushttp://www.blogger.com/profile/00291214843973166978noreply@blogger.com1tag:blogger.com,1999:blog-6480555434853676325.post-60391063133216599212010-02-02T23:01:00.006-07:002010-02-09T16:41:35.121-07:00Configuring the InnoDB Plugin (1.0.6) in MySQL 5.1.43Configuring the InnoDB Plugin (1.0.6) is just as easy in the MySQL 5.1.43 release. There are a few subtle changes in the new release. Set the following parameters to configure the InnoDB plugin in 5.1.43. A few notes: Set the PLUGIN_DIR parameter to the location of the plugin libraries.
Verify all the libraries listed below are in the PLUGIN_DIR directory.
The PLUGIN_LOAD Anonymoushttp://www.blogger.com/profile/00291214843973166978noreply@blogger.com3tag:blogger.com,1999:blog-6480555434853676325.post-71462169933758897402010-01-14T01:16:00.024-07:002010-03-17T15:52:41.983-06:00Installing MySQL 5.1 on Linux using MOCAIntroductionThe following instructions will lay out an installation of MySQL on Linux using the MySQL Optimal Configuration Architecture (MOCA) for someone with fundamental knowledge of MySQL and basic Linux administration skills. MOCA is a set of best practices I put together to lay out a set of guidelines for installing and configuring a MySQL database server. MOCA is designed for someoneAnonymoushttp://www.blogger.com/profile/00291214843973166978noreply@blogger.com11tag:blogger.com,1999:blog-6480555434853676325.post-77268544754401734052010-01-12T23:55:00.001-07:002010-01-12T23:59:58.036-07:00MySQL Conference and Expo 2010The MySQL Users Conference and Expo 2010 scheduled for April 12 - 15, 2010 in Santa Clara is definitely a conference I highly recommend you attend if you can. The insights, networking and knowledge gained is invaluable. The fantastic dynamics of the open source community has to be experienced to be understood. :)Anonymoushttp://www.blogger.com/profile/00291214843973166978noreply@blogger.com0tag:blogger.com,1999:blog-6480555434853676325.post-60946251474655628372009-10-24T17:06:00.002-06:002009-12-03T22:54:49.108-07:00Accessing Metadata through Stored RoutinesAccessing metadata can be optimized by using stored routines. Stored routines provide the ability to filter the data in a more useful way. For example, when I'm looking at table data I usually want to look at the index information also. So I use a stored routine called tabinfo that gives me key information I need for tables and indexes.
-- Create the tabinfo stored procedure.
Anonymoushttp://www.blogger.com/profile/00291214843973166978noreply@blogger.com0tag:blogger.com,1999:blog-6480555434853676325.post-55138569285935926572009-09-28T09:44:00.001-06:002009-09-28T09:45:40.975-06:00Oracle Versus MySQL ClassesI'm always being asked what is the difference between Oracle classes and MySQL classes. What are the similarities and what are some of the differences? So I thought I'd jot down a few notes.
Course similarities:
Oracle Classes
MySQL Classes
Oracle Database 11g: Introduction to SQL
MySQL for Beginners
Oracle Database 11g: Introduction for Exp. SQL Users
MySQL for Developers
Anonymoushttp://www.blogger.com/profile/00291214843973166978noreply@blogger.com4tag:blogger.com,1999:blog-6480555434853676325.post-304363878649294412009-09-08T11:34:00.007-06:002009-09-08T11:48:27.109-06:00MySQL Continues to be a "Tipping Point" in the IT Industry
MySQL continues to be a tipping point for the IT industry. In March of 2008 and January 2009 I talked about MySQL being a very important factor in the IT industry. Today, MySQL continues to play an important role in the direction of the IT industry. Some facts about MySQL in a down economy:While technical conferences are being canceled or running at 50% Anonymoushttp://www.blogger.com/profile/00291214843973166978noreply@blogger.com1tag:blogger.com,1999:blog-6480555434853676325.post-227661682076168112009-09-04T11:52:00.001-06:002009-09-04T11:53:18.451-06:00Configuring INFORMATION_SCHEMA Plugin Tables for InnoDB PluginThere are seven new INFORMATION_SCHEMA tables (plugins) available with the InnoDB plugin. They need to be loaded to be used.
New InnoDB Plugins contain information on:
Compressed InnoDB tables
Compressed InnoDB buffer pool
Current InnoDB transactions
Transaction Locks
Blocking transactions
These INFORMATION_SCHEMA plugins are available by setting the plugin-load parmeter:
plugin-load=Anonymoushttp://www.blogger.com/profile/00291214843973166978noreply@blogger.com0tag:blogger.com,1999:blog-6480555434853676325.post-39882280451161567492009-09-04T09:33:00.005-06:002009-09-04T11:12:33.288-06:00InnoDB Plugin Parameters Here is the set of new parameters available with the InnoDB Plugin 1.0.4
NameScopeDynamicDefault
innodb_adaptive_flushingGLOBALYESTRUE
innodb_change_bufferingGLOBALYESinserts
innodb_file_formatGLOBALYESAntelope
innodb_file_format_checkGLOBALYESON
innodb_io_capacityGLOBALYES200
innodb_read_ahead_thresholdGLOBALYES56
innodb_read_io_threadsGLOBALNO4
innodb_spin_wait_delayGLOBALYES6
Anonymoushttp://www.blogger.com/profile/00291214843973166978noreply@blogger.com0