Und wenn ich mich einlogge dann dauerts ca. 5 min bis ich eingeloggt bin.
In db syserr steht:
Code:
SYSERR: May 22 05:00:42 :: Start: TABLE_POSTFIX not configured use default SYSERR: May 22 05:00:43 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous query: SELECT empire,pid,name,money,windate FROM monarch a,player b where a.pid=b.id SYSERR: May 22 05:00:43 :: LoadMonarch: DirectQuery failed( SELECT empire,pid,name,money,windate FROM monarch a,player b where a.pid=b.id ) SYSERR: May 22 05:00:43 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous query: SELECT pid,name,windate FROM monarch_candidacy a,player b where a.pid = b.id SYSERR: May 22 05:00:43 :: LoadMonarchCandidacy: DirectQuery failed( SELECT pid,name,windate FROM monarch_candidacy a,player b where a.pid = b.id ) SYSERR: May 22 05:00:43 :: LoadMonarchElection: DirectQuery failed( SELECT pid,selectedpid,electiondata FROM monarch_election ) SYSERR: May 22 05:02:03 :: heart_idle: losing 62 seconds. (lag occured) SYSERR: May 22 05:03:06 :: heart_idle: losing 62 seconds. (lag occured) SYSERR: May 22 05:04:00 :: heart_idle: losing 54 seconds. (lag occured) SYSERR: May 22 05:04:40 :: heart_idle: losing 39 seconds. (lag occured) Process: FDWATCH: peer null in event: ident 23 SYSERR: May 22 05:07:48 :: heart_idle: losing 33 seconds. (lag occured) SYSERR: May 22 05:07:58 :: Process: FDWATCH: peer null in event: ident 27 SYSERR: May 22 05:07:58 :: Process: FDWATCH: peer null in event: ident 29 SYSERR: May 22 05:07:58 :: Process: FDWATCH: peer null in event: ident 26 SYSERR: May 22 05:07:58 :: Process: FDWATCH: peer null in event: ident 28 SYSERR: May 22 05:07:58 :: Process: FDWATCH: peer null in event: ident 22 SYSERR: May 22 05:07:58 :: Process: FDWATCH: peer null in event: ident 24 SYSERR: May 22 05:09:04 :: heart_idle: losing 62 seconds. (lag occured) SYSERR: May 22 05:11:14 :: checkpointing: CHECKPOINT shutdown: tics did not updated.
Code:
May 22 05:11:14 :: reallocating buffer to 3371942, current 3371915 <-- Davon ganz viel aber immer andere zahlen! SYSERR: May 22 05:11:14 :: checkpointing: CHECKPOINT shutdown: tics did not updated.
ist das ALLES vllt. wegen der my.cnf?Quote:
connect: Operation timed out
die sieht so aus.
Code:
[mysqld] local-infile=0 query_cache_limit=32M query_cache_size=32M query_cache_type=1 max_connections=5000 interactive_timeout=100 wait_timeout=100 connect_timeout=20 thread_cache_size=128 key_buffer=16M join_buffer=1M max_allowed_packet=16M table_cache=1024 sort_buffer_size=2M read_buffer_size=2M max_connect_errors=9999 # Try number of CPU's*2 for thread_concurrency thread_concurrency=2 myisam_sort_buffer_size=64M server-id=1 innodb_use_sys_malloc =1 [safe_mysqld] err-log=/var/log/mysqld.log open_files_limit=8192 [mysqldump] quick max_allowed_packet=16M [mysql] no-auto-rehash #safe-updates [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
