Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 159 10 Older Entries

Displaying posts with tag: event (reset)

Developing modern applications using MySQL seminar
+0 Vote Up -0Vote Down

I recently completed a four country tour of Baltic Sea countries presenting this seminar series at:

  [Read more...]
Report from Trondheim MySQL User Group meeting, Thursday March 6, 2014
Employee_Team +3 Vote Up -0Vote Down

Yesterday we had our third MySQL User Group meeting in Trondheim with close to 40 participants, a mix of database administrators, application developers, database developers, and even university professors.

We had all gathered to listen to Truls Bergskaug from Basefarm a leading hosting provider for mission critical business applications. Truls Bergskaug is an experienced …

  [Read more...]
How to Enable MySQL Event Scheduler
+0 Vote Up -0Vote Down

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 …



  [Read more...]
Upcoming EMEA Events with MySQL!
Employee_Team +1 Vote Up -0Vote Down

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
Employee +2 Vote Up -0Vote Down

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 …













  [Read more...]
Automating Backups
Employee +0 Vote Up -0Vote Down

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 …

  [Read more...]
MySQL-related events & the ecosystem
+3 Vote Up -0Vote Down

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 …

  [Read more...]
Too many or too big open MyISAM tables??
+2 Vote Up -1Vote Down

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 …

  [Read more...]
Upcoming speaking engagements: Oracle OpenWorld, DOAG Conference
+3 Vote Up -0Vote Down

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  …

  [Read more...]
Oracle Open World 2011 Presentations
+0 Vote Up -0Vote Down


MySQL Explain


Better Indexes

At Oracle Open World 2011 I gave two presentations.

You can download updated versions of Explaining the MySQL Explain and …




  [Read more...]
Showing entries 1 to 10 of 159 10 Older Entries

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.