[Forum] trying to repaid database but got few error

[fassy4u]

Getting this error in one day more then 50 times , and nobody give me response about this error , this error after installing 4.1.7

Database error in vBulletin 4.1.7:

Invalid SQL:

SELECT *
FROM style
WHERE (styleid = 20 AND userselect = 1)
OR styleid = 20
ORDER BY styleid ASC
LIMIT 1;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Monday, November 21st 2011 @ 09:31:55 PM
Error Date : Monday, November 21st 2011 @ 09:36:12 PM
Script : http://www.desicorner.net/english-dubbed-movies/
Referrer : http://desicorner.net/
IP Address : 1.23.156.134
Username : Unregistered
Classname : vB_Database
MySQL Version :



Database error in vBulletin 4.1.7:

Invalid SQL:

SELECT *
FROM style
WHERE (styleid = 20 AND userselect = 1)
OR styleid = 20
ORDER BY styleid ASC
LIMIT 1;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Friday, November 25th 2011 @ 04:34:52 PM
Error Date : Friday, November 25th 2011 @ 04:39:51 PM
Script : http://www.desicorner.net/latest-blo...ch-online.html
Referrer : http://www.google.com/m/search?clien...site=universal
IP Address : 115.246.178.93
Username : Unregistered
Classname : vB_Database
MySQL Version :

[fassy4u]

guys need help

[Mr.Tampax]

MySQL Error : MySQL server has gone away

Contact your hosting provider - mysql server overload.

[Lynne]

"MySQL Server has gone away" is a server issue. See this: https://www.vbulletin.com/docs/html/...mysql_goneaway and this: https://www.vbulletin.com/forum/show...265#post310265 You will need to talk to your host about this in order to get it resolved.

[Riasat]

This usually happens when your site tries to create more MySQL connections (due to more visitors) than allowed by your host...

[fassy4u]

i m using vps and this is my etc/my.cnf fie please tell me its correct , or i have to made some changes ?

[mysqld]
#skip-name-resolve
#old_passwords
back_log = 50
max_connections = 500
key_buffer_size = 24M
myisam_sort_buffer_size = 64M
myisam_max_sort_file_size = 2048M
join_buffer_size = 256K
read_buffer_size = 256K
sort_buffer_size = 256K
table_definition_cache = 4000
table_open_cache = 4000
thread_cache_size = 64
wait_timeout = 60
interactive_timeout = 60
connect_timeout = 10
tmp_table_size = 64M
max_heap_table_size = 64M
max_allowed_packet = 64M
max_seeks_for_key = 1000
group_concat_max_len = 1024
max_length_for_sort_data = 1024
net_buffer_length = 16384
max_connect_errors = 100000
concurrent_insert = 2
read_rnd_buffer_size = 512K
bulk_insert_buffer_size = 8M
query_cache_limit = 512K
query_cache_size = 64M
query_cache_type = 1
query_prealloc_size = 262144
query_alloc_block_size = 65536
range_alloc_block_size = 4096
transaction_alloc_block_size = 8192
transaction_prealloc_size = 4096
default-storage-engine = MyISAM
max_write_lock_count = 4

innodb_open_files = 500
innodb_data_file_path= ibdata1:10M:autoextend
innodb_buffer_pool_size = 256M
innodb_additional_mem_pool_size = 32M

innodb_log_files_in_group = 2
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 2
innodb_thread_concurrency = 8
innodb_flush_method = O_DIRECT

slow_query_log=0
long_query_time=1
slow_query_log_file=/var/lib/mysql/slowq.log

[mysqld_safe]
nice = -5
open-files-limit = 8192

[mysqldump]
quick
max_allowed_packet = 64M

[myisamchk]
key_buffer_size = 32M
sort_buffer_size = 1M
read_buffer_size = 1M
write_buffer_size = 1M

[mysqlhotcopy]
interactive-timeout

[Riasat]

Try increasing the timeout values.

[fassy4u]

which on time out there is three timeout All Of them ?

wait_timeout = 60
interactive_timeout = 60
connect_timeout = 10

[Mr.Tampax]

You use InnoDB or MyISAM for vB? Download "mysqltuner.pl" and run it -without thinking, I can say that you have a very incorrect memory allocation for mysql.Also install the utility "htop" and watch memory usage and CPU when an error occurs.

[Lynne]

Your wait_timeout if pretty low (I think default is 28840). Try setting it to 120 and then increase by 60 if needed a few times.