Tag: MySQL

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.

Read More >

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.

Read More >

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.

Read More >

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

The season of conferences, webinars and seminars is coming. As the summer vacations are coming to a sumptuous and fulfilling end, the techies are getting ready towards sharpening and sharing their technical know-how with the public through the events. From MySQL to Oracle to SQL Server, the things are all set to appease your technical buds through the events. This Log Buffer contains some news about those events along with much more in this Log Buffer #233.

Read More >

A Missed Opportunity?

I am reading the announcement about the Percona MySQL event in place of the O’Reilly.
What I see and what I feel is that the whole MySQL community, including Oracle, Percona, SkySQL,MariaDB and any other company doing business with MySQL have lost a good opportunity (so far).

Read More >

Pythian Speaking at Oracle OpenWorld 2011

Pythian is pleased to announce our speaking schedule at this year’s Oracle OpenWorld 2011. We’re excited to be joined by our customers Western Union, and Worldwide Technologies (WWT) as we present real-world experiences and project success. If you’re attending, don’t miss the chance to hear our team of experts. Bring your toughest questions to be answered.

Read More >

Watch for Pythian Speakers at Upcoming Oracle Technology Days

t’s a busy summer at Pythian, with our continuing wave of speaking sessions at upcoming community and regional industry events. Coming to a city near you, watch for Pythian presenting hot Oracle and Microsoft SQL Server database topics.

Read More >

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

This week’s Log Buffer in its Log Buffer #232 has lumped some interesting posts together.

Read More >

How to Run a Streaming Backup with innobackupex

On many of our clients, we have a need to run XtraBackup as a regular OS user. Aside from running into the issue where tar4ibd was not provided with Percona’s xtrabackup-1.6.2.tar.gz package, our main issues have been with permissions when attempting a streaming backup. Here is the innobackupex command that works for us.

Read More >

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

Log Writer is busily and efficiently pumping out innumerable bytes from log buffer to online redo logs, while more and more exciting features are being added to the MySQL and the SQL Server community is getting more vibrant with each passing day, and in all this beautiful frenzy, we manage to catch some elegant blog posts from across all these Log Buffer editions and present you this Log Buffer #231.

Read More >
Page 29 of 64« First Page...10...2728293031...40...Last Page »