Tag: MySQL

Status Update on How MySQL Handles the Partition(s) for Maintenance

Let us talk how OPTIMIZE partitions doesn’t work and what to do. I have set up a simple test instance with two tables, and use my stresstool (java), to fill the tables and play with the inserting threads.

Read More >

Pythian Webinar Update: Exadata, MySQL HA, Exalogic, ASM & more…

Please join Pythian for our next series of live and recorded webinars and have the chance to ask questions directly of our DBA experts. If you miss a session, you can always check out select recorded webinars here

Read More >

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

Social media is buzzing with the news and views of bloggers. From the database side of this glorious media, we have picked out some of the gems for you in this edition of Log Buffer, which is the Log Buffer #223.

Read More >

Designing Index to Eliminate Sorting

Using algorithm described in “Relational Database Index Design and the Optimizers by Tapio Lahdenmaki and Mike Leach”, I quickly came up with two indexes and while first one looked fine, I was really confused by the second one for the elimination of the sort. Let me show an example, not copy one from the book, but rather show a test I did with MySQL.

Read More >

Enhancing Performance in WordPress by Moving from MyISAM to Innodb

WordPress is a really cool open source tool for easy web design and blogging. Unfortunately, it has limitations related to the use of MyISAM as a storage engine. But, there is good news, Word Press Supports InnoDB! Here are some approaches to set this up for your environment.

Read More >

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

Bloggers are touching base with the technologies which they cherish most and coming back with some master strokes. This new cool edition of Log Buffer, the coolest blog carnival covering hottest topics encompass that home coming. Now Chill with Log Buffer #222!!!

Read More >

Beginner’s Guide to MariaDB and mysqltuner 2.0 videos now online!

I am currently on my way to Percona Live in NYC.  For those that cannot be there, I have posted some new videos from Open DB Camp in Sardinia, Italy earlier this month. It will not be the same as…

Read More >

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

Another medley of database blogs under the famous banner of Log Buffer is in your virtual hands. This edition of Log Buffer, the Log Buffer #221 puts spotlight on the fresh and cool blogs from Oracle, MySQL and SQL Server arena.

Read More >

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