win7安装mysql没反应_求助啊 WIN7下安装mysql出问题老是说未响应~！！

╰半橙微兮° 2022-11-01 05:40 51阅读 0赞

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

\# The following options will be read by the MySQL Server. Make sure that

\# you have installed the server correctly (see above) so it reads this

\# file.

\[mysqld\]

\# The TCP/IP Port the MySQL Server will listen on

port=3306

\#Path to installation directory. All paths are usually resolved relative to this.

basedir="C:/Program Files/MySQL/MySQL Server 5.1/"

\#Path to the database root

datadir="C:/ProgramData/MySQL/MySQL Server 5.1/Data/"

\# The default character set that will be used when a new schema or table is

\# created and no character set is defined

default-character-set=latin1

\# The default storage engine that will be used when create new tables when

default-storage-engine=INNODB

\# Set the SQL mode to strict

sql-mode="STRICT\_TRANS\_TABLES,NO\_AUTO\_CREATE\_USER,NO\_ENGINE\_SUBSTITUTION"

\# The maximum amount of concurrent sessions the MySQL server will

\# allow. One of these connections will be reserved for a user with

\# SUPER privileges to allow the administrator to login even if the

\# connection limit has been reached.

max\_connections=100

\# Query cache is used to cache SELECT results and later return them

\# without actual executing the same query once again. Having the query

\# cache enabled may result in significant speed improvements, if your

\# have a lot of identical queries and rarely changing tables. See the

\# "Qcache\_lowmem\_prunes" status variable to check if the current value

\# is high enough for your load.

\# Note: In case your tables change very often or if your queries are

\# textually different every time, the query cache may result in a

\# slowdown instead of a performance improvement.

query\_cache\_size=0

\# The number of open tables for all threads. Increasing this value

\# increases the number of file descriptors that mysqld requires.

\# Therefore you have to make sure to set the amount of open files

\# allowed to at least 4096 in the variable "open-files-limit" in

\# section \[mysqld\_safe\]

table\_cache=256

\# Maximum size for internal (in-memory) temporary tables. If a table

\# grows larger than this value, it is automatically converted to disk

\# based table This limitation is for a single table. There can be many

\# of them.

tmp\_table\_size=18M

\# How many threads we should keep in a cache for reuse. When a client

\# disconnects, the client's threads are put in the cache if there aren't

\# more than thread\_cache\_size threads from before.   This greatly reduces

\# the amount of thread creations needed if you have a lot of new

\# connections. (Normally this doesn't give a notable performance

\# improvement if you have a good thread implementation.)

thread\_cache\_size=8

\#\*\*\* MyISAM Specific options

\# The maximum size of the temporary file MySQL is allowed to use while

\# recreating the index (during REPAIR, ALTER TABLE or LOAD DATA INFILE.

\# If the file-size would be bigger than this, the index will be created

\# through the key cache (which is slower).

myisam\_max\_sort\_file\_size=100G

\# If the temporary file used for fast index creation would be bigger

\# than using the key cache by the amount specified here, then prefer the

\# key cache method.   This is mainly used to force long character keys in

\# large tables to use the slower key cache method to create the index.

myisam\_sort\_buffer\_size=35M

\# Size of the Key Buffer, used to cache index blocks for MyISAM tables.

\# Do not set it larger than 30% of your available memory, as some memory

\# is also required by the OS to cache rows. Even if you're not using

\# MyISAM tables, you should still set it to 8-64M as it will also be

\# used for internal temporary disk tables.

key\_buffer\_size=25M

\# Size of the buffer used for doing full table scans of MyISAM tables.

\# Allocated per thread, if a full scan is needed.

read\_buffer\_size=64K

read\_rnd\_buffer\_size=256K

\# This buffer is allocated when MySQL needs to rebuild the index in

\# REPAIR, OPTIMZE, ALTER table statements as well as in LOAD DATA INFILE

\# into an empty table. It is allocated per thread so be careful with

\# large settings.

sort\_buffer\_size=256K

win7安装mysql没反应_求助啊 WIN7下安装mysql出问题老是说未响应~！！

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 win7mysql5.7.25安装教程_win7下MySql 5.7安装配置方法图文教程

相关 win7如何安装mysql5.7_WIN764安装mysql5.7

相关 mysql5.7.13 zip win7_MySQL 5.7 Zip 安装（win7）

相关 win7安装mysql没反应_求助啊 WIN7下安装mysql出问题老是说未响应~！！

相关 win7压缩包安装mysql_Win7下安装Mysql（解压缩版）

相关 win7下安装MySQL和myODBC

相关 Mysql5.7在win7下的安装

相关 win7安装mysql

相关 win7安装mysql

相关 Win10下安装Mysql5.7