SQL crashed by AB

[PeterS]

Hi there,

First: Sorry for my bad english

I have a problem running a (phpbb like)forum on DA.
Everything works fine, but when i do an apache bench stress test from another server, the SQL server crashes (hangs)!

Apache is then function normally and after a while sql comes back to normal operation too! (sometimes)

I have already installed ddos deflate on the box (running CentoS), which works fine, but in the minute between the crons it is still possible to crash the SQL server!


Anyone some tips for me?

Thank you

Regards,

Peter

 

[SeLLeRoNe]

what mysql log say?

 

[PeterS]

found in /var/lib/mysql/servername.com.err:

100323 9:28:49 [Note] /usr/sbin/mysqld: Normal shutdown

100323 9:28:52 InnoDB: Starting shutdown...
100323 9:28:53 InnoDB: Shutdown completed; log sequence number 0 43764
100323 9:28:53 [Note] /usr/sbin/mysqld: Shutdown complete

100323 09:28:53 mysqld ended

100323 09:28:59 mysqld started
100323 9:28:59 [Warning] Asked for 196608 thread stack, but got 126976
100323 9:29:00 InnoDB: Started; log sequence number 0 43764
/usr/sbin/mysqld: ready for connections.

Version: '4.1.21-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition - Standard (GPL)
~


Looks to me like the manually restart i did

 

[tillo]

It is probably a performance problem, which is very common on MySQL. The number of settings you should modify from the default value is huge, use mysqltuner.pl or tuning-primer.sh or any other dedicated script. There are many posts on how to use them in this forum.

 

[PeterS]

ok,

read a lot on this forum

Wanted to change my /etc/my.cnf file to optimize but there wasn't any!

Created a new /etc/my.cnf file according to knowlegde base, restarted mysqld and.....nothing! Didn't start anymore


Removed the new my.cnf file, restarted and now it's running again, pffff!!

What did i do wrong?

 

[SeLLeRoNe]

well, when didnt restart you had to check log file for see what problem he had.

 

[PeterS]

well, when didnt restart you had to check log file for see what problem he had.

100323 13:05:27 InnoDB: Starting shutdown...
100323 13:05:29 InnoDB: Shutdown completed; log sequence number 0 43764
100323 13:05:29 [Note] /usr/sbin/mysqld: Shutdown complete

100323 13:05:29 mysqld ended

100323 13:05:30 mysqld started
error: Found option without preceding group in config file: /etc/my.cnf at line: 2
Fatal error in defaults handling. Program aborted
100323 13:05:30 mysqld ended


100323 13:07:01 mysqld started
error: Found option without preceding group in config file: /etc/my.cnf at line: 2
Fatal error in defaults handling. Program aborted
100323 13:07:01 mysqld ended

here i removed the /etc/my.cnf

100323 13:07:46 mysqld started
100323 13:07:46 [Warning] Asked for 196608 thread stack, but got 126976
100323 13:07:46 InnoDB: Started; log sequence number 0 43764
/usr/sbin/mysqld: ready for connections.
Version: '4.1.21-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition - Standard (GPL)
100323 13:07:58 [Note] /usr/sbin/mysqld: Normal shutdown

100323 13:07:58 InnoDB: Starting shutdown...
100323 13:08:01 InnoDB: Shutdown completed; log sequence number 0 43764
100323 13:08:01 [Note] /usr/sbin/mysqld: Shutdown complete

100323 13:08:01 mysqld ended

100323 13:08:01 mysqld started


Something wrong with line 2 I suppose

I used this cnf:

http://help.directadmin.com/item.php?id=44

 

[SeLLeRoNe]

seems you missed

[mysqld]

at first line, recopy paste all this

my.cnf

[mysqld]
local-infile=0
skip-locking
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
max_connections=500
interactive_timeout=100
wait_timeout=100
connect_timeout=10
thread_cache_size=128
key_buffer=16M
join_buffer=1M
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=2M
read_buffer_size=2M
max_connect_errors=10
# Try number of CPU's*2 for thread_concurrency
thread_concurrency=2
myisam_sort_buffer_size=64M
server-id=1

[safe_mysqld]
err-log=/var/log/mysqld.log
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash
#safe-updates

[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[mysqlhotcopy]
interactive-timeout

 

[PeterS]

Andrea: Thanks for your help!

It is working now, but the original problem is still there

Even after replacing with the my-large.cnf SQL crashes after loads of requests.

I have to admit: It IS working quite faster now

 

[PeterS]

Does anybody knows where the Stack thing comes from? Should that be the problem?

100323 13:07:46 mysqld started
100323 13:07:46 [Warning] Asked for 196608 thread stack, but got 126976
100323 13:07:46 InnoDB: Started; log sequence number 0 43764
/usr/sbin/mysqld: ready for connections.





Thanks

Peter

 

[SeLLeRoNe]

well that is just a warning, dunno honestly what he means.. but ive noticed you using innodb that use to ask so much ram and that should be your problem maybe, the database you try to "overload" is using innodb?