Please join us at the DOUG (DALLAS ORACLE USERS GROUP) MySQL Forum meeting on Tuesday May 10th, 2011 from 4:30 pm – 6 pm (different than the usual meeting time).
Presentation Overview
MySQL 5.6 -- Stronger, faster, and it does NoSQL too!
Refreshments will be served.
To RSVP for this meeting, click on http://memberservices.membee.com/538/irmevents.aspx?id=49. Please contact dougadministrative@gmail.com if your plans change, so we can order the right amount of food.
Location: Oracle Offices (free parking)
7460 Warren Parkway
Suite 300
Frisco, TX 75034
Sunday, April 24, 2011
Monday, April 18, 2011
Review of Sessions at O'Reilly MySQL Conference
The annual trip to Santa Clara for the O'Reilly MySQL Users Conference is like trying to get a sip of water from a full on fire hose. So much is happening at once and cruel fate steps in to make sure that there are always two 'must attend' sessions going on at the same time. 
First, Tomas Ulin's keynote was great. Sorry to my European buddies, but it was like watching a major league baseball player at batting practice. Clearly, he articulated what Oracle has been doing with MySQL and then started smacking home runs out of the park with the new features. And a big thanks to Dups for getting up on stage to explain how a rushed upgrade to 5.5 produces a 25% performance gain for Empire Avenue.
The regular sessions where very good. The one that really sticks out was Baron Schwartz talk on modeling scalability. Everyone claims linear scaling but this talk explained why we do not see it.
Memachce and 5.6 and More Stable Query Execution Times by Improving InnoDB Statistics are two of the blog entries on Planet.MySQL.COM that are recommended for reading now that the conference is over. heck, it is worth scrolling back to see what you missed during the conference as a lot of good material gets lost in the flood from the UC. All the InnoDB sessions were filled and I need to hunt down the decks from those talks.
And thank you for all who ventured across the parking lot Wednesday night to attend the MySQL Community Party. A good time was had by all, even the MySQL founder who acquired a pair of dolphin balloons.
First, Tomas Ulin's keynote was great. Sorry to my European buddies, but it was like watching a major league baseball player at batting practice. Clearly, he articulated what Oracle has been doing with MySQL and then started smacking home runs out of the park with the new features. And a big thanks to Dups for getting up on stage to explain how a rushed upgrade to 5.5 produces a 25% performance gain for Empire Avenue.
The regular sessions where very good. The one that really sticks out was Baron Schwartz talk on modeling scalability. Everyone claims linear scaling but this talk explained why we do not see it.
Memachce and 5.6 and More Stable Query Execution Times by Improving InnoDB Statistics are two of the blog entries on Planet.MySQL.COM that are recommended for reading now that the conference is over. heck, it is worth scrolling back to see what you missed during the conference as a lot of good material gets lost in the flood from the UC. All the InnoDB sessions were filled and I need to hunt down the decks from those talks.
And thank you for all who ventured across the parking lot Wednesday night to attend the MySQL Community Party. A good time was had by all, even the MySQL founder who acquired a pair of dolphin balloons.
Tuesday, April 12, 2011
Talk today on Open Source BI Reporting Tools
First full day at the O'Reilly MySQL Conference after a great MySQL Community Dinner (Thanks to Sarah Novotny for her organization skills for getting 50 plus folks into Pedro's)
I will be talking on Open Source BI Reporting Tools in Ballroom A at 5:15. Very useful session for DBAs who need anything from a quickad hoc report to a large multi-segment printer killer.
I will be talking on Open Source BI Reporting Tools in Ballroom A at 5:15. Very useful session for DBAs who need anything from a quick
Tuesday, March 22, 2011
Speaking at POSSCON 2011 on Wednesday
Palmetto Open Source Software Conference opens tomorrow in Columbia, South Carolina and I have the privilege at the 4:10 PM Technical Breakout on What's new in MySQL. If you are attending the conference, please drop buy to say 'hi'.
Thursday, March 17, 2011
MySQL & Oracle presentation -- Dallas, March 19th
I will be speaking at the North Texas Linux1 Users Group Saturday, March 19th on MySQL and Oracle at 11AM. Directions here. 
NTLUG features an install project, a beginners lecture, and then the feature presentation. Hopefully I will have some time to demo MySQL Workbench and more.
1. Opps! First time I posted I posed MySQL instead of Linux. Sorry for the confusion!!
NTLUG features an install project, a beginners lecture, and then the feature presentation. Hopefully I will have some time to demo MySQL Workbench and more.
1. Opps! First time I posted I posed MySQL instead of Linux. Sorry for the confusion!!
Tuesday, March 15, 2011
Oracle Open World MySQL Track call for papers open
Oracle Open World will feature this year a dedicated MySQL track under the Database stream. The call for papers was announced for the show which will be held October 2-6, 2011 at the Moscone Center in San Francisco. So polish up your material on your MySQL storage engine, success story, tips, research, projects, implementation and/or experience so you can submit your proposal as soon as possible. The call for papers closes March 27th!
From the press release: “From C-level executives to developers, Oracle OpenWorld is a venue for customers and partners to share their ideas, experiences, and accomplishments regarding Oracle products and solutions. This year we look forward to receiving thousands of presentation proposals to help us deliver a unique experience to a diverse global audience,” said Tania Weidick, vice president, Oracle Corporate Event Marketing. “We’re also excited to welcome the MySQL community in a dedicated track designed to provide MySQL users with practical tips and best practices from the vibrant ecosystems of the MySQL community, customers, partners and Oracle's MySQL engineers.”
From the press release: “From C-level executives to developers, Oracle OpenWorld is a venue for customers and partners to share their ideas, experiences, and accomplishments regarding Oracle products and solutions. This year we look forward to receiving thousands of presentation proposals to help us deliver a unique experience to a diverse global audience,” said Tania Weidick, vice president, Oracle Corporate Event Marketing. “We’re also excited to welcome the MySQL community in a dedicated track designed to provide MySQL users with practical tips and best practices from the vibrant ecosystems of the MySQL community, customers, partners and Oracle's MySQL engineers.”
Wednesday, March 9, 2011
Free Hadoop class in Dallas
Cloudera Instructor Tom Hanlon will be presenting a free class on Hadoop Tuesday March 15th on Dallas. Tom is a familiar face to MySQLers in the North Texas area having previous taught many MySQL classes. 
Pizza and Drinks will be provided.
This will be an excellent opportunity for MySQL DBAs to learn from booth a MySQL and Hadoop expert. Hadoop is a computational paradigm named Map/Reduce, where the application is divided into many small fragments of work which may be executed any node in the cluster.
Register Here as they may need to shift locations to find the anticipated crowd.
This will be an excellent opportunity for MySQL DBAs to learn from booth a MySQL and Hadoop expert. Hadoop is a computational paradigm named Map/Reduce, where the application is divided into many small fragments of work which may be executed any node in the cluster.
Register Here as they may need to shift locations to find the anticipated crowd.
Wednesday, March 2, 2011
When did that statement finish?
A friend wanted to go to lunch but need to time (roughly) how long a UPDATE took on one of his instances. 
The friend had a co-worker who said the statement would take X time and the friend was pretty sure it was X/2. Me? I was hungry.
I edited the ˜.my.cnf and added the following:
This changes the mysql client prompt from mysql> to 11:42:22am>. The friend started the mysql client, entered the query, and we went to lunch. We when returned, there on the prompt line was the time the command finished.
An old simple trick but it did what was needed. The documentation on the prompt string details more options. I probably would not want to use this trick for more than the crudest of benchmarks. I do use something similar to display the hostname when dealing with slaves in replication.
I edited the ˜.my.cnf and added the following:
[mysql] prompt="\\r:\\m:\\s\\P>"
This changes the mysql client prompt from mysql> to 11:42:22am>. The friend started the mysql client, entered the query, and we went to lunch. We when returned, there on the prompt line was the time the command finished.
An old simple trick but it did what was needed. The documentation on the prompt string details more options. I probably would not want to use this trick for more than the crudest of benchmarks. I do use something similar to display the hostname when dealing with slaves in replication.
Thursday, February 17, 2011
SCALE Conference
On Sunday February 27th, I will be speaking on What's New In MySQLin the Carmel room at 11:30AM as part of the SCaLE (Southern California Linux Expo) near LAX Airport. If you are in the area, this is a great event. And if you are attending, please say 'hi' to me.
Tuesday, February 15, 2011
Collaborate Sneak Preview: MySQL
The IOUG is presenting a free webinar on Wednesday, February 16th that will be a sneak peek of a session that will be presented at Collaborate in April. Kaj Arnö will describe the essentials of MySQL's background and history, to the extent its relevant for today's needs of an IOUG member. Hopefully it will be fine for non-IOUG members to listen in also.
Register
Register
Subscribe to:
Posts (Atom)