Page faults are the number of times that a process has to be loaded into memory??
mysqld-nt.exe has a huge number (or what I think is huge) - 12,000,000 in about 20 hours of uptime.
Is this affecting my performance? How can I fix this?
Thanks
Full Version: Page Faults
you can try tuning up mysql config... enabling query caching (on mysql4) and so on...
however i dunno if 12,000,000 is a "standard" value or if it's excessive... the only sure thing is that lower that number will be, better performance you will get
however i dunno if 12,000,000 is a "standard" value or if it's excessive... the only sure thing is that lower that number will be, better performance you will get
Here is my config file. Any suggestions?
HTML
#This File was made from template file created by PLESK installator program
#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions
[mysqld]
# change this to the actual path to mysql root
basedir=C:/Program Files/SWsoft/Plesk/MySql
# change this to actual path to the data dir
datadir=C:/Program Files/SWsoft/Plesk/MySql/data
[mysqld]
skip-innodb
max_connections = 650
key_buffer = 16M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1024
thread_cache_size = 64
wait_timeout = 10800
connect_timeout = 10
tmp_table_size = 32M
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
query_prealloc_size = 16384
query_alloc_block_size = 16384
[mysqld_safe]
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
[WinMySQLadmin]
Server=C:/Program Files/SWsoft/Plesk/MySql/bin/mysqld-nt.exe
#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions
[mysqld]
# change this to the actual path to mysql root
basedir=C:/Program Files/SWsoft/Plesk/MySql
# change this to actual path to the data dir
datadir=C:/Program Files/SWsoft/Plesk/MySql/data
[mysqld]
skip-innodb
max_connections = 650
key_buffer = 16M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1024
thread_cache_size = 64
wait_timeout = 10800
connect_timeout = 10
tmp_table_size = 32M
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
query_prealloc_size = 16384
query_alloc_block_size = 16384
[mysqld_safe]
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
[WinMySQLadmin]
Server=C:/Program Files/SWsoft/Plesk/MySql/bin/mysqld-nt.exe
Anyone else help??
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.