#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html
# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with
# ticks/quotes escpecially if they contain "#" chars...
# Remember to edit /etc/mysql/debian.cnf when changing
# the socket location.
[client]
port =3306
#socket = /var/run/mysqld/mysqld.sock
# Here is entries for some specific programs
# The following values assume you have at least 32M ram
# This was formally known as [safe_mysqld]. Both versions
# are currently parsed.
[mysqld_safe]
#socket = /var/run/mysqld/mysqld.sock
#nice = 0
[mysqld]
#
# * Basic Settings
#
#
# * IMPORTANT
# If you make changes to these settings and your system uses
# apparmor, you may also need to also adjust
# /etc/apparmor.d/usr.sbin.mysqld.
#
#user = mysql
#socket = /var/run/mysqld/mysqld.sock
port =3306
#basedir = /usr
#datadir = /var/lib/mysql
#tmpdir = /tmp
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address =127.0.0.1
#
# * Fine Tuning
#
key_buffer =16M
max_allowed_packet =16M
thread_stack =192K
thread_cache_size =8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover =BACKUP
#max_connections = 100
#table_cache = 64
#thread_concurrency = 10
#
# * Query Cache Configuration
#
query_cache_limit =1M
query_cache_size =16M
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
# As of 5.1 you can enable the log at runtime!
#general_log_file = /var/log/mysql/mysql.log
#general_log = 1
log_error =/var/log/mysql/error.log
# Here you can see queries with especially long duration
#log_slow_queries = /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes
#
# The following can be used as easy to replay backup logs or
# for replication.
# note: if you are setting up a replication slave, see
# README.Debian about other settings you may need
# to change.
#server-id = 1
#log_bin = /var/log/mysql/mysql-bin.log
expire_logs_days =10
max_binlog_size =100M
#binlog_do_db = include_database_name
#binlog_ignore_db = include_database_name
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
#
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem
# Query Caching
query-cache-type=1
# Default to InnoDB
default-storage-engine=innodb
[mysqldump]
quick
quote-names
max_allowed_packet =16M
[mysql]
#no-auto-rehash # faster start of mysql but no tab completition
[isamchk]
key_buffer =16M
相关推荐
rosdep update
Mac OSX MySql 管理工具 Sequel-pro 非常好用,比Mysql Workbench 好用,试试就知道了.
USB 串口 PL2303 MAC OSX 驱动,适用于 OS X 10.9 以上的版本。 Mac OS X Universal Binary Driver v1.6.2 (PKG file format) For Mac OS High Sierra (version 10.15) - see NOTE below. For Mac OS High Sierra ...
Mac OSX的文件系统介绍 各目录说明
苹果电脑安装 Windows 和 Mac_OSX 双系统 苹果电脑作为一款高性能的个人计算机,安装Windows和Mac_OSX双系统可以满足不同用户的需求。 Boot Camp 是苹果电脑系统自带的双系统安装工具,可以帮助用户安装Windows和...
【MAC版本】mysql-5.5.53-osx10.9-x86_64.dmg 官网下载巨慢,放这里加速下载方便使用
自制服务 许基于包装器控制服务从Node.js的MACOS要求安装了Brew的OSX Node.js 7.6以上安装npm install --save homebrew-services用法列出所有服务返回所有服务及其已启动或已停止状态的Map。 const brew = require ...
homebrew-universal-ctags, 在OSX上,Homebrew 点击通用 Ctags Homebrew 点击通用 Ctags由于官方 Exuberant source源source活动,它被分叉并更名为通用 Ctags,可以在 https://github.com/universal-ctags/ct
### 硬盘安装Mac OSx #### 概述 本文档主要介绍如何在Windows XP系统环境下使用特定工具实现Mac OSx(版本10.5.6)的硬盘安装过程。这一过程涉及到多个步骤和技术要点,包括使用Mac硬盘安装助手软件来写入Mac安装...
在 MAC OSX 中安装 ZooKeeper 需要使用 Homebrew 工具。Homebrew 是一个流行的包管理器,能够帮助用户快速安装和管理软件包。 首先,需要安装 Homebrew,然后使用以下命令安装 ZooKeeper: ``` brew install ...
【Mac OSX 音乐汇】是一款专为Mac OS X操作系统设计的音乐聚合应用,它集成了多个知名在线音乐服务,包括音悦TV、虾米电台、百度音乐和豆瓣电台等,为用户提供了丰富的音乐资源和便捷的收听体验。这款应用旨在让Mac...
双击mysql-8.0.0-dmr-osx10.11-x86_64.dmg进行解压, 安装。 Continue -> Continue, Agree -> Install。记录下来弹窗中的密码。 进入系统偏好设置, 找到mysql, 启动服务 将mysql的命令添加到系统中 (1).进入/usr/...
polycom 宝利通 的Mac OSX客户端,可以PC到会议系统,PC跟PC之间视频通话。这个是官方账户里下载的最新版本。安全可靠,十分难得,值得收藏
Mac OS X Universal Binary Driver v1.6.2 (PKG file format) For Mac OS High Sierra (version 10.15) - see NOTE below. For Mac OS High Sierra (version 10.14) For Mac OS High Sierra (version 10.13) ...
根据提供的文件信息,我们可以深入探讨与“osx 10.10.5--osx 10.13.6原版镜像”相关的知识点。这些操作系统版本都是苹果公司推出的Mac OS X(现更名为macOS)的重要更新,涵盖了从Yosemite到High Sierra的多个版本。...
压缩包中的文件名`mysql-connector-c-6.0.2-osx10.5-x86-64bit`表明这是MySQL Connector/C的6.0.2版本,针对的是Mac OS 10.5(Leopard)或更高版本的64位系统。尽管文件名为osx10.5,但在实际中,它通常也能在更新...
本文将详细讲解如何使用提供的解锁文件在 VMware 上安装 Mac OSX 系统,以及涉及到的关键知识点。 首先,我们要理解的是,Mac OSX 通常只允许在其官方认可的苹果硬件上运行,这被称为苹果的“苹果操作系统独占”...
适用于 Mac OSX x86 64 位的 MySQL 服务器 5.6 在应用程序目录中的当前用户下安装并运行。 npm install mysql-server-5.6-osx-x64 提供用于生成具有可选配置设置的 MySQL 服务器实例的功能。 返回 。 每个应用...