Tag Archives: MySQL
Common MySQL performance problems – how to fix them
MySQL is very known to best suited open source Database system when it comes about web application. But still it shows bad performance which causes bad times for web site owners. Most of the time its not MySQL’s capability, rather database design or SQL code causes MySQL act badly. In this article we will discuss about some common issues related MySQL performance and give you some direction to fixing this problem.
Generally there are 4 kinds of problem that may hit MySQL performance:
- Inefficient schema design
- Poor indexing or no indexing
- Bad SQL Code writing
- Server Variable not tuned properly
A Simple Shell Script to Backup MySQL Database
The Shell script is a script where we are writing different types of commands and executing those commands from a single file. We can execute that command manually, by entering command one by one. But if we use shell script we have to write those commands into a text file for the first time and then we can run those commands as many times as required.
In this article first I will show you, Complete Script. Later on, you will get a description of that script. I assumed that you know about shell scripting, mysqldump and crontab.
Operating System: Any Linux or UNIX.
