Tag: MySQL

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 >

Better late than never…. prizes for this year’s OOW11 Blogger’s Meetup

Better late than never – we absolutely have prizes this year for the Blogger’s Meetup. Alex has been way too busy of late to get this organized (joking, not ALL his fault…). Seriously, we do have prizes. We will have beer and there will be food at Jillian’s in a very short time.

Read More >

Change Views DEFINER Without ALTER VIEW: How to Fix Thousands of Views

Recently I faced an interesting challenge: modify over 26k views on a single mysqld instance. Altering the view one by one was far from an easy task, so a I had to look for an efficient way to do it….

Read More >

Change Views DEFINER without ALTER VIEW : how to fix thousands of views!

Recently I faced an interesting challenge: modify over 26k views on a single mysqld instance. Altering the view one by one was far from an easy task, so a I had to look for an efficient way to do it….

Read More >

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

With Oracle Open World in the offing, Oracle and MySQL bloggers and professionals are flocking to either San Fransisco or to their blogs to relish this annual medley of technologies under one roof. This Log Buffer Edition covers that and much more in Log Buffer #240.

Read More >

Rounding Errors in MYSQL with DECIMAL Type

It seems to be assumed that fixed-point values, DECIMAL and NUMERIC, in MySQL are not susceptible to rounding errors because they are exact numeric data types. It must be kept it mind, that there are limits in precision, and the maximum number of digits for DECIMAL is 65. What I am discussing here is rounding error.

Read More >

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

Integrated and Turnkey solutions are the name of game these days. Solutions based on software, hardware, storage, and networking tightly knitted in one box with the option of customization are shaping the future. Oracle, once again leading the pack has come up with a groundbreaking appliance and blogs are buzzing with it and so is this Log Buffer Edition. ODA and various sizzling news from SQL Server and MySQL are adorning this Log Buffer #239.

Read More >
Page 28 of 65« First Page...10...2627282930...40...Last Page »