public marks

PUBLIC MARKS with tags configuration & admin

November 2008

Check Your Mysql Server Performance with MySQLTuner -- Debian Admin

by camel & 1 other
MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability. Within seconds, it will display statistics about your MySQL installation and the areas where it can be improved. It’s key to remember that MySQLTuner is a script which can assist you with your server, but it is not the solution to a badly performing MySQL server. The best performance gains come from a thorough review of the queries sent to the server, and an evaluation of the MySQL server itself. A qualified developer in your application’s programming or scripting language should be able to work with a MySQL database administrator to find improvements for your server. Once the server and application are optimized well, you may need to consider hardware upgrades to the physical server itself. This is a really useful tool for helping to optimize MySQL performance.Understanding the various my.cnf variables and how they affect performance can seem really complicated but this tool takes some of the pain away and makes it easier to understand the effects of each variable.It is especially useful to be able to see the global memory usage, memory usage per thread and the maximum possible memory usage - that is really valuable information that is otherwise complex to calculate.

October 2007

NTP Server and Client Configuration in debian -- Debian Admin

by camel
Using NTP is a great way to keep your system clock set correctly. It works by contacting a number of servers around the world, asking them for the time and then calculating what the correct local time is from their responses.

July 2007

SIW | System Information for Windows

by jdrsantos & 7 others
System Information for Windows Everything you want to know about your computer.

PUBLIC TAGS related to tag configuration

admin +   application +   database +   debian +   email +   install +   linux +   list +   mail +   management +   mysql +   optimize +   performance +   postfix +   programming +   script +   server +  

Active users

camel
last mark : 09/11/2008 16:35

jdrsantos
last mark : 18/07/2007 10:35