mysql stop responding to my requests till restart mysql
Posted by: seco (---.44.247.247.tedata.net)
Date: October 19, 2014 12:48PM

Hi
im using wamp 2.4
im testing a script in my localhost using a auditing tool called burp suite. this tool sends many requests to the server
after some time it stop responding but when i open from a different browser it opens good
and the problem is solved when i restart mysql specifically
i make my.ini best tuned but still i have to restart mysql to make it work again with my session
and here is my.ini settings

[wampmysqld]
port = 3306
socket = /tmp/mysql.sock
back_log = 75
max_connections = 500
wait_timeout=7200
key_buffer = 384M
myisam_sort_buffer_size = 64M
read_buffer_size = 1M
sort_buffer_size = 2M
thread_cache_size = 384
tmp_table_size = 64M
max_heap_table_size = 64M
max_allowed_packet = 64M
bulk_insert_buffer_size = 8M
query_cache_limit = 4M
query_cache_size =128M
query_cache_type = 1
query_prealloc_size = 65536
query_alloc_block_size = 131072
default-storage-engine = MyISAM

net_buffer_length = 8K
myisam_sort_buffer_size = 64M

how i can mysql works without having to restart it every time it stop responding to my session?
thanks in advance.

Options: ReplyQuote
Re: mysql stop responding to my requests till restart mysql
Posted by: RiggsFolly (---.dynamic.dsl.as9105.com)
Date: October 19, 2014 01:13PM

Its difficult to tell what the problam may be without a lot more information.

What are you seeing in your mysql error log? And the windows Event Viewer.

Are you running these burp's from the same PC that is running WAMPServer or from a different PC on your network.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: mysql stop responding to my requests till restart mysql
Posted by: seco (---.44.247.247.tedata.net)
Date: October 19, 2014 02:15PM

yes im running these burp's from the same PC that is running WAMPServer on windows 7

and this is the error log
2014-10-19 14:11:11 3992 [Warning] You need to use --log-bin to make --binlog-format work.
2014-10-19 14:11:11 3992 [Note] Plugin 'FEDERATED' is disabled.
2014-10-19 14:11:11 3992 [Note] InnoDB: The InnoDB memory heap is disabled
2014-10-19 14:11:11 3992 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-10-19 14:11:11 3992 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-10-19 14:11:11 3992 [Note] InnoDB: Not using CPU crc32 instructions
2014-10-19 14:11:11 3992 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-10-19 14:11:11 3992 [Note] InnoDB: Completed initialization of buffer pool
2014-10-19 14:11:11 3992 [Note] InnoDB: Highest supported file format is Barracuda.
2014-10-19 14:11:12 3992 [Note] InnoDB: 128 rollback segment(s) are active.
2014-10-19 14:11:12 3992 [Note] InnoDB: Waiting for purge to start
2014-10-19 14:11:12 3992 [Note] InnoDB: 5.6.12 started; log sequence number 5639256
2014-10-19 14:11:12 3992 [Note] Server hostname (bind-address): '*'; port: 3306
2014-10-19 14:11:12 3992 [Note] IPv6 is available.
2014-10-19 14:11:12 3992 [Note] - '::' resolves to '::';
2014-10-19 14:11:12 3992 [Note] Server socket created on IP: '::'.
2014-10-19 14:11:12 3992 [Note] Event Scheduler: Loaded 0 events
2014-10-19 14:11:12 3992 [Note] wampmysqld: ready for connections.
Version: '5.6.12' socket: '' port: 3306 MySQL Community Server (GPL)

Options: ReplyQuote
Re: mysql stop responding to my requests till restart mysql
Posted by: seco (---.44.247.247.tedata.net)
Date: October 19, 2014 02:16PM

as i mention before
from any other browser i can browse the script very well

Options: ReplyQuote


Sorry, only registered users may post in this forum.