If your New to Runner or just registered please check your junk mail or spam folder to activate registration . Welcome to Runner ... Movie section will be closing on runner to view movies go to Tell It As It Is for latest movies videos @ https://tellitasitis.ga/

Go Back   Runner > Coding Corner > All Other's

All Other's all other coding ? Apache mods etc

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 06-16-2021, 07:39 PM
Runner's Avatar
Runner Runner is offline
Administrator
 
Join Date: Nov 2020
Location: Moose Jaw
Posts: 329
Send a message via Skype™ to Runner
Default MySQL version: 8.0.22

Tips if you run into certain problems



#set the complete "forgiving" mode
sql-mode = ""
# alternatively you can set sql mode to the following
#sql-mode = "STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_ZER O_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO"




Code:
#
# Server MySQL Settings file,
#
# this is required MySQL
# settings for MySQL 8.0

[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
password_require_current=ON
collation-server = utf8_unicode_520_ci
init-connect='SET NAMES utf8'
character-set-server = utf8
default_authentication_plugin = mysql_native_password
wait_timeout = 600
default-storage-engine=MYISAM
max_connections=151
#federated
#skip-networking
bind-address=127.0.0.1
table_open_cache=4000
tmp_table_size=256M
max_heap_table_size=256M
thread_cache_size=512
myisam_max_sort_file_size=100G
myisam_sort_buffer_size=128M
key_buffer_size=128M
read_buffer_size=1M
read_rnd_buffer_size=1M
sort_buffer_size=2M
#*** MYISAM Specific default options ***  
#skip-MYISAM
#MYISAM_additional_mem_pool_size = 7M
join_buffer_size=500K
MYISAM_file_per_table=off
MYISAM_io_capacity=1000
MYISAM_read_io_threads=64
MYISAM_write_io_threads=64
net_read_timeout=600
net_write_timeout=600
table_open_cache=8192
MYISAM_flush_log_at_trx_commit=0
#MYISAM_flush_method = O_DIRECT 
MYISAM_log_buffer_size = 64M
MYISAM_buffer_pool_instances=1
MYISAM_buffer_pool_size=1G
MYISAM_log_file_size=256M
MYISAM_open_files=1000
MYISAM_stats_on_metadata=0
MYISAM_thread_concurrency=1
MYISAM_concurrency_tickets=5000
MYISAM_autoextend_increment=128
MYISAM_old_blocks_time=1000
MYISAM_checksum_algorithm=0
flush_time=0
sort_buffer_size=512K
max_allowed_packet=268435456
#open_files_limit=10000
MYISAM_data_home_dir="C:\ProgramData\MySQL\MySQL Server 8.0\Data"
MYISAM_data_file_path=ibdata1:100M:autoextend
MYISAM_log_group_home_dir="C:\ProgramData\MySQL\MySQL Server 8.0\Data"
MYISAM_lock_wait_timeout=50
#set the complete "forgiving" mode
sql-mode = ""
# alternatively you can set sql mode to the following
#sql-mode = "STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO"
#max_execution_time = 30000
# Change directory Data Here:
datadir = C:\ProgramData\MySQL\MySQL Server 8.0\Data
basedir = C:\ProgramData\MySQL\MySQL Server 8.0\
 #*** Log Directeries ***                                                          
default-time-zone = "SYSTEM"
log_error="C:/logs/mysql/mysql_error.log"
general_log=0
general_log_file="C:/logs/mysql/mysql.log" 
slow_query_log=0
slow_query_log_file="C:/logs/mysql/mysql-slow.log"
[mysqldump]
quick
quote_names
__________________
Easy come Easy go
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -6. The time now is 11:24 PM.


Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright ©2020 - 2021, Runner
Ad Management plugin by RedTyger