我的复制mysql数据库,由amazonrds极光托管,性能很差。db非常强大,所以性能应该不是问题。
当我执行死刑的时候
SHOW VARIABLES;
我找不到innodb\u buffer\u pool\u size。怎么会这样?我怀疑这个参数与性能不佳有关。
以下是我的配置变量:
变量名称值aurora\u lab\u mode off aurora\u load\u from\u s3\u role
aurora\u max\u alter\u table\u log\u entries 1000 aurora\u max\u connections\u limit 16000 aurora\u select\u into\u s3\u role
aurora\u服务器\u id表aurora\u在aurora\u版本1.17.2上使用\u密钥\u预取自动\u增量\u增量1自动\u增量\u偏移量1自动提交自动\u sp\u权限在aws上\u默认\u lambda\u角色aws\u默认\u s3\u角色awsauthenticationplugin\u最大后退\u延迟2000 awsauthenticationplugin\u最大重试\u计数3 awsauthenticationplugin\u重试\u延迟250后退\u日志650 basedir/rdsdbbin/oscar/big\u tables off bind\u addressbinlog\u cache\u size 32768 binlog\u checksum crc32 binlog\u direct\u non\u transactional\u updates off binlog\u format statement binlog\u max\u flush\u queue\u time 0 binlog\u order\u commits on binlog\u row\u image full binlog\u rows\u query\u log\u events off binlog\u stmt\u cache\u size 32768 bulk\u insert\u buffer size 8388608字符集\客户端utf8字符集\连接utf8字符集\数据库拉丁1字符集\文件系统二进制字符集\结果utf8字符集\服务器拉丁1字符集\系统utf8字符集\目录排序规则\连接utf8 \常规ci排序规则\数据库拉丁1瑞典ci排序规则\服务器拉丁1瑞典ci完成类型\无\u链并发\u插入自动连接\u超时10核心\u文件在datadir/rdsdbdata/db/date \u格式%y-%m-%d datetime \u格式%y-%m-%d%h:%i:%s默认\u存储\u引擎innodb默认\u tmp \u存储\u引擎innodb默认\u周\u格式0延迟\u键写入延迟\u插入\u限制100延迟\u插入\u超时300延迟\u队列大小1000断开连接\u打开\u过期\u密码打开\u精度\u增量4结束\u标记\u在\u json关闭强制\u gtid \u一致性关闭eq \u范围\u索引\u下降\u限制10错误\u计数0事件\u调度程序关闭过期\u日志\u天数0显式\u默认值\u外部\u用户的\u时间戳
flush off flush\u time 0 foreign\u key\u检查ft\u boolean\u语法+-><()~:\“&|”ft\u max\u word\u len 84 ft\u min\u word\u len 4 ft\u query\u expansion\u limit 20 ft\u stopword\u file(内置)general\u log off general\u log file/rdsdbdata/log/general/mysql-general.log group\u concat\u max\u len 1024 gtid\u executed
gtid\模式关闭gtid\下一个自动gtid\拥有
gtid \u pulled have \u compress yes have \u crypt yes have \u dynamic \u loading yes have \u geometry yes have \u openssl yes have \u profiling yes have \u query \u cache yes have \u rtree \u keys yes have \u ssl yes have \u symlink host \u cache size 128 hostnameidentity 0 ignore \u builtin \u innodb off ignore \u db \u dirs
忽略默认存储引擎错误关闭初始化连接
初始化文件
初始化从机
innodb\u adaptive\u flushing on innodb\u adaptive\u flushing\u lwm 10 innodb\u adaptive\u hash\u index off innodb\u adaptive\u max\u sleep\u delay 150000 innodb\u additional\u mem\u pool\u size 8388608 innodb\u api\u bk\u commit\u interval 5 innodb\u api\u disable\u rowlock off innodb\u api\u enable\u binlog off innodb\u api\u enable\mdl off innodb\u api\u trx\u level 0 innodb\u aurora\u enable\u auto\u akp offinnodb\u autoextend\u increment 64 innodb\u autoinc\u lock\u mode 1 innodb\u buffer\u pool\u dump\u关闭innodb\u buffer\u pool\u dump\u现在关闭innodb\u buffer\u pool\u文件名ib\u buffer\u pool innodb\u buffer\u pool\u示例8 innodb\u buffer\u pool\u load\u中止innodb\u buffer\u pool\u load\u启动时关闭innodb\u buffer\u pool\u load\u现在关闭innodb\u change\u buffer\u max\u size 25innodb\u change\u buffering none innodb\u checksum\u algorithm none innodb\u checksums off innodb\u cmp\u per\u index\u enabled off innodb\u commit\u concurrency 0 innodb\u compression\u failure\u threshold\u pct 5 innodb\u compression\u level 6 innodb\u compression\u pad\u pct\u max 50 innodb\u concurrency\u tickets 5000 innodb\u data\u file\u path ibdata1:12m:autoextend innodb\u data\u home\u dir
innodb\ u disable\ u sort\ u file\ u cache off innodb\ u doublewrite off innodb\ u fast\ u shutdown 1 innodb\ u file\ u format antelope innodb\ u file\ u format\ u check on innodb\ u file\ u format\ u max antelope innodb\ u file\ u per\ u table on innodb\ u flush\ u log\ u at\ u timeout 1 innodb\ u flush\ u log\ at\ u trx\ u commit 1 innodb\ u flush\方法o\ u direct innodb\ u flush\ u neighbories 1 innodb\ u flush\ u avg\ u loops 30innodb\ u force\ u load\ u corrupted off innodb\ u force\ u recovery 0 innodb\ u ft\ u aux\ u table innodb\ u ft\ u cache\ size 8000000 innodb\ u ft\ u enable\ u diag\ u print off innodb\ u ft\ u enable\ u stopword on innodb\ u ft\ u max\ u token size 84 innodb\ u ft\ u min\ u token size 3 innodb\ u ft\ u num\ u word\ u optimize 2000 innodb\ u ft\ u result\ u cache\ u limit 2000000000 innodb\ u ft\ u server\ u stopword\ u tableinnodb\u ft\u sort\u pll\u degree 2 innodb\u ft\u total\u cache\u size 640000000 innodb\u ft\u user\u stopword\u表
innodb\u io\u容量200 innodb\u io\u容量\u最大2000 innodb\u大前缀off innodb\u lock\u wait\u超时50 innodb\u locks\u unsafe\u for\u binlog off innodb\u log\u buffer大小8388608 innodb\u log\u file大小50331648 innodb\u log\u files\u in\u group 2 innodb\u log\u group\u home\u dir./innodb\u lru scan深度1024 innodb\u max\u dirty\u pages\u pct 75 innodb\u max\u dirty\u pages\u pct\u lwm 0innodb\u max\u purge\u lag 0 innodb\u max\u purge\u lag\u delay 0 innodb\u mirrored\u log\u groups 1 innodb\u monitor\u disable
innodb\监视器\启用
innodb\监视器\重置
innodb\u监视器\u重置\u所有
innodb\u old\u blocks\u pct 37 innodb\u old\u blocks\u time 1000 innodb\u online\u alter\u log\u max\u size 134217728 innodb\u open\u files 6000 innodb\u optimize\u fulltext\u only off innodb\u page\u size 16384 innodb\u print\u all\u死锁off innodb\u purge\u batch\u size 900 innodb\u purge\u threads 3 innodb\u random\u read\u off innodb\u read\u ahead\u threshold 56 innodb\u read\u线程16innodb\u read\u read only off innodb\u replication\u delay 0 innodb\u rollback\u on\u timeout off innodb\u rollback\u segments 128 innodb\u shared\u buffer\u pool\u uses\u innodb\u sort\u buffer\u size 1048576 innodb\u spin\u wait\u delay 6 innodb\u stats\u auto\u recalc on innodb\u stats\u method nulls\u equal innodb\u stats\u on\u metadata off innodb\u stats\u persistent oninnodb\u stats\u persistent\u sample\u pages 20 innodb\u stats\u sample\u pages 8 innodb\u stats\u transient\u sample\u pages 8 innodb\u strict\u mode off innodb\u support \u xa on innodb\u sync\u array\u size 1 innodb\u sync\u spin\u loops 30 innodb\u table\u锁on innodb\u thread\u并发0 innodb\u thread\u sleep\u delay 10000 innodb\u undo\u目录。innodb\u undo\u logs 128 innodb\u undo\u tablespaces 0 innodb\u use\u native\u aio off innodb\u use\u sys\u malloc on innodb\u version 1.2.10 innodb\u write\u io\u threads 4 insert\u id 0 interactive\u timeout 28800 join\u buffer\u size 262144 keep\u files\u on\u create off key\u buffer\u size 16777216 key\u cache age\u threshold 300 key\u cache\u block\u size 1024 key\u cache\u division\u limit 100大\u文件\u支持大\u页面\u大小0大\u页面关闭上次\u插入\u id 0 lc\u消息en\u us lc\u消息\u dir*lc\u时间\u名称en\u us许可证gpl本地\u填充打开锁定\u等待\u超时31536000锁定在\u内存中关闭日志\u bin关闭日志\u bin\u basename
日志索引
log\u bin\u trust\u function\u creators off log\u bin\u use\u v1\u row\u events off log error/rdsdbdata/log/error/mysql-error.log log\u output table log\u querys\u not\u using off log\u slave更新on log\u throttle\u querys\u not使用索引0 log\u warnings 1 long\u query time 10 low\u priority更新off lower\u file\u system off lower\u case\u table\u names 0master\u info\u repository table master\u verify\u checksum off max\u allowed\u packet 4194304 max\u binlog\u cache大小1.84467e+19 max\u binlog\u大小134217728 max\u binlog\u stmt\u cache大小1.84467e+19 max\u connect errors 100 max\u connections 3000 max\u delayed\u threads 20 max\u digest\u length 1024 max\u error\u count 64 max\u heap\u table大小16777216 max\u insert\u delayed\u threads 20最大\u连接\u大小1.84467e+19最大\u长度\u排序\u数据1024最大\u准备\u测试\u计数16382最大\u中继\u日志大小0最大\u查找\u密钥1.84467e+19最大\u排序长度1024最大\u sp \u递归\u深度0最大\u tmp \u表32最大\u用户\u连接0最大\u写锁\u计数1.84467e+19元数据\u锁\u缓存大小1024最小\u检查行\u限制0多\u范围\u计数256myisam\u数据\u指针\u大小6 myisam\u最大\u排序\u文件大小9.22337e+18 myisam\u mmap\u大小1.84467e+19 myisam\u恢复\u选项关闭myisam\u修复\u线程1 myisam\u排序\u缓冲区大小8388608 myisam\u统计\u方法为空\u不相等的myisam\u使用\u mmap off net\u缓冲区长度16384 net\u读取\u超时30 net\u重试\u计数10 net\u写入\u超时60 new off old off old\u alter\u表关闭旧\u密码0打开\u文件\u限制65535优化器\u修剪\u级别1优化器\u搜索\u深度62优化器\u切换索引\u合并=打开,索引\u合并\u联合=打开,索引\u合并\u排序\u联合=打开,索引\u合并\u交叉=打开,引擎\u条件\u下推=打开,索引\u条件\u下推=打开,mrr=打开,mrr \u成本\u基于=打开,块\u嵌套\u循环=打开,批处理\u键\u访问=关闭,物化=打开,semijoin=on,loosescan=on,firstmatch=on,subquery\u materialization\u cost\u based=on,use\u index\u extensions=on,hash\u join=on,hash\u join\u cost\u based=on optimizer\u trace enabled=off,one\u line=off optimizer\u trace\u features greedy\u search=on,range\u optimizer=on,dynamic\u range=on,重复\u subselect=on optimizer\u trace\u limit 1 optimizer\u trace\u max\u mem size 16384 optimizer\u trace\u offset-1 performance\u schema off performance\u schema\u auto\u on performance\u schema\u accounts\u size 100 performance\u schema\u digests\u size 10000 performance\u schema\u events\u history\u long\u size 10000 performance\u schema\u events\u history\u size 10性能\架构\事件\语句\历史\长\大小10000性能\架构\事件\语句\历史\大小10性能\架构\事件\等待\历史\长\大小10000性能\架构\事件\等待\历史\大小10性能\架构\主机\大小100性能\架构\最大条件\类80性能\架构\最大条件\示例52160性能\架构\最大\摘要\长度1024性能\架构\最大\文件\类50性能\架构\最大\文件\处理32768性能\架构\最大\文件\示例92616性能\架构\最大\互斥体\类200性能\架构\最大\互斥体\示例319090性能\架构\最大\ rwlock \类40性能\架构\最大\ rwlock \示例126430性能\架构\最大\套接字\类10个性能\架构\最大\套接字\示例6050个性能\架构\最大\阶段\类150个性能\架构\最大\语句\类177个性能\架构\最大\表\处理12000个性能\架构\最大\表\示例25000个性能\架构\最大\线程\类50个性能\架构\最大\线程\示例6130性能\架构\会话\连接\属性\大小512性能\架构\设置\参与者\大小100性能\架构\设置\对象\大小100性能\架构\用户\大小
暂无答案!
目前还没有任何答案,快来回答吧!