473,703 Members | 4,345 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

mysql in a startup/shutdown loop at 30 sec intervals

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
js******@indust ryinet.com

Nov 23 '05 #1
1 3376
>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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
6967
by: Lynn | last post by:
I'm running Oracle 8.1.7.4.1 on W2K and have the services for my oracle instances set to automatically startup and shutdown with the W2K server. Unfortunately, neither is working. Nothing gets logged in my alert file for the shutdown or startup, however, the databases are down and when I manually start them up, the alert log reveals a crash recovery. I've verified the settings in the registry for automatic shutdown and startup. I've...
4
867
by: Ka | last post by:
I install a mysql server in default installation with latin charset, but I want to use GBK(a chinese charset), so that I can store and search chinese words directly. so, I download, unpack and then rewrite the mysql.spec and then recompile the package mysql-3.23.56-1.80.src.rpm. first, this file contains some files: # rpm2cpio mysql-3.23.56-1.80.src.rpm |cpio -t
2
1735
by: Lazy Hill Wineries | last post by:
For some reason I cannot get my MySQL server to start. It has been running fine until Friday, when we has a strange issue with the Solaris server which it is running on. The server had a few files get their chmod setting messed up and now after fixing that, MySQL won't start. Exerpt from neuro18.err: 040830 15:55:19 mysqld started 040830 15:55:19 Can't start server : UNIX Socket : Permission denied
1
121532
by: jiing | last post by:
Now let me describe what I have done and my purpose: Originally, I want to user ports to install phpBB But I found that phpBB doesn't support mysql 5.x (but the ports installed mySQL 5.0.0 alpha) so I deinstall mysql5-server and mysql5-client And then I install mysql41-server and mysql41-client on FreeBSD 5.3 by ports but now , mysql is not workable
1
2191
by: adiavr | last post by:
Hi, I have read up on MySQL failover/replication and decided that weren't many cons to setting up two way replication where two servers are both master and slave to eachother. Here's the my.cnf: log-bin log-slave-updates server-id=2 master-host=10.0.0.2 master-user=repl
0
1094
by: Andy | last post by:
I hv just kill the mysql server process ( by killing the process ID ) , not normally shutdown the mysql server ( mysql stop ) , now the mysql can't start , I also can't find any process related to mysql , except reboot the server , can suggest how to start the server again ? thx
8
5969
by: sundeep.kumara | last post by:
hi all, I am a newbie .....I have compiled the source code of mysql-4.1.9 on PPC-Linux Its not giving any errors during configure,make or make install. But,when i try to start the server using mysqld_safe...its throwing error like this..
74
8020
by: John Wells | last post by:
Yes, I know you've seen the above subject before, so please be gentle with the flamethrowers. I'm preparing to enter a discussion with management at my company regarding going forward as either a MySql shop or a Postgresql shop. It's my opinion that we should be using PG, because of the full ACID support, and the license involved. A consultant my company hired before bringing me in is pushing hard for MySql, citing speed and community...
3
1599
by: tbone | last post by:
In trying to improve the throughput of a classic ASP app I wrote a few years ago, I added monitoring to the application and session start and end methods. I'm counting the total number of sessions and the high water mark. The results are puzzling to me. In Application_OnStart, I clear the current and highwater session counts, and write an app startup event to my app log file (a text file). In Application_OnEnd, I write an app shutdown...
0
8760
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8670
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9254
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9122
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
7872
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
4433
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4687
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3125
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2458
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.