Hi everyone how are you, first I'll like to Thank everyone for this amazing place, second I wan to ask if some one have some information on an issue that i'm having with ISPConfig. I have a VPS on Virtual Host (www.vr.org) 256Mb RAM, 15Gb space, 2 CPU, Debian Etch. I've tryed to adapt the default instalation that Virtual Host (VH) make on the server to the Debian Etch prefect install, then I've installed without any issue ISPConfig, and added my domain as a site that I've bought with Godaddy (sharksoftwareinc.com), I've installed Chrooted BIND, and followed the tutorial to make my own domain server. So far everything was going smooth , up untill I've tryed to add an other domain to ISPConfig (sharkinc.com.ar). I've added the domain in ISPConfig and BIND resolved the domain without a problem, but I'm having some rare issue, in the first week the both websites (sharkinc.com.ar and sharksoftwareinc.com) worked fantastic, but in the last few weeks just sharksoftwareinc.com works perfect, sharkinc.com,ar gets resolved but it doesn't load the page... Can some body please help me, I've tryed to see if the problem was BIND but it returns me an IP, I've try to see if the problem was the server, but it doesn't show any CPU / Memory usage problems (load in the server is very low), and a friend told me to make a telnet sharkinc.com.ar 80, to see if the web server was listening and it show some reply after I write asdasd...so can some body gide me???? I want to lear, so links to read are ok, I read / write in english and spanish (my default language is spanish). Thanks in advance. Gonzalo.
I've found the problem ^_^!!! MySQL is the problem... ... al thought I've tryed to do a little optimizations to mysql seems to me that i've screwed up big time!!!... does anyone here could offerme a manual to optimize MySQL Server???? Just in case anyone ask here's my.cnf: Code: # # The MySQL database server configuration file. # # You can copy this to one of: # - "/etc/mysql/my.cnf" to set global options, # - "~/.my.cnf" to set user-specific options. # # One can use all long options that the program supports. # Run program with --help to get a list of available options and with # --print-defaults to see which it would actually understand and use. # # For explanations see # http://dev.mysql.com/doc/mysql/en/server-system-variables.html # This will be passed to all mysql clients # It has been reported that passwords should be enclosed with ticks/quotes # escpecially if they contain "#" chars... # Remember to edit /etc/mysql/debian.cnf when changing the socket location. [client] port = 3306 socket = /var/run/mysqld/mysqld.sock # Here is entries for some specific programs # The following values assume you have at least 32M ram # This was formally known as [safe_mysqld]. Both versions are currently parsed. [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0 [mysqld] # # * Basic Settings # user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp language = /usr/share/mysql/english skip-external-locking # # localhost which is more compatible and is not less secure. bind-address = 127.0.0.1 # # * Fine Tuning # key_buffer = 512K max_allowed_packet = 16M thread_stack = 128K thread_cache_size = 8 table_cache = 1024 max_connections = 100 max_user_connections = 30 max_connect_errors = 100 wait_timeout = 10 interactive_timeout = 10 # # * Query Cache Configuration # query_cache_type = 1 query_cache_limit = 1M query_cache_size = 4M # # * Logging and Replication # # Both location gets rotated by the cronjob. # Be aware that this log type is a performance killer. log = /var/log/mysql/mysql.log # # Error logging goes to syslog. This is a Debian improvement :) # # Here you can see queries with especially long duration log_slow_queries = /var/log/mysql/mysql-slow.log long_query_time = 5 log-queries-not-using-indexes # # The following can be used as easy to replay backup logs or for replication. #server-id = 1 log_bin = /var/log/mysql/mysql-bin.log # WARNING: Using expire_logs_days without bin_log crashes the server! See README.Debian! expire_logs_days = 10 max_binlog_size = 100M #binlog_do_db = include_database_name #binlog_ignore_db = include_database_name # # * BerkeleyDB # # Using BerkeleyDB is now discouraged as its support will cease in 5.1.12. skip-bdb # # * InnoDB # # InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/. # Read the manual for more InnoDB related options. There are many! # You might want to disable InnoDB to shrink the mysqld process by circa 100MB. skip-innodb # # * Security Features # # Read the manual, too, if you want chroot! # chroot = /var/lib/mysql/ # # For generating SSL certificates I recommend the OpenSSL GUI "tinyca". # # ssl-ca=/etc/mysql/cacert.pem # ssl-cert=/etc/mysql/server-cert.pem # ssl-key=/etc/mysql/server-key.pem [mysqldump] quick quote-names max_allowed_packet = 16M [mysql] #no-auto-rehash # faster start of mysql but no tab completition [isamchk] key_buffer = 16M # # * NDB Cluster # # See /usr/share/doc/mysql-server-*/README.Debian for more information. # # The following configuration is read by the NDB Data Nodes (ndbd processes) # not from the NDB Management Nodes (ndb_mgmd processes). # # [MYSQL_CLUSTER] # ndb-connectstring=127.0.0.1 # # * IMPORTANT: Additional settings that can override those from this file! # !includedir /etc/mysql/conf.d/
Well thank you falko for the quick answer!! I've run both script mentioned on this site (mysqltuner and tuning-primer) and both script "guideme" into the current confiuration, althoug I think that the problem is that I didn't wait the 48hs expected by both scripts... I think I'll wait to tomorrow to run the scripts... do you think that this is a problem?
These links might help as well: http://www.databasejournal.com/feat...p/3367871/Optimizing-the-mysqld-variables.htm http://dev.mysql.com/doc/refman/5.0/en/server-parameters.html
Sorry, for the delay but I decided to quit on the Debian Etch installation and go for the Ubuntu, since Ubuntu haves the php 5.2.6, and is debian based... So i've reinstalled the O.S. and well oviously MySQL start working (aparently perfect)... Thanks falko for all the help and advises
