MySQL Performance: MyISAM vs InnoDB

Posted on by Jason Potter | Updated:
Category: Series | Tags: , , , , , , ,
Reading Time: 5 minutes

 

A major factor in database performance is the storage engine used by the database, and more specifically, its tables. Different storage engines provide better performance in one situation over another. For general use, there are two contenders to be considered. These are MyISAM, which is the default MySQL storage engine, or InnoDB, which is an alternative engine built-in to MySQL intended for high-performance databases. Before we can understand the difference between the two storage engines, we need to understand the term “locking.” Continue reading “MySQL Performance: MyISAM vs InnoDB” →

MySQL Performance: Identifying Long Queries

Posted on by Jason Potter | Updated:
Category: Featured Articles, Series | Tags: , , , , , , ,
Reading Time: 5 minutes

Every MySQL backed application can benefit from a finely tuned database server. The Liquid Web Heroic Support team has encountered numerous situations over the years where some minor adjustments have made a world of difference in website and application performance. In this series of articles, we have outlined some of the more common recommendations that have had the largest impact on performance. Continue reading “MySQL Performance: Identifying Long Queries” →

How to Install MariaDB 5.5 on Ubuntu 14.04 LTS

Posted on by J. Mays | Updated:
Category: Tutorials | Tags: , , , , , ,
Reading Time: 3 minutes

MariaDB is a drop-in replacement for MySQL. It is easy to install, offers many speed and performance improvements, and is easy to integrate into most MySQL deployments. Answers for compatibility questions can be found at MariaDB versus MySQL – Compatibility. MariaDB offers more storage engines than MySQL, including Cassandra (NoSQL), XtraDB (drop-in replacement for InnoDB), and OQGRAPH.

Preflight Check
  • These instructions are intended for installing MariaDB 5.5 on a single Ubuntu 14.04 LTS node (without MySQL already installed).
  • I’ll be working from a Liquid Web Self Managed Ubuntu 14.04 LTS server, and I’ll be logged in as a non-root user, but with sudo access. For information on giving a user sudo access visit our page on How to Add a User and Grant Root Privileges on Ubuntu 14.04.

Continue reading “How to Install MariaDB 5.5 on Ubuntu 14.04 LTS” →

How to Install OQGRAPH for MariaDB 10.0 on Fedora 20

Posted on by J. Mays | Updated:
Category: Tutorials | Tags: , , , , , , ,
Reading Time: 2 minutes
Note:
Please note that this article is considered legacy documentation because Fedora 20 has reached its end-of-life support.

MariaDB is a drop-in replacement for MySQL. It is easy to install, offers many speed and performance improvements, and is easy to integrate into most MySQL deployments. Answers for compatibility questions can be found at MariaDB versus MySQL – Compatibility. MariaDB offers more storage engines than MySQL, including Cassandra (NoSQL), XtraDB (drop-in replacement for InnoDB), and OQGRAPH.

Preflight Check
  • These instructions are intended for installing the Open Query Graph engine (OQGRAPH) for MariaDB 10.0 on Fedora 20.
  • I’ll be working from a Liquid Web Self Managed Fedora 20 server, and I’ll be logged in as root.
  • Your server should already have MariaDB 10.0 installed. If you’re working from MariaDB 5.5 visit our tutorial on How to Upgrade MariaDB 5.5 to MariaDB 10.0 on Fedora 20

Continue reading “How to Install OQGRAPH for MariaDB 10.0 on Fedora 20” →

How to Install OQGRAPH for MariaDB 10.0 on CentOS 7

Posted on by J. Mays | Updated:
Category: Tutorials | Tags: , , , , , , ,
Reading Time: 2 minutes

MariaDB is a drop-in replacement for MySQL. It is easy to install, offers many speed and performance improvements, and is easy to integrate into most MySQL deployments. Answers for compatibility questions can be found at: MariaDB versus MySQL – Compatibility. MariaDB offers more storage engines than MySQL, including Cassandra (NoSQL), XtraDB (drop-in replacement for InnoDB), and OQGRAPH.

Pre-Flight Check
  • These instructions are intended for installing the Open Query Graph engine (OQGRAPH) for MariaDB 10.0 on CentOS 7.
  • I’ll be working from a Liquid Web Core Managed CentOS 7 server, and I’ll be logged in as root.
  • Your server should already have MariaDB 10.0 installed. If you’re working from MariaDB 5.5 visit our tutorial on How to Upgrade MariaDB 5.5 to MariaDB 10.0 on CentOS 7

Continue reading “How to Install OQGRAPH for MariaDB 10.0 on CentOS 7” →

How to Install the Cassandra Storage Engine on Fedora 20

Posted on by J. Mays | Updated:
Category: Tutorials | Tags: , , , , , , ,
Reading Time: 2 minutes
Note:
Please note that this article is considered legacy documentation because Fedora 20 has reached its end-of-life support.

MariaDB is a drop-in replacement for MySQL. It is easy to install, offers many speed and performance improvements, and is easy to integrate into most MySQL deployments. Answers for compatibility questions can be found at: MariaDB versus MySQL – Compatibility. MariaDB offers more storage engines than MySQL, including Cassandra (NoSQL), XtraDB (drop-in replacement for InnoDB), and OQGRAPH.

Pre-Flight Check
  • These instructions are intended for installing the Cassandra Storage Engine for MariaDB 10.0 on Fedora 20.
  • I’ll be working from a Liquid Web Self Managed Fedora 20 server, and I’ll be logged in as root.
  • Your server should already have MariaDB 10.0 installed. If you’re working from MariaDB 5.5, visit our tutorial on: How to Upgrade MariaDB 5.5 to MariaDB 10.0 on Fedora 20

Continue reading “How to Install the Cassandra Storage Engine on Fedora 20” →

How to Upgrade MariaDB 5.5 to MariaDB 10.0 on Fedora 20

Posted on by J. Mays | Updated:
Category: Tutorials | Tags: , , , , , , , , , , , ,
Reading Time: 2 minutes
Note:
Please note that this article is considered legacy documentation because Fedora 20 has reached its end-of-life support.

MariaDB is a drop-in replacement for MySQL installed by default on CentOS 7, and offers many speed and performance improvements. MariaDB offers more storage engines than MySQL, including Cassandra (NoSQL), XtraDB (drop-in replacement for InnoDB), and OQGRAPH.

Pre-Flight Check
  • These instructions are intended for upgrading from MariaDB 5.5 to MariaDB 10.0 on Fedora 20.
  • I’ll be working from a Liquid Web Self Managed Fedora 20 server, and I’ll be logged in as root.

Continue reading “How to Upgrade MariaDB 5.5 to MariaDB 10.0 on Fedora 20” →

How to Install the Cassandra Storage Engine on CentOS 7

Posted on by J. Mays | Updated:
Category: Tutorials | Tags: , , , , , ,
Reading Time: 2 minutes

MariaDB is a drop-in replacement for MySQL. It is easy to install, offers many speed and performance improvements, and is easy to integrate into most MySQL deployments. Answers for compatibility questions can be found at: MariaDB versus MySQL – Compatibility. MariaDB offers more storage engines than MySQL, including Cassandra (NoSQL), XtraDB (drop-in replacement for InnoDB), and OQGRAPH.

Preflight Check
  • These instructions are intended for installing the Cassandra Storage Engine for MariaDB 10.0 on CentOS 7.
  • I’ll be working from a Liquid Web Core Managed CentOS 7 server, and I’ll be logged in as root.
  • Your server should already have MariaDB 10.0 installed. If you’re working from MariaDB 5.5, visit our tutorial on: How to Upgrade MariaDB 5.5 to MariaDB 10.0 on CentOS 7

Continue reading “How to Install the Cassandra Storage Engine on CentOS 7” →

How to Install OQGRAPH for MariaDB 10.0 on CentOS 6

Posted on by J. Mays | Updated:
Category: Technical Support | Tags: , , , , , , , , , ,
Reading Time: 2 minutes

MariaDB is a drop-in replacement for MySQL. It is easy to install, offers many speed and performance improvements, and is easy to integrate into most MySQL deployments. Answers for compatibility questions can be found at MariaDB versus MySQL – Compatibility. MariaDB offers more storage engines than MySQL, including Cassandra (NoSQL), XtraDB (drop-in replacement for InnoDB), and OQGRAPH.

PreFlight Check
  • These instructions are intended for installing the Open Query Graph engine (OQGRAPH) for MariaDB 10.0 on CentOS 6.
  • I’ll be working from a Liquid Web Core Managed CentOS 6.5 server, and I’ll be logged in as root.
  • Your server should already have MariaDB 10.0 installed. If you’re working from MySQL 5.1 or MariaDB 5.5, visit our tutorial on How to Upgrade MySQL 5.1 to MariaDB 10.0 on CentOS 6

Continue reading “How to Install OQGRAPH for MariaDB 10.0 on CentOS 6” →

How to Install the Cassandra Storage Engine on CentOS 6

Posted on by J. Mays | Updated:
Category: Tutorials | Tags: , , , , , , ,
Reading Time: 2 minutes

MariaDB is a drop-in replacement for MySQL. It is easy to install, offers many speed and performance improvements, and is easy to integrate into most MySQL deployments. Answers for compatibility questions can be found at: MariaDB versus MySQL – Compatibility. MariaDB offers more storage engines than MySQL, including Cassandra (NoSQL), XtraDB (drop-in replacement for InnoDB), and OQGRAPH.

Preflight Check
  • These instructions are intended for installing the Cassandra Storage Engine for MariaDB 10.0 on CentOS 6.
  • I’ll be working from a Liquid Web Core Managed CentOS 6.5 server, and I’ll be logged in as root.
  • Your server should already have MariaDB 10.0 installed. If you’re working from MySQL 5.1 or MariaDB 5.5, visit our tutorial on: How to Upgrade MySQL 5.1 to MariaDB 10.0 on CentOS 6

Continue reading “How to Install the Cassandra Storage Engine on CentOS 6” →