1. Apache and MySQL Logging with Syslog-ng
This article shows how to use the popular system logging tool Syslog-ng to log Apache and MySQL events. Apache does not log via syslog-ng by default so we go over two methods of easily remedying this. We also show how to use SQL queries to view syslog-ng data.

2. Using M3 to take System Monitors to the Next Level
Monitis provides built in functionality to monitor a wide variety of system statistics as well as the ability to create custom system monitors. Monitis Monitor Manager, or M3 for short, allows you to take these custom monitors …

Isn’t that that time of the year again? Yes, it is — it’s time for our annual Oracle Bloggers Meetup and of course Oracle is piggybacking OpenWorld with the meetup again! ;) What: Oracle Bloggers Meetup 2011 When: Wed, 5-Oct-2011, 5:00pm Where: Main Dining Room, Jillian’s Billiards @ Metreon, 101 Fourth Street, San Francisco, CA [...]

The much-anticipated ability to access MySQL data via a NoSQL solution has been realized. Using HandlerSocket, significant performance gains can be realized for certain workloads. Sound like something you are interested in? Join us for Percona Live London to hear Ryan Lowe, Percona’s Director of American Consulting speak on this subject. In Ryan’s session he will answer the questions like:

• What is HandlerSocket?
• Where does HandlerSocket fit in my application stack?
• Why would I want to use HandlerSocket?
• How do I use Handlersocket?

He’ll walk through relevant configuration & tuning options, and at the end of the presentation attendees will be able to identify candidate use cases within their application to use HandlerSocket.

For a chance to win a free ticket to Percona Live London and get the opportunity to hear Ryan and so many others speak on a number of different …

In an earlier post Connecting to MySQL with Python, we only returned a single result line from a “SELECT VERSION()” query. We will now take a look at returning multiple rows of data from a MySQL database using Python.

You will need to have Python (including the MySQLdb and sys modules) and MySQL installed. We will also use the same database table (address) from a previous post, Inserting Data into MySQL with Perl.

Here is the SQL statement that we used to create the table:

SET NAMES latin1;
SET FOREIGN_KEY_CHECKS = 0;

CREATE TABLE `address` (
  `name_first` varchar(30) NOT NULL,
  `name_last` varchar(30) NOT NULL,
  `address_01` varchar(40) NOT NULL,
  `address_02` varchar(40) NOT NULL, …

"FLUSH TABLES" is generally used for closing all tables by force in MySQL. Its really interesting that how mysql do this. Most of time we are doing this because someone adds new tables outside of MySQL. (Like for MyISAM tables, … Continue reading →

…

This week is all about events - events in MySQL, and calls for papers for 2012 conferences.

Percona Live MySQL Conference & Expo call for papers opens soon. http://www.percona.com/live/mysql-conference-2012/

A session matrix for all of the MySQL sessions at Oracle OpenWorld is at http://bit.ly/oow11mysql.

MySQL Community Reception (free, no need to be registered to Oracle OpenWorld) - Tuesday, October 4, 2011 7-9 pm at the San Francisco Marriott Marquis Foothill G. RSVP for the *free* MySQL Community Reception.

…

We sent out this week the September special edition of the MySQL newsletter, which is focused on Oracle OpenWorld.

If you haven’t received it yet or do not subscribe, you can see it here.

This year we have a very impressive lineup of MySQL activities at OpenWorld, including:

• 14 MySQL sessions put together by the IOUG/MySQL Community on Sunday
• 31 MySQL sessions in the main database track
• 3 Demo Pods
• 1 Hands-on Labs
• Last but not least, the MySQL Community Reception on Tuesday at 7.00 pm at the Marriott Marquis! Wei-Chen blogged about it a couple of days ago and we hope to see you there if you’re attending OpenWorld or if you’re local.

You …

We sent out this week the September special edition of the MySQL newsletter, which is focused on Oracle OpenWorld.

If you haven’t received it yet or do not subscribe, you can see it here.

This year we have a very impressive lineup of MySQL activities at OpenWorld, including:

• 14 MySQL sessions put together by the IOUG/MySQL Community on Sunday
• 31 MySQL sessions in the main database track
• 3 Demo Pods
• 1 Hands-on Labs
• Last but not least, the MySQL Community Reception on Tuesday at 7.00 pm at the Marriott Marquis! Wei-Chen blogged about it a couple of days ago and we hope to see you there if you’re attending OpenWorld or if you’re local.

You …

Oracle users across the globe keep searching for easier ways to accomplish time consuming tasks, or keep searching for the solutions of errors and issues and then often land on valuable blog posts. In quest for this Log Buffer Edition, we also landed upon some chic blog posts across database technologies and hence this Log [...]

In our last episode we started building up our online bookshop database, with tables for publishers, authors, formats and books.  At the moment we only have one book in there, so before we go too far, lets add a few more:

INSERT INTO `book` VALUES
 ( NULL, 'The Big Score', 2, 4, 1, '2007-01-01',  9781741752236, 29.95 ),
 ( NULL, 'Split', 3, 2, 1, '2003-01-01', 0732268133, 29.95 );

So what is this NULL thing, and why have I used it?  If you remember we set the first field to an auto_increment id.  Because we don't want to supply a value for this, but let the database create the next value, we need to give a value that indicates we want this to happen.  For this instance, NULL is the value to use.  We must supply a value because we didn't restrict our insert by supplying a …