Hello.
> records) takes a long time and drains memory to the point I have to > reboot the system. Here is the status after a single large query is What version of MySQL do you use? I'm not familiar with msyslog, so what queries takes such long time? In what state does the weird queries spend their time? Please send complete output of SHOW STATUS and SHOW VARIABLES. See: http://dev.mysql.com/doc/mysql/en/show-processlist.html http://dev.mysql.com/doc/mysql/en/slow-query-log.html "Jennifer Fountain" <[EMAIL PROTECTED]> wrote: > Hi, > I am new to the list and mysql for that matter. I am trying to > configure a centralized syslog server using mysql, msyslog and php. > Works great until the DB grows to about 2GB. After the database gets > over 2GB, running queries on a particular hostname (that has a lot of > records) takes a long time and drains memory to the point I have to > reboot the system. Here is the status after a single large query is > ran: > > total used free shared buffers=20 > cached=20 > Mem: 3889616 3871504 18112 0 21336=20 > 3654652=20 > -/+ buffers/cache: 195516 3694100=20 > Swap: 4194232 0 4194232=20 > > > > Here is a copy of my.cnf: > > [mysqld] > datadir=3D/data > socket=3D/var/lib/mysql/mysql.sock > skip-locking > set-variable =3D key_buffer_size=3D384M > set-variable =3D max_allowed_packet=3D1M > set-variable =3D table_cache=3D512 > set-variable =3D sort_buffer=3D2M > set-variable =3D record_buffer=3D2M > set-variable =3D thread_cache=3D8 > set-variable =3D read_rnd_buffer_size=3D2M > # Try number of CPU's*2 for thread_concurrency > set-variable =3D thread_concurrency=3D8 > set-variable =3D myisam_sort_buffer_size=3D64M > log-bin > server-id =3D 1 =20 > > [mysql.server] > user=3Dmysql > basedir=3D/var/lib > > [safe_mysqld] > err-log=3D/var/log/mysqld.log > pid-file=3D/var/run/mysqld/mysqld.pid > > > [mysqldump] > quick > set-variable =3D max_allowed_packet=3D16M > > [mysql] > no-auto-rehash > # Remove the next comment character if you are not familiar with SQL > #safe-updates > > [isamchk] > set-variable =3D key_buffer=3D256M > set-variable =3D sort_buffer=3D256M > set-variable =3D read_buffer=3D2M > set-variable =3D write_buffer=3D2M > > [myisamchk] > set-variable =3D key_buffer=3D256M > set-variable =3D sort_buffer=3D256M > set-variable =3D read_buffer=3D2M > set-variable =3D write_buffer=3D2M > > [mysqlhotcopy] > interactive-timeout > > Any thoughts as to what I am missing? Thanks for any information! > > Kind Regards, > > Jennifer Fountain > Systems Administrator/Security > R&B Distribution > 3400 E Walnut Street > Colmar, PA 18915=20 > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
