Showing entries 11 to 20 of 169
« 10 Newer Entries | 10 Older Entries »
Displaying posts with tag: event (reset)
How to Enable MySQL Event Scheduler

You may think that you already know what's the opposite of "DISABLED", but with MySQL Event Scheduler you'll be wrong.

In fact MySQL Event Scheduler may have three different states[1][2]:

DISABLED -  The Event Scheduler thread does not run [1]. In addition, the Event Scheduler state cannot be changed at runtime.
OFF (default) - The Event Scheduler thread does not run [1]. When the Event Scheduler is OFF it can be started by setting the value of event_scheduler to ON.
ON - The Event Scheduler is started; the event scheduler thread runs and executes all scheduled events.

So if you're going to find it in the DISABLED state and instinctively set it to ENABLED you'll end up with a non-starting MySQL daemon.
Be warned and stay safe out there!


[1]: http://dev.mysql.com/doc/refman/5.5/en/events-configuration.html
[2]: When the Event Scheduler is not running does not appear …

[Read more]
Upcoming EMEA Events with MySQL!

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).

[Read more]
Bangalore MySQL User Camp - 22 Mar

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.


Automating Backups

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:

  • Either run mysqldump (or mysqlbackup if you have an Enterprise licence) from an operating system scheduler, for example in Linux using "cron" or in Windows using the "Task Scheduler". This is the most commonly used option.
  • Alternatively, use the Event Scheduler to perform a series of  SELECT ... INTO OUTFILE ... commands, one for each table you need to back up. This is a less commonly used option, but you might still find it useful.

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]
MySQL-related events & the ecosystem

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]
Too many or too big open MyISAM tables??

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 …

[Read more]
Upcoming speaking engagements: Oracle OpenWorld, DOAG Conference

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]
Oracle Open World 2011 Presentations


MySQL Explain


Better Indexes

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]
Next New York Meeting – Understanding Indexing

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

  • 7:00 Meet and Greet
  • 7:15 Presentation
  • 8:15 Q & A
  • 8:30 Networking

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]
Join us at the OTN Sys Admin Day for Oracle Linux and Solaris on Sep. 22nd, Seattle (WA)

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]
Showing entries 11 to 20 of 169
« 10 Newer Entries | 10 Older Entries »