mysql 5.1 configure 编译参数详解
-static 13%
--with-client-ldflags=-all-static
--with-mysqld-ldflags=-all-static
静态链接提高13%性能
Unix Socket 7.5%
--with-unix-socket path=/usr/local/mysql/tmp/mysql.sock
使用unix套接字链接提高7.5%性能，所以在windows下mysql性能肯定不如unix下面
--enable-assembler
The --enable-assembler options of configure allows for
compiling in x86 (and sparc) versions of common
string
operations, which should result in more
performance.
汇编x86的普通操作符，可以提高性能
--with-extra-charsets
=complex字符支持
--enable-thread-safe-client
#Compile the client with
threads. 也就是让客户端支持线程的意思
--with-big-tables
There is a limit of 232
(~4.295E+09) rows in a MyISAM
table. If you build MySQL
with the --with-big-tables
option, the
row limitation is increased to (232
)2
(1.844E+19) rows
--with-ssl
--with-embedded-server
#编译成embedded MySQL library (libmysqld.a
),
--enable-local-infile
#让mysql支持从本地文件 导入数据库
load data local infile '/usr/test' into table test fields terminated by ' ';
ERROR 1148 (42000): The used command is
not allowed with this
MySQL version）
--with-plugins=innobase
存储引擎
Mysql5.1开始，编译添加innodb插件就从--with-innodb 改成了 --with-plugins=innobase
--with-plugins=PLUGIN[[[,PLUGIN..]]]
Plugins to include in
mysqld. (default
is
: none)
相关文档：
#两日期/时间之间相差的天数：
To_Days(end_time)-To_Days(start_time)
#两日期/时间之间相差的秒数：
SELECT UNIX_TIMESTAMP(end_time)- UNIX_TIMESTAMP(start_time);
#两日期/时间之间相差的时分数：
SELECT SEC_TO_TIME(UNIX_TIMESTAMP(end_time)- UNIX_T ......
mysql 大对象存取:
类型一般应该用mediumblod,
blob只能存2的16次方个byte,
mediumblod是24次方,
一般来说够用了.longblob是32次方有些大.
MYSQL默认配置只能存1M大小的文件,要修改配置,WIN版本的在mysql.ini文件中
修改max_allowed_packet,net_buffer_length等几个参数,或直接SET GLOBAL varName=value.
linux版� ......
To shut down the cluster, enter the following command in a shell
on the machine hosting the management node:
shell> ndb_mgm -e shutdown
The -e
option here is used to pass a command to
the ndb_mgm
client from the shell. (See
Section 4.23, “ ......
以下转自 Osss.cn 邮件，请使用过、正在使用或者支持开源的朋友支持一下MySql，谢谢。
也希望教育部、科技部给予直接支持！
大家好：今天看到这则新闻，与大家共享一下，MySQL创始人希望中国商务部能介入Oracle&Sun收购案，好像并没有实质进展。而俄罗斯联邦反垄断机构在上周展开调查。如果需要商务� ......
