Tag: MySQL

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 >

SkySQL Reference Architecture and What’s New in MySQL 5.5 videos

If you missed Percona Live yesterday, you missed an awesome 1-day conference.  However, to solace you, here are a few videos from Open Database Camp: SkySQL Reference Architecture – by Kaj Arnö of SkySQL What’s New in MySQL 5.5 – by Giuseppe…

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 >

Keeping a Slave in Sync and Advanced Replication for the Masses videos

Tomorrow is Percona Live, New York City’s second* MySQL Conference, at which I will be speaking at 3 pm in the Cafe room about a Nagios plugin that efficiently allows arbitrary calculations with any number of system or status variables…

Read More >

Running MySQL on SSDs and Databases: The Legal Layer

The weekly MySQL podcast, conferences, plus my regular day job here at PalominoDB have kept me quite busy in the past few months.  However, for those that missedOpenDBCamp in Sardinia, I have good news:  I will be uploading videos from…

Read More >

DATETIME vs. TIMESTAMP

Shlomi blogged over the weekend about DATETIME vs. TIMESTAMP, and hit all the major differences, except one extremely important one that very few people know about (in my opinion). Coincidentally, last week’s OurSQL podcast was about time, and included the…

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