after opening a Support ticket I was told to make an new thread here. I changed recently (again) server and went from MySql 4.x to 5.0.27-standard but after a while I saw that some tables keep on crashing, such as "threadviews" and "posts" and "posthash".
so I post my specs here, maybe you can see any mistake?
the forum runs very well, even with 2500 users online the server flys, but there is this mentioned issue with the database.
1. dedicated server
2. Dual Intel Xeon 5160, 8 GB Ram, 250 GB HDD SATA RAID1, SuSe 10.1 64 Bit, PHP 5.1.2, MySql 5.0.27-standard + xcache installed
3. vB 3.5.5
4. no innobs
5. by binary files ( I was at 5.0.18 installed with yast and just loaded the binarys to 5.0.27)
6. Top:
top - 10:45:57 up 19:35, 1 user, load average: 0.82, 0.58, 0.25
Tasks: 211 total, 1 running, 209 sleeping, 0 stopped, 1 zombie
Cpu(s): 15.6% us, 1.5% sy, 0.0% ni, 81.1% id, 1.6% wa, 0.0% hi, 0.2% si
Mem: 8179404k total, 5370892k used, 2808512k free, 77700k buffers
Swap: 2104472k total, 104k used, 2104368k free, 4111296k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
14591 wwwrun 15 0 245m 24m 10m S 34 0.3 0:02.46 httpd2-prefork
15126 wwwrun 15 0 243m 22m 8260 S 16 0.3 0:00.12 httpd2-prefork
15097 wwwrun 16 0 244m 21m 8756 S 6 0.3 0:00.46 httpd2-prefork
14711 wwwrun 17 0 244m 23m 10m S 4 0.3 0:02.72 httpd2-prefork
14949 mysql 16 0 288m 183m 3012 S 4 2.3 0:00.87 mysqld
15107 mysql 16 0 288m 183m 3012 S 4 2.3 0:00.14 mysqld
14533 wwwrun 16 0 0 0 0 Z 2 0.0 0:02.35 httpd2-pr
14602 wwwrun 15 0 245m 25m 10m S 2 0.3 0:02.57 httpd2-prefork
15067 mysql 16 0 288m 183m 3012 S 2 2.3 0:00.11 mysqld
1 root 16 0 780 300 252 S 0 0.0 0:01.40 init
2 root RT 0 0 0 0 S 0 0.0 0:00.24 migration/0
3 root 34 19 0 0 0 S 0 0.0 0:00.06 ksoftirqd/0
4 root RT 0 0 0 0 S 0 0.0 0:00.04 migration/1
5 root 34 19 0 0 0 S 0 0.0 0:00.01 ksoftirqd/1
6 root RT 0 0 0 0 S 0 0.0 0:00.04 migration/2
7 root 34 19 0 0 0 S 0 0.0 0:00.04 ksoftirqd/2
8 root RT 0 0 0 0 S 0 0.0 0:00.08 migration/3
7. MySql variables:
# The MySQL server
[mysqld]
set-variable=local-infile=0
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
max_connections = 750
max_allowed_packet = 32M
key_buffer_size = 160M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
sort_buffer_size = 2M
read_buffer_size = 1M
read_rnd_buffer_size = 512K
net_buffer_length = 8K
query_cache_limit = 6M
query_cache_size = 96M
query_cache_type = 1
thread_stack = 128K
thread_concurrency = 2
thread_cache = 8
table_cache = 1200
connect_timeout = 10
long_query_time = 8
8. MySql Stats:
+---------------------------------+------------------------------------------+
Variable_name Value
+---------------------------------+------------------------------------------+
auto_increment_increment 1
auto_increment_offset 1
automatic_sp_privileges ON
back_log 50
basedir /usr/
binlog_cache_size 32768
bulk_insert_buffer_size 8388608
character_set_client latin1
character_set_connection latin1
character_set_database latin1
character_set_filesystem binary
character_set_results latin1
character_set_server latin1
character_set_system utf8
character_sets_dir /usr/share/mysql/charsets/
collation_connection latin1_swedish_ci
collation_database latin1_swedish_ci
collation_server latin1_swedish_ci
completion_type 0
concurrent_insert 1
connect_timeout 10
datadir /var/lib/mysql/
date_format %Y-%m-%d
datetime_format %Y-%m-%d %H:%i:%s
default_week_format 0
delay_key_write ON
delayed_insert_limit 100
delayed_insert_timeout 300
delayed_queue_size 1000
div_precision_increment 4
engine_condition_pushdown OFF
expire_logs_days 0
flush OFF
flush_time 0
ft_boolean_syntax + -><()~*:""&
ft_max_word_len 84
ft_min_word_len 4
ft_query_expansion_limit 20
ft_stopword_file (built-in)
group_concat_max_len 1024
have_archive YES
have_bdb NO
have_blackhole_engine NO
have_compress YES
have_crypt YES
have_csv NO
have_dynamic_loading NO
have_example_engine NO
have_federated_engine NO
have_geometry YES
have_innodb YES
have_isam NO
have_merge_engine YES
have_ndbcluster NO
have_openssl DISABLED
have_query_cache YES
have_raid NO
have_rtree_keys YES
have_symlink YES
init_connect
init_file
init_slave
innodb_additional_mem_pool_size 1048576
innodb_autoextend_increment 8
innodb_buffer_pool_awe_mem_mb 0
innodb_buffer_pool_size 8388608
innodb_checksums ON
innodb_commit_concurrency 0
innodb_concurrency_tickets 500
innodb_data_file_path ibdata1:10M:autoextend
innodb_data_home_dir
innodb_doublewrite ON
innodb_fast_shutdown 1
innodb_file_io_threads 4
innodb_file_per_table OFF
innodb_flush_log_at_trx_commit 1
innodb_flush_method
innodb_force_recovery 0
innodb_lock_wait_timeout 50
innodb_locks_unsafe_for_binlog OFF
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_max_dirty_pages_pct 90
innodb_max_purge_lag 0
innodb_mirrored_log_groups 1
innodb_open_files 300
innodb_support_xa ON
innodb_sync_spin_loops 20
innodb_table_locks ON
innodb_thread_concurrency 8
innodb_thread_sleep_delay 10000
interactive_timeout 28800
join_buffer_size 1044480
key_buffer_size 167772160
key_cache_age_threshold 300
key_cache_block_size 1024
key_cache_division_limit 100
language /usr/share/mysql/english/
large_files_support ON
large_page_size 0
large_pages OFF
lc_time_names en_US
license GPL
local_infile OFF
locked_in_memory OFF
log OFF
log_bin OFF
log_bin_trust_function_creators OFF
log_error
log_queries_not_using_indexes OFF
log_slave_updates OFF
log_slow_queries OFF
log_warnings 1
long_query_time 8
low_priority_updates OFF
lower_case_file_system OFF
lower_case_table_names 0
max_allowed_packet 33553408
max_binlog_cache_size 4294967295
max_binlog_size 1073741824
max_connect_errors 10
max_connections 750
max_delayed_threads 20
max_error_count 64
max_heap_table_size 16777216
max_insert_delayed_threads 20
max_join_size 18446744073709551615
max_length_for_sort_data 1024
max_prepared_stmt_count 16382
max_relay_log_size 0
max_seeks_for_key 4294967295
max_sort_length 1024
max_sp_recursion_depth 0
max_tmp_tables 32
max_user_connections 0
max_write_lock_count 4294967295
MySQL: Table always crashing (error 134) - LinuxQuestions.org::
11 posts - Last post: Oct 17, 2008Recently one of my tables is always crashing, having error 134, . where 1 master table keeps being reported as corrupted (error 134).
http://www.linuxquestions.org/questions/linux-general-1/mysql-table-always-crashing-error-134-660767/HOME |
multi_range_count 256
myisam_data_pointer_size 6
myisam_max_sort_file_size 2147483647
myisam_recover_options OFF
myisam_repair_threads 1
myisam_sort_buffer_size 67108864
myisam_stats_method nulls_unequal
net_buffer_length 8192
net_read_timeout 30
net_retry_count 10
net_write_timeout 60
new OFF
old_passwords OFF
open_files_limit 3760
optimizer_prune_level 1
optimizer_search_depth 62
pid_file /var/lib/mysql/mysqld.pid
port 3306
preload_buffer_size 32768
prepared_stmt_count 0
protocol_version 10
query_alloc_block_size 8192
query_cache_limit 6291456
query_cache_min_res_unit 4096
query_cache_size 100663296
query_cache_type ON
query_cache_wlock_invalidate OFF
query_prealloc_size 8192
range_alloc_block_size 2048
read_buffer_size 1044480
read_only OFF
read_rnd_buffer_size 520192
relay_log_purge ON
relay_log_space_limit 0
rpl_recovery_rank 0
secure_auth OFF
server_id 1
skip_external_locking ON
skip_networking OFF
skip_show_database OFF
slave_compressed_protocol OFF
slave_load_tmpdir /var/lib/mysql/tmp/
slave_net_timeout 3600
slave_skip_errors OFF
slave_transaction_retries 10
slow_launch_time 2
socket /var/lib/mysql/mysql.sock
sort_buffer_size 2097144
sql_big_selects ON
sql_mode
sql_notes ON
sql_warnings OFF
ssl_ca
ssl_capath
ssl_cert
ssl_cipher
ssl_key
storage_engine MyISAM
sync_binlog 0
sync_frm ON
system_time_zone CET
table_cache 1200
table_lock_wait_timeout 50
table_type MyISAM
thread_cache_size 8
thread_stack 131072
time_format %H:%i:%s
time_zone SYSTEM
timed_mutexes OFF
tmp_table_size 33554432
tmpdir /var/lib/mysql/tmp/
transaction_alloc_block_size 8192
transaction_prealloc_size 4096
tx_isolation REPEATABLE-READ
updatable_views_with_limit YES
version 5.0.27-standard
version_comment MySQL Community Edition - Standard (GPL)
version_compile_machine i686
version_compile_os pc-linux-gnu
wait_timeout 28800
+---------------------------------+------------------------------------------+
+-----------------------------------+------------+
Variable_name Value
+-----------------------------------+------------+
Aborted_clients 0
Aborted_connects 1
Binlog_cache_disk_use 0
Binlog_cache_use 0
Bytes_received 17011199
Bytes_sent 2868048655
Com_admin_commands 0
Com_alter_db 0
Com_alter_table 0
Com_analyze 0
Com_backup_table 0
Com_begin 0
Com_change_db 4097
Com_change_master 0
Com_check 228
Com_checksum 0
Com_commit 0
Com_create_db 0
Com_create_function 0
Com_create_index 0
Com_create_table 0
Com_dealloc_sql 0
Com_delete 300
Com_delete_multi 0
Com_do 0
Com_drop_db 0
Com_drop_function 0
Com_drop_index 0
Com_drop_table 0
Com_drop_user 0
Com_execute_sql 0
Com_flush 0
Com_grant 0
Com_ha_close 0
Com_ha_open 0
Com_ha_read 0
Com_help 0
Com_insert 1366
Com_insert_select 8
Com_kill 0
Com_load 0
Com_load_master_data 0
Com_load_master_table 0
Com_lock_tables 0
Com_optimize 228
Com_preload_keys 0
Com_prepare_sql 0
Com_purge 0
Com_purge_before_date 0
Com_rename_table 0
Com_repair 0
Com_replace 316
Com_replace_select 0
Com_reset 0
Com_restore_table 0
Com_revoke 0
Com_revoke_all 0
Com_rollback 0
Com_savepoint 0
Com_select 17747
Com_set_option 2
Com_show_binlog_events 0
Com_show_binlogs 0
Com_show_charsets 0
Com_show_collations 0
Com_show_column_types 0
Com_show_create_db 0
Com_show_create_table 0
Com_show_databases 0
Com_show_errors 0
Com_show_fields 0
Com_show_grants 0
Com_show_innodb_status 0
Com_show_keys 0
Com_show_logs 0
Com_show_master_status 0
Com_show_ndb_status 0
Com_show_new_master 0
Com_show_open_tables 0
Com_show_privileges 0
Com_show_processlist 0
Com_show_slave_hosts 0
Com_show_slave_status 0
Com_show_status 1
Com_show_storage_engines 0
Com_show_tables 0
Com_show_triggers 0
Com_show_variables 6
Com_show_warnings 0
Com_slave_start 0
Com_slave_stop 0
Com_stmt_close 0
Com_stmt_execute 0
Com_stmt_fetch 0
Com_stmt_prepare 0
Com_stmt_reset 0
Com_stmt_send_long_data 0
Com_truncate 0
Com_unlock_tables 0
Com_update 4386
Com_update_multi 0
Com_xa_commit 0
Com_xa_end 0
Com_xa_prepare 0
Com_xa_recover 0
Com_xa_rollback 0
Com_xa_start 0
Compression OFF
Connections 4101
Created_tmp_disk_tables 67
Created_tmp_files 177
Created_tmp_tables 658
Delayed_errors 0
Delayed_insert_threads 0
Delayed_writes 0
Flush_commands 1
Handler_commit 1
Handler_delete 584
Handler_discover 0
Handler_prepare 0
Handler_read_first 1137
Handler_read_key 918744
Handler_read_next 950192
Handler_read_prev 24168
Handler_read_rnd 218562
Handler_read_rnd_next 4625828
Handler_rollback 0
Handler_savepoint 0
Handler_savepoint_rollback 0
Handler_update 7029
Handler_write 8039
Innodb_buffer_pool_pages_data 31
Innodb_buffer_pool_pages_dirty 0
Innodb_buffer_pool_pages_flushed 1
Innodb_buffer_pool_pages_free 481
Innodb_buffer_pool_pages_latched 0
Innodb_buffer_pool_pages_misc 0
Innodb_buffer_pool_pages_total 512
Innodb_buffer_pool_read_ahead_rnd 1
Innodb_buffer_pool_read_ahead_seq 0
Innodb_buffer_pool_read_requests 420
Innodb_buffer_pool_reads 24
Innodb_buffer_pool_wait_free 0
Innodb_buffer_pool_write_requests 1
Innodb_data_fsyncs 7
Innodb_data_pending_fsyncs 0
Innodb_data_pending_reads 0
Innodb_data_pending_writes 0
Innodb_data_read 2691072
Innodb_data_reads 37
Innodb_data_writes 7
Innodb_data_written 35328
Innodb_dblwr_pages_written 1
Innodb_dblwr_writes 1
Innodb_log_waits 0
Innodb_log_write_requests 0
Innodb_log_writes 2
Innodb_os_log_fsyncs 5
Innodb_os_log_pending_fsyncs 0
Innodb_os_log_pending_writes 0
Innodb_os_log_written 1024
Innodb_page_size 16384
Innodb_pages_created 0
Innodb_pages_read 31
Innodb_pages_written 1
Innodb_row_lock_current_waits 0
Innodb_row_lock_time 0
Innodb_row_lock_time_avg 0
Innodb_row_lock_time_max 0
Innodb_row_lock_waits 0
Innodb_rows_deleted 0
Innodb_rows_inserted 0
Innodb_rows_read 2
Innodb_rows_updated 0
Key_blocks_not_flushed 0
Key_blocks_unused 127982
Key_blocks_used 138076
Key_read_requests 3117707
Key_reads 251990
Key_write_requests 6523
Key_writes 1848
Last_query_cost 0.000000
Max_used_connections 31
Not_flushed_delayed_rows 0
Open_files 204
Open_streams 0
Open_tables 121
Opened_tables 358
Qcache_free_blocks 660
Qcache_free_memory 90626424
Qcache_hits 23776
Qcache_inserts 17339
Qcache_lowmem_prunes 0
Qcache_not_cached 416
Qcache_queries_in_cache 1451
Qcache_total_blocks 3892
Questions 56552
Rpl_status NULL
Select_full_join 126
Select_full_range_join 0
Select_range 4776
Select_range_check 0
Select_scan 1744
Slave_open_temp_tables 0
Slave_retried_transactions 0
Slave_running OFF
Slow_launch_threads 0
Slow_queries 0
Sort_merge_passes 86
Sort_range 3022
Sort_rows 267565
Sort_scan 1426
Ssl_accept_renegotiates 0
Ssl_accepts 0
Ssl_callback_cache_hits 0
Ssl_cipher
Ssl_cipher_list
Ssl_client_connects 0
Ssl_connect_renegotiates 0
Ssl_ctx_verify_depth 0
Ssl_ctx_verify_mode 0
Ssl_default_timeout 0
Ssl_finished_accepts 0
Ssl_finished_connects 0
Ssl_session_cache_hits 0
Ssl_session_cache_misses 0
Ssl_session_cache_mode NONE
Ssl_session_cache_overflows 0
Ssl_session_cache_size 0
Ssl_session_cache_timeouts 0
Ssl_sessions_reused 0
Ssl_used_session_cache_entries 0
Ssl_verify_depth 0
Ssl_verify_mode 0
Ssl_version
Table_locks_immediate 45956
Table_locks_waited 130
Tc_log_max_pages_used 0
Tc_log_page_size 0
Tc_log_page_waits 0
Threads_cached 6
Threads_connected 9
Threads_created 138
Threads_running 1
Uptime 554
+-----------------------------------+------------+
Uptime: 554 Threads: 7 Questions: 56560 Slow queries: 0 Opens: 358 Flush tables: 1 Open tables: 121 Queries per second avg: 102.094
mysqladmin Ver 8.41 Distrib 5.0.27, for pc-linux-gnu on i686
(C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 5.0.27-standard
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 9 min 14 sec
Threads: 7 Questions: 56560 Slow queries: 0 Opens: 358 Flush tables: 1 Open tables: 121 Queries per second avg: 102.094
9. it's the only site on the server
10. cookie timeout 1200, max users: 2600 with 50k registered users
11. Apache Conf:
# number of server processes to start
# http://httpd.apache.org/docs/2.2/mod/mpm_common.html#startservers
StartServers 10
# minimum number of server processes which are kept spare
# http://httpd.apache.org/docs/2.2/mod/prefork.html#minspareservers
MinSpareServers 10
# maximum number of server processes which are kept spare
# http://httpd.apache.org/docs/2.2/mod/prefork.html#maxspareservers
MaxSpareServers 15
# highest possible MaxClients setting for the lifetime of the Apache process.
# http://httpd.apache.org/docs/2.2/mod/mpm_common.html#serverlimit
ServerLimit 800
# maximum number of server processes allowed to start
# http://httpd.apache.org/docs/2.2/mod/mpm_common.html#maxclients
MaxClients 800
# maximum number of requests a server process serves
# http://httpd.apache.org/docs/2.2/mod/mpm_common.html#maxrequestsperchild
MaxRequestsPerChild 10000
.......
# KeepAlive: Whether or not to allow persistent connections (more than
# one request per connection). Set to "Off" to deactivate.
#
KeepAlive On
#
# MaxKeepAliveRequests: The maximum number of requests to allow
# during a persistent connection. Set to 0 to allow an unlimited amount.
# We recommend you leave this number high, for maximum performance.
#
MaxKeepAliveRequests 150
#
# KeepAliveTimeout: Number of seconds to wait for the next request from the
# same client on the same connection.
#
KeepAliveTimeout 5
12. no large files like this
13. Linux thegreekz 2.6.16.13-4-smp #1 SMP Wed May 3 04:53:23 UTC 2006 x86_64 x86_64 x86_64 GNU/Linux
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
pending signals (-i) 71680
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
stack size (kbytes, -s) unlimited
cpu time (seconds, -t) unlimited
max user processes (-u) 71680
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
processor : 0
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU 5160 @ 3.00GHz
stepping : 6
cpu MHz : 2992.591
cache size : 4096 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 2
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm constant_tsc pni monitor ds_cpl vmx est tm2 cx16 xtpr lahf_lm
bogomips : 5994.19
clflush size : 64
cache_alignment : 64
address sizes : 36 bits physical, 48 bits virtual
power management:
processor : 1
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU 5160 @ 3.00GHz
stepping : 6
cpu MHz : 2992.591
cache size : 4096 KB
physical id : 3
siblings : 2
core id : 0
cpu cores : 2
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm constant_tsc pni monitor ds_cpl vmx est tm2 cx16 xtpr lahf_lm
bogomips : 5985.48
clflush size : 64
cache_alignment : 64
address sizes : 36 bits physical, 48 bits virtual
power management:
processor : 2
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU 5160 @ 3.00GHz
stepping : 6
cpu MHz : 2992.591
cache size : 4096 KB
physical id : 0
siblings : 2
core id : 1
cpu cores : 2
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm constant_tsc pni monitor ds_cpl vmx est tm2 cx16 xtpr lahf_lm
bogomips : 5985.35
clflush size : 64
cache_alignment : 64
address sizes : 36 bits physical, 48 bits virtual
power management:
processor : 3
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Xeon(R) CPU 5160 @ 3.00GHz
stepping : 6
cpu MHz : 2992.591
cache size : 4096 KB
physical id : 3
siblings : 2
core id : 1
cpu cores : 2
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm constant_tsc pni monitor ds_cpl vmx est tm2 cx16 xtpr lahf_lm
bogomips : 5985.50
clflush size : 64
cache_alignment : 64
address sizes : 36 bits physical, 48 bits virtual
power management:
any help is appreciated....
hello Eva, thank you for replying.
you where right, the Database crashed afterwards with a big loss of Data. Luckily I had a fresh backup from my older MySql 4.x version
I changed Server OS to Debian 3.1 and now have MySql 4.1.15 with PHP 5.2.1 and vB 3.5.7 running with no errors.
maybe the problems with the 5.x MySql resultet from some plugins which I have installed.
for question #7 the uptime for mysql to gather those stats is only 10 minutes not enough for indicative figures... if you can leave mysql and forums running for a few hours before outputing those stats it would help
do you run mysql replication ?
what error message you get with crashed mysql tables ? mysql error log reports what exactly ? Did these errors happen around xcache installation or before as well ?
try edit /etc/my.cnf and place the following mysql server settings in /etc/my.cnf and restart mysql server afterwards
[mysqld]
set-variable=local-infile=0
port = 3306
socket = /var/lib/mysql/mysql.sock
old_passwords
back_log = 100
skip-innodb
max_connections = 800
key_buffer = 512M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 4M
table_cache = 2500
thread_cache_size = 512
wait_timeout = 25
connect_timeout = 10
tmp_table_size = 512M
max_heap_table_size = 256M
max_allowed_packet = 80M
max_connect_errors = 10
read_rnd_buffer_size = 1M
bulk_insert_buffer_size = 8M
query_cache_limit = 8M
query_cache_size = 128M
query_cache_type = 1
query_prealloc_size = 65536
query_alloc_block_size = 131072
default-storage-engine = MyISAM
thread_concurrency = 4
[mysqld_safe]
nice = -10
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 80M
[myisamchk]
key_buffer = 384M
sort_buffer = 384M
read_buffer = 256M
write_buffer = 256M
Also upgrade to PHP 5.1.6 or if you want to use PHP 5.2.0 you need to update to vB 3.5.7 at least
yes I had just restarted the mysql after upgrading.
What I did now is that I downgraded to mysql-max-4.1.22 by replacing the binaries and with mysql -V in the Shell it gives me the correct Version but in my PhpInfo it still shows 5.0.27 :confused: did I miss a point in downgrading?!
Thus, the database seems to run better now, at least after one hour and optimizing it again there where no errors. I guess it's an error with the Mysql 5.x version but it would be good if the correct version would show up?!
I had xcache running since 2-3 months with no problems.
the errors occured looked like this:
post Check Error: Wrong bytesec: 0-0-0 at linkstart: 212708596
post Check Error: Corrupt
post
posthash Check Error: Record-count is not ok; is 228 Should be: 229
posthash Check Warning: Found 20678 deleted space. Should be 20629
posthash Check Warning: Found 422 deleted blocks Should be: 421
posthash Check Error: Corrupt
posthash
postindex Check Warning: Table is marked as crashed
postindex Check Error: record delete-link-chain corrupted
postindex Check Error: Corrupt
well, i will apply your settings to my sql config and I will try to figure out how to replace the rest of the mysql files with the old version.
Hopfully it was just an Version conflict :o
You shouldn't have downgraded mysql as it could of messed something up. In past MySQL 5.0x had issues downgrading to 4 with vB as it stripped vB database of some autoincrement fields messing up the vB database. Not sure if that was ever fixed ?
Do you still have a backup made from MySQL 5.0.x version ? I'd upgrade to MySQL 5.0.27 again and restore that backup made from MySQL 5.0.x prior to the downgrade first.
The phpinfo shows mysql client library used not mysql server used. To get php to use the same version you must always recompile PHP --with-mysql=/path/to/mysql after each mysql upgrade/downgrade.
Ah lucky you had backups :)
I'd update to MySQL 4.1.22 at least though :)
 Where's The Advantage In Windows Genuine Advantage?
 Stocks Bounce After S&P Joins Bear Market |
HOME