daily pastebin goal
64%
SHARE
TWEET

Untitled

a guest Aug 15th, 2018 47 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top