丶阿狸不哭_个人页

最后报错貌似看不到了 FILE I/O I/O thread 0 state: waiting for completed aio requests (insert buffer thread)I/O thread 1 state: waiting for completed aio requests (log thread)I/O thread 2 state: waiting for completed aio requests (read thread)I/O thread 3 state: waiting for completed aio requests (read thread)I/O thread 4 state: waiting for completed aio requests (read thread)I/O thread 5 state: waiting for completed aio requests (read thread)I/O thread 6 state: waiting for completed aio requests (read thread)I/O thread 7 state: waiting for completed aio requests (read thread)I/O thread 8 state: waiting for completed aio requests (read thread)I/O thread 9 state: waiting for completed aio requests (read thread)I/O thread 10 state: waiting for completed aio requests (write thread)I/O thread 11 state: waiting for completed aio requests (write thread)I/O thread 12 state: waiting for completed aio requests (write thread)I/O thread 13 state: waiting for completed aio requests (write thread)I/O thread 14 state: waiting for completed aio requests (write thread)I/O thread 15 state: waiting for completed aio requests (write thread)I/O thread 16 state: waiting for completed aio requests (write thread)I/O thread 17 state: waiting for completed aio requests (write thread)Pending normal aio reads: 0 [0, 0, 0, 0, 0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0, 0, 0, 0, 0] , ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0Pending flushes (fsync) log: 0; buffer pool: 03228795 OS file reads, 79307426 OS file writes, 53415531 OS fsyncs 0.12 reads/s, 16384 avg bytes/read, 18.57 writes/s, 18.57 fsyncs/s INSERT BUFFER AND ADAPTIVE HASH INDEX Ibuf: size 1, free list len 7343, seg size 7345, 221744 mergesmerged operations: insert 760128, delete mark 30713, delete 10041discarded operations: insert 0, delete mark 0, delete 0Hash table size 151384511, node heap has 0 buffer(s) 0.00 hash searches/s, 125235.99 non-hash searches/s LOG Log sequence number 1211209887140Log flushed up to 1211209886822Pages flushed up to 1211199528202Last checkpoint at 12111995282020 pending log writes, 0 pending chkp writes 21554306 log i/o's done, 18.57 log i/o's/second BUFFER POOL AND MEMORY Total memory allocated 70330089472; in additional pool allocated 0Dictionary memory allocated 3050346Buffer pool size 4194296Free buffers 612428Database pages 3581868Old database pages 1322105Modified db pages 6988Pending reads 0Pending writes: LRU 0, flush list 2, single page 0Pages made young 21711, not young 00.00 youngs/s, 0.00 non-youngs/sPages read 3221371, created 360497, written 480254980.12 reads/s, 0.17 creates/s, 0.00 writes/sBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/sLRU len: 3581868, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] INDIVIDUAL BUFFER POOL INFO ---BUFFER POOL 0Buffer pool size 524287Free buffers 74538Database pages 449749Old database pages 166003Modified db pages 1559Pending reads 0Pending writes: LRU 0, flush list 2, single page 0Pages made young 2734, not young 00.00 youngs/s, 0.00 non-youngs/sPages read 404393, created 45356, written 108182270.00 reads/s, 0.02 creates/s, 0.00 writes/sBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/sLRU len: 449749, unzip_LRU len: 0I/O sum[0]:cur[0], unzip sum[0]:cur[0]---BUFFER POOL 1Buffer pool size 524287Free buffers 75464Database pages 448823Old database pages 165664Modified db pages 675Pending reads 0Pending writes: LRU 0, flush list 0, single page 0Pages made young 2696, not young 00.00 youngs/s, 0.00 non-youngs/sPages read 403809, created 45014, written 40149190.02 reads/s, 0.00 creates/s, 0.00 writes/sBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/sLRU len: 448823, unzip_LRU len: 0I/O sum[0]:cur[0], unzip sum[0]:cur[0]---BUFFER POOL 2Buffer pool size 524287Free buffers 73881Database pages 450406Old database pages 166244Modified db pages 636Pending reads 0Pending writes: LRU 0, flush list 0, single page 0Pages made young 2662, not young 00.00 youngs/s, 0.00 non-youngs/sPages read 403732, created 46674, written 39969520.02 reads/s, 0.00 creates/s, 0.00 writes/sBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/sLRU len: 450406, unzip_LRU len: 0I/O sum[0]:cur[0], unzip sum[0]:cur[0]---BUFFER POOL 3Buffer pool size 524287Free buffers 76810Database pages 447477Old database pages 165181Modified db pages 947Pending reads 0Pending writes: LRU 0, flush list 0, single page 0Pages made young 2910, not young 00.00 youngs/s, 0.00 non-youngs/sPages read 402913, created 44564, written 85749130.02 reads/s, 0.00 creates/s, 0.00 writes/sBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/sLRU len: 447477, unzip_LRU len: 0I/O sum[0]:cur[0], unzip sum[0]:cur[0]---BUFFER POOL 4Buffer pool size 524287Free buffers 77520Database pages 446767Old database pages 164920Modified db pages 770Pending reads 0Pending writes: LRU 0, flush list 0, single page 0Pages made young 2546, not young 00.00 youngs/s, 0.00 non-youngs/sPages read 402432, created 44335, written 68310570.02 reads/s, 0.05 creates/s, 0.00 writes/sBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/sLRU len: 446767, unzip_LRU len: 0I/O sum[0]:cur[0], unzip sum[0]:cur[0]---BUFFER POOL 5Buffer pool size 524287Free buffers 81699Database pages 442588Old database pages 163359Modified db pages 677Pending reads 0Pending writes: LRU 0, flush list 0, single page 0Pages made young 2803, not young 00.00 youngs/s, 0.00 non-youngs/sPages read 398192, created 44396, written 41508310.00 reads/s, 0.02 creates/s, 0.00 writes/sBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/sLRU len: 442588, unzip_LRU len: 0I/O sum[0]:cur[0], unzip sum[0]:cur[0]---BUFFER POOL 6Buffer pool size 524287Free buffers 75357Database pages 448930Old database pages 165700Modified db pages 907Pending reads 0Pending writes: LRU 0, flush list 0, single page 0Pages made young 2625, not young 00.00 youngs/s, 0.00 non-youngs/sPages read 404076, created 44854, written 45544630.02 reads/s, 0.00 creates/s, 0.00 writes/sBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/sLRU len: 448930, unzip_LRU len: 0I/O sum[0]:cur[0], unzip sum[0]:cur[0]---BUFFER POOL 7Buffer pool size 524287Free buffers 77159Database pages 447128Old database pages 165034Modified db pages 817Pending reads 0Pending writes: LRU 0, flush list 0, single page 0Pages made young 2735, not young 00.00 youngs/s, 0.00 non-youngs/sPages read 401824, created 45304, written 50841360.00 reads/s, 0.07 creates/s, 0.00 writes/sBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/sLRU len: 447128, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ROW OPERATIONS 0 queries inside InnoDB, 0 queries in queue2 read views open inside InnoDBMain thread process no. 7890, id 140438058379008, state: enforcing dict cache limitNumber of rows inserted 25334846, updated 19974009, deleted 3278941, read 1085167903960 14.57 inserts/s, 9.70 updates/s, 0.15 deletes/s, 630031.82 reads/s END OF INNODB MONITOR OUTPUT InnoDB: ###### Diagnostic info printed to the standard error streamInnoDB: Error: semaphore wait has lasted > 600 secondsInnoDB: We intentionally crash the server, because it appears to be hung.2017-06-01 13:35:18 7fba49d54700 InnoDB: Assertion failure in thread 140438079358720 in file srv0srv.cc line 1756InnoDB: 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, evenInnoDB: immediately after the mysqld startup, there may beInnoDB: corruption in the InnoDB tablespace. Please refer toInnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.htmlInnoDB: about forcing recovery.05:35:18 UTC - mysqld got signal 6 ;This could be because you hit a bug. It is also possible that this binaryor 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 helpdiagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=8388608read_buffer_size=2097152max_used_connections=1221max_threads=2000thread_count=1221connection_count=1221It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 8225785 K bytes of memoryHope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0Attempting backtrace. You can use the following information to find outwhere mysqld died. If you see no messages after this, something wentterribly wrong...stack_bottom = 0 thread_stack 0x40000/app/mysql/bin/mysqld(my_print_stacktrace+0x35)[0x910535]/app/mysql/bin/mysqld(handle_fatal_signal+0x3d8)[0x6755e8]/lib64/libpthread.so.0[0x31b3e0f710]/lib64/libc.so.6(gsignal+0x35)[0x31b3a32625]/lib64/libc.so.6(abort+0x175)[0x31b3a33e05]/app/mysql/bin/mysqld[0x9e53bd]/lib64/libpthread.so.0[0x31b3e079d1]/lib64/libc.so.6(clone+0x6d)[0x31b3ae89dd]The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html containsinformation that should help you find out what is causing the crash.170601 13:35:18 mysqld_safe Number of processes running now: 0170601 13:35:18 mysqld_safe mysqld restarted 没人吗？问下怎么解决