Tag: MySQL

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 >

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

Once again this week, you are holding the new edition of Log Buffer in your hands. From across the database planet, fresh and sizzling blog posts of Oracle, SQL Server and MySQL are presented just for you in Log Buffer #230. Enjoy and give your feedback in the comments.

Read More >

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

Blogs are not just yet another piece of writing. They are the manifestation of passion, perfection and purity of love towards the community. Bloggers take immense pride in sharing what they know or want to know in their blog posts, and that enables the community to respond by learning or by teaching. Log Buffer is a way to appreciate this passion, and Log Buffer #229 is yet another example of that.

Read More >

Pythian & Schooner Partner to Deliver MySQL Services and Solutions

Pythian & Schooner announced a partnership to deliver advanced support and high availability for MySQL. Customers who are deploying Schooner MySQL into their infrastructure and require additional MySQL technical resources to do so successfully, now have a professional services option to consider through Pythian.

Read More >

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 >
Page 31 of 65« First Page...10...2930313233...40...Last Page »