WordPress database error: [Can't create/write to file '/tmp/#sql_60b_0.MYI' (Errcode: 28)]
SHOW FULL COLUMNS FROM `wp_options`

WordPress database error: [Can't create/write to file '/tmp/#sql_60b_0.MYI' (Errcode: 28)]
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND tr.object_id IN (39) ORDER BY t.name ASC

Log Management with logrotate | Data Networking Blog

WordPress database error: [Can't create/write to file '/tmp/#sql_60b_0.MYI' (Errcode: 28)]
SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (31) ORDER BY t.name ASC

WordPress database error: [Can't create/write to file '/tmp/#sql_60b_0.MYI' (Errcode: 28)]
SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (37) ORDER BY t.name ASC

Data Networking Blog
Blog for Admins

Log Management with logrotate

Standard

If you are an administrator for a company or just looking after some personal servers, you will soon realise that it is important to properly manage your log files. Log files give you important information about the health and security of your system. If you have not planned for log management then chances are you are logging everything in a single file which can grow to be hundreds of megabytes and make it really hard for you to pin point important information or the system is automatically deleting your logs older than a certain period of time.

I have experienced similar situations and that is when I implemented logrotate. It allows you to manage your log files and rotate these files daily, weekly, monthly or to a schedule you prefer. You can keep older files by defining a higher rotation number or let the system overwrite older files by defining a lower value for rotation. To install logrotate on a CentOS system type the following command in a terminal.

Once installed inspect the configuration file /etc/logrotate.conf. Below is the default configuration file for logrotate version 3.7.8.

As you can see the default configuration rotates log files weekly and keeps four log files after which it will overwrite existing log files. You can also compress your log files and rotate the files based on file size instead of a time frame.

It is a good idea not to change the default configuration instead create new configurations inside the directory /etc/logrotate.d/. As you can see above the main configuration file has a directive to include all configuration inside /etc/logrotate.d/.

Let’s create a configuration for a mail server and rotate the /var/log/maillog file on daily basis. I just prefer separating files according to a day rather than weeks. How often should you rotate depends on how quickly the file grows. So if you have high traffic on a server then doing it on daily basis makes more sense.

I have created the following configuration which you can modify easily to meet your requirements.

I am just using a few settings here but the logrotate offers much more. I will be implementing more settings in future but for now I will just keep it simple. See the comments I have added above for information on what each directive is doing. Remember to include all settings enclosed inside curly braces.

You can also email or compress log files or run a pre or post rotate command which I will try to include in a future post. Have fun and don’t forget to check the manual page for more information.

February 6, 2015 Uncategorised Jd

Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">

Font Size
Decrease Size Default Size Increase Size
Select Skin
Select Underlay Background
Select Overlay Background
Scheme Switcher Toggle