MySQL

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

Oracle users across the globe keep searching for easier ways to accomplish time consuming tasks, or keep searching for the solutions of errors and issues and then often land on valuable blog posts. In quest for this Log Buffer Edition, we also landed upon some chic blog posts across database technologies and hence this Log Buffer #237.

MySQL Content at Oracle OpenWorld – Session Matrix

While the online content catalog and schedule builder are great tools to help plan out what sessions I want to see at Oracle OpenWorld, what I really want is a matrix of only the MySQL content, preferably in a matrix that easily shows all the sessions per time period. So I decided to make the matrix myself – view…

My Broken Planet MySQL feed..

Having recently joined Pythian’s MySQL team, in anticipation of my first blog post, I was eager to add my blog feed to Planet MySQL for aggregation. Unfortunately in my haste I pasted the link to my blog as opposed to the blog feed and as the link was erroneous, Planet MySQL recursed back up the url until it reached a valid feed. Unfortunately for me, that was the main Pythian Blog feed and as a result all Pythian blog content is now getting aggregated under my name.

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

Don’t restrict your database blogging diet to just your blog reader or to your casual surfing on the net. Scour the brave bold world of database blogs from end to end. Huh? difficult? That is why we have brought you another Log Buffer Edition. Covering Oracle technologies to the SQL Server forays before culminating at the adventures in MySQL, here is the Log Buffer #236 for your eyes.

Curious Case with MySQL Replication

MySQL Replication is a powerful tool and it’s hard to find a production system not using it. On the other hand debugging replication issues can be very hard and time consuming. Especially if your replication setup is not straightforward and you are using filtering of some kind. Let’s look at an issue I had..

Alter Waiting on Select Statement to Complete

A few days ago, we faced an interesting problem on one of our customer’s slave mysqld servers. An Alter for adding a new column was run on master server took 542 seconds where as it took few hours on the slave server to complete due to a SELECT blocking the Alter was not allowed to complete. What happened in this situation was: ALTER started first, then concurrent SELECT started on the same table, when ALTER finished copy to a temp table it tried to RENAME table, but failed to get global lock on data dictionary. All the threads that started after this point had to wait on ALTER to finish.

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

Oracle has launched Java 7, Steve Jobs has resigned, IBM has made new alignments with HP and so on. The industry is buzzing with the breaking news while one thing is rest assured that the brightest and most innovative days are ahead of the IT industry, and so blogging is anticipating some thrilling times ahead and so are the Log Buffer Editions. To get a peek of future, lets savor Log Buffer #235.

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

Well like all good things, summer is also ending and its closing days are rapidly approaching. For most of the database techies, there is nothing to get remorseful, because they are thrilled to be back in full flow managing and loving their databases. They are gearing up, refreshing up, re-evaluating and reassessing themselves and also blogging about it. This Log Buffer enjoys the last days of summer in this Log Buffer #234.

Page 24 of 84« First...10...2223242526...304050...Last »