mysql get date interval of 30 days

Very often we need to extract last 30 days, 7 days data from mysql DB. Here we will show easy way

Read more

What is the best way to reduce the size of ibdata in mysql?

The busiest file in the InnoDB infrastructure is /var/lib/mysql/ibdata1 This file normally houses many classes of information (when innodb_file_per_table is 0) Table

Read more