http://dev.mysql.com/doc/refman/5.6/en/option-files.html
http://dev.mysql.com/doc/refman/5.6/en/server-default-configuration-file.html
5.1.2.1. Changes to Server Defaults
Beginning with MySQL 5.6.6, several MySQL Server parameter defaults differ from the defaults in previous releases. The motivation for these changes is to provide better out-of-box performance and to reduce the need for database administrators to change settings manually.
In some cases, a parameter has a different fixed default value. In other cases, the server autosizes a parameter at startup using a formula based on other related parameters or server host configuration, rather than using a fixed value. For example, the setting for back_log
is its previous default of 50, adjusted up by an amount proportional to the value of max_connections
. The idea behind autosizing is that when the server has information available to make a decision about a parameter setting likely to be better than a fixed default, it will.
The following table summarizes changes to defaults. The Version column indicates when each default changed. For variables that are autosized, the main variable description provides additional detail about the sizing algorithm. See Section 5.1.4, “Server System Variables”, and Section 14.2.6, “InnoDB
Startup Options and System Variables”. Any of these default settings can be overridden by specifying an explicit value at server startup.
Table 5.2. Changes to Server Defaults in MySQL 5.6
In MySQL 5.6.6, the default for innodb_checksum_algorithm
was changed from INNODB
to CRC32
. For compatibility reasons, the default was returned in 5.6.7 to INNODB
.
5.1.2.2. Using a Sample Default Server Configuration File
As of MySQL 5.6.8, on Unix platforms, mysql_install_db creates a default option file named my.cnf in the base installation directory. This file is created from a template included in the distribution package named my-default.cnf. You can find the template in or under the base installation directory. When started usingmysqld_safe, the server uses my.cnf file by default. If my.cnf already exists, mysql_install_db assumes it to be in use and writes a new file named my-new.cnf instead.
With one exception, the settings in the default option file are commented and have no effect. The exception is that the file changes the sql_mode system variable from its default of NO_ENGINE_SUBSTITUTION to also includeSTRICT_TRANS_TABLES:
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
This setting produces a server configuration that results in errors rather than warnings for bad data in operations that modify transactional tables. See Section 5.1.7, “Server SQL Modes”.
The my-default.cnf template replaces the older sample option files formerly supplied with MySQL distributions (my-small.cnf, my-medium.cnf, my-large.cnf, and my-huge.cnf). As of MySQL 5.6.8, these older files are no longer distributed.
On Windows, MySQL Installer interacts with the user and creates a file named my.ini in the base installation directory as the default option file. If you install on Windows from a Zip archive, you can copy the my-default.ini template file in the base installation directory to my.ini and use the latter as the default option file.
Note
On Windows, the .ini or .cnf option file extension might not be displayed.
On any platform, after completing the installation process, you can edit the default option file at any time to modify the parameters used by the server. For example, to use a parameter setting in the file that is commented with a #character at the beginning of the line, remove the #, and modify the parameter value if necessary. To disable a To disable a setting, either add a # to the beginning of the line or remove it.
For additional information about option file format and syntax, see Section 4.2.3.3, “Using Option Files”.
Before MySQL 5.6.8, MySQL distributions include several sample option files that can be used as a basis for tuning the MySQL server. Look for files named my-small.cnf, my-medium.cnf, my-large.cnf, and my-huge.cnf, which are sample files for small, medium, large, and very large systems. On Windows, the extension is.ini rather than .cnf.
For a binary distribution, look for the sample files in or under your installation directory. If you have a source distribution, look in the support-files directory. To use a sample file as a base configuration file, rename a copy of it and place the copy in the appropriate location. Regarding names and appropriate location, see the general information provided in Section 4.2.3.3, “Using Option Files”.
相关推荐
下面开始优化下my.conf文件(这里的优化只是在mysql本身的优化,之前安装的时候也要有优化) cat /etc/my.cnf # For advice on how to change settings please see # ...
2.修改mysql的配置文件my.conf 一般在/etc目录下,运行命令:vi /etc/my.cnf,编辑文件 在文件的[mysqld]标签下添加一句:skip-grant-tables 然后wq!保存退出。 3.重启数据库 运行命令:service mysqld start 4....
--with-mysql --with-mysqli \ --with-openssl --with-zlib --with-curl --with-gd \ --with-jpeg-dir --with-png-dir --with-iconv \ --enable-fpm --enable-zip --enable-mbstring && \ make -j 4 && make ...
环境:Apache 2.4.41 MySQL 5.6.48 PHP-5.6 大家好做一个区块链商城源码的部署搭建视频教程 首先说下环境 可以用宝塔面板一键配置比较简单 这个是搭建环境Apache 2.4.41 MySQL 5.6.48 PHP-5.6 不要搞错了 好教程...
测试环境:Nginx 1.18.0-MySQL5.6.51-PHP-5.6 搭建教程: 1.创建站点,上传源码,解压 2.把数据库信息改成自己的修改文件路径地址:/Application/Common/Conf/db.php 3.导入数据库文件1.sql 4.短信配置:/...
测试环境:Nginx 1.18.0-MySQL5.6.51-PHP-5.6 搭建教程: 1.创建站点,上传源码,解压 2.把数据库信息改成自己的修改文件路径地址:/Application/Common/Conf/db.php 3.导入数据库文件1.sql 4.短信配置:/...
Nginx 1.18.0--MySQL 5.6.50--PHP-5.6--phpMyAdmin 5.0 //PHP7.0安装拓展fileinfo 创建站点,创建数据库并导入 1)设置网站伪静态 /thinkphp 2)数据库配置文件 \App\Common\Conf\config.php 3)修改商户信息...
测试环境:宝塔windows + apache +mysql 5.6 +php5.6 注意:此源码在Linux下因目录大小写问题,可能会导致打不开,建议在windows服务器下搭建。 另外此源码已经修复了令人头痛的被恶意提现的问题,和恶意伪造IP发送...
测试环境:Nginx 1.20.1 MySQL 5.6.50 php7.21.创建站点,上传源码至根目录,设置伪静态规则 thinkphp2.创建数据库并导入3.修改数据库信息:/Application/Common/Conf/db.php4.修改短信及邮箱配置信息:/Application...
1、安装部署环境,PHP 5.5 + mysql 5.6 + IIS 或者 Linux服务器配置为 PHP 5.5 + mysql 5.6 + Apache 2、将data.sql导入到数据库中,在Application/Common/Conf/Config.php中修改数据库连接等相关配置 3、将代码中的...
--with-mysql=mysqlnd\ --with-mysqli=mysqlnd\ --with-pdo-mysql=mysqlnd\ --enable-opcache\ --enable-pcntl\ --enable-mbstring\ --enable-soap\ --enable-zip\ --enable-calendar\ --enable-bcmath\ ...
环境nginx1.18+mysql5.6+php5.6 修改数据库配置 web/Apps/Common/Conf/db.php
环境:宝塔面板 Ng1.18 php7.0 mysql5.6 1,导入数据库文件db.sql到你的数据库 2,修改数据库配置文件 /Application/Common/Conf/config.php 3,配置好伪静态(宝塔里选择thinkphp的规则) 4,宝塔里把运行目录...
安装环境:PHP5.6、MYSQL5.6 安装教程: 1.上传压缩文件、导入数据库文件 2.找到Application/Common/Conf/db.php文件,修改相关数据库信息 3.设置伪静态 location ~* (runtime|application)/{ return 403; } ...
测试环境 PHP7.0+MySQL5.6 数据库修改文件路径 /Application/Common/Conf/config.php 伪静态规则设置为 thinkphp规则 后台登录地址 /Youni 后台登录账户 admin 后台登录密码 123123 详情:http://ban.maonius.cn
请使用 win 系统(注:必须是宝塔面板,虚拟主机不能搭建) apache +php5.6 +mysql5.6 进行安装。 安装说明 1、上传到网站根目录 2、用 phpMyadmin 导入数据库文件.sql 3、修改数据库链接文件 /APP/Conf/config.php ...
单独定制的版本,并未流通过,UI很漂亮,专业的早起打开平台,和之前的那个打卡套理财的,不是一个版本,...测试环境:宝塔面板 + Nginx1.18 + php7.2 + mysql5.6 数据库配置文件 Application/Common/Conf/config.php
测试环境:php5.6+mysql5.6 1、修改数据库配置文件 App\Conf\db.php 2、导入数据库文件 用户:admin 密码:www.jocat.cn https://czqixidi.com/wp-content/uploads/2023/08/image-118-613x1024.png
2. 数据库使用的是mysql5.6, 实例涉及一张表 t_user,请查看sqlScript中的脚本 数据库、用户名可根据具体情况更改,查看 src/conf/jdbc.properties 进行 更改 3. java编译环境 jdk1.6, tomcate 6 4. 该工程使用...
环境:阿帕奇 + mysql5.6 + php7.0(必须7.0并安装 memcache 扩展) 安装步骤: 1.新建站点--》上传--》解压 2.导入数据库文件 3.修改/数据库 /app/Common/Conf/config.php 4. 运行目录设置public 5. 后台地址/cp...