欢迎来到Doc100.Net免费学习资源知识分享平台!
您的位置:首页 > 程序异常 >

关于mysql5.6.13的一个疑义

更新时间: 2014-01-05 02:09:45 责任编辑: Author_N1

 

关于mysql5.6.13的一个疑问

现在在做一个系统

使用了这么一个查询

select a.id,a.fdate,a.fbillno,e.fname as fwarehousename,a.fnote,c.fname as fsupplyname,d.fname as fdeptname,a.fempname,b.fid,b.fname,b.fnumber,b.fprice,b.famount,a.fyear,a.fperiod,a.fbillerid,b.fac,a.voucherid from stockbill a right join entry b on a.fbillno=b.fbillno left join supplier c on a.fsupplyid=c.fid left join department d on a.fdeptid=d.fid left join warehouse e on a.fwarehouse=e.fid where a.fbilltypeid='1' and a.fdeleted=0 and b.fbilltypeid='1' and a.fdate>='2013-07-01' and a.fdate<='2013-07-31' and b.fdate>='2013-07-01' and b.fdate<='2013-07-31' order by a.fdate desc,a.fbillno desc

我用同样的配置

发现mysql 5.5.33进行了缓存,另一个mysql 5.6.13没有缓存到,很奇怪

使用show status like 'Qcache',发现运行了一天后

Qcache_hits值为0

但是5.5.33运行一会就有了数据

my.ini的内容如下:

[mysqld]
# generic configuration options
port  = 3306
basedir=D:/wamp/mysql
datadir=D:/wamp/data5/
tmpdir=D:/wamp/tmp/
#change1 character-set-server=utf8
#character_set_server=utf8 either is ok
character-set-server=utf8
#change 2 无法使用
#table_cache=2048
wait_timeout=60
interactive_timeout=30
skip-name-resolve
bind-address=0.0.0.0
innodb_file_per_table=1
innodb_open_files=2048

back_log = 500

max_connections = 50

max_connect_errors = 100

table_open_cache = 2048

max_allowed_packet = 32M

binlog_cache_size = 1M

max_heap_table_size = 256M

read_buffer_size = 16M

read_rnd_buffer_size = 16M

sort_buffer_size = 16M

join_buffer_size = 32M

thread_cache_size = 64

thread_concurrency =4

query_cache_size = 128M

query_cache_limit = 2M

ft_min_word_len = 4

default-storage-engine = Innodb

thread_stack = 192K

# Set the default transaction isolation level. Levels available are:
# READ-UNCOMMITTED, READ-COMMITTED, REPEATABLE-READ, SERIALIZABLE
#change 11 事务隔离级别
#transaction_isolation = REPEATABLE-READ

tmp_table_size = 256M

max_tmp_tables=512

slow-query-log=1

long_query_time = 2

slow-query-log-file=slow.log

server-id = 1

#*** MyISAM Specific options


key_buffer_size = 128M

bulk_insert_buffer_size = 64M

myisam_sort_buffer_size = 128M

myisam_max_sort_file_size=2048M

myisam_repair_threads = 1

myisam_recover

# *** INNODB Specific options ***

innodb_additional_mem_pool_size = 16M

innodb_buffer_pool_size =2048M

innodb_data_file_path = ibdata1:10M:autoextend

innodb_write_io_threads = 8
innodb_read_io_threads = 8

innodb_thread_concurrency =4

innodb_flush_log_at_trx_commit = 0

innodb_log_buffer_size = 8M

innodb_log_file_size = 128M

innodb_log_files_in_group = 2

innodb_max_dirty_pages_pct = 80

innodb_lock_wait_timeout = 60


 

 

上一篇:上一篇
下一篇:下一篇

 

随机推荐程序问答结果

 

 

如对文章有任何疑问请提交到问题反馈,或者您对内容不满意,请您反馈给我们DOC100.NET论坛发贴求解。
DOC100.NET资源网,机器学习分类整理更新日期::2014-01-05 02:09:45
如需转载,请注明文章出处和来源网址:http://www.doc100.net/bugs/t/6396/
本文WWW.DOC100.NET DOC100.NET版权所有。