Tag: MySQL

Announcing PalominoDB’s Non Profit Program

I’ve always had a dream of being able to use what we are doing at PalominoDB not only for our for profit clients, but for those who go out day to day helping those who need it.  We always try…

Read More >

Log Buffer #243, A Carnival of the Vanities for DBAs

From Percona Live, London to TechEd Australia to Oracle Open World USA, the blogosphere of Oracle, MySQL, SQL Server and the related technologies is bustling with the eye witness accounts of these conferences, technical overviews, observations, predictions, and much more. This Log Buffer Edition covers all that and as usual more in Log Buffer #243.

Read More >

Log Buffer #242, A Carnival of the Vanities for DBAs

Whenever Oracle Open World ends, it not only leaves the technology professionals in awe and full of pride, it also makes them come up with new and great blogging ideras and this Log Buffer Edition covers that flowing notions from bloggers across the Oracle and MySQL beauties, in addition to SQL Server in Log Buffer #242.

Read More >

Exporting the mysql.slow_log table into slow query log format

Using pt-query-digest is an excellent way to perform a SQL review. However, sometimes you don’t have access to the slow_query_log_file. For example, when MySQL runs on Amazon RDS, the slow_query_log_file is unavailable (see the RDS FAQ). To get around this,…

Read More >

The Empty Error Log

The MySQL errorlog is an important point of reference when administering a MySQL Server. We can grasp much about the state of our MySQL instance by the informational and error messages written out to it by our MySQL daemon. I was asked to investigate some replication outage alerts a colleague had received overnight. One of the primary directions I took was the error log file. This is where I would expect find any evidence of replication being stopped or crashes etc. When I ran the command to tail the log I was shocked to see the log was totally empty.

Read More >

Important Caveats When Using pt-online-schema-change

Using pt-online-schema-change is a great way to change a table without downtime or switching over to a secondary database first. While using it on production systems, we found some interesting issues to consider. 1) There were foreign_keys referencing the table…

Read More >

New replication features in MySQL 5.6

This post was thought of as an attempt to make some performance test with new multi-threaded replication in 5.6, at least that was my initial intention. Based on Luis Soarez – Replication Team Leader in Oracle – post. I wanted to play with new set of variables and features in order to understand how new multi-threaded replication works and make some performance tests.

Read More >

PalominoDB at PerconaLive

PalominoDB is very excited about our participation in the upcoming PerconaLiveconference in London.  We’ll have two of our European staff presenting.  On Monday, Jonathan Levin will be doing a tutorial on Advanced MySQL Scaling Strategies for Developers, and on Tuesday Rene…

Read More >

Why are your indexes larger than your actual data?

I sometimes encounter this phenomenon when a database has tables in which the indexes are larger—sometimes much larger—than the actual data stored in the table. Often, the table becomes unwieldy, which generates a number of questions: Should I partition? Should…

Read More >

Log Buffer #241, A Carnival of the Vanities for DBAs

World has opened up in San Fransisco with the database bangs. MySQL and Oracle databases have scintillated the hearts of developers, DBAs, technology aficionados, and the mere spectators. That and plethora of news has also poured in from SQLServer melas. This Log Buffer Edition is proud to shed spotlight on all these happenings in this Log Buffer #241.

Read More >
Page 27 of 64« First Page...10...2526272829...40...Last Page »