Monthly Archives: March 2014

Remove files / directories older than N days

by

Looked for the simple command today and here it is:

find <path to files> -mtime +N -type f -delete
find <path to directories> -mtime +N -type d -delete

Where +N is how many days ago.
So in case of 2 days it should be: -mtime +2

How to get list of indexes in MySQL

by

This is query which returns the list of indexes in mysql:

SELECT table_name,
       index_name,
       GROUP_CONCAT(column_name ORDER BY seq_in_index) as 'columns_list'
FROM information_schema.statistics
GROUP BY table_name, index_name;