i trying setup mysql oranghrm using xampp, each time giving me error: mysql shutdown unexpectedly.
i tried editing “my.ini” file , change 'max_allowed_packet' setting larger value in server. error persistent.
please find below snapshot my.ini file:
# here follows entries specific programs # mysql server [mysqld] port= 3306 socket = "c:/xampp/mysql/mysql.sock" basedir = "c:/xampp/mysql" tmpdir = "c:/xampp/tmp" datadir = "c:/xampp/mysql/data" pid_file = "mysql.pid" # enable-named-pipe key_buffer = 16m max_allowed_packet = 1m sort_buffer_size = 512k net_buffer_length = 8k read_buffer_size = 256k read_rnd_buffer_size = 512k myisam_sort_buffer_size = 8m log_error = "mysql_error.log" # change here bind listening # bind-address="127.0.0.1" # bind-address = ::1 # ipv6 # plugins live plugin_dir = "c:/xampp/mysql/lib/plugin/" # don't listen on tcp/ip port @ all. can security enhancement, # if processes need connect mysqld run on same host. # interaction mysqld must made via unix sockets or named pipes. # note using option without enabling named pipes on windows # (via "enable-named-pipe" option) render mysqld useless! # # commented in lampp security #skip-networking skip-federated # replication master server (default) # binary logging required replication # log-bin deactivated default since xampp 1.4.11 #log-bin=mysql-bin # required unique id between 1 , 2^32 - 1 # defaults 1 if master-host not set # not function master if omitted server-id = 1 # replication slave (comment out master section use this) # # configure host replication slave, can choose between # 2 methods : # # 1) use change master command (fully described in our manual) - # syntax is: # # change master master_host=<host>, master_port=<port>, # master_user=<user>, master_password=<password> ; # # replace <host>, <user>, <password> quoted strings , # <port> master's port number (3306 default). # # example: # # change master master_host='125.564.12.1', master_port=3306, # master_user='joe', master_password='secret'; # # or # 2) set variables below. however, in case choose method, # start replication first time (even unsuccessfully, example # if mistyped password in master-password , slave fails # connect), slave create master.info file, , later # change in file variables' values below ignored , # overridden content of master.info file, unless shutdown # slave server, delete master.info , restart slaver server. # reason, may want leave lines below untouched # (commented) , instead use change master (see above) # # required unique id between 2 , 2^32 - 1 # (and different master) # defaults 2 if master-host set # not function slave if omitted #server-id = 2 # # replication master slave - required #master-host = <hostname> # # username slave use authentication when connecting # master - required #master-user = <username> # # password slave authenticate when connecting # master - required #master-password = <password> # # port master listening on. # optional - defaults 3306 #master-port = <port> # # binary logging - not required slaves, recommended #log-bin=mysql-bin # point following paths different dedicated disks #tmpdir = "c:/xampp/tmp" #log-update = /path-to-dedicated-directory/hostname # uncomment following if using bdb tables #bdb_cache_size = 4m #bdb_max_lock = 10000 # comment following if using innodb tables #skip-innodb innodb_data_home_dir = "c:/xampp/mysql/data" innodb_data_file_path = ibdata1:10m:autoextend innodb_log_group_home_dir = "c:/xampp/mysql/data" #innodb_log_arch_dir = "c:/xampp/mysql/data" ## can set .._buffer_pool_size 50 - 80 % ## of ram beware of setting memory usage high innodb_buffer_pool_size = 16m innodb_additional_mem_pool_size = 2m ## set .._log_file_size 25 % of buffer pool size innodb_log_file_size = 5m innodb_log_buffer_size = 8m innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 ## utf 8 settings #init-connect=\'set names utf8\' #collation_server=utf8_unicode_ci #character_set_server=utf8 #skip-character-set-client-handshake #character_sets-dir="c:/xampp/mysql/share/charsets" [mysqldump] quick max_allowed_packet = 254m [mysql] no-auto-rehash # remove next comment character if not familiar sql #safe-updates [isamchk] key_buffer = 20m sort_buffer_size = 20m read_buffer = 2m write_buffer = 2m [myisamchk] key_buffer = 20m sort_buffer_size = 20m read_buffer = 2m write_buffer = 2m [mysqlhotcopy] interactive-timeout any suggestions?
my error logs is:
2015-07-14 11:39:47 25716 [note] plugin 'federated' disabled. 2015-07-14 11:39:47 6368 innodb: warning: using innodb_additional_mem_pool_size deprecated. option may removed in future releases, option innodb_use_sys_malloc , innodb's internal memory allocator. 2015-07-14 11:39:47 25716 [note] innodb: using atomics ref count buffer pool pages 2015-07-14 11:39:47 25716 [note] innodb: innodb memory heap disabled 2015-07-14 11:39:47 25716 [note] innodb: mutexes , rw_locks use windows interlocked functions 2015-07-14 11:39:47 25716 [note] innodb: memory barrier not used 2015-07-14 11:39:47 25716 [note] innodb: compressed tables use zlib 1.2.3 2015-07-14 11:39:47 25716 [note] innodb: not using cpu crc32 instructions 2015-07-14 11:39:47 25716 [note] innodb: initializing buffer pool, size = 16.0m 2015-07-14 11:39:47 25716 [note] innodb: completed initialization of buffer pool 2015-07-14 11:40:08 25716 [note] innodb: highest supported file format barracuda. 2015-07-14 11:40:08 25716 [note] innodb: log sequence numbers 1665234 , 1665234 in ibdata files not match log sequence number 15437456 in ib_logfiles! 2015-07-14 11:40:08 25716 [note] innodb: database not shutdown normally! 2015-07-14 11:40:08 25716 [note] innodb: starting crash recovery. 2015-07-14 11:40:08 25716 [note] innodb: reading tablespace information .ibd files... 2015-07-14 11:40:08 25716 [note] innodb: restoring possible half-written data pages 2015-07-14 11:40:08 25716 [note] innodb: doublewrite buffer... 2015-07-14 11:40:11 25716 [note] innodb: 128 rollback segment(s) active. 2015-07-14 11:40:11 25716 [note] innodb: waiting purge start 2015-07-14 11:40:11 25716 [note] innodb: 5.6.24 started; log sequence number 15437456 2015-07-14 11:40:11 25716 [note] server hostname (bind-address): '*'; port: 3306 2015-07-14 11:40:11 25716 [note] ipv6 available. 2015-07-14 11:40:11 25716 [note] - '::' resolves '::'; 2015-07-14 11:40:11 25716 [note] server socket created on ip: '::'. 2015-07-14 13:00:52 26796 [note] plugin 'federated' disabled. 2015-07-14 13:00:52 68b0 innodb: warning: using innodb_additional_mem_pool_size deprecated. option may removed in future releases, option innodb_use_sys_malloc , innodb's internal memory allocator. 2015-07-14 13:00:52 26796 [note] innodb: using atomics ref count buffer pool pages 2015-07-14 13:00:52 26796 [note] innodb: innodb memory heap disabled 2015-07-14 13:00:52 26796 [note] innodb: mutexes , rw_locks use windows interlocked functions 2015-07-14 13:00:52 26796 [note] innodb: memory barrier not used 2015-07-14 13:00:52 26796 [note] innodb: compressed tables use zlib 1.2.3 2015-07-14 13:00:52 26796 [note] innodb: not using cpu crc32 instructions 2015-07-14 13:00:52 26796 [note] innodb: initializing buffer pool, size = 16.0m 2015-07-14 13:00:52 26796 [note] innodb: completed initialization of buffer pool 2015-07-14 13:01:22 26796 [note] innodb: highest supported file format barracuda. 2015-07-14 13:01:22 26796 [note] innodb: log scan progressed past checkpoint lsn 17276706 2015-07-14 13:01:22 26796 [note] innodb: database not shutdown normally! 2015-07-14 13:01:22 26796 [note] innodb: starting crash recovery. 2015-07-14 13:01:22 26796 [note] innodb: reading tablespace information .ibd files... 2015-07-14 13:01:22 26796 [note] innodb: restoring possible half-written data pages 2015-07-14 13:01:22 26796 [note] innodb: doublewrite buffer... innodb: doing recovery: scanned log sequence number 17389703 2015-07-14 13:01:25 26796 [note] innodb: starting apply batch of log records t0 database...
innodb: progress in percent: 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 innodb: apply batch completed 2015-07-14 13:01:26 26796 [note] innodb: 128 rollback segment(s) active. 2015-07-14 13:01:26 26796 [note] innodb: waiting purge start 2015-07-14 13:01:26 26796 [note] innodb: 5.6.24 started; log sequence number 17389703 2015-07-14 13:01:26 26796 [note] server hostname (bind-address): '*'; port: 3306 2015-07-14 13:01:26 26796 [note] ipv6 available. 2015-07-14 13:01:26 26796 [note] - '::' resolves '::'; 2015-07-14 13:01:26 26796 [note] server socket created on ip: '::'. @mcwayweb
Comments
Post a Comment