Advertisement
Guest User

Logfile mysql

a guest
Mar 7th, 2015
249
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.05 KB | None | 0 0
  1. 2015-03-06 23:51:06 4394 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
  2. 2015-03-06 23:51:06 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
  3. 2015-03-06 23:51:06 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  4. 2015-03-06 23:51:06 4759 [Note] Plugin 'FEDERATED' is disabled.
  5. 2015-03-06 23:51:06 4759 [Note] InnoDB: Using atomics to ref count buffer pool pages
  6. 2015-03-06 23:51:06 4759 [Note] InnoDB: The InnoDB memory heap is disabled
  7. 2015-03-06 23:51:06 4759 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  8. 2015-03-06 23:51:06 4759 [Note] InnoDB: Memory barrier is not used
  9. 2015-03-06 23:51:06 4759 [Note] InnoDB: Compressed tables use zlib 1.2.8
  10. 2015-03-06 23:51:06 4759 [Note] InnoDB: Using CPU crc32 instructions
  11. 2015-03-06 23:51:06 4759 [Note] InnoDB: Initializing buffer pool, size = 16.0M
  12. 2015-03-06 23:51:06 4759 [Note] InnoDB: Completed initialization of buffer pool
  13. 2015-03-06 23:51:06 4759 [Note] InnoDB: Setting log file /opt/lampp/var/mysql/ib_logfile101 size to 5 MB
  14. 2015-03-06 23:51:06 4759 [Note] InnoDB: Setting log file /opt/lampp/var/mysql/ib_logfile1 size to 5 MB
  15. 2015-03-06 23:51:06 4759 [Note] InnoDB: Renaming log file /opt/lampp/var/mysql/ib_logfile101 to /opt/lampp/var/mysql/ib_logfile0
  16. 2015-03-06 23:51:06 4759 [Warning] InnoDB: New log files created, LSN=1624742
  17. 2015-03-06 23:51:06 4759 [Note] InnoDB: Highest supported file format is Barracuda.
  18. 2015-03-06 23:51:06 4759 [Note] InnoDB: 128 rollback segment(s) are active.
  19. 2015-03-06 23:51:06 4759 [Note] InnoDB: Waiting for purge to start
  20. 2015-03-06 23:51:06 4759 [Note] InnoDB: 5.6.21 started; log sequence number 1625100
  21. 2015-03-06 23:51:06 4759 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 4656e2cb-c453-11e4-8865-645a040e363f.
  22. 2015-03-06 23:51:07 4759 [Note] RSA private key file not found: /opt/lampp/var/mysql//private_key.pem. Some authentication plugins will not work.
  23. 2015-03-06 23:51:07 4759 [Note] RSA public key file not found: /opt/lampp/var/mysql//public_key.pem. Some authentication plugins will not work.
  24. 2015-03-06 23:51:07 4759 [Note] Server hostname (bind-address): '*'; port: 3306
  25. 2015-03-06 23:51:07 4759 [Note] IPv6 is available.
  26. 2015-03-06 23:51:07 4759 [Note] - '::' resolves to '::';
  27. 2015-03-06 23:51:07 4759 [Note] Server socket created on IP: '::'.
  28. 2015-03-06 23:51:07 4759 [Note] Event Scheduler: Loaded 0 events
  29. 2015-03-06 23:51:07 4759 [Note] /opt/lampp/sbin/mysqld: ready for connections.
  30. Version: '5.6.21' socket: '/opt/lampp/var/mysql/mysql.sock' port: 3306 Source distribution
  31. 2015-03-07 00:14:18 4759 [Note] /opt/lampp/sbin/mysqld: Normal shutdown
  32.  
  33. 2015-03-07 00:14:18 4759 [Note] Giving 0 client threads a chance to die gracefully
  34. 2015-03-07 00:14:18 4759 [Note] Event Scheduler: Purging the queue. 0 events
  35. 2015-03-07 00:14:18 4759 [Note] Shutting down slave threads
  36. 2015-03-07 00:14:18 4759 [Note] Forcefully disconnecting 0 remaining clients
  37. 2015-03-07 00:14:18 4759 [Note] Binlog end
  38. 2015-03-07 00:14:18 4759 [Note] Shutting down plugin 'partition'
  39. 2015-03-07 00:14:18 4759 [Note] Shutting down plugin 'ARCHIVE'
  40. 2015-03-07 00:14:18 4759 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
  41. 2015-03-07 00:14:18 4759 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
  42. 2015-03-07 00:14:18 4759 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
  43. 2015-03-07 00:14:18 4759 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
  44. 2015-03-07 00:14:18 4759 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
  45. 2015-03-07 00:14:18 4759 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
  46. 2015-03-07 00:14:18 4759 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
  47. 2015-03-07 00:14:18 4759 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
  48. 2015-03-07 00:14:18 4759 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
  49. 2015-03-07 00:14:18 4759 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
  50. 2015-03-07 00:14:18 4759 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
  51. 2015-03-07 00:14:18 4759 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
  52. 2015-03-07 00:14:18 4759 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
  53. 2015-03-07 00:14:18 4759 [Note] Shutting down plugin 'INNODB_FT_DELETED'
  54. 2015-03-07 00:14:18 4759 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
  55. 2015-03-07 00:14:18 4759 [Note] Shutting down plugin 'INNODB_METRICS'
  56. 2015-03-07 00:14:18 4759 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
  57. 2015-03-07 00:14:18 4759 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
  58. 2015-03-07 00:14:18 4759 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
  59. 2015-03-07 00:14:18 4759 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
  60. 2015-03-07 00:14:18 4759 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
  61. 2015-03-07 00:14:18 4759 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
  62. 2015-03-07 00:14:18 4759 [Note] Shutting down plugin 'INNODB_CMPMEM'
  63. 2015-03-07 00:14:18 4759 [Note] Shutting down plugin 'INNODB_CMP_RESET'
  64. 2015-03-07 00:14:18 4759 [Note] Shutting down plugin 'INNODB_CMP'
  65. 2015-03-07 00:14:18 4759 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
  66. 2015-03-07 00:14:18 4759 [Note] Shutting down plugin 'INNODB_LOCKS'
  67. 2015-03-07 00:14:18 4759 [Note] Shutting down plugin 'INNODB_TRX'
  68. 2015-03-07 00:14:18 4759 [Note] Shutting down plugin 'InnoDB'
  69. 2015-03-07 21:47:17 15906 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
  70. 2015-03-07 21:47:17 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
  71. 2015-03-07 21:47:17 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  72. 2015-03-07 21:47:17 16253 [Note] Plugin 'FEDERATED' is disabled.
  73. 2015-03-07 21:47:17 16253 [Note] InnoDB: Using atomics to ref count buffer pool pages
  74. 2015-03-07 21:47:17 16253 [Note] InnoDB: The InnoDB memory heap is disabled
  75. 2015-03-07 21:47:17 16253 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  76. 2015-03-07 21:47:17 16253 [Note] InnoDB: Memory barrier is not used
  77. 2015-03-07 21:47:17 16253 [Note] InnoDB: Compressed tables use zlib 1.2.8
  78. 2015-03-07 21:47:17 16253 [Note] InnoDB: Using CPU crc32 instructions
  79. 2015-03-07 21:47:17 16253 [Note] InnoDB: Initializing buffer pool, size = 16.0M
  80. 2015-03-07 21:47:17 16253 [Note] InnoDB: Completed initialization of buffer pool
  81. 2015-03-07 21:47:18 16253 [Note] InnoDB: Highest supported file format is Barracuda.
  82. 2015-03-07 21:47:18 16253 [Note] InnoDB: The log sequence numbers 1624742 and 1624742 in ibdata files do not match the log sequence number 1625110 in the ib_logfiles!
  83. 2015-03-07 21:47:18 16253 [Note] InnoDB: Database was not shutdown normally!
  84. 2015-03-07 21:47:18 16253 [Note] InnoDB: Starting crash recovery.
  85. 2015-03-07 21:47:18 16253 [Note] InnoDB: Reading tablespace information from the .ibd files...
  86. 2015-03-07 21:47:18 16253 [Note] InnoDB: Restoring possible half-written data pages
  87. 2015-03-07 21:47:18 16253 [Note] InnoDB: from the doublewrite buffer...
  88. 2015-03-07 21:47:19 16253 [Note] InnoDB: 128 rollback segment(s) are active.
  89. 2015-03-07 21:47:19 16253 [Note] InnoDB: Waiting for purge to start
  90. 2015-03-07 21:47:19 16253 [Note] InnoDB: 5.6.21 started; log sequence number 1625110
  91. 2015-03-07 21:47:19 16253 [Note] RSA private key file not found: /opt/lampp/var/mysql//private_key.pem. Some authentication plugins will not work.
  92. 2015-03-07 21:47:19 16253 [Note] RSA public key file not found: /opt/lampp/var/mysql//public_key.pem. Some authentication plugins will not work.
  93. 2015-03-07 21:47:19 16253 [Note] Server hostname (bind-address): '*'; port: 3306
  94. 2015-03-07 21:47:19 16253 [Note] IPv6 is available.
  95. 2015-03-07 21:47:19 16253 [Note] - '::' resolves to '::';
  96. 2015-03-07 21:47:19 16253 [Note] Server socket created on IP: '::'.
  97. 2015-03-07 21:47:21 16253 [Note] Event Scheduler: Loaded 0 events
  98. 2015-03-07 21:47:21 16253 [Note] /opt/lampp/sbin/mysqld: ready for connections.
  99. Version: '5.6.21' socket: '/opt/lampp/var/mysql/mysql.sock' port: 3306 Source distribution
  100. 2015-03-07 22:00:47 16253 [Note] /opt/lampp/sbin/mysqld: Normal shutdown
  101.  
  102. 2015-03-07 22:00:47 16253 [Note] Giving 0 client threads a chance to die gracefully
  103. 2015-03-07 22:00:47 16253 [Note] Event Scheduler: Purging the queue. 0 events
  104. 2015-03-07 22:00:47 16253 [Note] Shutting down slave threads
  105. 2015-03-07 22:00:47 16253 [Note] Forcefully disconnecting 0 remaining clients
  106. 2015-03-07 22:00:47 16253 [Note] Binlog end
  107. 2015-03-07 22:00:47 16253 [Note] Shutting down plugin 'partition'
  108. 2015-03-07 22:00:47 16253 [Note] Shutting down plugin 'ARCHIVE'
  109. 2015-03-07 22:00:47 16253 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
  110. 2015-03-07 22:00:47 16253 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
  111. 2015-03-07 22:00:47 16253 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
  112. 2015-03-07 22:00:47 16253 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
  113. 2015-03-07 22:00:47 16253 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
  114. 2015-03-07 22:00:47 16253 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
  115. 2015-03-07 22:00:47 16253 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
  116. 2015-03-07 22:00:47 16253 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
  117. 2015-03-07 22:00:47 16253 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
  118. 2015-03-07 22:00:47 16253 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
  119. 2015-03-07 22:00:47 16253 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
  120. 2015-03-07 22:00:47 16253 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
  121. 2015-03-07 22:00:47 16253 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
  122. 2015-03-07 22:00:47 16253 [Note] Shutting down plugin 'INNODB_FT_DELETED'
  123. 2015-03-07 22:00:47 16253 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
  124. 2015-03-07 22:00:47 16253 [Note] Shutting down plugin 'INNODB_METRICS'
  125. 2015-03-07 22:00:47 16253 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
  126. 2015-03-07 22:00:47 16253 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
  127. 2015-03-07 22:00:47 16253 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
  128. 2015-03-07 22:00:47 16253 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
  129. 2015-03-07 22:00:47 16253 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
  130. 2015-03-07 22:00:47 16253 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
  131. 2015-03-07 22:00:47 16253 [Note] Shutting down plugin 'INNODB_CMPMEM'
  132. 2015-03-07 22:00:47 16253 [Note] Shutting down plugin 'INNODB_CMP_RESET'
  133. 2015-03-07 22:00:47 16253 [Note] Shutting down plugin 'INNODB_CMP'
  134. 2015-03-07 22:00:47 16253 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
  135. 2015-03-07 22:00:47 16253 [Note] Shutting down plugin 'INNODB_LOCKS'
  136. 2015-03-07 22:00:47 16253 [Note] Shutting down plugin 'INNODB_TRX'
  137. 2015-03-07 22:00:47 16253 [Note] Shutting down plugin 'InnoDB'
  138. 2015-03-07 22:00:47 16253 [Note] InnoDB: FTS optimize thread exiting.
  139. 2015-03-07 22:00:47 16253 [Note] InnoDB: Starting shutdown...
  140. 2015-03-07 22:00:49 16253 [Note] InnoDB: Shutdown completed; log sequence number 1625120
  141. 2015-03-07 22:00:49 16253 [Note] Shutting down plugin 'BLACKHOLE'
  142. 2015-03-07 22:00:49 16253 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
  143. 2015-03-07 22:00:49 16253 [Note] Shutting down plugin 'MyISAM'
  144. 2015-03-07 22:00:49 16253 [Note] Shutting down plugin 'MEMORY'
  145. 2015-03-07 22:00:49 16253 [Note] Shutting down plugin 'CSV'
  146. 2015-03-07 22:00:49 16253 [Note] Shutting down plugin 'MRG_MYISAM'
  147. 2015-03-07 22:00:49 16253 [Note] Shutting down plugin 'sha256_password'
  148. 2015-03-07 22:00:49 16253 [Note] Shutting down plugin 'mysql_old_password'
  149. 2015-03-07 22:00:49 16253 [Note] Shutting down plugin 'mysql_native_password'
  150. 2015-03-07 22:00:49 16253 [Note] Shutting down plugin 'binlog'
  151. 2015-03-07 22:00:49 16253 [Note] /opt/lampp/sbin/mysqld: Shutdown complete
  152.  
  153. 2015-03-07 22:00:49 15906 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/notebook-linux.pid ended
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement