By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,835 Members | 1,454 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,835 IT Pros & Developers. It's quick & easy.

mysql in a startup/shutdown loop at 30 sec intervals

P: n/a
I'm pretty much a newbie on mysql, and I need some help.

I am running mysql Ver 12.22 Distrib 4.0.24, for portbld-freebsd5.4
(i386) on a server hosting an active website.

The site's developer uses his own php shopping cart to receive customer
orders.

The configuration was done via cPanel with no external modifications -
which produced no protests when built, ran and connected with no
problem.

My error log shows:

[..snip..]

051123 15:53:57 InnoDB: Started
/usr/local/libexec/mysqld: ready for connections.
Version: '4.0.24' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port:
mysql-server-4.0.24
051123 15:54:32 mysqld restarted
051123 15:54:32 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 21851038
InnoDB: Doing recovery: scanned up to log sequence number 0 21851038
051123 15:54:32 InnoDB: Flushing modified pages from the buffer
pool...
051123 15:54:32 InnoDB: Started
/usr/local/libexec/mysqld: ready for connections.
Version: '4.0.24' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port:
mysql-server-4.0.24
051123 15:55:07 mysqld restarted
051123 15:55:07 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 21851048
InnoDB: Doing recovery: scanned up to log sequence number 0 21851048
051123 15:55:07 InnoDB: Flushing modified pages from the buffer
pool...
051123 15:55:07 InnoDB: Started
/usr/local/libexec/mysqld: ready for connections.
Version: '4.0.24' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port:
mysql-server-4.0.24
051123 15:55:42 mysqld restarted
051123 15:55:42 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 21851058
InnoDB: Doing recovery: scanned up to log sequence number 0 21851058
051123 15:55:42 InnoDB: Flushing modified pages from the buffer
pool...
051123 15:55:42 InnoDB: Started
/usr/local/libexec/mysqld: ready for connections.
Version: '4.0.24' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port:
mysql-server-4.0.24
051123 15:56:17 mysqld restarted
051123 15:56:17 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 21851068
InnoDB: Doing recovery: scanned up to log sequence number 0 21851068
051123 15:56:17 InnoDB: Flushing modified pages from the buffer
pool...
051123 15:56:17 InnoDB: Started
/usr/local/libexec/mysqld: ready for connections.
Version: '4.0.24' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port:
mysql-server-4.0.24
051123 15:56:53 mysqld restarted
051123 15:56:53 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 21851301
InnoDB: Doing recovery: scanned up to log sequence number 0 21851301
051123 15:56:53 InnoDB: Flushing modified pages from the buffer
pool...
051123 15:56:53 InnoDB: Started
/usr/local/libexec/mysqld: ready for connections.

[..snip..] continuously resetting as above

Variables:

mysql> show variables;
+---------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------+
| Variable_name | Value

|
+---------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------+
| back_log | 50

|
| basedir | /usr/local/

|
| bdb_cache_size | 8388600

|
| bdb_log_buffer_size | 32768

|
| bdb_home | /var/db/mysql/

|
| bdb_max_lock | 10000

|
| bdb_logdir |

|
| bdb_shared_data | OFF

|
| bdb_tmpdir | /var/tmp/

|
| bdb_version | Sleepycat Software: Berkeley DB
3.2.9a: (March 5, 2005)
|
| binlog_cache_size | 32768

|
| bulk_insert_buffer_size | 8388608

|
| character_set | latin1

|
| character_sets | latin1 dec8 dos german1 hp8 koi8_ru
latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian
koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 |
| concurrent_insert | ON

|
| connect_timeout | 5

|
| convert_character_set |

|
| datadir | /var/db/mysql/

|
| default_week_format | 0

|
| delay_key_write | ON

|
| delayed_insert_limit | 100

|
| delayed_insert_timeout | 300

|
| delayed_queue_size | 1000

|
| flush | OFF

|
| flush_time | 0

|
| ft_boolean_syntax | + -><()~*:""&|

|
| ft_min_word_len | 4

|
| ft_max_word_len | 254

|
| ft_max_word_len_for_sort | 20

|
| ft_stopword_file | (built-in)

|
| have_bdb | YES

|
| have_crypt | YES

|
| have_innodb | YES

|
| have_isam | YES

|
| have_raid | NO

|
| have_symlink | YES

|
| have_openssl | NO

|
| have_query_cache | YES

|
| init_file |

|
| innodb_additional_mem_pool_size | 1048576

|
| innodb_autoextend_increment | 8

|
| innodb_buffer_pool_size | 8388608

|
| innodb_data_file_path | ibdata1:10M:autoextend

|
| innodb_data_home_dir |

|
| innodb_file_io_threads | 4

|
| innodb_force_recovery | 0

|
| innodb_thread_concurrency | 8

|
| innodb_flush_log_at_trx_commit | 1

|
| innodb_fast_shutdown | ON

|
| innodb_flush_method |

|
| innodb_lock_wait_timeout | 50

|
| innodb_log_arch_dir | ./

|
| innodb_log_archive | OFF

|
| innodb_log_buffer_size | 1048576

|
| innodb_log_file_size | 5242880

|
| innodb_log_files_in_group | 2

|
| innodb_log_group_home_dir | ./

|
| innodb_mirrored_log_groups | 1

|
| innodb_max_dirty_pages_pct | 90

|
| innodb_max_purge_lag | 0

|
| innodb_table_locks | ON

|
| interactive_timeout | 28800

|
| join_buffer_size | 131072

|
| key_buffer_size | 8388600

|
| language | /usr/local/share/mysql/english/

|
| large_files_support | ON

|
| license | GPL

|
| local_infile | ON

|
| locked_in_memory | OFF

|
| log | OFF

|
| log_update | OFF

|
| log_bin | OFF

|
| log_slave_updates | OFF

|
| log_slow_queries | OFF

|
| log_warnings | 1

|
| long_query_time | 10

|
| low_priority_updates | OFF

|
| lower_case_file_system | OFF

|
| lower_case_table_names | 0

|
| max_allowed_packet | 1048576

|
| max_binlog_cache_size | 4294967295

|
| max_binlog_size | 1073741824

|
| max_connections | 1000

|
| max_connect_errors | 10

|
| max_delayed_threads | 20

|
| max_insert_delayed_threads | 20

|
| max_heap_table_size | 16777216

|
| max_join_size | 4294967295

|
| max_relay_log_size | 0

|
| max_seeks_for_key | 4294967295

|
| max_sort_length | 1024

|
| max_user_connections | 0

|
| max_tmp_tables | 32

|
| max_write_lock_count | 4294967295

|
| myisam_max_extra_sort_file_size | 268435456

|
| myisam_max_sort_file_size | 2147483647

|
| myisam_repair_threads | 1

|
| myisam_recover_options | OFF

|
| myisam_sort_buffer_size | 8388608

|
| net_buffer_length | 16384

|
| net_read_timeout | 30

|
| net_retry_count | 1000000

|
| net_write_timeout | 60

|
| new | OFF

|
| open_files_limit | 11095

|
| pid_file |
/var/db/mysql/virtual5.industryinet.com.pid

|
| log_error |

|
| port | 3306

|
| protocol_version | 10

|
| query_alloc_block_size | 8192

|
| query_cache_limit | 1048576

|
| query_cache_size | 0

|
| query_cache_type | ON

|
| query_cache_wlock_invalidate | OFF

|
| query_prealloc_size | 8192

|
| range_alloc_block_size | 2048

|
| read_buffer_size | 131072

|
| read_only | OFF

|
| read_rnd_buffer_size | 262144

|
| rpl_recovery_rank | 0

|
| server_id | 0

|
| slave_net_timeout | 3600

|
| skip_external_locking | ON

|
| skip_networking | OFF

|
| skip_show_database | OFF

|
| slow_launch_time | 2

|
| socket | /tmp/mysql.sock

|
| sort_buffer_size | 2097144

|
| sql_mode | 0

|
| table_cache | 64

|
| table_type | MYISAM

|
| thread_cache_size | 0

|
| thread_stack | 196608

|
| tx_isolation | REPEATABLE-READ

|
| timezone | CST

|
| tmp_table_size | 33554432

|
| tmpdir | /var/tmp/

|
| transaction_alloc_block_size | 8192

|
| transaction_prealloc_size | 4096

|
| version | 4.0.24

|
| version_comment | FreeBSD port: mysql-server-4.0.24

|
| version_compile_os | portbld-freebsd5.4

|
| wait_timeout | 28800

|
+---------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------+
143 rows in set (0.00 sec)

More info:

[ Variables | InnoDB Status ]

InnoDB is available on this MySQL server.

Data home directory
Data files ibdata1:10M:autoextend
Autoextend increment 8
Buffer pool size 8,192 KB
MyISAM
MyISAM is the default storage engine on this MySQL server.

Automatic recovery mode OFF
Maximum size for temporary sort files 2,048 MB
Maximum size for temporary files on index creation 262,144 KB
Repair threads 1
Sort buffer size 8,192 KB
Variable Session value Global value
back log 50 50
basedir /usr/local/ /usr/local/
bdb cache size 8388600 8388600
bdb log buffer size 32768 32768
bdb home /var/db/mysql/ /var/db/mysql/
bdb max lock 10000 10000
bdb logdir
bdb shared data OFF OFF
bdb tmpdir /var/tmp/ /var/tmp/
bdb version Sleepycat Software: Berkeley DB 3.2.9a: (March 5, 2005)
Sleepycat Software: Berkeley DB 3.2.9a: (March 5, 2005)
binlog cache size 32768 32768
bulk insert buffer size 8388608 8388608
character set latin1 latin1
character sets latin1 dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7
cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr
greek win1250 croat cp1257 latin5 latin1 dec8 dos german1 hp8 koi8_ru
latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian
koi8_ukr win1251ukr greek win1250 croat cp1257 latin5
concurrent insert ON ON
connect timeout 5 5
convert character set
datadir /var/db/mysql/ /var/db/mysql/
default week format 0 0
delay key write ON ON
delayed insert limit 100 100
delayed insert timeout 300 300
delayed queue size 1000 1000
flush OFF OFF
flush time 0 0
ft boolean syntax + -><()~*:""&| + -><()~*:""&|
ft min word len 4 4
ft max word len 254 254
ft max word len for sort 20 20
ft stopword file (built-in) (built-in)
have bdb YES YES
have crypt YES YES
have innodb YES YES
have isam YES YES
have raid NO NO
have symlink YES YES
have openssl NO NO
have query cache YES YES
init file
innodb additional mem pool size 1048576 1048576
innodb autoextend increment 8 8
innodb buffer pool size 8388608 8388608
innodb data file path ibdata1:10M:autoextend ibdata1:10M:autoextend
innodb data home dir
innodb file io threads 4 4
innodb force recovery 0 0
innodb thread concurrency 8 8
innodb flush log at trx commit 1 1
innodb fast shutdown ON ON
innodb flush method
innodb lock wait timeout 50 50
innodb log arch dir ./ ./
innodb log archive OFF OFF
innodb log buffer size 1048576 1048576
innodb log file size 5242880 5242880
innodb log files in group 2 2
innodb log group home dir ./ ./
innodb mirrored log groups 1 1
innodb max dirty pages pct 90 90
innodb max purge lag 0 0
innodb table locks ON ON
interactive timeout 28800 28800
join buffer size 131072 131072
key buffer size 8388600 8388600
language /usr/local/share/mysql/english/
/usr/local/share/mysql/english/
large files support ON ON
license GPL GPL
local infile ON ON
locked in memory OFF OFF
log OFF OFF
log update OFF OFF
log bin OFF OFF
log slave updates OFF OFF
log slow queries OFF OFF
log warnings 1 1
long query time 10 10
low priority updates OFF OFF
lower case file system OFF OFF
lower case table names 0 0
max allowed packet 1048576 1048576
max binlog cache size 4294967295 4294967295
max binlog size 1073741824 1073741824
max connections 1000 1000
max connect errors 10 10
max delayed threads 20 20
max insert delayed threads 20 20
max heap table size 16777216 16777216
max join size 4294967295 4294967295
max relay log size 0 0
max seeks for key 4294967295 4294967295
max sort length 1024 1024
max user connections 0 0
max tmp tables 32 32
max write lock count 4294967295 4294967295
myisam max extra sort file size 268435456 268435456
myisam max sort file size 2147483647 2147483647
myisam repair threads 1 1
myisam recover options OFF OFF
myisam sort buffer size 8388608 8388608
net buffer length 16384 16384
net read timeout 30 30
net retry count 1000000 1000000
net write timeout 60 60
new OFF OFF
open files limit 11095 11095
pid file /var/db/mysql/virtual5.industryinet.com.pid
/var/db/mysql/virtual5.industryinet.com.pid
log error
port 3306 3306
protocol version 10 10
query alloc block size 8192 8192
query cache limit 1048576 1048576
query cache size 0 0
query cache type ON ON
query cache wlock invalidate OFF OFF
query prealloc size 8192 8192
range alloc block size 2048 2048
read buffer size 131072 131072
read only OFF OFF
read rnd buffer size 262144 262144
rpl recovery rank 0 0
server id 0 0
slave net timeout 3600 3600
skip external locking ON ON
skip networking OFF OFF
skip show database OFF OFF
slow launch time 2 2
socket /tmp/mysql.sock /tmp/mysql.sock
sort buffer size 2097144 2097144
sql mode 0 0
table cache 64 64
table type MYISAM MYISAM
thread cache size 0 0
thread stack 196608 196608
tx isolation REPEATABLE-READ REPEATABLE-READ
timezone CST CST
tmp table size 33554432 33554432
tmpdir /var/tmp/ /var/tmp/
transaction alloc block size 8192 8192
transaction prealloc size 4096 4096
version 4.0.24 4.0.24
version comment FreeBSD port: mysql-server-4.0.24 FreeBSD port:
mysql-server-4.0.24
version compile os portbld-freebsd5.4 portbld-freebsd5.4
wait timeout 28800 28800
More log info:

/var/log/mysqld.log
051123 15:22:15 13 Query SELECT * FROM pdb WHERE
Partnumber='07/00077X'
13 Query SELECT * FROM pdb WHERE
Partnumber='07/00077X'
13 Quit
051123 15:22:16 14 Connect imafs_fsdb@localhost on
14 Init DB imafs_fsdb
14 Query SELECT * FROM pdb WHERE Page=NULL
OR Page REGEXP ''ORDER BY Name
14 Init DB imafs_fsdb
14 Query SELECT * FROM prestegious
14 Quit
051123 15:22:17 15 Connect imafs_fsdb@localhost on
15 Init DB imafs_fsdb
15 Quit
/usr/local/libexec/mysqld, Version: 4.0.24-log, started with:
Tcp port: 3306 Unix socket: /tmp/mysql.sock
Time Id Command Argument
051123 15:22:27 1 Connect imafs_fsdb@localhost on
1 Init DB imafs_fsdb
1 Query SELECT * FROM pdb WHERE Page=NULL
OR Page REGEXP ''ORDER BY Name
1 Init DB imafs_fsdb
1 Query SELECT * FROM prestegious
2 Connect imafs_fsdb@localhost on
2 Init DB imafs_fsdb
2 Query SELECT * FROM pdb WHERE Page=NULL
OR Page REGEXP ''ORDER BY Name
2 Init DB imafs_fsdb
2 Query SELECT * FROM prestegious
051123 15:22:28 2 Quit
051123 15:22:29 3 Connect imafs_fsdb@localhost on
3 Init DB imafs_fsdb
3 Query SELECT * FROM pdb WHERE Page=NULL
OR Page REGEXP ''ORDER BY Name
3 Init DB imafs_fsdb
3 Query SELECT * FROM prestegious
051123 15:22:30 3 Quit
051123 15:22:37 4 Connect imafs_fsdb@localhost on
4 Init DB imafs_fsdb
4 Quit
051123 15:22:39 5 Connect imafs_fsdb@localhost on
5 Init DB imafs_fsdb
5 Query SELECT * FROM pdb WHERE
Partnumber='01/00130'
5 Init DB imafs_fsdb
5 Query SELECT * FROM prestegious
051123 15:22:40 5 Query SELECT * FROM pdb WHERE
Partnumber='01/00090'
5 Query SELECT * FROM pdb WHERE
Partnumber='01/00338'
5 Query SELECT * FROM pdb WHERE
Partnumber='01/00012'
5 Query SELECT * FROM pdb WHERE
Partnumber='01/00013'
5 Quit
6 Connect imafs_fsdb@localhost on
6 Init DB imafs_fsdb
6 Query SELECT * FROM pdb WHERE Page=NULL
OR Page REGEXP ''ORDER BY Name
6 Init DB imafs_fsdb
6 Query SELECT * FROM prestegious
6 Quit
051123 15:22:41 7 Connect root@localhost on
7 Quit
8 Connect root@localhost on mysql
8 Query SET AUTOCOMMIT=1
8 Quit
051123 15:22:48 9 Connect imafs_fsdb@localhost on
9 Init DB imafs_fsdb
9 Query SELECT * FROM pdb WHERE Page=NULL
OR Page REGEXP ''ORDER BY Name
9 Init DB imafs_fsdb
9 Query SELECT * FROM prestegious
051123 15:22:49 10 Connect imafs_fsdb@localhost on
10 Init DB imafs_fsdb
10 Quit
9 Quit
11 Connect imafs_fsdb@localhost on
11 Init DB imafs_fsdb
11 Query SELECT * FROM pdb WHERE Page=NULL
OR Page REGEXP ''ORDER BY Name
11 Init DB imafs_fsdb
11 Query SELECT * FROM prestegious
11 Quit
12 Connect imafs_counter@localhost on
12 Init DB imafs_counter
12 Query SELECT count FROM froogles WHERE
partnumber='21/258'
12 Query INSERT INTO froogles SET
partnumber='21/258', count=1
13 Connect imafs_fsdb@localhost on
13 Init DB imafs_fsdb
13 Query SELECT * FROM pdb WHERE
Partnumber='21/258'
12 Quit
13 Quit
051123 15:22:50 14 Connect imafs_fsdb@localhost on
14 Init DB imafs_fsdb
14 Query SELECT * FROM pdb WHERE Page=NULL
OR Page REGEXP ''ORDER BY Name
14 Init DB imafs_fsdb
14 Query SELECT * FROM prestegious
14 Quit
051123 15:22:51 15 Connect imafs_fsdb@localhost on
15 Init DB imafs_fsdb
15 Query SELECT * FROM pdb WHERE Page=NULL
OR Page REGEXP ''ORDER BY Name
15 Init DB imafs_fsdb
15 Query SELECT * FROM prestegious
15 Quit
16 Connect imafs_fsdb@localhost on
16 Init DB imafs_fsdb
16 Quit
17 Connect imafs_fsdb@localhost on
17 Init DB imafs_fsdb
17 Query SELECT * FROM pdb WHERE Page REGEXP
'Lighting: Pre-Packed: Party' ORDER BY Price1 DESC
17 Init DB imafs_fsdb
17 Query SELECT * FROM prestegious
17 Query SELECT * FROM pdb WHERE Partnumber
= '21/ZX20LQ'
17 Query SELECT * FROM pdb WHERE Partnumber
= '21/444A'
17 Query SELECT * FROM pdb WHERE Partnumber
= '12/F650'
17 Query SELECT * FROM pdb WHERE Partnumber
= '21/202B'
17 Query SELECT * FROM pdb WHERE Partnumber
= '21/ZX20LQ'
17 Query SELECT * FROM pdb WHERE Partnumber
= '21/444A'
17 Query SELECT * FROM pdb WHERE Partnumber
= '12/F650'
17 Query SELECT * FROM pdb WHERE Partnumber
= '21/202B'
17 Query SELECT * FROM pdb WHERE Partnumber
= '12/B50'
17 Query SELECT * FROM pdb WHERE Partnumber
= '21/MBK1'
17 Query SELECT * FROM pdb WHERE Partnumber
= '21/F18'
17 Query SELECT * FROM pdb WHERE Partnumber
= '21/444A'
17 Query SELECT * FROM pdb WHERE Partnumber
= '21/ZX5'
17 Query SELECT * FROM pdb WHERE Partnumber
= '12/B50'
17 Query SELECT * FROM pdb WHERE Partnumber
= '21/MBK1'
17 Query SELECT * FROM pdb WHERE Partnumber
= '21/F18'
17 Query SELECT * FROM pdb WHERE Partnumber
= '21/444A'
17 Query SELECT * FROM pdb WHERE Partnumber
= '21/ZX5'
17 Query SELECT * FROM pdb WHERE Partnumber
= '12/F650'
17 Query SELECT * FROM pdb WHERE Partnumber
= '21/204'
17 Query SELECT * FROM pdb WHERE Partnumber
= '21/202B'
17 Query SELECT * FROM pdb WHERE Partnumber
= '21/1000S'
17 Query SELECT * FROM pdb WHERE Partnumber
= '12/F650'
17 Query SELECT * FROM pdb WHERE Partnumber
= '21/204'
17 Query SELECT * FROM pdb WHERE Partnumber
= '21/202B'
17 Query SELECT * FROM pdb WHERE Partnumber
= '21/1000S'
17 Query SELECT * FROM pdb WHERE Partnumber
= '21/MBK1'
17 Query SELECT * FROM pdb WHERE Partnumber
= '21/F18'
17 Query SELECT * FROM pdb WHERE Partnumber
= '21/730'
17 Query SELECT * FROM pdb WHERE Partnumber
= '21/YA145RB'
051123 15:22:52 17 Query SELECT * FROM pdb WHERE Partnumber
= '21/MBK1'
17 Query SELECT * FROM pdb WHERE Partnumber
= '21/F18'
17 Query SELECT * FROM pdb WHERE Partnumber
= '21/730'
17 Query SELECT * FROM pdb WHERE Partnumber
= '21/YA145RB'
17 Quit
18 Connect imafs_fsdb@localhost on
18 Init DB imafs_fsdb
18 Query SELECT * FROM pdb WHERE Page=NULL
OR Page REGEXP ''ORDER BY Name
18 Init DB imafs_fsdb
18 Query SELECT * FROM prestegious
18 Quit
19 Connect imafs_fsdb@localhost on
19 Init DB imafs_fsdb
19 Quit
/usr/local/libexec/mysqld, Version: 4.0.24-log, started with:
Tcp port: 3306 Unix socket: /tmp/mysql.sock
Time Id Command Argument
051123 15:23:01 1 Connect imafs_fsdb@localhost on
1 Init DB imafs_fsdb
1 Query SELECT * FROM pdb WHERE Page REGEXP
'X-Mas: Clothing: Santa Suits' OR Page REGEXP 'X-Mas: Suit:
Upgrade' OR Page REGEXP 'X-Mas: Accessories: Suit Accessories' ORDER BY
Name
1 Init DB imafs_fsdb
1 Query SELECT * FROM prestegious
1 Query SELECT * FROM pdb WHERE
Partnumber='07/00099X'
1 Query SELECT * FROM pdb WHERE
Partnumber='07/00099XX'
1 Query SELECT * FROM pdb WHERE
Partnumber='07/00099X'
1 Query SELECT * FROM pdb WHERE
Partnumber='07/00099XX'
1 Query SELECT * FROM pdb WHERE
Partnumber='07/00088X'
1 Query SELECT * FROM pdb WHERE
Partnumber='07/00088XX'
1 Query SELECT * FROM pdb WHERE
Partnumber='07/00088X'
1 Query SELECT * FROM pdb WHERE
Partnumber='07/00088XX'
1 Query SELECT * FROM pdb WHERE
Partnumber='07/00077X'
1 Query SELECT * FROM pdb WHERE
Partnumber='07/00077X'
051123 15:23:02 1 Quit
2 Connect imafs_fsdb@localhost on
2 Init DB imafs_fsdb
2 Query SELECT * FROM pdb WHERE Page=NULL
OR Page REGEXP ''ORDER BY Name
2 Init DB imafs_fsdb
2 Query SELECT * FROM prestegious
2 Quit
3 Connect imafs_fsdb@localhost on
3 Init DB imafs_fsdb
3 Quit
051123 15:23:06 4 Connect imafs_fsdb@localhost on
4 Init DB imafs_fsdb
4 Query SELECT * FROM pdb WHERE Page=NULL
OR Page REGEXP ''ORDER BY Name
4 Init DB imafs_fsdb
4 Query SELECT * FROM prestegious
5 Connect imafs_fsdb@localhost on
5 Init DB imafs_fsdb
5 Quit
4 Quit
6 Connect imafs_fsdb@localhost on
6 Init DB imafs_fsdb
6 Query SELECT * FROM pdb WHERE Page=NULL
OR Page REGEXP ''ORDER BY Name
6 Init DB imafs_fsdb
6 Query SELECT * FROM prestegious
6 Quit
051123 15:23:12 7 Connect imafs_fsdb@localhost on
7 Init DB imafs_fsdb
7 Query SELECT * FROM pdb WHERE Page REGEXP
'Lighting: DMX Lighting' ORDER BY Name
7 Init DB imafs_fsdb
7 Query SELECT * FROM prestegious
7 Query SELECT * FROM pdb WHERE
Partnumber='21/ELC3'
7 Query SELECT * FROM pdb WHERE
Partnumber='21/USELC3'
7 Query SELECT * FROM pdb WHERE
Partnumber='21/ELC3'
7 Query SELECT * FROM pdb WHERE
Partnumber='21/USELC3'
7 Query SELECT * FROM pdb WHERE
Partnumber='21/ELC3'
7 Query SELECT * FROM pdb WHERE
Partnumber='21/USELC3'
7 Query SELECT * FROM pdb WHERE
Partnumber='21/ELC3'
7 Query SELECT * FROM pdb WHERE
Partnumber='21/USELC3'
7 Query SELECT * FROM pdb WHERE
Partnumber='21/64514'
7 Query SELECT * FROM pdb WHERE
Partnumber='21/US64514'
7 Query SELECT * FROM pdb WHERE
Partnumber='21/64516'
7 Query SELECT * FROM pdb WHERE
Partnumber='21/ELC3'
7 Query SELECT * FROM pdb WHERE
Partnumber='21/USELC3'
7 Query SELECT * FROM pdb WHERE
Partnumber='21/EFR5'
7 Query SELECT * FROM pdb WHERE
Partnumber='21/USEFR5'
7 Query SELECT * FROM pdb WHERE
Partnumber='21/ELC3'
7 Query SELECT * FROM pdb WHERE
Partnumber='21/USELC3'
7 Quit
8 Connect imafs_fsdb@localhost on
8 Init DB imafs_fsdb
8 Query SELECT * FROM pdb WHERE Page=NULL
OR Page REGEXP ''ORDER BY Name
8 Init DB imafs_fsdb
8 Query SELECT * FROM prestegious
9 Connect imafs_fsdb@localhost on
9 Init DB imafs_fsdb
9 Quit
051123 15:23:13 8 Quit
051123 15:23:19 10 Connect imafs_fsdb@localhost on
10 Init DB imafs_fsdb
10 Query SELECT * FROM pdb WHERE Page=NULL
OR Page REGEXP ''ORDER BY Name
10 Init DB imafs_fsdb
10 Query SELECT * FROM prestegious
051123 15:23:20 10 Quit
11 Connect imafs_fsdb@localhost on
11 Init DB imafs_fsdb
11 Query SELECT * FROM pdb WHERE Page=NULL
OR Page REGEXP ''ORDER BY Name
11 Init DB imafs_fsdb
11 Query SELECT * FROM prestegious
12 Connect imafs_fsdb@localhost on
12 Init DB imafs_fsdb
12 Quit
11 Quit
051123 15:23:28 13 Connect imafs_fsdb@localhost on
13 Init DB imafs_fsdb
13 Query SELECT * FROM pdb WHERE Page REGEXP
'Lighting: Effect Lighting' ORDER BY Name
13 Init DB imafs_fsdb
13 Query SELECT * FROM prestegious
13 Query SELECT * FROM pdb WHERE
Partnumber='21/ELC3'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/USELC3'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/ELC3'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/USELC3'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/CHR30BL'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/CHR30R'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/CHR30G'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/CHR30Y'
14 Connect imafs_fsdb@localhost on
14 Init DB imafs_fsdb
14 Query SELECT * FROM pdb WHERE Page=NULL
OR Page REGEXP ''ORDER BY Name
14 Init DB imafs_fsdb
14 Query SELECT * FROM prestegious
13 Query SELECT * FROM pdb WHERE
Partnumber='21/CBFS'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/CBFS'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/EFR5'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/USEFR5'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/CONEF2'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/64514'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/US64514'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/64516'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/64514'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/US64514'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/64516'
15 Connect imafs_fsdb@localhost on
15 Init DB imafs_fsdb
15 Quit
13 Query SELECT * FROM pdb WHERE
Partnumber='21/64514'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/US64514'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/64516'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/BRL'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/BRL'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/EHJ'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/ELC3'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/USELC3'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/EHM'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/EHM2'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/J120V100W'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/J230V100W'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/BRL'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/64514'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/US64514'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/64516'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/64514'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/US64514'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/64516'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/ELC3'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/USELC3'
14 Quit
13 Query SELECT * FROM pdb WHERE
Partnumber='21/EFP5'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/64514'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/US64514'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/64516'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/EFP5'
051123 15:23:29 13 Query SELECT * FROM pdb WHERE
Partnumber='21/ELC3'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/USELC3'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/64514'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/US64514'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/64516'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/EFP5'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/FCR'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/FCR'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/EFR5'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/USEFR5'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/EFR5'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/USEFR5'
13 Query SELECT * FROM pdb WHERE
Partnumber='21/FCR'
13 Quit
16 Connect imafs_fsdb@localhost on
16 Init DB imafs_fsdb
16 Query SELECT * FROM pdb WHERE Page=NULL
OR Page REGEXP ''ORDER BY Name
16 Init DB imafs_fsdb
16 Query SELECT * FROM prestegious
17 Connect imafs_fsdb@localhost on
17 Init DB imafs_fsdb
17 Query SELECT * FROM pdb WHERE Page=NULL
OR Page REGEXP ''ORDER BY Name
17 Init DB imafs_fsdb
17 Query SELECT * FROM prestegious
17 Quit
051123 15:23:30 16 Quit
18 Connect imafs_fsdb@localhost on
18 Init DB imafs_fsdb
18 Quit
/usr/local/libexec/mysqld, Version: 4.0.24-log, started with:
Tcp port: 3306 Unix socket: /tmp/mysql.sock
Time Id Command Argument
051123 15:23:33 1 Connect imafs_fsdb@localhost on
1 Init DB imafs_fsdb
1 Query SELECT * FROM prestegious
051123 15:23:34 2 Connect imafs_fsdb@localhost on
2 Init DB imafs_fsdb
2 Query SELECT * FROM pdb WHERE Page=NULL
OR Page REGEXP ''ORDER BY Name
2 Init DB imafs_fsdb
2 Query SELECT * FROM prestegious
1 Quit
051123 15:23:35 3 Connect imafs_fsdb@localhost on
3 Init DB imafs_fsdb
3 Query SELECT * FROM prestegious
3 Quit
051123 15:23:37 2 Quit
051123 15:23:40 4 Connect imafs_fsdb@localhost on
4 Init DB imafs_fsdb
4 Quit
5 Connect imafs_fsdb@localhost on
5 Init DB imafs_fsdb
5 Quit
051123 15:23:46 6 Connect imafs_fsdb@localhost on
6 Init DB imafs_fsdb
6 Query SELECT * FROM pdb WHERE Page=NULL
OR Page REGEXP ''ORDER BY Name
6 Init DB imafs_fsdb
6 Query SELECT * FROM prestegious
051123 15:23:48 7 Connect imafs_fsdb@localhost on
7 Init DB imafs_fsdb
7 Query SELECT * FROM pdb WHERE Page=NULL
OR Page REGEXP ''ORDER BY Name
7 Init DB imafs_fsdb
7 Query SELECT * FROM prestegious
7 Quit
051123 15:23:49 8 Connect imafs_fsdb@localhost on
8 Init DB imafs_fsdb
8 Query SELECT * FROM pdb WHERE Page=NULL
OR Page REGEXP ''ORDER BY Name
8 Init DB imafs_fsdb
8 Query SELECT * FROM prestegious
9 Connect imafs_fsdb@localhost on
9 Init DB imafs_fsdb
9 Quit
051123 15:23:50 8 Quit
051123 15:23:55 10 Connect imafs_fsdb@localhost on
10 Init DB imafs_fsdb
10 Quit
/usr/local/libexec/mysqld, Version: 4.0.24-log, started with:
Tcp port: 3600 Unix socket: /tmp/mysql.sock
I've done an "analyze table" and "checktable" on all databases and all
tables with no apparent errors.

Is there some configuration error that I've made here?... or any
suggestions on the next path to follow?

Any help would be greatly appreciated.

Jerry Stretch
js******@industryinet.com

Nov 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
>I'm pretty much a newbie on mysql, and I need some help.

I am running mysql Ver 12.22 Distrib 4.0.24, for portbld-freebsd5.4
(i386) on a server hosting an active website.

The site's developer uses his own php shopping cart to receive customer
orders.

The configuration was done via cPanel with no external modifications -
which produced no protests when built, ran and connected with no
problem.


If you can, look at /var/log/messages on the server. Is mysqld
aborting (e.g. segfaulting)? Some versions do that. It might or
might not have to do with corrupt tables, or it might be just some
query that tickles a bug. And it's possible the query causing the
problem doesn't get logged because it never finishes. In any case,
it's quitting for some reason, and unless there's a "mysqladmin
shutdown" in your log somewhere that I'm missing, that's not good.

I note that the last query before the connection numbers recycle
is in each case "select * from prestegious", although that query
seems to have completed. Whether or not that has anything to do
with anything, I'm not sure.

Can you upgrade to a newer version? That one's pretty old.

Gordon L. Burditt

Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.