Guest User

Untitled

a guest
Aug 15th, 2018
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.56 KB | None | 0 0
  1. here is the logs i got:
  2. =======================
  3.  
  4. 101026 15:55:57 mysqld_safe Starting mysqld daemon with databases from /srv/database/mysql/data
  5. 101026 15:55:57 [Note] Flashcache bypass: disabled
  6. 101026 15:55:57 [Note] Flashcache setup error is : ioctl failed
  7.  
  8. 101026 15:55:57 [Note] Plugin 'FEDERATED' is disabled.
  9. /usr/local/Percona-Server-5.1.49-12/libexec/mysqld: Table 'mysql.plugin' doesn't exist
  10. 101026 15:55:57 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
  11. InnoDB: The InnoDB memory heap is disabled
  12. InnoDB: Mutexes and rw_locks use GCC atomic builtins
  13. InnoDB: Compressed tables use zlib 1.2.3
  14. InnoDB: unable to create ./innodb_status.8146: Permission denied
  15. 101026 15:55:57 [ERROR] Plugin 'InnoDB' init function returned error.
  16. 101026 15:55:57 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
  17. 101026 15:55:57 [Warning] Storage engine 'SPHINX' has conflicting typecode. Assigning value 42.
  18. 101026 15:55:57 [ERROR] Unknown/unsupported table type: InnoDB
  19. 101026 15:55:57 [ERROR] Aborting
  20.  
  21. 101026 15:55:57 [Note] /usr/local/Percona-Server-5.1.49-12/libexec/mysqld: Shutdown complete
  22.  
  23. 101026 15:55:57 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
  24.  
  25. here is my conf:
  26. ================
  27.  
  28. # vim: ts=8 shiftwidth=8
  29. #
  30. # The following options will be passed to all MySQL clients
  31. #
  32. [client]
  33. port = 3306
  34. socket = /tmp/mysqld.sock
  35.  
  36. [mysql]
  37. prompt = \R:\m \u@{-INSTANCE-}:\d [\c]>\_
  38.  
  39. #
  40. # The following options will be passed to MySQL server
  41. #
  42. [server]
  43. port = 3306
  44. socket = /tmp/mysqld.sock
  45. basedir = /usr/local/mysql
  46. datadir = /srv/database/mysql/data
  47.  
  48. [mysqld]
  49. init-connect = 'SET NAMES utf8'
  50. init-file = /srv/database/mysql/init/init.sql
  51. event-scheduler = 1
  52. skip-external-locking
  53. skip-name-resolve
  54. skip-networking
  55. sql_mode = TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE
  56.  
  57. #server-id = {-SERVER_ID-}
  58. default-storage-engine = InnoDB
  59. #report-host = {-HOST-}.{-INSTANCE-}
  60. auto_increment_offset = 1
  61. auto_increment_increment = 2
  62. #log-slave-updates
  63.  
  64.  
  65. general_log = 0
  66. general_log_file = /srv/database/mysql/log/general.log
  67. log-error = /srv/database/mysql/log/error.log
  68. #log-bin = /srv/database/mysql/log/binary
  69. long-query-time = 3
  70. slow-query-log = 0
  71. slow-query-log-file = /srv/database/mysql/log/slow_query.log
  72. max-binlog-size = 1000M
  73. expire_logs_days = 4
  74. relay-log = /srv/database/mysql/log/relay
  75.  
  76. table_cache = 512
  77.  
  78. max_connections = 800
  79. key_buffer_size = 100M
  80. sort_buffer_size = 100M
  81. read_buffer_size = 512k
  82. max_allowed_packet = 16M
  83. tmp_table_size = 64M
  84. max_heap_table_size = 64M
  85. ft_min_word_len = 3
  86. myisam_sort_buffer_size = 100M
  87. thread_cache_size = 4
  88.  
  89. query_cache_size = 128M
  90.  
  91. thread_concurrency = 12
  92. wait_timeout = 30
  93.  
  94. # This works great, as long as we don't run out of memory.
  95. #tmpdir = /dev/shm
  96. tmpdir = /srv/database/mysql/tmp/
  97.  
  98. innodb_status_file
  99. innodb_file_per_table
  100. innodb_rollback_on_timeout
  101. # The lack of "autoextend " is intentional
  102. innodb_data_file_path = ibdata1:200M
  103. innodb_buffer_pool_size = 256M
  104. innodb_additional_mem_pool_size = 8M
  105. innodb_log_file_size = 64M
  106. innodb_log_buffer_size = 16M
  107. innodb_flush_log_at_trx_commit = 2
  108. innodb_flush_method = O_DIRECT
  109.  
  110. [mysql.server]
  111. user = mysql
  112.  
  113. [mysqld_safe]
  114. log-err = /srv/database/mysql/log/error.log
  115. pid-file = /var/run/mysqld/mysqld.pid
  116.  
  117. [mysqldump]
  118. quick
  119. max_allowed_packet = 16M
Add Comment
Please, Sign In to add comment