473,287 Members | 1,978 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,287 software developers and data experts.

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_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
1 3343
>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
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...
4
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...
2
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...
1
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...
1
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:...
0
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...
8
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...
74
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...
3
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...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

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.