Hi, I have a strange problem. I am running mysqld (5.0.20) on NetBSD 3.0 and after the startup scripts are complete the mysqld process ramps up to 100% utilization. However this only happens if I make mysql calls from within the startup scripts.
If I wait until the startup scripts have completed before accessing the database, then everything is ok. The server is being run as follows: /usr/pkg/libexec/mysqld -uroot & and I am accessing it using something like: echo "select * from MyTable" | /usr/pkg/bin/mysql -uroot -ppassword MyDatabase If these are put next to each other in the startup scripts (rc.local), mysqld becomes very unhappy. This has worked fine in the past with mysql 3 and 4. Having compiled and run mysqld with --debug the following appears in the trace file: > [EMAIL PROTECTED] : | >hash_free > [EMAIL PROTECTED] : | | enter: hash: 0x852e76cd > [EMAIL PROTECTED] : | | >my_free > [EMAIL PROTECTED] : | | | my: ptr: 0x8534400 > [EMAIL PROTECTED] : | | <my_free > [EMAIL PROTECTED] : | <hash_free > [EMAIL PROTECTED] : | >hash_init > [EMAIL PROTECTED] : | | enter: hash: 0x852e76c size: 128 > [EMAIL PROTECTED] : | | >init_dynamic_array > [EMAIL PROTECTED] : | | | >my_malloc > [EMAIL PROTECTED] : | | | | my: size: 1024 my_flags: 16 > [EMAIL PROTECTED] : | | | | exit: ptr: 0x8534400 > [EMAIL PROTECTED] : | | | <my_malloc > [EMAIL PROTECTED] : | | <init_dynamic_array > [EMAIL PROTECTED] : | <hash_init > [EMAIL PROTECTED] : | >process_alarm > [EMAIL PROTECTED] : | | info: sig: 14 active alarms: 0 > [EMAIL PROTECTED] : | <process_alarm > [EMAIL PROTECTED] : | >process_alarm > [EMAIL PROTECTED] : | | info: sig: 14 active alarms: 0 > [EMAIL PROTECTED] : | <process_alarm > [EMAIL PROTECTED] : | >process_alarm > [EMAIL PROTECTED] : | | info: sig: 14 active alarms: 0 > [EMAIL PROTECTED] : | <process_alarm > [EMAIL PROTECTED] : | >process_alarm > [EMAIL PROTECTED] : | | info: sig: 14 active alarms: 0 > [EMAIL PROTECTED] : | <process_alarm > [EMAIL PROTECTED] : | >process_alarm > [EMAIL PROTECTED] : | | info: sig: 14 active alarms: 0 > [EMAIL PROTECTED] : | <process_alarm Does anyone have any idea about what could be causing this? Any help would be much appreciated... Stuart -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
