MySQL Community team is pleased to announce following events as the ones supported by us with a great MySQL staff attending. Find more details below (or at our Community wikis).
We are planning the kickoff meeting of the Bangalore MySQL User
Camp:
We would like to invite all MySQL enthusiasts at Bangalore to
join.
Plan is to have at-least one meeting every quarter and give an
opportunity to all to participate, attend and speak.
Agenda for 22 March Meeting:
1700-1715: Introductions
1715-1730 : Meet the MySQL Development team @ Bangalore
1730-1815 : Introduction to MySQL 5.6
1815-1830 : Q&A & Plan for the next meeting
1830-1900 : Tea and informal networking
Venue:
Conf Rom 0C001,
Ground Floor, B Wing, Oracle,
Kalyani Magnum Software technology Park
1st Main, J P Nagar 7th Phase,
Bangalore 560076
You can also join the google group "bangalore-mysql-user-camp" where we will be announcing further meetings etc.
If you need to automate backups, you might wonder about the different techniques available to you.
With regards to scheduling backups using built-in features of
MySQL, you have two main options:
Scheduling mysqlbackup with cron
mysqldump is a client program, so when you run it, you run it from a shell script, or at a terminal, rather than inside a MySQL statement. The following statement backs up the sakila …
[Read more]I had an interesting conversation with Sheeri (who I’ve known for many years, so consider this friendly banter) on Twitter about my recent blog post titled: once again, a split in events.
Disclaimer/Bias Warning: For those that don’t know me, I write this as a perspective of a community member. I was the first ever Community Engineer at MySQL, followed by being a Community Relations Manager right up till I left Sun Microsystems. I now work on MariaDB which is a branch of MySQL, so naturally we are in competition for user base. But I’m writing this as a community member at large who cares about MySQL & the ecosystem.
First of, this is a focus on the user ecosystem. I think the …
[Read more]
MySQL tries to be smart and to cram as much performance out of
available hardware, and one thing that most MySQLers knows is
that opening a table (ie. opening the frm file, and depending on
the storage engine, any additional files related to the table) is
expensive from a performance point of view. When we see the
opened_tables status variable increasing, we tend to
increase the table_open_cache setting and keep as many
tables as possible open and avoid reopening them.
When it comes to MyISAM though, this has a nasty side-effect.
When the server crashes and there are MyISAM tables open, these
might well need to be REPAIRed. And if you have big MyISAM
tables, this is an issue. Let's say that your application use
several MyISAM tables, with the same content, and that you create
new tables after a certain time, to keep the size of each
individual table down? There are other reasons why you have this
effect also, say a large …
It's that time of the year again — the summer holidays are over and the conference season starts!
I'm very excited to be at Oracle Open World in San Francisco again, where I will pretty busy. On Saturday and Sunday I will attend MySQL Connect, primarily to man the Oracle Linux booth in the exhibition area. But I hope to catch some of the talks as well (I shared my favourite sessions with Keith Larson from the MySQL team in this interview). During Open World, I will help out manning the Oracle Linux demo pods in the exhibition grounds in Moscone South, where we will showcase Oracle Linux with Ksplice and related technologies. I also have a joint presentation with two of our …
[Read more]At Oracle Open World 2011 I gave two presentations.
You can download updated versions of Explaining the MySQL Explain and Improving Performance with Better Indexes presentations.
Want to know more, check out our Effective MySQL: Optimizing SQL Statements book that goes into great detail …
[Read more]For our next meeting we have a guest speaker, Zardosht Kasheff, a frequent attendee at Effective MySQL. He will be talking about “Understanding Indexing”.
Registration Details
Event Date: Tuesday, October 11, 2011, 7:00 PM
Event Location: Hive at 55, 55 Broad Street, 13F,New York, NY
10004
We are switching to using EventBrite for registration. Please register at http://effectivemysql2011oct.eventbrite.com
The cost for event is $5 to cover the event space.
Agenda
Presentation Details
Indexes are used to improve query performance. As a result, good indexes are designed around queries that users find important in their application. This talk presents three simple and …
[Read more]Last week we concluded our first Oracle Technology Network Sys Admin Day in Sacramento (CA). Well, it was actually the second Sys Admin Day, but the first one that had two parallel tracks of sessions about both Oracle Linux and Oracle Solaris.
I helped preparing for the event by creating the Linux lab handbook as well as the VirtualBox appliance of Oracle Linux 6.1 that was used for the exercises. Unfortunately I could not be there in person, but it would have been pointless for me to go on an intercontinental flight just for one day.
From the feedback we've received so far, the attendees really enjoyed the event and were positively surprised about the depth and quality of the practical hands-on lab sessions.
If you've missed the first one and happen to live …
[Read more]In my last post, I provided a short review of what I have been working on in the past few months since I joined the Oracle Linux team. Now it's time for a summary of upcoming events! Looking forward, I already have a few more things lined up:
I'll attend and speak at the Oracle OpenWorld 2011 conference in San Francisco in October. I have a joint session with Chris Mason titled Overview: New Features in Oracle Linux 6 where we'll cover the latest developments. I have another joint presentation with my colleague Rob Young from the MySQL product …
[Read more]