itdevil
Tue 18th Sep '07, 6:14am
I have just moved to a new server, and I am daily receiving the fallowing error from my board
MySQL Error : Got error 28 from storage engine Error Number : 1030I am using only 25~GB of /home directory, and rest of all partition are used minimum, can any one help me sort it out.
/dev/mapper/VolGroup00-LogVol00
143G 25G 111G 19% /
/dev/hda1 99M 16M 79M 17% /boot
tmpfs 1014M 0 1014M 0% /dev/shm
/usr/tmpDSK 485M 15M 445M 4% /tmpthe server
CPU1: Intel(R) Xeon 2.80GHz
CPU2: Intel(R) Xeon 2.80GHz
2 GB DDR ECC RAM
160 GB HDD (WD1600BB-98DWA0, ATA DISK drive)
CentOS 5
cPanel/WHM 11
Apache 1.3.39
PHP 4.4.7
mySQL 4.1.22
vB 3.6.4
Apache httpd.conf
KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeout 1
MinSpareServers 10
MaxSpareServers 25
StartServers 15
MaxClients 512
Maxrequestsperchild 64uname
Linux s1.xxxxxxxx.com 2.6.18-8.1.8.el5 #1 SMP Tue Jul 10 06:50:22 EDT 2007 i686 i686 i386 GNU/Linux
ulimit -aH
core file size (blocks, -c) 1000000
data seg size (kbytes, -d) unlimited
max nice (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 32767
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 4096
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
max rt priority (-r) 0
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) 14335
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimitedcat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 2
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 9
cpu MHz : 2799.463
cache size : 512 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 1
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 2
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe cid xtpr
bogomips : 5600.42
processor : 1
vendor_id : GenuineIntel
cpu family : 15
model : 2
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 9
cpu MHz : 2799.463
cache size : 512 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 1
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 2
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe cid xtpr
bogomips : 5597.58
processor : 2
vendor_id : GenuineIntel
cpu family : 15
model : 2
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 9
cpu MHz : 2799.463
cache size : 512 KB
physical id : 3
siblings : 2
core id : 0
cpu cores : 1
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 2
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe cid xtpr
bogomips : 5597.73
processor : 3
vendor_id : GenuineIntel
cpu family : 15
model : 2
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 9
cpu MHz : 2799.463
cache size : 512 KB
physical id : 3
siblings : 2
core id : 0
cpu cores : 1
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 2
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe cid xtpr
bogomips : 5597.58my.cnf
[mysqld]
datadir=/var/lib/mysql
skip-locking
skip-innodb
safe-show-database
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
max_user_connections=500
max_connections=1200
interactive_timeout=10
wait_timeout=20
connect_timeout=20
thread_cache_size=128
key_buffer=128M
join_buffer=1M
max_connect_errors=20
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=1M
read_buffer_size=1M
read_rnd_buffer_size=1M
thread_concurrency=8
myisam_sort_buffer_size=64M
server-id=1
collation-server=latin1_general_ci
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192
[mysqldump]
quick
max_allowed_packet=16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[mysqlhotcopy]
interactive-timeout
mysqlreport
MySQL 4.1.22-standard uptime 0 13:6:36 Tue Sep 18 01:58:39 2007
__ Key __________________________________________________ _______________
Buffer used 21.58M of 128.00M %Used: 16.86
Current 35.82M %Usage: 27.98
Write hit 30.11%
Read hit 99.46%
__ Questions __________________________________________________ _________
Total 657.74k 13.9/s
DMS 324.06k 6.9/s %Total: 49.27
QC Hits 205.54k 4.4/s 31.25
Com_ 65.60k 1.4/s 9.97
COM_QUIT 62.63k 1.3/s 9.52
-Unknown 98 0.0/s 0.01
Slow 168 0.0/s 0.03 %DMS: 0.05
DMS 324.06k 6.9/s 49.27
SELECT 228.69k 4.8/s 34.77 70.57
UPDATE 50.10k 1.1/s 7.62 15.46
INSERT 23.27k 0.5/s 3.54 7.18
REPLACE 15.56k 0.3/s 2.37 4.80
DELETE 6.44k 0.1/s 0.98 1.99
Com_ 65.60k 1.4/s 9.97
change_db 63.63k 1.3/s 9.67
set_option 968 0.0/s 0.15
lock_tables 370 0.0/s 0.06
__ SELECT and Sort __________________________________________________ ___
Scan 41.61k 0.9/s %SELECT: 18.20
Range 58.72k 1.2/s 25.67
Full join 233 0.0/s 0.10
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 17.69k 0.4/s
Sort range 25.93k 0.5/s
Sort mrg pass 1 0.0/s
__ Query Cache __________________________________________________ _______
Memory usage 30.19M of 32.00M %Used: 94.35
Block Fragmnt 12.34%
Hits 205.54k 4.4/s
Inserts 221.52k 4.7/s
Insrt:Prune 3.65:1 3.4/s
Hit:Insert 0.93:1
__ Table Locks __________________________________________________ _______
Waited 128 0.0/s %Total: 0.02
Immediate 533.88k 11.3/s
__ Tables __________________________________________________ ____________
Open 1024 of 1024 %Cache: 100.00
Opened 6.85k 0.1/s
__ Connections __________________________________________________ _______
Max used 21 of 1200 %Max: 1.75
Total 62.68k 1.3/s
__ Created Temp __________________________________________________ ______
Disk table 3.12k 0.1/s
Table 13.20k 0.3/s
File 2 0.0/s
__ Threads __________________________________________________ ___________
Running 1 of 1
Cached 20 of 128 %Hit: 99.97
Created 21 0.0/s
Slow 0 0/s
__ Aborted __________________________________________________ ___________
Clients 97 0.0/s
Connects 2 0.0/s
__ Bytes __________________________________________________ _____________
Sent 4.09G 86.6k/s
Received 186.46M 4.0k/s
Thank You very much.
MySQL Error : Got error 28 from storage engine Error Number : 1030I am using only 25~GB of /home directory, and rest of all partition are used minimum, can any one help me sort it out.
/dev/mapper/VolGroup00-LogVol00
143G 25G 111G 19% /
/dev/hda1 99M 16M 79M 17% /boot
tmpfs 1014M 0 1014M 0% /dev/shm
/usr/tmpDSK 485M 15M 445M 4% /tmpthe server
CPU1: Intel(R) Xeon 2.80GHz
CPU2: Intel(R) Xeon 2.80GHz
2 GB DDR ECC RAM
160 GB HDD (WD1600BB-98DWA0, ATA DISK drive)
CentOS 5
cPanel/WHM 11
Apache 1.3.39
PHP 4.4.7
mySQL 4.1.22
vB 3.6.4
Apache httpd.conf
KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeout 1
MinSpareServers 10
MaxSpareServers 25
StartServers 15
MaxClients 512
Maxrequestsperchild 64uname
Linux s1.xxxxxxxx.com 2.6.18-8.1.8.el5 #1 SMP Tue Jul 10 06:50:22 EDT 2007 i686 i686 i386 GNU/Linux
ulimit -aH
core file size (blocks, -c) 1000000
data seg size (kbytes, -d) unlimited
max nice (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 32767
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 4096
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
max rt priority (-r) 0
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) 14335
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimitedcat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 2
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 9
cpu MHz : 2799.463
cache size : 512 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 1
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 2
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe cid xtpr
bogomips : 5600.42
processor : 1
vendor_id : GenuineIntel
cpu family : 15
model : 2
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 9
cpu MHz : 2799.463
cache size : 512 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 1
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 2
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe cid xtpr
bogomips : 5597.58
processor : 2
vendor_id : GenuineIntel
cpu family : 15
model : 2
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 9
cpu MHz : 2799.463
cache size : 512 KB
physical id : 3
siblings : 2
core id : 0
cpu cores : 1
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 2
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe cid xtpr
bogomips : 5597.73
processor : 3
vendor_id : GenuineIntel
cpu family : 15
model : 2
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 9
cpu MHz : 2799.463
cache size : 512 KB
physical id : 3
siblings : 2
core id : 0
cpu cores : 1
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 2
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe cid xtpr
bogomips : 5597.58my.cnf
[mysqld]
datadir=/var/lib/mysql
skip-locking
skip-innodb
safe-show-database
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
max_user_connections=500
max_connections=1200
interactive_timeout=10
wait_timeout=20
connect_timeout=20
thread_cache_size=128
key_buffer=128M
join_buffer=1M
max_connect_errors=20
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=1M
read_buffer_size=1M
read_rnd_buffer_size=1M
thread_concurrency=8
myisam_sort_buffer_size=64M
server-id=1
collation-server=latin1_general_ci
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192
[mysqldump]
quick
max_allowed_packet=16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[mysqlhotcopy]
interactive-timeout
mysqlreport
MySQL 4.1.22-standard uptime 0 13:6:36 Tue Sep 18 01:58:39 2007
__ Key __________________________________________________ _______________
Buffer used 21.58M of 128.00M %Used: 16.86
Current 35.82M %Usage: 27.98
Write hit 30.11%
Read hit 99.46%
__ Questions __________________________________________________ _________
Total 657.74k 13.9/s
DMS 324.06k 6.9/s %Total: 49.27
QC Hits 205.54k 4.4/s 31.25
Com_ 65.60k 1.4/s 9.97
COM_QUIT 62.63k 1.3/s 9.52
-Unknown 98 0.0/s 0.01
Slow 168 0.0/s 0.03 %DMS: 0.05
DMS 324.06k 6.9/s 49.27
SELECT 228.69k 4.8/s 34.77 70.57
UPDATE 50.10k 1.1/s 7.62 15.46
INSERT 23.27k 0.5/s 3.54 7.18
REPLACE 15.56k 0.3/s 2.37 4.80
DELETE 6.44k 0.1/s 0.98 1.99
Com_ 65.60k 1.4/s 9.97
change_db 63.63k 1.3/s 9.67
set_option 968 0.0/s 0.15
lock_tables 370 0.0/s 0.06
__ SELECT and Sort __________________________________________________ ___
Scan 41.61k 0.9/s %SELECT: 18.20
Range 58.72k 1.2/s 25.67
Full join 233 0.0/s 0.10
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 17.69k 0.4/s
Sort range 25.93k 0.5/s
Sort mrg pass 1 0.0/s
__ Query Cache __________________________________________________ _______
Memory usage 30.19M of 32.00M %Used: 94.35
Block Fragmnt 12.34%
Hits 205.54k 4.4/s
Inserts 221.52k 4.7/s
Insrt:Prune 3.65:1 3.4/s
Hit:Insert 0.93:1
__ Table Locks __________________________________________________ _______
Waited 128 0.0/s %Total: 0.02
Immediate 533.88k 11.3/s
__ Tables __________________________________________________ ____________
Open 1024 of 1024 %Cache: 100.00
Opened 6.85k 0.1/s
__ Connections __________________________________________________ _______
Max used 21 of 1200 %Max: 1.75
Total 62.68k 1.3/s
__ Created Temp __________________________________________________ ______
Disk table 3.12k 0.1/s
Table 13.20k 0.3/s
File 2 0.0/s
__ Threads __________________________________________________ ___________
Running 1 of 1
Cached 20 of 128 %Hit: 99.97
Created 21 0.0/s
Slow 0 0/s
__ Aborted __________________________________________________ ___________
Clients 97 0.0/s
Connects 2 0.0/s
__ Bytes __________________________________________________ _____________
Sent 4.09G 86.6k/s
Received 186.46M 4.0k/s
Thank You very much.