Security Consulting
  Unix Administration     Firewall     Intrusion Detection     Network Security     Hacking     MORE     HOME    

MySQL

  • You can have replications os databases with MySQL. The command you have to call is 
    safe_mysqld
    . The configuration is done in /etc/my.cnf.

  • Reclaiming lost space in databases: 
    mysqlcheck -o database
  • Renice your mysqld to increase it's scheduling priority: 
    renice -20 mysql_pid
  • Interested in the performance of MySQL? Run mtop.
  • In /etc/my.cnf, there are a few parameters which help with tuning: 
      set-variable=key_bugger=384M
set-variable=max_allowed_packet=1M
set-variable=table_cache=512
set-variable=sort_buffer=2M
set-variable=record_buffer=2M
set-variable=myisam_sort_buffer_size=64M
set-variable=tmp_table_size=8M
set-variable=max_connections=768
set-variable=wait_timeout=120



    CopyLeft (l) 2003 by Raffael Marty