如何提高Nginx Web服务器的安全性
and redirect packets net.ipv4.conf.all.log_martians = 1net.ipv4.conf.default.log_martians = 1 # No source routed packets herenet.ipv4.conf.all.accept_source_route =0 net.ipv4.conf.default.accept_source_route =0# Turn on reverse path filteringnet.ipv4.conf.all.rp_filter = 1net.ipv4.conf.default.rp_filter = 1 # Make sure no one can alter the routing tablesnet.ipv4.conf.all.accept_redirects =0 ...as a router net.ipv4.ip_forward =0 net.ipv4.conf.all.send_redirects =0 net.ipv4.conf.default.send_redirects =0# Turn on execshild kernel.exec-shield = 1 kernel.randomize_va_space = 1 # Tuen IPv6net.ipv6.conf.default.router_solicitations =0 net.ipv6.conf.default.accept_ra_rtr_pref =0 net.ipv6.conf.default.accept_ra_pinfo =0 net.ipv6.conf.default.accept_ra_defrtr =0 net.ipv6.conf.default.autoconf =0 net.ipv6.conf.default.dad_transmits =0 net.ipv6.conf.default.max_addresses = 1 # Optimization for port usefor LBs # Increase system file descriptor limit fs.file-max = 65535 # Allow for more PIDs(to reduce rollover problems)...
云虚拟主机支持的数据库版本
产品参数 独享基础增强版 独享标准增强版/独享高级增强版/独享豪华增强版 支持的操作系统 Linux Windows Linux Windows 支持的站点语言 PHP 5.3/5.4/5.5/5.6/7.0/7.1/7.2/7.4/8.0 HTML WAP ASP ASP.NET 2.0/3.5/4.0/4.8 HTML WAP ASP.NET ...
查询改写功能
物化视图创建语句如下：CREATE MATERIALIZED VIEW mv5 REFRESH NEXT now()+INTERVAL 1 day ENABLE QUERY REWRITE AS SELECT p.type,p.partkey,ps.suppkey FROM part AS p,partsupp AS ps WHERE p.partkey=ps.partkey;开启物化视图改写功能...
在函数中配置官方公共层
README.md Python36 Custom Python 3.6.15运行时层 README.md Python36-Package-Collection Custom Python 3.6.15的常用依赖库集合 README.md Dotnet6 Custom ASP.NET 6.0.5运行时层 README.md PHP81 Custom PHP 8.1运行时层 README.md ...
类型转换
5.0 as f1,1 as f2 from dual union all select false as f0,3.0 as f1,1 as f2 from dual union all select true as f0,4.0 as f1,1 as f2 from dual union all select false as f0,3.0 as f1,1 as f2 from dual union all select true as...
混合负载HTAP的实践和优化
io=1.0,net= 4.75,id=163602164|LogicalView(tables="[000000-000003].sbtest1_[00-15]",shardCount=16,sql="SELECT `id`,`k` FROM `sbtest1` AS `sbtest1` WHERE(`id`>?rowcount=1.0,cumulative cost=value=2.3755002E7,cpu=2.0,memory=...
重组分区
具体用法如下所示：表级用法#基于表名字进行表级的分区变更操作 ALTER TABLE l_t1/*表名*/REORGANIZE PARTITION p0,p1 INTO(PARTITION p3 VALUES IN(2020,2021,2022,2023,2024),PARTITION p4 VALUES IN(2025,2026,2027,2028,2029));...
外键
本文介绍了外键的使用方法。重要 由于在分区表上检查和维护外键约束的实现比单机数据库更为复杂，不合理的外键使用可能会导致较大的性能开销，导致系统吞吐显著下降。应用在性能敏感的场景之前，建议您对数据进行充分验证和全面测试后谨慎...
EXPLAIN
[00-15]",shardCount=16,sql="SELECT `L_ORDERKEY`,COUNT(*)AS `count(*)` FROM `lineitem` AS `lineitem` GROUP BY `L_ORDERKEY`"):rowcount=2508.0,cumulative cost=value=2.4860068E7,cpu=105038.0,memory=29796.0,io=201.0,net= 4.75,...
皮尔森系数
否 示例 输入表 create table pai_pearson_test_input as select*from(select 1.0 as f0,0.11 as f1 union all select 2.0 as f0,0.12 as f1 union all select 3.0 as f0,0.13 as f1 union all select 5.0 as f0,0.15 as f1 union all ...
创建部分索引
CREATE TABLE tenants(id INT,date DATE,count INT,KEY ind_id(id)(partition p0,partition p1(subpartition p1_1,subpartition p1_2,subpartition p1_3)),KEY ind_date(date)(partition p0(subpartition p0_1,subpartition p0_2),...
聚类模型评估
cluster_evaluation_test_input as select*from(select 1 as id,1 as f0,2 as f3 from dual union all select 2 as id,1 as f0,3 as f3 from dual union all select 3 as id,1 as f0,4 as f3 from dual union all select 4 as id,0 as f0,3...
K近邻
knn_test_input as select*from(select 1 as f0,2 as f1,'good' as class from dual union all select 1 as f0,3 as f1,'good' as class from dual union all select 1 as f0,4 as f1,'bad' as class from dual union all select 0 as f0,3...
逻辑回归二分类
cast(0 as double)as f1,cast(0 as double)as f2,cast(1 as double)as f3,cast(1 as bigint)as label from dual union all select cast(1 as double)as f0,cast(0 as double)as f1,cast(0 as double)as f2,cast(0 as double)as f3,cast(0 ...
修改部分索引
为 tenants 分区表中的二级分区 p0_3 和 p0_4 添加部分索引 ind_date。ALTER TABLE tenants ALTER INDEX ind_date ADD partition p0_3,p0_4;重建 tenants 分区表中的二级分区 p0_1 和 p1_1 上的部分索引 ind_date。ALTER TABLE tenants ...
如何分析及优化慢SQL
orders,nation where s_suppkey=l_suppkey and ps_suppkey=l_suppkey and ps_partkey=l_partkey and p_partkey=l_partkey and o_orderkey=l_orderkey and s_nationkey=n_nationkey and p_name like '%yellow%')as profit group by nation,o...
Table2KV
create table test as select*from(select 0 as rowid,1 as col0,1.1 as col1,2 as col2 from dual union all select 1 as rowid,0 as col0,1.2 as col1,3 as col2 from dual union all select 2 as rowid,1 as col0,2.3 as col1,4 as col2...
预测
rf_test_input as select*from(select 1 as f0,2 as f1,"good"as class from dual union all select 1 as f0,3 as f1,"good"as class from dual union all select 1 as f0,4 as f1,"bad"as class from dual union all select 0 as f0,3 as ...
逻辑回归多分类
cast(1 as double)as f1,cast(0 as double)as f2,cast(0 as double)as f3,cast(0 as bigint)as label from dual union all select cast(0 as double)as f0,cast(0 as double)as f1,cast(1 as double)as f2,cast(0 as double)as f3,cast(2 ...
K均值聚类
kmeans_test_input as select*from(select 'id1' as id,1 as f0,2 as f1 from dual union all select 'id2' as id,1 as f0,3 as f1 from dual union all select 'id3' as id,1 as f0,4 as f1 from dual union all select 'id4' as id,0 as ...
KEY-RANGE
2023 VALUES LESS THAN('2023-04-01'),SUBPARTITION p0_q2_2023 VALUES LESS THAN('2023-07-01'),SUBPARTITION p0_q3_2023 VALUES LESS THAN('2023-10-01'),SUBPARTITION p0_q4_2023 VALUES LESS THAN('2024-01-01')),PARTITION p1...
增加分区
t2`(`a` bigint(20)UNSIGNED NOT NULL,`b` bigint(20)UNSIGNED NOT NULL,`c` datetime NOT NULL,`d` varchar(16)NOT NULL,`e` varchar(16)NOT NULL)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 PARTITION BY RANGE(YEAR(`c`))(PARTITION p0 ...
C3P0 连接池配置示例
本文介绍 C3P0 连接池配置依赖和示例代码。配置依赖<dependency><groupId>com.oceanbase</groupId> <artifactId>oceanbase-client</artifactId> <version>2.4.0</version></dependency><dependency><groupId>...
清空分区
2022)(SUBPARTITION p0sp0 VALUES LESS THAN(2020),SUBPARTITION p0sp1 VALUES LESS THAN(2022)),PARTITION p1 VALUES IN(2021,2023)(SUBPARTITION p1sp0 VALUES LESS THAN(2021),SUBPARTITION p1sp1 VALUES LESS THAN(2023),SUBPARTITION ...
删除分区
2022)(SUBPARTITION p0sp0 VALUES LESS THAN(2020),SUBPARTITION p0sp1 VALUES LESS THAN(2022)),PARTITION p1 VALUES IN(2021,2023)(SUBPARTITION p1sp0 VALUES LESS THAN(2021),SUBPARTITION p1sp1 VALUES LESS THAN(2023),SUBPARTITION ...
故障图片上传获取签名信息
bf4d-4345-9ae6-158223c85dbd requestId data Object data bucketName String xxxx-xxxx-xxxx oss bucket name key String problem/xxxxxxxxxxxxxxxx1-b3185d529277 oss key policy String eyJleHBpcmF0a0p0IjoiMjAyMS0wNy0xM1QwNDowOTo0NS...
字符串相似度
命令如下：create table pai_ft_string_similarity_input as select*from(select 0 as id,"北京"as col0,"北京"as col1 union all select 1 as id,"北京"as col0,"北京上海"as col1 union all select 2 as id,"北京"as col0,"北京上海深圳...
随机森林
rf_test_input as select*from(select 1 as f0,2 as f1,"good"as class from dual union all select 1 as f0,3 as f1,"good"as class from dual union all select 1 as f0,4 as f1,"bad"as class from dual union all select 0 as f0,3 as ...
字符串相似度-topN
命令如下：CREATE TABLE pai_ft_string_similarity_topn_input AS SELECT*FROM(SELECT 0 AS id,'北京' AS col0 UNION ALL SELECT 1 AS id,'北京上海' AS col0 UNION ALL SELECT 2 AS id,'北京上海深圳' AS col0)tmp;执行成功后，pai_ft_...
数据库连接池配置
本文主要对连接池的配置参数，包括 ZDAL 参数、Druid 参数、DBCP 参数、C3P0 参数以及 JDBC 参数等进行介绍。数据源配置参数 参数含义 说明 ZDAL 参数 Druid 参数 DBCP 参数 C3P0 参数 初始化连接数 连接池初始化时建立连接数。prefill=...
LIST DEFAULT HASH
创建多个DEFAULT分区示例如下：CREATE TABLE list_default_hash(a INT,b INT)PARTITION BY LIST(a)(PARTITION p0 VALUES IN(1,2,3,4,5),PARTITION p1 VALUES IN(6,7,8,9,10),PARTITION pd DEFAULT PARTITIONS 3);分区键字段类型为 VARCHAR ...
REORGANIZE PARTITION
修改3个分区 p0、p1、p2 为 q1、q2：ALTER TABLE sales_list_hash REORGANIZE PARTITION p0,p1,p2 INTO(PARTITION q1 VALUES in(1,2)(SUBPARTITION s0,SUBPARTITION s1),PARTITION q2 VALUES in(3,4)(SUBPARTITION s3,SUBPARTITION s4));
文章相似度
create table pai_doc_similarity_input as select*from(select 0 as id,"北京 上海"as col0,"北京 上海"as col1 union all select 1 as id,"北京 上海"as col0,"北京 上海 深圳"as col1)tmp 执行成功后，输入表pai_doc_similarity_input的...
分区表扫描算子
QUERY PLAN-PartitionedTableScan on part_range(actual time=86.404.86.405 rows=0 loops=1)Scan 1000 Partitions:part_range_p0,part_range_p1,part_range_p2,.->Seq Scan on part_range Planning Time:36.613 ms Execution Time:89.246 ...
debug
答：查看内存 p addr[数量：默认为16个][字节宽度显示,可选1/2/4，默认为4字节]举例说明：p 0x80000000-查看0x80000000处的内存值，默认输出16个地址，以4字节数据宽度显示 0x80000000:80020000 60012ee1 60012f81 60012f87 0x80000010:...
VPN网关支持BGP动态路由公告
路由类别 VPN网关内路由优先级 VPC内路由优先级 明细路由 P0 P0 系统路由 P1 P1 静态路由 P2 P2 动态路由 P3 P3 使用限制 单个VPN网关的BGP路由表默认支持的路由条目数为50条。如需提升配额，请 提交工单。启用BGP动态路由功能后，隧道网段...
初始化配置
config.json {/默认初始配置"default":{"firstScene":"p0"｜"normal",/初始视图,px表示进入全景图中的场景，normal表示进入3d视图"viewImage":'xxxx',/初始视图"fov":60,/初始相机fov"directionIn":[-0.019438116573232567,-2....
离散值特征分析
string,0 as col_bigint,1.0 as col_double union all select '01' as col_string,1 as col_bigint,cast(null as double)as col_double union all select '01' as col_string,1 as col_bigint,1.0 as col_double union all select '00' as ...
分析Apache日志
time_),'%m-%d%H:%i')order by time limit 1000 流入流出流量统计 图展示流量的流入和流出情况，所关联的查询分析语句如下所示：*|select date_format(date_trunc('hour',_time_),'%m-%d%H:%i')as time,sum(bytes_sent)as net_out...
配置IPsec连接路由
路由类别 IPsec连接路由优先级 明细路由 P0 系统路由 P1 静态路由 P2 动态路由 P3 配置目的路由 配置目的路由时，需要指定目标网段和下一跳信息，IPsec连接将基于流量的目的IP地址去匹配目的路由，然后根据流量匹配到的目的路由转发流量。...
- 产品推荐
- 这些文档可能帮助您