Tag: MySQL

Using KateSQL to connect to an Oracle database in Kate

Among the features announced with the release of version 4.6 of the KDE Software Compilation is KateSQL, a SQL Query plugin for the Kate text editor. It leverages the Qt SQL module, enabling connections to most types of databases, and includes support for MySQL and SQLite. In this post I’ll show you how to get it to connect to Oracle databases.

Read More >

InnoDB error: Total number of locks exceeds the lock table size

Recently, one of our customers had a problem with one of their replication slaves where a sql statement gave an error while executing on the slave which was executed successfully on the Master server. The slave stopped with the error. We found the main difference in MySQL configuration between Master and Slave was the amount of memory allocated to innodb_buffer_pool_size because Slave was running several MySQL instances that were used for backup purposes. We need to increase the memory of innodb_buffer_pool_size variable where the locks table can fit in the configuration file and restart the database. This should fix the problem.

Read More >

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

When big news is released, the world of modern information shakes – and nowhere is this more visible than with the blogs. Log Buffer is the ideal joint for the shakers and movers of the blogosphere. This edition Log Buffer #220 sheds a spotlight on those hot spots.

Read More >

Replication Issues: Never purge logs before slave catches them!!

A customer contacted us regarding a problem with one of their replication servers. We found they had deleted some binary logs from the master and relay logs from the slave to release space. It is not a good idea to delete logs that aren’t cached by the slave, in case they are needed. At least keep relay logs in slave to keep the replication working.

Read More >

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

There are plethora of thrilling business software trends on the horizon as the summer of 2011 starts. Many of these will significantly impact IT organizations seeking to align IT operations with business objectives. Awareness of such trends can help you to keep ahead of the competition. What better way to get abreast of these trends in a nutshell than the Log Buffer? Log Buffer #219 is in your hands to enjoy.

Read More >

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

Oracle’s assault on the global market goes on with full might and as it adds new products in it’s array, SQL Server also strives hard to get the attention of people through various public appearances, and MySQL is also not behind as its growing array of bloggers marches on. This week’s Log Buffer casts a shadow on some selective blogs from these three technology in its latest edition Log Buffer #218.

Read More >

MySQL at Collaborate: Bittersweet Success

As the MySQL track coordinator for Collaborate and having attended and spoken at the O’Reilly MySQL conference in previous years, I have my own feedback about this year’s Collaborate.  This post goes through why I planned the track the way…

Read More >

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

Clouds are dispersing and the sun has started shining through. On the IT horizon, the cloud of Amazon has also dispersed and that is the biggest news of the previous week. Well clouds are elastic and they congregate and become solid after dispersion, and so Amazon will be fine too. And our blogosphere is fine too and here is the latest report about them in this week’s edition Log Buffer #217.

Read More >

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

Log Buffer has become the mainstream carnival of the Oracle blogosphere. Technological advances in Oracle, MySQL, SQL Server and other database systems, more and more conferences, and increasing numbers of bloggers are making log buffering more and more interesting, and this week’s edition Log Buffer #216 is a clear manifestation of that.

Read More >

Nagios Plugin for MySQL

I am about to present the very first public appearance of PalominoDB’s nagios plugin for MySQL.  This has been running on several clients in production for about 6 months, so we know it’s stable.  The PDF’s of the presentation slides…

Read More >
Page 34 of 89« First Page...10...3233343536...40...Last Page »