- Главная Список форумов Ошибки Open Server
- Поиск
-
- Текущее время: 18 фев 2025, 11:58
- Часовой пояс: UTC+03:00
2020-09-04 17:19:35 0 [Note] c:\users\user\ospanel\modules\database\MariaDB-10.3-x64\bin\mysqld.exe (mysqld 10.3.13-MariaDB-log) starting as process 7728 ...
2020-09-04 17:19:35 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-09-04 17:19:35 0 [Note] InnoDB: Uses event mutexes
2020-09-04 17:19:35 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-09-04 17:19:35 0 [Note] InnoDB: Number of pools: 1
2020-09-04 17:19:35 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-09-04 17:19:35 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
2020-09-04 17:19:35 0 [Note] InnoDB: Completed initialization of buffer pool
2020-09-04 17:19:35 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=41516223646
2020-09-04 17:19:36 0 [Note] InnoDB: Last binlog file '.\0.000175', position 94077931
2020-09-04 17:20:51 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-09-04 17:20:51 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-09-04 17:20:51 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-09-04 17:20:51 0 [Note] InnoDB: Setting file 'c:\users\user\ospanel\userdata\MariaDB-10.3-x64\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-09-04 17:20:51 0 [Note] InnoDB: File 'c:\users\user\ospanel\userdata\MariaDB-10.3-x64\ibtmp1' size is now 12 MB.
2020-09-04 17:20:51 0 [Note] InnoDB: Waiting for purge to start
2020-09-04 17:20:51 0 [Note] InnoDB: 10.3.13 started; log sequence number 41516223655; transaction id 19975078
2020-09-04 17:20:51 0 [Note] InnoDB: Loading buffer pool(s) from c:\users\user\ospanel\userdata\MariaDB-10.3-x64\ib_buffer_pool
2020-09-04 17:20:51 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-09-04 17:20:51 0 [Note] Recovering after a crash using 0
2020-09-04 17:20:51 0 [Note] Starting crash recovery...
2020-09-04 17:20:51 0 [Note] Crash recovery finished.
2020-09-04 17:20:51 0 [Note] Server socket created on IP: '127.0.0.1'.
2020-09-04 17:20:55 0 [Note] Reading of all Master_info entries succeded
2020-09-04 17:20:55 0 [Note] Added new Master_info '' to hash table
2020-09-04 17:20:55 0 [Note] c:\users\user\ospanel\modules\database\MariaDB-10.3-x64\bin\mysqld.exe: ready for connections.
Version: '10.3.13-MariaDB-log' socket: '' port: 3306 mariadb.org binary distribution
2020-09-04 17:20:56 0 [Note] InnoDB: Buffer pool(s) load completed at 200904 17:20:56
[main] start=25 allow=1 autowait=0 emformat=txt maxmemcache=64 cgiprocess=6 pginitencode=UTF8 pginitlocale=Russian_Russia.1251 ip=127.0.0.1 http_log=1 mysql_log=1 postgresql_log=0 mongodb_log=0 dns_log=0 memcache_log=0 redis_log=0 debugmail=0 mysqlcharset=utf8_general_ci phpdriver="PHP_7.2" httpdriver="Apache_2.4-PHP_7.2-7.4" mysql_driver="MySQL-5.7" pg_driver=none mongo_driver=none memcachedriver=none redisdriver=none dnsdriver=none httpcharset=notset logreadsize=256 showversion=0 astart=0 crdisk=1 crpath=0 crdomain=2 showfvr=0 showprogs=0 hdomains=0 balloon=0 favorite=0 showswitch=1 debugmode=0 stext=1 sbrowser=1 email=0 vdisk=W selfhosts=0 webdir="domains" browser="%realprogdir%\progs\Default\launcher\launcher.exe" textred="%realprogdir%\progs\Default\sublime_text\sublime_text.exe" filebrowser="" sfilebrowser=0 maxrequests=0 folders="" [ports] mysqlport=3306 postgresqlport=5432 mongodbport=27017 httpport=80 httpsport=443 httpbackport=8080 ftpport=21 sftpport=990 phpport=9500 redisport=6379 memcacheport=11211 [ftp] ftp=0 ftpcommandtimeout=600 ftpconnecttimeout=60 [sendmail] smtp_server="" smtp_port="" auth_username="" auth_password="" smtp_ssl=0 pop3_server="" pop3_username="" pop3_password="" force_sender=""
[client] port = %mysqlport% character_sets_dir = "%dprogdir%\\modules\\database\\%mysql_driver%\\share\\charsets" [mysql] no-auto-rehash no-beep character_sets_dir = "%dprogdir%\\modules\\database\\%mysql_driver%\\share\\charsets" [mysqld] sql_mode = NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION # Required Settings basedir = "%dprogdir%\\modules\\database\\%mysql_driver%" bind-address = %ip% character_sets_dir = "%dprogdir%\\modules\\database\\%mysql_driver%\\share\\charsets" character_set_server = utf8mb4 collation_server = utf8mb4_unicode_ci datadir = "%dprogdir%\\userdata\\%mysql_driver%" default_storage_engine = InnoDB explicit_defaults_for_timestamp = 1 ft_min_word_len = 3 local_infile = 0 lower_case_table_names = 1 max_allowed_packet = 256M pid_file = "%dprogdir%\\userdata\\temp\\mysql.pid" port = %mysqlport% secure-file-priv = "%dprogdir%\\userdata\\php_upload" #skip_name_resolve = 1 ssl = 0 tmpdir = "%dprogdir%\\userdata\\temp" # Buffer Settings bulk_insert_buffer_size = 8M join_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 4M sort_buffer_size = 2M # Cache Settings query_cache_limit = 256K query_cache_size = 256M query_cache_type = 1 # Connection Settings max_connections = 64 max_connect_errors = 32 back_log = 128 thread_cache_size = 8 interactive_timeout = 180 wait_timeout = 180 # InnoDB Settings innodb_adaptive_hash_index = 0 innodb_buffer_pool_instances = 1 innodb_buffer_pool_size = 2048M innodb_data_file_path = ibdata1:10M:autoextend innodb_data_home_dir = "%dprogdir%\\userdata\\%mysql_driver%" innodb_file_per_table = 1 #innodb_force_recovery = 1 innodb_log_file_size = 64M innodb_read_io_threads = 8 #innodb_thread_concurrency = 4 innodb_write_io_threads = 8 # Logging %log%general_log = 1 %log%general_log_file = "%dprogdir%\\userdata\\logs\\%mysql_driver%_queries.log" log_error = "%dprogdir%\\userdata\\logs\\%mysql_driver%_error.log" skip-log-bin #log_queries_not_using_indexes = 1 #long_query_time = 5 #slow_query_log = 1 #slow_query_log_file = "%dprogdir%\\userdata\\logs\\%mysql_driver%_slow.log" # MyISAM Settings key_buffer_size = 32M myisam_max_sort_file_size = 256M myisam_recover_options = backup,force # Table Settings table_definition_cache = 10000 table_open_cache = 10000 open_files_limit = 60000 max_heap_table_size = 128M tmp_table_size = 128M [mysqldump] quick quote_names max_allowed_packet = 16M [myisamchk] key_buffer_size = 64M sort_buffer_size = 64M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout [mysqld_safe] open_files_limit = 60000Лог запуска сервера:
2020-10-08 22:46:35 -------------------------------------------- 2020-10-08 22:46:35 Начало процедуры запуска сервера 2020-10-08 22:46:35 Обновление Hosts файла 2020-10-08 22:46:35 Обновление конфигурации MySQL-5.7 2020-10-08 22:46:35 Обновление конфигурации Sendmail 2020-10-08 22:46:35 Обновление конфигурации PHP_7.2 2020-10-08 22:46:35 Обновление конфигурации PHPMyAdmin 2020-10-08 22:46:35 Обновление конфигурации Apache_2.4-PHP_7.2-7.4 2020-10-08 22:46:35 Запуск MySQL-5.7 2020-10-08 22:46:35 Запуск Apache_2.4-PHP_7.2-7.4 2020-10-08 22:46:35 Проверка состояния сервера 2020-10-08 22:47:07 Не удалось запустить MySQL-5.7 2020-10-08 22:47:07 Сбой запуска! 2020-10-08 22:47:07 -------------------------------------------- 2020-10-08 22:47:07 Начало процедуры остановки сервера 2020-10-08 22:47:07 Остановка системных модулей 2020-10-08 22:47:40 Отключение виртуального диска 2020-10-08 22:47:40 Сервер успешно остановлен за 33,172 секунд!В MySQL логха особо ничего не вижу. Подскажите в чем может быть проблема ? может есть какие-то параметры для MySQL с учетом объема БД ?