This week we finish up talking about the Openark Kit for MySQL. Ear Candy is using both --master-data and --tab with mysqldump, and At the Movies features Robert Hodges of Continuent presenting Scalable MySQL Operation in the Cloud with Continuent Tungsten.

Openark Kit series:
Part 1
Part 2

Openark Kit
oak-purge-master-logs
PURGE BINARY LOGS at the MySQL manual page.

read more

It was a long time that I wanted to dig more the solution proposed by Percona to improve "TRX list" (transactions list) code -- the initial story by Alexey is starting here, then my following analyze is here, and then another test results from Percona are here. The initial discussion was more related to the READ-ONLY TRANSACTIONS introduced within MySQL 5.6 (and it was introduced exactly to get a rid of TRX mutex on read-only requests where transactions are not required at all). But in the last tests Alexey involved a very good question: what …

What programming languages and platforms do you use for large-scale projects in your organization?

If something is missing from the list please leave a comment and share your story. Thanks!

Note: There is a poll embedded within this post, please visit the site to participate in this post's poll.

The post Poll: What programming languages and platforms do you use? appeared first on MySQL Performance Blog.

Finally, Connector/Python v1.1.0 is out. It’s the first of a series of alpha releases which will bring some new features. Check out the Change History if you want to keep up with what is being added and changed.

Notable changes for v1.1.0:

• Connector/Python v1.0 was known to work with Python v2.4 and 2.5. We now break compatibility with these older Python versions.
• MySQL Prepared Statements are supported using cursor.MySQLCursorPrepared.
• You can find out whether there is an ongoing transaction by checking MySQLConnection object’s property in_transaction. …

Learn to design web-based applications with MySQL and PHP - Developing Dynamic Web Applications. In this 4-day live, instructor-led class, you will learn to:

• Design schemas based on MySQL
• Use include files to make code easier to maintain
• Use PHP 5 and takes advantage of its advanced features
• Build applications following a precise flow
• Authenticate users in a secure way against a database
• Handle errors in your PHP applications efficiently and gracefully
• Writes composite queries using JOINs and subqueries
• Use indexing efficiently in order to manipulate large amounts of data efficiently
• Uses joins to extract data from multiple tables
…

All set, here’s the recording!

Hey there everyone!

Another informative and fun-filled #DBHangOps coming up this Wednesday, July 10th, 2013 at 12:00pm pacific (19:00 GMT). Join the discussion and contribute your experience on the following topics!

• Plugins for MySQL
  • Which do you use?
  • Are there plugins that you want?
• Kernel Parameters in Linux for MySQL, specifically:
  • Linux VM settings
  • Transparent Huge Pages
• InnoDB buffer pool size and settings
  • What works in your environment and why?
• And If there’s time, information about the TokuDB storage engine in …

All set, here's the recording!

Hey there everyone!

Another informative and fun-filled #DBHangOps coming up this Wednesday, July 10th, 2013 at 12:00pm pacific (19:00 GMT). Join the discussion and contribute your experience on the following topics!

• Plugins for MySQL
  • Which do you use?
  • Are there plugins that you want?
• Kernel Parameters in Linux for MySQL, specifically:
  • Linux VM settings
  • Transparent Huge Pages
• InnoDB buffer pool size and settings
  • What works in your environment and why?
• And If there's time, information about the TokuDB storage engine in MariaDB! …

Currently at Kinja we are in a middle of big architectural change on database servers, so I have run into a problem regarding this. Sometimes I have to check current connections on database servers, to see what schemas are in use, what servers using a given db server, or even which users are connected to database server.

Previously when I had to determine connected hosts, I just used a one-liner script in bash, what parsed through the output of netstat and listed the number of connections from given servers like this:

[root@sql-slave1 banyek]# netstat | grep mysql | awk '{print $5}' | awk -F: '{print $1}' | sort | uniq -c
      1 app01.bfc.kinja-ops.c
     83 app05.bfc.kinja-ops.c
     84 app09.bfc.kinja-ops.c
      9 dbcacti.bfc.kinja-ops
      1 nagios.bfc.kinja-ops.
      1 sql-master1.bfc.kinja

This was enough to quickly see the connected hosts, but the output wasn’t too chatty, and there are a lot of …

Roland opened a bug "Documentation indicates some MYSQL_FIELD->flags are deprecated which aren't."

The MySQL protocol uses the string values of ENUM- and SET-fields. To indicate that this string originated from a ENUM- or SET-column the ENUM_FLAG and SET_FLAG are used in the Column Defintion

Same as Roland I wonder why they are deprecated. Is it something new? Something old?

Searching through the history

In an attempt to find out since when ENUMs are sent as MYSQL_TYPE_STRING + ENUM_FLAG I grepped through the oldest MySQL release that can be found in the bzr tree:

mysql-3.23.22-beta$ find . -type f | xargs grep -n ENUM_FLAG …

Roland opened a bug “Documentation indicates some MYSQL_FIELD->flags are deprecated which aren’t.”

The MySQL protocol uses the string values of ENUM- and SET-fields. To indicate that this string originated from a ENUM- or SET-column the ENUM_FLAG and SET_FLAG are used in the Column Defintion

Same as Roland I wonder why they are deprecated. Is it something new? Something old?

Searching through the history

In an attempt to find out since when ENUMs are sent as MYSQL_TYPE_STRING + ENUM_FLAG I grepped through the oldest MySQL release that can be found in the bzr tree:

mysql-3.23.22-beta$ find . -type f | xargs grep -n ENUM_FLAG …