Le blog d’un serveradmin débutant…

  • 200 % ?

    You have a processor which has more than one core, or you have multiple processors. If you have two cores and a process is using 100% of both cores, it will show as 200% in top.

  • Optimize my.cnf

    http://www.linuxweblog.com/tune-my.cnf Had to do some fine tuning of MySQL 4.1.9 and here is what my.cnf file looks like for a 2GHz machine with 1GB of memory. [mysqld] socket=/path/to/mysql.sock datadir=/var/lib/mysql skip-locking skip-innodb # MySQL 4.x has query caching available. # Enable it for vast improvement and it may be all you need to tweak. query_cache_type=1 query_cache_limit=1M…

  • Réparation de tables

    http://mirrors.dotsrc.org/mysql/doc/refman/5.1/en/rebuilding-tables.html How To Repair Corrupted MySQL Tables Using myisamchk

  • Tar, tar.gz

    From : http://www.simplehelp.net/2008/12/15/how-to-create-and-extract-zip-tar-targz-and-tarbz2-files-in-linux/ TAR Here’s how you compress a directory: # tar -cvf archive_name.tar directory_to_compress And to extract the archive: # tar -xvf archive_name.tar.gz This will extract the files in the archive_name.tar archive in the current directory. Like with the tar format you can optionally extract the files to a different directory: # tar -xvf…

  • thread_cache_size

    The thread cache hit rate can be calculated with Threads_created/Connections. Ideally you want the threads cached to be able to handle all connections. So a stable (zero growth) or low Threads_created status variable is the goal. Depending on your specific situation, in some case this value can be very high (like 150+). For an idea…

  • thread_concurrency

    thread_concurrency should follow: number of CPU’s*2 for thread_concurrency thread_concurrency -> the number of processes which will run AT SAME TIME. In all modern OSs possible to run a lot of tasks simultaneously. But in real one processor will perform ONE task at once but very frequently switch between tasks. If you have few CPUs it…

  • skip-locking

    http://forums.mysql.com/read.php?21,85701,85966 In the system lock state there is not just done file locking, but also MyISAM locking of the table. In that phase just one thread can access the table, others must wait there. The MyISAM table lock is also used during « system unlocking » though this is not shown in the processlist. If the unlock…

  • Etre informé des connexions SSH par mail

    Trouvé ici : http://www.webhostgear.com/43.html 1. Login to your server and su to root, I know the irony! 2. cd /root 3. pico .bashrc 4. Scroll to the end of the file then add the following: echo ‘Accès Shell Root le ‘ `date` `who` | mail -s `hostname` Shell Root de `who | cut -d »( » -f2…

  • SPRI

    Trouvé ici : http://www.host.co.in/forums/f20/spri-system-priority-435/ SPRI – changes the priority of different processes in accordance to level of importance, hence increasing server performance. SPRI (System Priority) is a utility designed to que different processes with different priority levels based on 3 class levels of importance (high,med,low). The problem? Linux has priority levels to thread all tasks…

  • My.cnf

    Le thread_cache_size : le laisser a 0 revient plus ou moins à désactiver le pre-forking des children dans apache.

Vous avez des recommandations de livres ?