DEADLOCK Problem
Hallo zusammen,
ich habe ein großes Problem mit Deadlocks und weiss nicht wie ich es lösen kann, vielleicht hat jemand eine Idee??? Der Client bekommt immer einen Database Error 1205 SQLSTATE= HY000 Lock wait timeout exceeded; try restarting transaction.
Meine Idee wäre vielleicht das timeout hochzusetzen, aber ob das Problem so gelöst werden kann??? Es handel sich um eine große Produktivdatenbank.
Meine Konfiguration sieht wie folgt aus:
# Example MySQL config file for very large systems.
#
# This is for a large system with memory of 1G-2G where the system runs mainly
# MySQL.
#
# You can copy this file to
# /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is /var/lib/mysql) or
# ~/.my.cnf to set user-specific options.
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
skip-locking
key_buffer = 384M
max_allowed_packet = 200M
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8
max_connections=1000
innodb_log_file_size = 125M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
transaction-isolation = READ-UNCOMMITTED
init-connect = 'SET NAMES utf8'
collation_server=utf8_unicode_ci
character_set_server=utf8
default-storage-engine=INNODB
# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (via the "enable-named-pipe" option) will render mysqld useless!
#
#skip-networking
#Replication Parameters
server-id = 10
#log-bin=mysql-bin
# The safe_mysqld script
[safe_mysqld]
[mysqldump]
quick
max_allowed_packet = 200M
[mysql]
prompt = (\U) [\d]>
no-auto-rehash
# default-character-set=utf8
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
#transaction-isolation = READ-UNCOMMITTED
#init-connect = 'SET NAMES utf8'
#collation_server=utf8_unicode_ci
#character_set_server=utf8
Subject
Views
Written By
Posted
DEADLOCK Problem
2091
March 22, 2012 05:06AM
1056
March 22, 2012 05:37AM
934
March 22, 2012 06:48AM
944
March 22, 2012 08:54AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.