Tag: MySQL

2017 Annual Open Source Database Community Dinner in Santa Clara

Once again, Pythian is organizing the traditional Open Source Database Community dinner in Santa Clara! When: Tuesday April 25, 7pm-10pm Where: David’s Restaurant, a short 5-minute walk from the Santa Clara Convention center. Tickets: Register here! Among the attendees will…

Read More >

Using Transportable Tablespaces with Partitioned Tables

Overview In this post I will explain how to transfer a partitioned table using transportable tablespaces on MySQL 5.6. Note that the operation is not officially supported until MySQL 5.7, as the discard tablespace operation will fail if it is…

Read More >

Log Buffer #508: A Carnival of the Vanities for DBAs

This Log Buffer Edition covers Oracle, SQL Server and MySQL.

Read More >

Experiments with MySQL 5.7’s Online Buffer Pool Resize

One of the interesting features introduced in MySQL 5.7 is that innodb_buffer_pool_size is a dynamic variable (since 5.7.5, to be more specific). Yet, past experience tells us that just because a variable is dynamic, it does not make it is…

Read More >

Asynchronous Replication from MySQL Cluster

MySQL Cluster is a highly available, distributed, shared-nothing database with very interesting performance characteristics for some workloads. Among other features, it supports automatic sharding and allows us to bypass the SQL layer if we don’t need it, via the NDB…

Read More >

Log Buffer #507: A Carnival of the Vanities for DBAs

This Log Buffer edition covers Oracle, SQL Server and MySQL blog posts with a touch of Cloud.

Read More >

Pythian at the PerconaLive 2017 Open Source Database Conference

With PerconaLive 2017 coming up in a couple of months, go ahead and get excited! The conference is being held in Santa Clara, California from April 24-28, 2017. While you’re there, be sure to add these Pythian sessions to your…

Read More >

Log Buffer #505: A Carnival of the Vanities for DBAs

This Log Buffer Edition searches through various blogs of Oracle, SQL Server and MySQL and picks a few contemporary ones.

Read More >

Log Buffer #504: A Carnival of the Vanities for DBAs

This edition of Log Buffer covers Oracle, Microsoft SQL Server, and MySQL.

Read More >

MySQL may return results in non-deterministic order with ‘order by’

Whenever we want a query’s results sorted, you may think of using the clause “order by.” You are correct: most of the time, MySQL will return the results in expected order with “order by.” Be careful, though. Sometimes MySQL may return…

Read More >
Page 1 of 6712345...10...Last Page »