mysql in a startup/shutdown loop at 30 sec intervals

This topic is closed.

jlee
#1

mysql in a startup/shutdown loop at 30 sec intervals

Nov 23 '05, 10:35 PM

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_si ze | 32768

|
| bulk_insert_buf fer_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_inse rt | ON

|
| connect_timeout | 5

|
| convert_charact er_set |

|
| datadir | /var/db/mysql/

|
| default_week_fo rmat | 0

|
| delay_key_write | ON

|
| delayed_insert_ limit | 100

|
| delayed_insert_ timeout | 300

|
| delayed_queue_s ize | 1000

|
| flush | OFF

|
| flush_time | 0

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

|
| ft_min_word_len | 4

|
| ft_max_word_len | 254

|
| ft_max_word_len _for_sort | 20

|
| ft_stopword_fil e | (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_cach e | YES

|
| init_file |

|
| innodb_addition al_mem_pool_siz e | 1048576

|
| innodb_autoexte nd_increment | 8

|
| innodb_buffer_p ool_size | 8388608

|
| innodb_data_fil e_path | ibdata1:10M:aut oextend

|
| innodb_data_hom e_dir |

|
| innodb_file_io_ threads | 4

|
| innodb_force_re covery | 0

|
| innodb_thread_c oncurrency | 8

|
| innodb_flush_lo g_at_trx_commit | 1

|
| innodb_fast_shu tdown | ON

|
| innodb_flush_me thod |

|
| innodb_lock_wai t_timeout | 50

|
| innodb_log_arch _dir | ./

|
| innodb_log_arch ive | OFF

|
| innodb_log_buff er_size | 1048576

|
| innodb_log_file _size | 5242880

|
| innodb_log_file s_in_group | 2

|
| innodb_log_grou p_home_dir | ./

|
| innodb_mirrored _log_groups | 1

|
| innodb_max_dirt y_pages_pct | 90

|
| innodb_max_purg e_lag | 0

|
| innodb_table_lo cks | ON

|
| interactive_tim eout | 28800

|
| join_buffer_siz e | 131072

|
| key_buffer_size | 8388600

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

|
| large_files_sup port | ON

|
| license | GPL

|
| local_infile | ON

|
| locked_in_memor y | OFF

|
| log | OFF

|
| log_update | OFF

|
| log_bin | OFF

|
| log_slave_updat es | OFF

|
| log_slow_querie s | OFF

|
| log_warnings | 1

|
| long_query_time | 10

|
| low_priority_up dates | OFF

|
| lower_case_file _system | OFF

|
| lower_case_tabl e_names | 0

|
| max_allowed_pac ket | 1048576

|
| max_binlog_cach e_size | 4294967295

|
| max_binlog_size | 1073741824

|
| max_connections | 1000

|
| max_connect_err ors | 10

|
| max_delayed_thr eads | 20

|
| max_insert_dela yed_threads | 20

|
| max_heap_table_ size | 16777216

|
| max_join_size | 4294967295

|
| max_relay_log_s ize | 0

|
| max_seeks_for_k ey | 4294967295

|
| max_sort_length | 1024

|
| max_user_connec tions | 0

|
| max_tmp_tables | 32

|
| max_write_lock_ count | 4294967295

|
| myisam_max_extr a_sort_file_siz e | 268435456

|
| myisam_max_sort _file_size | 2147483647

|
| myisam_repair_t hreads | 1

|
| myisam_recover_ options | OFF

|
| myisam_sort_buf fer_size | 8388608

|
| net_buffer_leng th | 16384

|
| net_read_timeou t | 30

|
| net_retry_count | 1000000

|
| net_write_timeo ut | 60

|
| new | OFF

|
| open_files_limi t | 11095

|
| pid_file |
/var/db/mysql/virtual5.indust ryinet.com.pid

|
| log_error |

|
| port | 3306

|
| protocol_versio n | 10

|
| query_alloc_blo ck_size | 8192

|
| query_cache_lim it | 1048576

|
| query_cache_siz e | 0

|
| query_cache_typ e | ON

|
| query_cache_wlo ck_invalidate | OFF

|
| query_prealloc_ size | 8192

|
| range_alloc_blo ck_size | 2048

|
| read_buffer_siz e | 131072

|
| read_only | OFF

|
| read_rnd_buffer _size | 262144

|
| rpl_recovery_ra nk | 0

|
| server_id | 0

|
| slave_net_timeo ut | 3600

|
| skip_external_l ocking | ON

|
| skip_networking | OFF

|
| skip_show_datab ase | OFF

|
| slow_launch_tim e | 2

|
| socket | /tmp/mysql.sock

|
| sort_buffer_siz e | 2097144

|
| sql_mode | 0

|
| table_cache | 64

|
| table_type | MYISAM

|
| thread_cache_si ze | 0

|
| thread_stack | 196608

|
| tx_isolation | REPEATABLE-READ

|
| timezone | CST

|
| tmp_table_size | 33554432

|
| tmpdir | /var/tmp/

|
| transaction_all oc_block_size | 8192

|
| transaction_pre alloc_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:aut oextend
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:aut oextend ibdata1:10M:aut oextend
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.indust ryinet.com.pid
/var/db/mysql/virtual5.indust ryinet.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@loca lhost 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@loca lhost 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@loca lhost 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@loca lhost 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@loca lhost 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@loca lhost on
4 Init DB imafs_fsdb
4 Quit
051123 15:22:39 5 Connect imafs_fsdb@loca lhost 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@loca lhost 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@loca lhost 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@loca lhost on
10 Init DB imafs_fsdb
10 Quit
9 Quit
11 Connect imafs_fsdb@loca lhost 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@l ocalhost 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@loca lhost 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@loca lhost 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@loca lhost 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@loca lhost on
16 Init DB imafs_fsdb
16 Quit
17 Connect imafs_fsdb@loca lhost 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@loca lhost 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@loca lhost 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@loca lhost 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@loca lhost 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@loca lhost on
3 Init DB imafs_fsdb
3 Quit
051123 15:23:06 4 Connect imafs_fsdb@loca lhost 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@loca lhost on
5 Init DB imafs_fsdb
5 Quit
4 Quit
6 Connect imafs_fsdb@loca lhost 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@loca lhost 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@loca lhost 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@loca lhost on
9 Init DB imafs_fsdb
9 Quit
051123 15:23:13 8 Quit
051123 15:23:19 10 Connect imafs_fsdb@loca lhost 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@loca lhost 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@loca lhost on
12 Init DB imafs_fsdb
12 Quit
11 Quit
051123 15:23:28 13 Connect imafs_fsdb@loca lhost 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@loca lhost 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@loca lhost 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@loca lhost 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@loca lhost 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@loca lhost 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@loca lhost on
1 Init DB imafs_fsdb
1 Query SELECT * FROM prestegious
051123 15:23:34 2 Connect imafs_fsdb@loca lhost 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@loca lhost 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@loca lhost on
4 Init DB imafs_fsdb
4 Quit
5 Connect imafs_fsdb@loca lhost on
5 Init DB imafs_fsdb
5 Quit
051123 15:23:46 6 Connect imafs_fsdb@loca lhost 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@loca lhost 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@loca lhost 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@loca lhost on
9 Init DB imafs_fsdb
9 Quit
051123 15:23:50 8 Quit
051123 15:23:55 10 Connect imafs_fsdb@loca lhost 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
jstretch@indust ryinet.com
Tags: None
Gordon Burditt
#2

Nov 23 '05, 11:05 PM

Re: mysql in a startup/shutdown loop at 30 sec intervals

>I'm pretty much a newbie on mysql, and I need some help.[color=blue]
>
>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.[/color]

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
Comment

Previous template Next

mysql in a startup/shutdown loop at 30 sec intervals

mysql in a startup/shutdown loop at 30 sec intervals

Comment