Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- here is the logs i got:
- =======================
- 101026 15:55:57 mysqld_safe Starting mysqld daemon with databases from /srv/database/mysql/data
- 101026 15:55:57 [Note] Flashcache bypass: disabled
- 101026 15:55:57 [Note] Flashcache setup error is : ioctl failed
- 101026 15:55:57 [Note] Plugin 'FEDERATED' is disabled.
- /usr/local/Percona-Server-5.1.49-12/libexec/mysqld: Table 'mysql.plugin' doesn't exist
- 101026 15:55:57 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
- InnoDB: The InnoDB memory heap is disabled
- InnoDB: Mutexes and rw_locks use GCC atomic builtins
- InnoDB: Compressed tables use zlib 1.2.3
- InnoDB: unable to create ./innodb_status.8146: Permission denied
- 101026 15:55:57 [ERROR] Plugin 'InnoDB' init function returned error.
- 101026 15:55:57 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
- 101026 15:55:57 [Warning] Storage engine 'SPHINX' has conflicting typecode. Assigning value 42.
- 101026 15:55:57 [ERROR] Unknown/unsupported table type: InnoDB
- 101026 15:55:57 [ERROR] Aborting
- 101026 15:55:57 [Note] /usr/local/Percona-Server-5.1.49-12/libexec/mysqld: Shutdown complete
- 101026 15:55:57 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
- here is my conf:
- ================
- # vim: ts=8 shiftwidth=8
- #
- # The following options will be passed to all MySQL clients
- #
- [client]
- port = 3306
- socket = /tmp/mysqld.sock
- [mysql]
- prompt = \R:\m \u@{-INSTANCE-}:\d [\c]>\_
- #
- # The following options will be passed to MySQL server
- #
- [server]
- port = 3306
- socket = /tmp/mysqld.sock
- basedir = /usr/local/mysql
- datadir = /srv/database/mysql/data
- [mysqld]
- init-connect = 'SET NAMES utf8'
- init-file = /srv/database/mysql/init/init.sql
- event-scheduler = 1
- skip-external-locking
- skip-name-resolve
- skip-networking
- sql_mode = TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE
- #server-id = {-SERVER_ID-}
- default-storage-engine = InnoDB
- #report-host = {-HOST-}.{-INSTANCE-}
- auto_increment_offset = 1
- auto_increment_increment = 2
- #log-slave-updates
- general_log = 0
- general_log_file = /srv/database/mysql/log/general.log
- log-error = /srv/database/mysql/log/error.log
- #log-bin = /srv/database/mysql/log/binary
- long-query-time = 3
- slow-query-log = 0
- slow-query-log-file = /srv/database/mysql/log/slow_query.log
- max-binlog-size = 1000M
- expire_logs_days = 4
- relay-log = /srv/database/mysql/log/relay
- table_cache = 512
- max_connections = 800
- key_buffer_size = 100M
- sort_buffer_size = 100M
- read_buffer_size = 512k
- max_allowed_packet = 16M
- tmp_table_size = 64M
- max_heap_table_size = 64M
- ft_min_word_len = 3
- myisam_sort_buffer_size = 100M
- thread_cache_size = 4
- query_cache_size = 128M
- thread_concurrency = 12
- wait_timeout = 30
- # This works great, as long as we don't run out of memory.
- #tmpdir = /dev/shm
- tmpdir = /srv/database/mysql/tmp/
- innodb_status_file
- innodb_file_per_table
- innodb_rollback_on_timeout
- # The lack of "autoextend " is intentional
- innodb_data_file_path = ibdata1:200M
- innodb_buffer_pool_size = 256M
- innodb_additional_mem_pool_size = 8M
- innodb_log_file_size = 64M
- innodb_log_buffer_size = 16M
- innodb_flush_log_at_trx_commit = 2
- innodb_flush_method = O_DIRECT
- [mysql.server]
- user = mysql
- [mysqld_safe]
- log-err = /srv/database/mysql/log/error.log
- pid-file = /var/run/mysqld/mysqld.pid
- [mysqldump]
- quick
- max_allowed_packet = 16M
Add Comment
Please, Sign In to add comment