devopsdays

All about Devops, Cloud and Linux

Tag: MySQL

MySQL/MariaDB Performance Tuning and Optimization Tips

Share

MySQL is a powerful open source Relational Database Management System or in short RDBMS. It was released back in 1995 (20 years old). It uses Structured Query Language which is probably the most popular choice for managing content within a database. The latest MySQL version is 5.6.25 and was released on 29 May 2015.

An interesting fact about MySQL is the fact that the name comes from Michael Widenius’s (MySQL’s creator) daughter My. Even though there are plenty of interesting facts about MySQL, this article is meant to show you some useful practices to help you manage your MySQL server.

Continue reading

Two ways to import and export a MySQL Database

Share
 Option 1 – phpMyAdmin

 Migrate a MySQL database is as simple as selecting the DB in the left column, clicking the Export link, and saving the database to a file. Then on the new server, select the DB in the left column, click the Import link, and choose the file you just exported.

Use this method when:

  • Both servers have phpMyAdmin installed
  • The database size is under 50MB
  • The database export file is small enough to overcome upload size

With large or very complex databases, you run the risk of the PHP request timing out before the operation completes. This will leave you with a partial import. So this method is best used for smaller databases.

Continue reading

© 2020 devopsdays

Theme by Anders NorenUp ↑

Share