Tag: MySQL

MySQL requires maintenance

May 4, 2014 Emil C
No Comments
Even if you’re running on a tiny VPS or on a huge server when you have a LAMP stack your biggest memory consumer will probably be MySQL. Some even prefer running it on a different machine when it comes to high traffic web apps. But, as your apps are put…
Tips & Tricks

TIP: Make Postfix use less SQL connections

August 9, 2013 Emil C
No Comments
When you manage Postfix mail servers using SQL connections to find informations about usernames, mailbox/maildir locations on the disk you probably have in your main.cf something like : virtual_alias_maps = mysql:/etc/postfix/mysql_virtual_alias_maps.cf virtual_mailbox_domains = mysql:/etc/postfix/mysql_virtual_domains_maps.cf virtual_mailbox_maps = mysql:/etc/postfix/mysql_virtual_mailbox_maps.cf relay_domains = mysql:/etc/postfix/mysql_relay_domains_maps.cf But, this way, each process(postfix process) uses one MySQL connection.…
Tips & Tricks

Running on MariaDB

February 7, 2013 Emil C
No Comments
An old and good friend of mine kept telling me that MariaDB is faster and better that the good old MySQL, that wince Oracle got it, MySQL is not what it used to be. So I decided to try it. I went to MariaDB website, to “Repository Configuration Tool”, chose…
linux