MySQL实践总结.ppt

MySQL实践总结罗良珍2010-05-061、在一台数据库上如何跑多个MySQL服务端口?2、f介绍[client]password=a_passwordsocket=/data/dbs/subject/-character-set=gbk[mysqld64010]basedir=/usr/local/mysql-=/usr/local/mysql-=/data/dbs-=64010socket=/data/dbs-、配置文件pid-file=/data/dbs-=mysqllog-slow-queries=/data/dbs-=1log-error=/data/dbs---bin=/data/dbs--bin-files/log-binserver-id=6464010log-slave-updatesskip-name-resolvekey_buffer=2048Mtable_cache=4096thread_cache=8back_log=200一、配置文件thread_concurrency=16max_connections=2000max_connect_errors=200max_allowed_packet=40Msort_buffer=1Mrecord_buffer=1Mmyisam_sort_buffer_size=256Minteractive_timeout=3600wait_timeout=3600max_binlog_size=40Mtmp_table_size=512Mmax_heap_table_size=1500M一、配置文件master-host=-port=6401master-user=slave_usermaster-password=slave_passwordslave-skip-errors=1062[mysqld65020]…一、配置文件1、rpm安装下载服务器和客户端删除现有安装rpm-e--allmatches--nodepsmysql安装新版本mysqlserver和clientrpm-ivhMySQL-munity---ivhMySQL-munity--、安装2、源码安装tar-xzfmysql-./configure–prefix=/usr/local/mysql-–with-charset=gbk–with-extra-charsets=gb2312,utf8–with-mysqld-user=mysql–without-debug–with-mysqld-ldflags=-all-static–enable-assembler–enable-local-infile–enable-thread-safe-client–with-big-tables–with-pthreadmakemakeinstallmakeclean3、初始化二、安装1、MyISAM2、MERGE3、InnoDB4、MEMORY三、表类型1、字符集和校对规则2、如何查看字符集3、如何设置字符集4、如何修改字符集四、字符集1、哪些字段需要建索引2、如何选择索引字段3、短索引4、复合索引5、最左匹配规律6、or的索引使用7、like的索引使用8、索引带来的坏处五、索引