Tag: MySQL

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

un is shining and the warm wind is blowing and bringing in new and novel ideas for the technology blogs and database are no exception. From the SQL Server to MySQL and up to Oracle, blogs are bubbling with warm and cool blog posts and we present you the pick of the week in this Log Buffer #228 edition of Log Buffer.

Read More >

Turning off the Query Cache works in Percona Server 5.1 , before MySQL Server 5.5

In a previous blog post I wrote that is not possible to completely turn off the Query Cache in MySQL before 5.5 . Although, it is possible to completely turn off the Query Cache with Percona Server 5.1 . MySQL bug #38551 reports…

Read More >

You can’t turn Query Cache Off before MySQL 5.5

… or at least, not completely! It often happens to see and hear of replication SQL thread almost always in state “invalidating query cache entries (table)” . The classic tip is “set global query_cache_size=0” . While sometime this works, others…

Read More >

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

An ideal summer day is when the sun is shining, the warm sunshine refreshes your body, the light breeze becomes naught with your hair, the birds sitting on intoxicated leaves smile at you, and you to top all of that you get the latest hot issue of the Log Buffer. Yes to put cherry on your cake, Log Buffer #227 is here.

Read More >

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

In your hands, the new edition of Log Buffer is smiling and it wants your undivided attention, because it is full of selected simmering yet cool blog posts from around the blogistan of database arena. Enjoy the Log Buffer #226.

Read More >

Replication and EC2 gotcha

Tonight a client restarted some instances on EC2 and they got different IPs. This broke replication because the slaves were trying to connect to the masters using IPs that weren’t existing any more. To solve the task is easy: just…

Read More >

Open Source Bridge, day 1 keynote

Hacker Lounge – open 22 hours a day (closed between 6 and 8 fit cleaning). Android app Session notes link on each page, takes you to thewiki. #osb11 is the official hashtag Friday is unconference (I won’t be here on…

Read More >

Liveblogging: A dozen databases in 45 minutes

Actually, the slide is 12 databases in 25 minutes (and 20 minutes of theory) by Eric Redmond (@inviite). Complex data:  A lot of data isn’t really complex, it’s just modeled in a complex way. “Complexity is a symptom of confusion,…

Read More >

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

March of bloggers goes on and so is the unstoppable production of the blog posts. It’s getting more exciting week after week watching the new and old bloggers adding spice to the database blogosphere. This edition of Log Buffer brings some of the simmering and scintillating posts from around the globe in Log Buffer #225.

Read More >

Silent MyISAM Table Definition Changes and mysqldump

While trying to move a schema from one MySQL server to another, I encountered a very odd issue. The schema to be moved contained both MyISAM and InnoDB tables, so the only option I had was to dump the schema using mysqldump on the source server and import it on the destination server. I did some digging and found that the problem was that the MyISAM engine silently changed the table definition without any indications. Here are some solutions.

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