tag:blogger.com,1999:blog-85750591971936678982024-02-19T07:58:12.253-08:00Dave's StuffI am a MySQL Community Manager. Part of the job is working with <i>you</i> to help define MySQL future. Please feel free to let me know where you want MySQL to be next month, next year, and next decade. And the views expressed on this blog are my own and do not necessarily reflect the views of Oracle.Dave Stokeshttp://www.blogger.com/profile/16737653465494764723noreply@blogger.comBlogger172125tag:blogger.com,1999:blog-8575059197193667898.post-63388047411397552472011-11-18T13:51:00.000-08:002011-11-18T13:51:53.040-08:00Wordpress from a MySQL DBA view<a href="http://www.wordpress.org/">Wordpress</a> is a very popular Content Management System, usually built on top of a MySQL Database. Recently I attended a local Wordpress user group an that started me wondering what the database tables look like. So I installed a new Wordpress installation on a Ubuntu test box running MySQL 5.6.2. <br />
<br />
Wordpress creates eleven tables: wp-commentmeta, wp_comments, wp_links, wp_options, wp_postmeta, wp_posts, wp_term_relationships, wp_term_taxonomy, wp_terms, wp_usermeta, and wp_users. <br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiQOp2Rm2LL837k9d6C70yBfrmlwg2nCOujf_iIIsWSmvoBsStfzuOOfSV6aZF0UUNCA1AysMkfA8HQNNGBuyQfXfx-ZIiKTNFJpzlEWjQeKY8iXfWgWIgZDMP7xst8MZQa5f7xxuhZk3g/s1600/wordpress.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="253" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiQOp2Rm2LL837k9d6C70yBfrmlwg2nCOujf_iIIsWSmvoBsStfzuOOfSV6aZF0UUNCA1AysMkfA8HQNNGBuyQfXfx-ZIiKTNFJpzlEWjQeKY8iXfWgWIgZDMP7xst8MZQa5f7xxuhZk3g/s320/wordpress.png" width="320" /></a>MySQL Workbench generated an EER Model you can see nearby. The first thing that caught me eye was the use of unsigned BIGINTs in every table as keys. Usually you want to use the <i>smallest</i> data type you can for keys. The smaller the key, usually the fast the system can evaluate it. But then maybe there are blog out there that need 18,446,744,073,709,551,615 posts or authors or links.</div><br />
Hmm, can I start a side business making Wordpress faster by converting all those BIGINTs for those who only to expect 4,294,967,295 posts??<br />
<br />
Since I am using MySQl 5.6, the table formats defaulted to InnoDB. Some plugins for Wordpress require full-text search indexes which is now available in the 5.6 preview release.Dave Stokeshttp://www.blogger.com/profile/16737653465494764723noreply@blogger.com6tag:blogger.com,1999:blog-8575059197193667898.post-53665958245122663302011-08-31T12:49:00.000-07:002011-08-31T12:49:26.745-07:00MySQL for Oracle DBAs, or How to Speak MySQL for Beginners<img border="0" height="220" width="320" align="right" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiM0IQe2SlnNrJTFvFvWoONMKLxqh2f51UF_hKQ_9o-Lk5ufS_ZgX-nqEpvmsdopB5I42CFkKojX5NCcYv5MGh0D4CkurcVVFvQ78hODVxhiPl_aht3Myez4T7JuU1UsVQW9SuSKtnAnlk/s320/dolphin+2.jpg" vspace=10 hspace=10 /><br />
I will be speaking at <a href="http://www.oracle.com/openworld/index.html" title="MySQL For Beginners @ OOW">Oracle Open World</a> on <em>MySQL for Oracle DBAs, or How to Speak MySQL for Beginners</em> on Tuesday, October 4th in the Golden Gate B room in the Marriot Marquis. And at the same time down the hall, Sunny Bains will be presenting on <em>InnoDB Performance Tuning</em>. And just a short time later there will be a MySQL Community Reception.<br />
<br />
Dave Stokeshttp://www.blogger.com/profile/16737653465494764723noreply@blogger.com0tag:blogger.com,1999:blog-8575059197193667898.post-64815534641571064902011-08-14T19:20:00.000-07:002011-08-14T19:20:04.868-07:00Bem-vindo ao Meetup MySQL Brasil!For those of you in around Sao Paulo this week, Aiton Lastori send me the following:<br />
<br />
<i>Next week we will host a MySQL Happy Hour at Oracle's Sao Paulo office.<br />
We are exited because there are room for 100 people and over 500<br />
subscribed! Oracle marketin provided the money for the free beer and Ana, our lead dev in Brazil, and is doing an amazing job organizing<br />
everything. I've created a group in meetup.com <a href="http://www.meetup.com/MySQL-BR/">http://www.meetup.com/MySQL-BR/</a></i>.<br />
Dave Stokeshttp://www.blogger.com/profile/16737653465494764723noreply@blogger.com0Sao Paulo - São Paulo, Brazil-23.5489433 -46.6388182-23.8749538 -46.869311700000004 -23.222932800000002 -46.4083247tag:blogger.com,1999:blog-8575059197193667898.post-64923652655030163552011-07-05T08:37:00.000-07:002011-07-05T08:37:47.885-07:00FISL12 -- Open Source show with Music and Dancing in Brazil.Not so long ago, it was easy to judge a technical conference by the number of small screwdrivers<sup>1</sup> you picked up as swag from the show. Open source shows usually have similar elements in common with each other like someone in a penguin costume, at least one guy in a kilt<sup>2</sup>, piles of Linux distro CDROMs, and bonus points for either Mad Dog or Linus in person. Last week I was in Porto Alegre, Brazil for <a href="http://softwarelivre.org/fisl12">FISL</a> where they had all that plus folk songs and dancing<sup>3</sup>. They really raised the bar for open source shows. <div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEibIR9NrUBtfOeKpsJdtGTpdU5wyra27zHATWDYi1zXJXoZ-s-eJXZkFyNH55pfXe9hepaXm6X0ruVbe2t-xEGFnR58nOrvfEIKtnaP-OE1mXI1fNCc7f5DTQeMedk5uq6UmOddAnYiGTc/s1600/SAM_0973.JPG" imageanchor="1" style="clear:right; float:right; margin-left:1em; margin-bottom:1em"><img border="0" height="150" width="200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEibIR9NrUBtfOeKpsJdtGTpdU5wyra27zHATWDYi1zXJXoZ-s-eJXZkFyNH55pfXe9hepaXm6X0ruVbe2t-xEGFnR58nOrvfEIKtnaP-OE1mXI1fNCc7f5DTQeMedk5uq6UmOddAnYiGTc/s200/SAM_0973.JPG" /></a></div><br />
The MySQL Community is large, vibrant, and inquisitive. Davi Arnaut, one of our developers who lives in the North of Brazil, presented on MySQL 5.5 and 5.6 to a full room. I was in the Oracle booth answering questions about new features, workbench and the Enterprise edition. During the four days, there was a constant flow to the booth and we got to meet many developer and students who rely on MySQL. <div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiavNytUfwhryVbh7Ffp0m8Qhu3OFitVSiE6778mRRyYL4sJGlgxdNKEyhA8S7EHYEMJLxLkQZkjCuaa_b6Fwfxg0X5pHZi5hhLO8tXerW3dr4ZgDsgZ0stxxKQ_Db9LICFN2PkEZ9RBIQ/s1600/SAM_0959.JPG" imageanchor="1" style="clear:right; float:right; margin-left:1em; margin-bottom:1em"><img border="0" height="150" width="200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiavNytUfwhryVbh7Ffp0m8Qhu3OFitVSiE6778mRRyYL4sJGlgxdNKEyhA8S7EHYEMJLxLkQZkjCuaa_b6Fwfxg0X5pHZi5hhLO8tXerW3dr4ZgDsgZ0stxxKQ_Db9LICFN2PkEZ9RBIQ/s200/SAM_0959.JPG" /></a></div>I enjoyed meeting all the <i>'MySQ-elle'</i> users at FISL.<br />
<br />
And next year I will have more MySQL swag for the attendees. The stickers and t-shirts were popular and went quickly.<br />
<br />
<br />
<ol><li> Philips head, flat head or the rare Allen head.</li>
<li> Usually a Ultilikilt</li>
<li> Most of the show attendees on the floor were gathered around the booth for a local restaurant belting out songs.<br />
</ol>Dave Stokeshttp://www.blogger.com/profile/16737653465494764723noreply@blogger.com0tag:blogger.com,1999:blog-8575059197193667898.post-49605176969721116452011-05-20T13:27:00.000-07:002011-05-20T13:27:17.417-07:00Performance tuning -- option files from the distribution and a simple benchmark<p align="justify">Hopefully you are caught up on the recommended reading from the last post as today we will look at creating a simple benchmark using a common tool to determine which option file to use. The MySQL server will use default values if it can not find an option file. Under the <tt>/usr/local/mysql/support-files</tt> for MySQL 5.6 are <i>eight</i><sup>1</sup><br />
sample configuration files that can be renamed and dropped in place as a staring point. See the <a href="http://dev.mysql.com/doc/refman/5.6/en/option-files.html">Using Option File</a> page for details.</p><p align="justify">But these files have not kept pace with hardware. For instance, a small system is listed as being under 64m of memory while huge is 1-2G. More modern settings will be covered in a later post but we can use these files in a simple test on a fairly simple test machine<sup>2</sup>.</p><p align="justify">So how do we know which configuration is the best for the environment? A simple test will be run that accesses the database on the system and the time will be recorded. Usually you want to use a test that as closely mimics your 'normal' load but this is an introductory series and we will grow into more rigorous tests. Testing these various configuration files was done with <i>mysqlslap</i> and the next post will go into details on <i>mysqlslap</i> and how to use it with queries from your logs.</p><p align="justify">A simple <i>mysqlslap</i> test was run<sup>3</sup> and the times recorded. The various option files were copied to <tt>/etc/mysql/my.cnf</tt>, <tt>mysqld_safe --user=mysq&</tt> was used to start the server, and then the test was run. We change one variable, the option file, repeat the test, and not the differences.</P><table><tr><th>Config file</th><th>Avg Run Time</th></tr>
<tr><td>None</td><td align=right>1.362</td></tr>
<tr><td>Small</td><td align=right>1.604</td></tr>
<tr><td>Medium</td><td align=right>1.373</td></tr>
<tr><td>Large</td><td align=right>1.348</td></tr>
<tr><td>Huge</td><td align=right>1.337</td></tr>
<tr><td>InnoDB Heavy</td><td align=right>1.526</td></tr>
</table> <p align="justify">So the system with 1.5G of memory runs best on the option file designed for system with 1-2G of memory! That result will probably not shock too many people. This was an overly simple example and next time we will go a bit deeper on using <i>mysqlslap</i> and then start to look at some other tools. Then we will create a simple web based application for testing.</p><br />
<i>To be continues</i><br />
<br />
Next time: Using your data with <i>mysqlslap</i><br />
<br />
<ol><li> Three files for Windows: <i>config.small.ini, config.medium.ini, and config.huge.ini</i> and five for UNIX-like systems: <i>my-small.cnf, my-medium.cnf, my-large.cnf, my-huge.cnf, and my-innoidb-heavy-4g.cnf</i></li>
<li> The test box is a IBM Thinkpad R50e that I use for testing and runs a recent version of Fedora with 1.5G of memory.</li>
<li> <tt>mysqlslap --auto-generate-sql --concurrency=100</tt></li>
</ol>Dave Stokeshttp://www.blogger.com/profile/16737653465494764723noreply@blogger.com0tag:blogger.com,1999:blog-8575059197193667898.post-58095997166002217932011-05-19T11:58:00.000-07:002011-05-19T11:58:37.368-07:00Performance tuning basicsI have been getting a lot of questions about performance tuning this month. So this will be the first in a series on the basics. <br />
<br />
Go get your copies of <a href="http://www.amazon.com/High-Performance-MySQL-Optimization-Replication/dp/0596101716/ref=sr_1_2?ie=UTF8&qid=1305825169&sr=8-2-spell">High Performance MySQL: Optimization, Backups, Replication, and More</a> and <a href="http://www.amazon.com/MySQL-Administrators-Bible-Wiley/dp/0470416912/ref=sr_1_2?s=books&ie=UTF8&qid=1305829471&sr=1-2">MySQL Administrator's Bible</a><sup>1</sup> and read up on benchmarking. Also take a peek at <a href="http://mysql-dba-journey.blogspot.com/2007/12/mysql-architecture-using-moca.html">George Trujillo's MOCA</a>. These readings will provide you with a overview of the methods and approaches you will see in later entries. The goal is to get a baseline measurement so that a change can be evaluated as an improvement or a determent. <br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEipJKIMS9Zz_giwOEAQb_ejD5JrloW_7uC24yYRbIbTxhYR1l3vMbswVOcixWXW8pYXR-qZ5f94qABVgRp8R4H9z5eDlINZD3sCfmLTvaujc6JC_AKJM-5VlhfqKk2fw7NE1vJ75WeP5TQ/s1600/SAM_0601.JPG" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="150" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEipJKIMS9Zz_giwOEAQb_ejD5JrloW_7uC24yYRbIbTxhYR1l3vMbswVOcixWXW8pYXR-qZ5f94qABVgRp8R4H9z5eDlINZD3sCfmLTvaujc6JC_AKJM-5VlhfqKk2fw7NE1vJ75WeP5TQ/s200/SAM_0601.JPG" width="200" /></a></div>Then do a fresh install of MySQL server on a <i><b>non production system</b></i>.<br />
<br />
And lastly get a copy of your new installation's <a href="http://dev.mysql.com/doc/refman/5.6/en/option-files.html">option file</a>, usually <i>my.cnf</i> or <i>my.ini</i> for Windows systems. But do not be surprised if your system does not have one.<br />
<br />
<i>To be continued</i> <br />
<br />
Next time: A simple test using <i>mysqlslap</i><br />
<br />
1. You <strike>should have</strike> need to have copies of these books in your library.Dave Stokeshttp://www.blogger.com/profile/16737653465494764723noreply@blogger.com0tag:blogger.com,1999:blog-8575059197193667898.post-31297070915740944282011-05-06T13:10:00.000-07:002011-05-09T18:45:05.917-07:00MySQL Lunch-n-Learn<a href="http://www.mysql.com/news-and-events/lunch-n-learn/">MySQL Lunch-n-Learn</a> is not a new performance schema table or a new BLOB data type for Chef Gordon Ramsey. It is where a MySQL engineer comes to <i>your</i> office bringing lunch to talk about the most popular open source database. I was asked to participate in one this morning at a major company headquartered in Dallas. The company wanted some information on updates to the MySQL server, a comparison between InnoDB and MyISAM, and some company specific questions.<br />
<br />
It is often hard to get new product news to our users and this program provides us with a way to answer specific questions. And the customer gets to select the agenda items to make certain they get what they need form this event. <br />
<br />
So if you want to get the latest on MySQL 5.6, Memcahched-to-InnoDB, or replication strategies, use the link at the top of this entry to set up your Lunch-n-Learn.Dave Stokeshttp://www.blogger.com/profile/16737653465494764723noreply@blogger.com0tag:blogger.com,1999:blog-8575059197193667898.post-11094924292694062002011-05-04T10:05:00.000-07:002011-05-04T10:05:44.818-07:00Dallas MySQL Users Meeting May 10thMay 10th meeting -- Join us for a presentation on the new features in MySQL 5.6<br />
<br />
Tuesday May 10th 4:30 PM to 6:00 PM (doors lock at 5PM)<br />
<br />
Please <a href="http://memberservices.membee.com/538/irmevents.aspx?id=49">RSVP</a>!<br />
<br />
Refreshments provided!!<br />
Oracle Offices<br />
7460 Warren Parkway<br />
Suite 300.<br />
Frisco, TX 75034Dave Stokeshttp://www.blogger.com/profile/16737653465494764723noreply@blogger.com0tag:blogger.com,1999:blog-8575059197193667898.post-53701745829297374622011-05-03T08:58:00.000-07:002011-05-03T08:58:40.510-07:00OTN MySQL Developer Day in Santa Clara<div class="separator" style="clear: both; text-align: center;">Today is the MySQL Developer Day in Santa Clara. We have a full day of sessions on everything from basics to performance tuning.<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhgDLbNMPyL2yzad0Wb-UO8VYmVX7LFkVbiYbpTUH6apQ85tKfVfKmRlxepNKH_NfovDa7lTC9e3rseGBXD7TwdwaASGB4BCP4wdrcsq6VMZENSMLdJjBbQooXH8_wCpJB8dw5wZyTHW6E/s1600/otn.jpg" imageanchor="1" style="clear:right; float:right; margin-left:1em; margin-bottom:1em"><img border="0" height="150" width="200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhgDLbNMPyL2yzad0Wb-UO8VYmVX7LFkVbiYbpTUH6apQ85tKfVfKmRlxepNKH_NfovDa7lTC9e3rseGBXD7TwdwaASGB4BCP4wdrcsq6VMZENSMLdJjBbQooXH8_wCpJB8dw5wZyTHW6E/s200/otn.jpg" /></a></div>Dave Stokeshttp://www.blogger.com/profile/16737653465494764723noreply@blogger.com0tag:blogger.com,1999:blog-8575059197193667898.post-86537092200643242102011-04-26T09:52:00.000-07:002011-04-26T09:52:01.767-07:00OTN MySQL Developer Day in Santa Clara-- RSVP before the seats are all gone!<div>The OTN MySQL Developer Day in Santa Clara is one week away. Be sure to <a href="http://www.oracle.com/webapps/events/ns/EventsDetail.jsp?p_eventId=131822&src=7011174&src=7011174&Act=191">register</a> as space is going fast. <br />
<img border="0" height="57" width="110" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEio14MYvfDs8EQ3aaTlz-HgTApCWTTDuW8dITbEMppMZWUdM8FoONYkTsg7khBU4dus6KHPLLZbkcKkgQkQ76AXGPMqTgcCUM9KmO9TH4_OGCdmvxWM1LFRpAacqacFc2W5B9JEHcbuSTA/s200/logo-mysql-110x57.png" hspace="10" vspace="20" align="left" /></div><br />
<br />
<br />
Get the Technical Know-how to Succeed with the World’s Most Popular Open Source Database<br />
<br />
MySQL is the world’s most popular open-source database, and powers websites and applications of numerous leading and fast-growing organizations.<br />
<br />
The OTN Developer Day MySQL is a one-stop shop for you to learn all the essential skills about MySQL. In this free, one-day seminar, we will cover everything you need to know to successfully design, develop, and manage your MySQL databases. You’ll also learn the guidelines and best practices in performance tuning and scalability.<br />
<br />
Attend this event and gain the knowledge to:<br />
<br />
<ul><li>Develop your new applications cost-effectively using MySQL<br />
<li> Improve performance of your existing MySQL databases<br />
<li> Manage your MySQL environment more efficiently</ul>
Don’t miss this exclusive opportunity to network with your peers, and hear the tips and tricks from the MySQL experts at Oracle. No matter you’re a DBA or a developer, come find out how you can make the best of MySQL in your IT infrastructure.
<table><th>Agenda</th>
<tr><td>8:00 a.m. – 9:00 a.m.</td>
<td>Registration</td></tr>
<tr>
<td>9:00 a.m. – 10:00 a.m.</td>
<td>Keynote: MySQL Essentials</td></tr>
<tr>
<td>10:00 a.m. – 11:00 a.m.</td>
<td>Session: MySQL Replication and Scalability</td>
</tr>
<tr><td>11:00 a.m. – 11:15 a.m.</td>
<td>Break</td>
</tr>
<tr><td>11:15 a.m. – 12:15 p.m.</td>
<td>Session: MySQL on Windows</td></tr>
<tr><td>12:15 p.m. – 1:00 p.m.</td>
<td>Lunch</td></tr>
<tr><td>1:00 p.m. – 2:00 p.m.</td>
<td>Session: MySQL Performance Tuning</td></tr>
<tr><td>2:00 p.m. – 3:30 p.m.</td>
<td>Hands-On Lab: MySQL Administration and Management Tools</td></tr>
<tr>
<td>3:30 p.m. – 4:00 p.m.</td>
<td>Raffle and Closing</td></tr></table>Dave Stokeshttp://www.blogger.com/profile/16737653465494764723noreply@blogger.com1tag:blogger.com,1999:blog-8575059197193667898.post-79103191385869037492011-04-24T16:39:00.000-07:002011-04-24T19:24:05.448-07:00Dallas Area -- Learn about MySQL 5.6 on May 10thPlease 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).<br />
<br />
<b>Presentation Overview</b><br />
<br />
<i><font size+=2>MySQL 5.6 -- Stronger, faster, and it does NoSQL too!</font></i><br />
<br />
Refreshments will be served. <br />
<br />
To RSVP for this meeting, click on <a href="http://memberservices.membee.com/538/irmevents.aspx?id=49">http://memberservices.membee.com/538/irmevents.aspx?id=49</a>. Please contact dougadministrative@gmail.com if your plans change, so we can order the right amount of food. <br />
<br />
Location: Oracle Offices (free parking)<br />
7460 Warren Parkway<br />
Suite 300<br />
Frisco, TX 75034Dave Stokeshttp://www.blogger.com/profile/16737653465494764723noreply@blogger.com0tag:blogger.com,1999:blog-8575059197193667898.post-52725930901204941782011-04-18T10:26:00.000-07:002011-04-18T10:26:41.308-07:00Review of Sessions at O'Reilly MySQL ConferenceThe 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. <div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhu5a9eGve_owuwmRnSFmfwneoD8Bgf4MOnq4dZHSHJRt9Q4sfAv8aQY4eRiOX6BHCck23lFg4bTaxtzwOhko5Ah7kGNG3u8hrItbltP7nDnd6BPqGIqHxLncUDBk3sl3G5MpXBkAxWWIc/s1600/party1.jpg" imageanchor="1" style="clear:right; float:right; margin-left:1em; margin-bottom:1em"><img border="0" height="185" width="200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhu5a9eGve_owuwmRnSFmfwneoD8Bgf4MOnq4dZHSHJRt9Q4sfAv8aQY4eRiOX6BHCck23lFg4bTaxtzwOhko5Ah7kGNG3u8hrItbltP7nDnd6BPqGIqHxLncUDBk3sl3G5MpXBkAxWWIc/s200/party1.jpg" /></a></div><br />
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 <a href="http://empireavenue.com/">Empire Avenue</a>.<br />
<br />
The regular sessions where very good. The one that really sticks out was Baron Schwartz talk on <a href="http://www.xaprb.com/blog/2011/04/16/subtleties-in-the-universal-scalability-law/">modeling scalability</a>. Everyone claims linear scaling but this talk explained why we do not see it.<br />
<br />
<a href="http://schlueters.de/blog/archives/152-Not-only-SQL-memcache-and-MySQL-5.6.html">Memachce and 5.6</a> and <a href="http://oysteing.blogspot.com/2011/04/more-stable-query-execution-time-by.html">More Stable Query Execution Times by Improving InnoDB Statistics</a> are two of the blog entries on <a href="http://planet.mysql.com">Planet.MySQL.COM</a> 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.<br />
<br />
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.Dave Stokeshttp://www.blogger.com/profile/16737653465494764723noreply@blogger.com1tag:blogger.com,1999:blog-8575059197193667898.post-79551024933838483562011-04-12T05:46:00.000-07:002011-04-12T05:46:12.773-07:00Talk today on Open Source BI Reporting ToolsFirst 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)<br />
<br />
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 <strike>ad hoc</strike> report to a large multi-segment printer killer.Dave Stokeshttp://www.blogger.com/profile/16737653465494764723noreply@blogger.com1tag:blogger.com,1999:blog-8575059197193667898.post-51337252758439972692011-03-22T14:37:00.000-07:002011-03-22T14:37:23.099-07:00Speaking at POSSCON 2011 on Wednesday<a href="http://posscon.org/">Palmetto Open Source Software Conference</a> opens tomorrow in Columbia, South Carolina and I have the privilege at the 4:10 PM Technical Breakout on <i>What's new in MySQL</i>. If you are attending the conference, please drop buy to say 'hi'.Dave Stokeshttp://www.blogger.com/profile/16737653465494764723noreply@blogger.com0tag:blogger.com,1999:blog-8575059197193667898.post-92209963501164513912011-03-17T08:47:00.000-07:002011-03-17T19:22:05.637-07:00MySQL & Oracle presentation -- Dallas, March 19thI will be speaking at the <a href="ntlug.org">North Texas <b>Linux</b><sup>1</sup> Users Group</a> Saturday, March 19th on MySQL and Oracle at 11AM. <a href="http://www.ntlug.org/Main/Directions">Directions</a> here. <div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgGB4k_eO_BO2T7MQLHSd-5ggxDUyulfkyCabLAPRiXDFJSJ4khc12tEvARil2RZEsCwjNLjTjIuhXU1ZusGYWc5h5lPJPwkU-Sy6Nyz_0vYZvKQxG4ti67LjoRO1Rh19CPXk2qQKfGckM/s1600/IMG00045-20101031-1601.jpg" imageanchor="1" style="clear:right; float:right; margin-left:1em; margin-bottom:1em"><img border="0" height="150" width="200" hspace="10" vpsace="10" alt="Alamo" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgGB4k_eO_BO2T7MQLHSd-5ggxDUyulfkyCabLAPRiXDFJSJ4khc12tEvARil2RZEsCwjNLjTjIuhXU1ZusGYWc5h5lPJPwkU-Sy6Nyz_0vYZvKQxG4ti67LjoRO1Rh19CPXk2qQKfGckM/s200/IMG00045-20101031-1601.jpg" /></a></div><br />
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.<br />
<br />
1. Opps! First time I posted I posed MySQL instead of Linux. Sorry for the confusion!!Dave Stokeshttp://www.blogger.com/profile/16737653465494764723noreply@blogger.com0tag:blogger.com,1999:blog-8575059197193667898.post-10572197613522662802011-03-15T08:52:00.000-07:002011-03-15T08:52:57.406-07:00Oracle Open World MySQL Track call for papers open<a href="http://www.oracle.com/us/corporate/press/338122">Oracle Open World</a> will feature this year a dedicated MySQL track under the Database stream. The call for <a href="https://oracleus.wingateweb.com/portal/cfp/cfpLogin.ww;jsessionid=abc3Zd0O_71i1fgK6QD6s">papers</a> 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! <br />
<br />
From the press release: <i>“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.” </i>Dave Stokeshttp://www.blogger.com/profile/16737653465494764723noreply@blogger.com0tag:blogger.com,1999:blog-8575059197193667898.post-15338537800500145572011-03-09T12:51:00.000-08:002011-03-09T12:51:48.530-08:00Free Hadoop class in DallasCloudera Instructor Tom Hanlon will be presenting a <i>free</i> 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. <div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjTKMlNGjLhXnI7F0Pi1gtuu9gGgoL4tGDwcFEaKL2qgHdpqQmDOUv1wz42bH6jXfBuI0oq8svJiv4CE_zm2mokzgMeaUOvLDKOovxHbw5TAHFEbY0c1YdH5vc__CcqQ7u_o840sups_CI/s1600/SAM_0576.JPG" imageanchor="1" style="clear:right; float:right; margin-left:1em; margin-bottom:1em"><img border="0" height="240" width="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjTKMlNGjLhXnI7F0Pi1gtuu9gGgoL4tGDwcFEaKL2qgHdpqQmDOUv1wz42bH6jXfBuI0oq8svJiv4CE_zm2mokzgMeaUOvLDKOovxHbw5TAHFEbY0c1YdH5vc__CcqQ7u_o840sups_CI/s320/SAM_0576.JPG" /></a></div>Pizza and Drinks will be provided.<br />
<br />
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.<br />
<br />
<a href="http://www.meetup.com/DFW-BigData/">Register Here</a> as they may need to shift locations to find the anticipated crowd.Dave Stokeshttp://www.blogger.com/profile/16737653465494764723noreply@blogger.com0tag:blogger.com,1999:blog-8575059197193667898.post-6108450314166998102011-03-02T14:00:00.000-08:002011-03-02T14:00:38.210-08:00When 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. <div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg4or6Ld_2tCI4GR4bMN1xtDx9048BUTEYsQ6Gc1o3iFCEXgzSujF4nAA2pjUkGXlvDU2hL8PQDYtoV-x2w7uByBuL6hK_tUVMp3O-hUAhr2TO_iEM522O3WsyxurHYI8MhXqRlf5O68X0/s1600/SAM_0612.JPG" imageanchor="1" style="clear:left; float:left;margin-right:1em; margin-bottom:1em"><img border="0" height="320" width="240" hspace="10" vspace="20" valign="top" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg4or6Ld_2tCI4GR4bMN1xtDx9048BUTEYsQ6Gc1o3iFCEXgzSujF4nAA2pjUkGXlvDU2hL8PQDYtoV-x2w7uByBuL6hK_tUVMp3O-hUAhr2TO_iEM522O3WsyxurHYI8MhXqRlf5O68X0/s320/SAM_0612.JPG" /></a></div>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.<br />
<br />
I edited the <tt>˜.my.cnf</tt> and added the following:<br />
<pre><tt>
[mysql]
prompt="\\r:\\m:\\s\\P>"
</tt></pre><br />
This changes the mysql client prompt from <tt>mysql></tt> to <tt>11:42:22am></tt>. 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.<br />
<br />
An old simple trick but it did what was needed. The documentation on the <a href="http://dev.mysql.com/doc/refman/5.0/en/mysql-commands.html"> prompt string</a> 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.Dave Stokeshttp://www.blogger.com/profile/16737653465494764723noreply@blogger.com8tag:blogger.com,1999:blog-8575059197193667898.post-49673228704827300422011-02-17T11:36:00.000-08:002011-02-17T11:36:37.433-08:00SCALE Conference<a href="http://www.socallinuxexpo.org"><img src="http://www.socallinuxexpo.org/scale9x/sites/socallinuxexpo.org.scale9x/files/promo-items/125x125_9x.gif" hspace="5" vspace="5" align="left"></a> On Sunday February 27th, I will be speaking on <b>What's New In MySQL</b>in the Carmel room at 11:30AM as part of the <a href="http://www.socallinuxexpo.org/scale9x/">SCaLE</a> (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.Dave Stokeshttp://www.blogger.com/profile/16737653465494764723noreply@blogger.com0tag:blogger.com,1999:blog-8575059197193667898.post-39073465667047050292011-02-15T13:46:00.000-08:002011-02-15T13:46:51.497-08:00Collaborate Sneak Preview: MySQLThe 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.<br />
<br />
<a href="https://www1.gotomeeting.com/register/999968169">Register</a>Dave Stokeshttp://www.blogger.com/profile/16737653465494764723noreply@blogger.com0tag:blogger.com,1999:blog-8575059197193667898.post-78096553107834732972011-02-11T14:45:00.000-08:002011-02-11T12:47:39.669-08:00Dallas area meeting March 1stMarch 1st will be the first meeting of the <a href="http://www.northtexasmysql.org">North Texas MySQL Users Group</a> for 2011. A presentation on <b><i>What is new in MySQL 5.5</i></b> will start at 4:30 PM and finish and we can go for a 'post-meeting' at one of the establishments nearby. This group is a now a Special Interest Group of the <a href="http://www.doug.org">Dallas Oracle Users Group</a>. <br />
<br />
There will be soft drinks and cookies served!<br />
<br />
Room 3014<br />
Oracle Offices<br />
7460 Warren Parkway<br />
Suite 300<br />
Frisco, TX 75034Dave Stokeshttp://www.blogger.com/profile/16737653465494764723noreply@blogger.com0tag:blogger.com,1999:blog-8575059197193667898.post-18764431079554471512011-01-27T06:54:00.000-08:002011-01-27T06:54:16.292-08:00The San Francisco MySQL GroupLast night, Lenz Grimmer, Lenz's posse, and I left the Oracle Leaders Summit to go north into San Francisco. <div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEghkyWc6DYwR5MuFGSPbknvnw8bTEM36HYesUB0Ht0G6wiPgChww6mGTkm7GMFWoltWQnJScVav2UfuvUrA62zHhqbDVJsWzJIPSqXBnA1ULVCYYoJ4tJKGOOJmmptO3ShJWEj0bU_eGXw/s1600/lenzsf.jpg" imageanchor="1" style="clear:left; float:left;margin-right:1em; margin-bottom:1em"><img border="0" height="150" width="200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEghkyWc6DYwR5MuFGSPbknvnw8bTEM36HYesUB0Ht0G6wiPgChww6mGTkm7GMFWoltWQnJScVav2UfuvUrA62zHhqbDVJsWzJIPSqXBnA1ULVCYYoJ4tJKGOOJmmptO3ShJWEj0bU_eGXw/s200/lenzsf.jpg" /></a></div>He had been invited by the <a href="http://www.sfmysql.org/">San Francisco MySQL Meetup Group</a> to present on MySQL High Availability. We had been warned that over 140 people had RSVP-ed and there were people on the waiting list. Mike and Erin, the organizers greeted us warmly and took us to the very large room. Soon the place was packed -well over a hundred people. The crowd was thoughtful, curious, and engaging. Lenz did his usual stellar job with the presentation and the following discussion with the audience was equally impressive.<br />
<br />
If you find yourself in the San Francisco area, please make the effort to visit on of their meetings.Dave Stokeshttp://www.blogger.com/profile/16737653465494764723noreply@blogger.com3tag:blogger.com,1999:blog-8575059197193667898.post-77182503892386704472011-01-10T09:16:00.000-08:002011-01-10T09:16:12.723-08:00Free webinar Wednesday on MySQL ClusterDo not forget the What's New in Managing MySQL Cluster webinar on Wednesday the 11th. Learn about NDBINFO, MySQL Cluster Manager, and MySQL Cluster Adviser & Graphs -- three new enhancements. And the webinar is free!<br />
<br />
Please register at http://mysql.com/news-and-events/web-seminars/display-599.htmlDave Stokeshttp://www.blogger.com/profile/16737653465494764723noreply@blogger.com0tag:blogger.com,1999:blog-8575059197193667898.post-30271114640030084092010-12-15T14:06:00.000-08:002010-12-15T14:06:45.283-08:00Speaking at the O'Reilly MySQL Conference - April 2011<P align="justify">I will be speaking at least once at the 2011 O'Reilly MySQL conference. I <br />
have not heard back on all my proposed session but I will be talking <br />
about Open Source BI tools. There are several great packages to help <br />
DBAs make reports from their MySQL instances. These tools are great for <br />
simple ad-hoc reports to highly detailed data dumps.</p>Dave Stokeshttp://www.blogger.com/profile/16737653465494764723noreply@blogger.com1tag:blogger.com,1999:blog-8575059197193667898.post-60233734341860277292010-11-29T15:53:00.000-08:002010-11-29T15:53:56.309-08:00MySQL 5.5 Authentication GoodiesMySQL 5.5 is currently in the Release Candidate phase and making good <br />
progress on the way to being a Generally Available release. There <br />
are many new features that will improve performance, make service <br />
more robust, and generally make life better for DBAs. But since <br />
5.5.7 was released for evaluation in October, there has not been a <br />
lot of attention given to the changes in authentication.<br />
<br />
To greatly simplify, MySQL has a table with a list of users and a <br />
list of hosts from which those users are allowed access. So user <br />
'jones' and the host they connect from are checked to make sure they <br />
are allowed access. If they match, they can access the instance.<br />
<br />
As of 5.5.7, MySQL authentication now supports pluggable <br />
authentication and proxies. So now you can use PAM, Windows native <br />
authentication, LDAP, or something similar to control user accounts.<br />
Or use proxies for group of users. For example user 'smith' is in the <br />
'programmer' group in the LDAP directory. But there is no entry in <br />
the MySQL.user table for that user. The server will now use the <br />
pluggable authentication to reference an outside authentication <br />
service to determine the group. The connection will be established <br />
with the USER() set to 'smith@host' and CURRENT_USER() set to <br />
'programmer@%'. Please refer to <br />
http://dev.mysql.com/doc/refman/5.5/en/proxy-users.html for details.Dave Stokeshttp://www.blogger.com/profile/16737653465494764723noreply@blogger.com5