Sometimes you need to get reports or something like, that runs a complex query which includes `JOIN`, `GROUP BY`, `HAVING` and etc. The time of running is depends on amount of records and complexity. To run queries faster we can use temporary tables. How Temporary table helps us It is faster to get data from [...]
Tags: MySQL, Optimization
Posted in MySQL
In order to change MySql root Password in linux, you need to follow these simple steps: 1.Login as root to linux 2.Stop MySql server /etc/init.d/mysql stop 3.Start MySql safe mode with –skip-grant-tables so there will be no prompt for password /usr/bin/mysqld_safe –skip-grant-tables 4.Now login into MySql mysql -u root 5.Update password and flush privileges UPDATE [...]
Even if you set the character set and collation of fields or table to UTF8 using simple “load data infile” command doesn’t import UTF8 texts correctly into the table. The solution is easy, you have to use “character set UTF8” after table name to instruct MySQL to consider this issue. For example the following command [...]
Posted in MySQL
Somehow you need to relocate MySQL database to another machine. To do this the same as other RDBMSs you need to export the schema and import it into the destination database. There are various methods but they all have the same two stages, Import and Export. You can use the following commands: Export `mysqldump` command is [...]
Yes, suddenly mytop shows many stocked query and even restarting the mysql does not solve the problem. The IP guy of the company says we have no problem in your mysql machine, your own software has problem. They IP guy was wright and wrong, we had no problem in the mysql server but it was [...]
Posted in MySQL
No Comments