九色国产,午夜在线视频,新黄色网址,九九色综合,天天做夜夜做久久做狠狠,天天躁夜夜躁狠狠躁2021a,久久不卡一区二区三区

df -h

ls -lh

TopicNewController.getTopicSoftList() error='Java heap space From class java.lang.OutOfMemoryError'appstore_apitomcat

.bin.tgz---.bin.tar--.bin

# 內(nèi)存OOM時(shí)，自動(dòng)生成dump文件 -XX:+HeapDumpOnOutOfMemoryError -XX:HeapDumpPath=/data/logs/

2020-10-27T20:27:57.733+0800: 639877.297: [Full GC (Heap Inspection Initiated GC) 2020-10-27T20:27:57.733+0800: 639877.297: [CMS: 165992K->120406K(524288K), 0.7776748 secs] 329034K->120406K(1004928K), [Metaspace: 178787K->178787K(1216512K)], 0.7787158 secs] [Times: user=0.71 sys=0.00, real=0.78 secs] 

@Transactional(rollbackFor = Exception.class)void saveOrUpdate(MeetingInfo info) {    // insert ignore into table values (...)    int result = mapper.insertIgnore(info);    if (result>0) {       return;    }    // update table set xx=xx where id = xx    mapper.update(info);}

DROP TABLE IF EXISTS `emp`;CREATE TABLE `emp` (`id` int(11) NOT NULL AUTO_INCREMENT,`salary` int(10) DEFAULT NULL,`name` varchar(255) DEFAULT NULL,PRIMARY KEY (`id`),KEY `idx_name` (`name`(191)) USING BTREE) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;

排序數(shù)據(jù)庫連接的數(shù)目 mysql -h127.0.0.0.1 -uabc_test -pXXXXX -P3306 -A -e 'show processlist'| awk '{print $4}'|sort|uniq -c|sort -rn|head -10

select * from table where name = 'a'

 select * from table where ?;

SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;  -- READ UNCOMMITTED/READ COMMITTED/REPEATABLE READ/SERIALIZABLE

DROP TABLE IF EXISTS `employee`;CREATE TABLE `employee` (  `id` int(11) NOT NULL,  `name` varchar(50) NOT NULL,  `salary` int(11) DEFAULT NULL,  KEY `IDX_ID` (`id`) USING BTREE) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ------------------------------ Records of employee-- ----------------------------INSERT INTO `employee` VALUES ('10', '1s', '10');INSERT INTO `employee` VALUES ('20', '2s', '20');INSERT INTO `employee` VALUES ('30', '3s', '30');

-- select操作均不加鎖，采用的是快照讀，因此在下面的討論中就忽略了SQL1：select * from t1 where id = 10;SQL2：delete from t1 where id = 10;

performance_schema.global_variables performance_schema.session_variables performance_schema.variables_by_thread performance_schema.global_status performance_schema.session_status performance_schema.status_by_thread performance_schema.status_by_account performance_schema.status_by_host performance_schema.status_by_user

# 查詢慢SQL查詢是否開啟show variables like 'slow_query_log';# 查詢慢SQL的時(shí)間show variables like 'long_query_time';# 查看慢SQL存放路徑，一般：/home/mysql/data3016/mysql/slow_query.logshow variables like 'slow_query_log_file';
# 查看數(shù)據(jù)庫的事務(wù)隔離級(jí)別,RDS:READ-COMMITTED   Mysql:Repeatable readshow variables like 'tx_isolation';  # innodb數(shù)據(jù)頁大小  16384show variables like 'innodb_page_size'; 
show status  like 'innodb_row_%';
# 查看慢SQLSHOW SLOW limit 10;show full slow limit 10;
# 查看autocommit配置select @@autocommit;  # 同上show variables like 'autocommit'; #設(shè)置SQL自動(dòng)提交模式  1:默認(rèn),自動(dòng)提交   0:需要手動(dòng)觸發(fā)commit,否則不會(huì)生效set autocommit=1;　　# 查看默認(rèn)的搜索引擎show variables like '%storage_engine%'; 
# 設(shè)置事務(wù)隔離級(jí)別SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;

maxmemory xxxxxx

maxmemory-policy allkeys-lru

Sampled 122114 keys in the keyspace!Total key length in bytes is 3923725 (avg len 32.13)

Biggest string Key Top   1  found 'xx1' has 36316 bytesBiggest string Key Top   2  found 'xx2' has 1191 bytesBiggest string Key Top   3  found 'xx3' has 234 bytesBiggest   list Key Top   1  found 'x4' has 204480 itemsBiggest   list Key Top   2  found 'x5' has 119999 itemsBiggest   list Key Top   3  found 'x6' has 60000 itemsBiggest    set Key Top   1  found 'x7' has 14205 membersBiggest    set Key Top   2  found 'x8' has 292 membersBiggest    set Key Top   3  found 'x,7' has 21 membersBiggest   hash Key Top   1  found 'x' has 302939 fieldsBiggest   hash Key Top   2  found 'xc' has 92029 fieldsBiggest   hash Key Top   3  found 'xd' has 39634 fields

rdb -c memory dump.rdb -t list -f dump-formal-list.csv

debug object key 

# 配置查詢時(shí)間超過1毫秒的， 第一個(gè)參數(shù)單位是微秒config set slowlog-log-lower-than 1000
# 保存200條慢查記錄config set slowlog-max-len 200

maxclients 10000

[rgp@iZ23rjcqbczZ ~]$ /data/program/redis-3.0.3/bin/redis-cli -c -h <ip> -p <port>ip:port> cluster nodes9f194f671cee4a76ce3b7ff14d3bda190e0695d5 m1 master - 0 1550322872543 65 connected 10923-16383a38c6f957f2706f269cf5d9b628586a9372265e9 s1 slave 9f194f671cee4a76ce3b7ff14d3bda190e0695d5 0 1550322872943 65 connected77ce43ec23f25f77ec68fe71ae3cb799e7300c6d s2 slave 03d72a3a5050c85e280e0bbeb687056b84f10077 0 1550322873543 63 connected03d72a3a5050c85e280e0bbeb687056b84f10077 m2 master - 0 1550322873343 63 connected 5461-109225799070c6a63314296f3661b315b95c6328779f7 :0 slave,fail,noaddr 6147bf416ef216b6a1ef2f100d15de4f439b7352 1550320811474 1550320808793 49 disconnected6147bf416ef216b6a1ef2f100d15de4f439b7352 m3 myself,master - 0 0 49 connected 0-5460

[rgp@iZ23rjcqbczZ ~]$ /data/program/redis-3.0.3/bin/redis-trib.rb del-node m3 b643d7baa69922b3fdbd1e25ccbe6ed73587b948>>> Removing node b643d7baa69922b3fdbd1e25ccbe6ed73587b948 from cluster m3>>> Sending CLUSTER FORGET messages to the cluster...>>> SHUTDOWN the node.

/data/program/redis-3.0.3/bin/redis-server /data/program/redis-3.0.3/etc/7001/redis.conf &

netstat -n|grep SYN_RECV

netstat -n | awk '/^tcp/ {++S[$NF]} END {for(a in S) print a, S[a]}'

netstat -nap | grep SYN_RECV

cat error.log|grep -n ' java.lang.reflect.InvocationTargetException'