Several users have reported that certain queries with IN predicates can’t use index scans even though all the columns in the query are indexed. What’s worse, if you reformulate your query without IN, the indexes are used. Let’s take some example query. Suppose we have a table with two indexed columns:CREATE TABLE t1 ( 
  col1 INTEGER,
  col2 INTEGER,
  …   KEY key1( col1, col2 ) ); Let’s take a look at some queries that could take advantage of the key1 index to read rows without accessing the table.

1. SELECT col1, col2 FROM t1 WHERE col1 = 100;
2. SELECT col1, col2 FROM t1 WHERE col1 > 100 AND col1 < 200;
3. SELECT col1, col2 FROM t1 WHERE col1 > 100 AND col1 < 200 OR col1 > 300 AND col1 < 400;
4. SELECT col1, col2 FROM t1 WHERE col1 = 100 AND col2 > 100 AND cold2 < 200;

These queries will use what MySQL …

In the past few days I have been working on a puppet module for galera. It's not done yet, but a work in progress can be found here. One of the benefits of developing a puppet module is that you need to go through the config files thoroughly to determine which settings do what exactly. While doing that, I thought I'd post a blog outlining the most important ones.

I believe that inter-node communication should preferrably take place on an unmetered private network interface if possible. For this article, we assume each machine has a private and a public interface, like so (Debian-style):

root@node1:~# cat /etc/network/interfaces
[..snip..]
# Public interface
auto eth0
iface eth0 inet static
address 5.1.2.3
netmask 255.255.255.248
gateway 5.1.2.254

# Private interface
auto eth1
iface eth1 …

In the past few days I have been working on a puppet module for galera. It's not done yet, but a work in progress can be found here. One of the benefits of developing a puppet module is that you need to go through the config files thoroughly to determine which settings do what exactly. While doing that, I thought I'd post a blog outlining the most important ones.

I believe that inter-node communication should preferrably take place on an unmetered private network interface if possible. For this article, we assume each machine has a private and a public interface, like so (Debian-style):

root@node1:~# cat /etc/network/interfaces
[..snip..]
# Public interface
auto eth0
iface eth0 inet static
address 5.1.2.3
netmask 255.255.255.248
gateway 5.1.2.254

# Private interface
auto eth1
iface eth1 …

Important variables for configuring galera with Percona XtraDB Cluster 5.6 Walter Heck Sat, 12/21/2013 - 23:32

Important variables for configuring galera with Percona XtraDB Cluster 5.6

In the past few days I have been working on a puppet module for galera. It's not done yet, but a work in progress can be found here. One of the benefits of developing a puppet module is that you need to go through the config files thoroughly to determine which settings do what exactly. While doing that, I thought I'd post a blog outlining the most important ones.

I believe that inter-node communication should preferrably take place on an unmetered private network interface if possible. For this article, we assume each machine has a private and a public interface, like so (Debian-style):

root@node1:~# cat /etc/network/interfaces
[..snip..]
# …

Important variables for configuring galera with Percona XtraDB Cluster 5.6 Walter Heck Sat, 12/21/2013 - 23:32

Important variables for configuring galera with Percona XtraDB Cluster 5.6

In the past few days I have been working on a puppet module for galera. It's not done yet, but a work in progress can be found here. One of the benefits of developing a puppet module is that you need to go through the config files thoroughly to determine which settings do what exactly. While doing that, I thought I'd post a blog outlining the most important ones.

I believe that inter-node communication should preferrably take place on an unmetered private network interface if possible. For this article, we assume each machine has a private and a public interface, like so (Debian-style):

root@node1:~# cat /etc/network/interfaces
[..snip..]
# …

Important variables for configuring galera with Percona XtraDB Cluster 5.6 Walter Heck Sat, 12/21/2013 - 23:32

Important variables for configuring galera with Percona XtraDB Cluster 5.6

In the past few days I have been working on a puppet module for galera. It's not done yet, but a work in progress can be found here. One of the benefits of developing a puppet module is that you need to go through the config files thoroughly to determine which settings do what exactly. While doing that, I thought I'd post a blog outlining the most important ones.

I believe that inter-node communication should preferrably take place on an unmetered private network interface if possible. For this article, we assume each machine has a private and a public interface, like so (Debian-style):

root@node1:~# cat /etc/network/interfaces
[..snip..]
# …

The MySQL@Oracle announced 5.7.3 development milestone release, now available for download at dev.mysql.com. You can find the full list of changes and bug fixes in the 5.7.3 Release Notes. One of the changes which went in this milestone release was MAKE –REPLICATION-* FILTER SETTINGS DYNAMIC. With this work the slave options –replicate-* can be changed dynamically through the new command CHANGE REPLICATION FILTER. These new options allow slave replication filters to be changed while the server is running, without requiring a server stop and restart.
This blog is intended to explain the design decision of choosing a “new command” over “extending the existing SET command”.

Alternatives:
…

Dear MySQL users,

MySQL Connector/Net 6.8.3, a new version of the all-managed .NET driver for MySQL has been released. This is a GA release for 6.8.x and can be used for production environments.

It is appropriate for use with MySQL server versions 5.0-5.6

It is now available in source and binary form from http://dev.mysql.com/downloads/connector/net/#downloads and mirror sites (note that not all mirror sites may be up to date at this point-if you can't find this version on some mirror, please try again later or choose another download site.)

The 6.8.3 version of MySQL Connector/Net has support for Entity Framework 6.0

The release is available to download at http://dev.mysql.com/downloads/connector/net/#downloads

Enjoy and …

There is an upcoming meeting of the Triangle Linux Users Group in Raleigh. The topic will be MySQL 5.6, presented by Alexander Rubin from Percona.

http://trilug.org/2014-01-09/mysql

Topic: What is new in MySQL 5.6
Presenter: Alexander Rubin
When: Thursday, 9th January 2014, 7pm (pizza from 6.45pm)
Where: NC State Engineering Building II Room TBA, Centennial Campus
Parking: The parking decks and Oval Drive street parking are free after 5pm

This week we discuss setting up Percona Replication Manager. Ear Candy is playing with Unicode to make seasonal pictures and At the Movies is about systems performance with lots of MySQL examples.

Events
DB Hangops - every other Wednesay at noon Pacific time

FOSDEM 2014 - Sat February 1 - Sun February 2 in Brussels, Belgium.
Upcoming MySQL events

The call for papers for OSCon 2014 is open until Thursday, January 30th

read more