*** mysql ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 215, free list len 938, seg size 1154, 1913792 merges merged operations: insert 15514089, delete mark 96176481, delete 4796129 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 276671, node heap has 736 buffer(s) 8833.87 hash searches/s, 3259.55 non-hash searches/s --- LOG --- Log sequence number 1066804114686 Log flushed up to 1066804114592 Last checkpoint at 1066803038222 1 pending log writes, 0 pending chkp writes 708530 log i/o's done, 1.58 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 137363456; in additional pool allocated 0 Dictionary memory allocated 9742970 Buffer pool size 8191 Free buffers 0 Database pages 7439 Old database pages 2726 Modified db pages 8 Pending reads 144 Pending writes: LRU 2, flush list 0, single page 0 Pages made young 303762706, not young 0 156.52 youngs/s, 0.00 non-youngs/s Pages read 191718287, created 1726045, written 10660532 121.39 reads/s, 0.00 creates/s, 3.71 writes/s Buffer pool hit rate 997 / 1000, young-making rate 4 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 17.84/s, Random read ahead 0.00/s LRU len: 7439, unzip_LRU len: 0 I/O sum[100605]:cur[3273], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 59 read views open inside InnoDB Main thread process no. 27336, id 139859652019968, state: master purging Number of rows inserted 149173632, updated 251054, deleted 88945774, read 51022267926 0.08 inserts/s, 0.08 updates/s, 0.00 deletes/s, 19006.03 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Error: semaphore wait has lasted > 600 seconds InnoDB: We intentionally crash the server, because it appears to be hung. 130328 8:02:25 InnoDB: Assertion failure in thread 139856914773760 in file srv0srv.c line 2455 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 21:02:25 UTC - mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=2147483648 read_buffer_size=131072 max_used_connections=132 max_threads=151 thread_count=119 connection_count=119 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 81285689 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0 thread_stack 0x30000 /usr/sbin/mysqld(my_print_stacktrace+0x29)[0x7f339fe71039] /usr/sbin/mysqld(handle_fatal_signal+0x483)[0x7f339fd379c3] /lib/x86_64-linux-gnu/libpthread.so.0(+0xfcb0)[0x7f339ea88cb0] /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x35)[0x7f339e0f4425] /lib/x86_64-linux-gnu/libc.so.6(abort+0x17b)[0x7f339e0f7b8b] /usr/sbin/mysqld(+0x5dd30a)[0x7f339fefd30a] /lib/x86_64-linux-gnu/libpthread.so.0(+0x7e9a)[0x7f339ea80e9a] /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f339e1b1cbd] The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)' Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! *** kern.log init: mysql main process (27336) terminated with status 1 Mar 28 08:02:29 hs kernel: [9059699.782707] init: mysql main process ended, respawning *** mysql-slow.log # Time: 130328 8:08:04 # User@Host: hobbit[hobbit] @ localhost [] # Query_time: 0.121699 Lock_time: 0.000223 Rows_sent: 500 Rows_examined: 158765 SET timestamp=1364418484; select user_id,user_name,might1,might2,(select alliance_name from alliances al where al.map_time_id = 3916 and al.alliance_id = mightLoss.alliance_id limit 1) as alliance_name from (select a.alliance_id,a.user_id,a.user_name,a.might as might1,b.might as might2 from users a left join users b on (a.user_id = b.user_id and b.map_time_id = 3916) where a.map_time_id = 3916 and a.might>0 and b.might>0 order by abs(b.might-a.might) desc limit 500) as mightLoss; # Time: 130328 8:28:53 # User@Host: kocbattle[kocbattle] @ localhost [] # Query_time: 1524.059268 Lock_time: 1523.763375 Rows_sent: 187 Rows_examined: 23347 use kocbattle; SET timestamp=1364419733; select alliance_id from (select alliance_id,sum(1) as might from users u where map_time_id = 9217 and alliance_id is not null and alliance_id > 0 group by alliance_id ) as mightsum where might between 15 and 100;