0

0

varchar 所占内存的影响 测试_MySQL

php中文网

php中文网

发布时间:2016-06-01 13:06:26

|

944人浏览过

|

来源于php中文网

原创

准备数据

sysbench --test=oltp --oltp-nontrx-mode=update_key --mysql-table-engine=innodb --oltp-table-size=1000000 --mysql-socket=/tmp/mysql3392.sock --mysql-user=dba --mysql-host=localhost --mysql-password=localdba --db-driver=mysql --mysql-db=test prepare

mysql> desc sbtest;

+-------+------------------+------+-----+---------+----------------+

| Field | Type             | Null | Key | Default | Extra          |

+-------+------------------+------+-----+---------+----------------+

| id    | int(10) unsigned | NO   | PRI | NULL    | auto_increment |

| k     | int(10) unsigned | NO   | MUL | 0       |                |

| c     | char(120)        | NO   |     |         |                |

| pad   | char(60)         | NO   |     |         |                |

+-------+------------------+------+-----+---------+----------------+

mysql> select count(c) from sbtest;

+----------+

| count(c) |

+----------+

|  1000000 |

+----------+

mysql> desc select * from sbtest order by pad;

+----+-------------+--------+------+---------------+------+---------+------+---------+----------------+

| id | select_type | table  | type | possible_keys | key  | key_len | ref  | rows    | Extra          |

+----+-------------+--------+------+---------------+------+---------+------+---------+----------------+

|  1 | SIMPLE      | sbtest | ALL  | NULL          | NULL | NULL    | NULL | 1000126 | Using filesort |

+----+-------------+--------+------+---------------+------+---------+------+---------+----------------+

mysql> set profiling = 1;

Query OK, 0 rows affected (0.00 sec)

mysql> select count(*) from sbtest order by pad;     

+----------+

| count(*) |

+----------+

|  1000000 |

+----------+

1 row in set (0.53 sec)

mysql> show profiles;

+----------+------------+------------------------------------------+

| Query_ID | Duration   | Query                                    |

+----------+------------+------------------------------------------+

|        1 | 0.53102850 | select count(*) from sbtest order by pad |

+----------+------------+------------------------------------------+

1 row in set (0.02 sec)

mysql> show profile cpu,block io for query 1;

+----------------------+----------+----------+------------+--------------+---------------+

| Status               | Duration | CPU_user | CPU_system | Block_ops_in | Block_ops_out |

+----------------------+----------+----------+------------+--------------+---------------+

| starting             | 0.000127 | 0.000000 |   0.000000 |            0 |             0 |

| checking permissions | 0.000017 | 0.000000 |   0.000000 |            0 |             0 |

| Opening tables       | 0.000042 | 0.000000 |   0.000000 |            0 |             0 |

| System lock          | 0.000022 | 0.000000 |   0.000000 |            0 |             0 |

| init                 | 0.000038 | 0.000000 |   0.000000 |            0 |             0 |

| optimizing           | 0.000011 | 0.000000 |   0.000000 |            0 |             0 |

| statistics           | 0.000022 | 0.000000 |   0.000000 |            0 |             0 |

| preparing            | 0.000017 | 0.000000 |   0.000000 |            0 |             0 |

| executing            | 0.000014 | 0.000000 |   0.000000 |            0 |             0 |

| Sending data         | 0.530471 | 0.502923 |   0.018997 |           32 |             0 |

| end                  | 0.000034 | 0.000000 |   0.000000 |            0 |             0 |

| query end            | 0.000010 | 0.000000 |   0.000000 |            0 |             0 |

| closing tables       | 0.000025 | 0.000000 |   0.000000 |            0 |             0 |

| freeing items        | 0.000037 | 0.000000 |   0.000000 |            0 |             0 |

| logging slow query   | 0.000004 | 0.000000 |   0.000000 |            0 |             0 |

| logging slow query   | 0.000128 | 0.000000 |   0.000000 |            0 |             8 |

| cleaning up          | 0.000012 | 0.000000 |   0.000000 |            0 |             0 |

+----------------------+----------+----------+------------+--------------+---------------+

/////char change to varchar

mysql> alter table sbtest change pad pad varchar(60);

Query OK, 1000000 rows affected (10.72 sec)

Records: 1000000  Duplicates: 0  Warnings: 0

mysql> select pad from sbtest limit 30;

+----------------------------------------------------+

| pad                                                |

+----------------------------------------------------+

| qqqqqqqqqqwwwwwwwwwweeeeeeeeeerrrrrrrrrrtttttttttt |

| qqqqqqqqqqwwwwwwwwwweeeeeeeeeerrrrrrrrrrtttttttttt |

| qqqqqqqqqqwwwwwwwwwweeeeeeeeeerrrrrrrrrrtttttttttt |

| qqqqqqqqqqwwwwwwwwwweeeeeeeeeerrrrrrrrrrtttttttttt |

| qqqqqqqqqqwwwwwwwwwweeeeeeeeeerrrrrrrrrrtttttttttt |

| qqqqqqqqqqwwwwwwwwwweeeeeeeeeerrrrrrrrrrtttttttttt |

| qqqqqqqqqqwwwwwwwwwweeeeeeeeeerrrrrrrrrrtttttttttt |

| qqqqqqqqqqwwwwwwwwwweeeeeeeeeerrrrrrrrrrtttttttttt |

| qqqqqqqqqqwwwwwwwwwweeeeeeeeeerrrrrrrrrrtttttttttt |

| qqqqqqqqqqwwwwwwwwwweeeeeeeeeerrrrrrrrrrtttttttttt |

| qqqqqqqqqqwwwwwwwwwweeeeeeeeeerrrrrrrrrrtttttttttt |

| qqqqqqqqqqwwwwwwwwwweeeeeeeeeerrrrrrrrrrtttttttttt |

| qqqqqqqqqqwwwwwwwwwweeeeeeeeeerrrrrrrrrrtttttttttt |

| qqqqqqqqqqwwwwwwwwwweeeeeeeeeerrrrrrrrrrtttttttttt |

| qqqqqqqqqqwwwwwwwwwweeeeeeeeeerrrrrrrrrrtttttttttt |

| qqqqqqqqqqwwwwwwwwwweeeeeeeeeerrrrrrrrrrtttttttttt |

| qqqqqqqqqqwwwwwwwwwweeeeeeeeeerrrrrrrrrrtttttttttt |

mysql> desc sbtest;

+-------+------------------+------+-----+---------+----------------+

| Field | Type             | Null | Key | Default | Extra          |

+-------+------------------+------+-----+---------+----------------+

| id    | int(10) unsigned | NO   | PRI | NULL    | auto_increment |

| k     | int(10) unsigned | NO   | MUL | 0       |                |

| c     | char(120)        | NO   |     |         |                |

| pad   | varchar(60)      | YES  |     | NULL    |                |

+-------+------------------+------+-----+---------+----------------+

================无索引的情况下:=====================

mysql> desc  select * from sbtest order by pad;

+----+-------------+--------+------+---------------+------+---------+------+---------+----------------+

| id | select_type | table  | type | possible_keys | key  | key_len | ref  | rows    | Extra          |

+----+-------------+--------+------+---------------+------+---------+------+---------+----------------+

|  1 | SIMPLE      | sbtest | ALL  | NULL          | NULL | NULL    | NULL | 1000117 | Using filesort |

+----+-------------+--------+------+---------------+------+---------+------+---------+----------------+

mysql> select count(*) from sbtest order by pad;

+----------+

| count(*) |

+----------+

|  1000000 |

+----------+

1 row in set (0.51 sec)

mysql> show profile cpu,block io for query 11;

+----------------------+----------+----------+------------+--------------+---------------+

| Status               | Duration | CPU_user | CPU_system | Block_ops_in | Block_ops_out |

+----------------------+----------+----------+------------+--------------+---------------+

| starting             | 0.000081 | 0.000000 |   0.000000 |            0 |             0 |

| checking permissions | 0.000014 | 0.000000 |   0.000000 |            0 |             0 |

| Opening tables       | 0.000033 | 0.000000 |   0.000000 |            0 |             0 |

| System lock          | 0.000025 | 0.000000 |   0.000000 |            0 |             0 |

| init                 | 0.000028 | 0.000000 |   0.000000 |            0 |             0 |

| optimizing           | 0.000009 | 0.000000 |   0.000000 |            0 |             0 |

| statistics           | 0.000019 | 0.000000 |   0.000000 |            0 |             0 |

| preparing            | 0.000013 | 0.000000 |   0.000000 |            0 |             0 |

| executing            | 0.000011 | 0.000000 |   0.000000 |            0 |             0 |

| Sending data         | 0.506327 | 0.489925 |   0.018997 |            0 |             0 |

| end                  | 0.000026 | 0.001000 |   0.000000 |            0 |             0 |

| query end            | 0.000010 | 0.000000 |   0.000000 |            0 |             0 |

| closing tables       | 0.000022 | 0.000000 |   0.000000 |            0 |             0 |

| freeing items        | 0.000034 | 0.000000 |   0.000000 |            0 |             0 |

| logging slow query   | 0.000003 | 0.000000 |   0.000000 |            0 |             0 |

| logging slow query   | 0.000114 | 0.000000 |   0.000000 |            0 |             8 |

| cleaning up          | 0.000009 | 0.000000 |   0.000000 |            0 |             0 |

+----------------------+----------+----------+------------+--------------+---------------+

varchar(120)的情况下:

mysql> alter table sbtest change pad pad varchar(120);

Query OK, 1000000 rows affected (11.77 sec)

Records: 1000000  Duplicates: 0  Warnings: 0

mysql> desc sbtest;

+-------+------------------+------+-----+---------+----------------+

| Field | Type             | Null | Key | Default | Extra          |

+-------+------------------+------+-----+---------+----------------+

| id    | int(10) unsigned | NO   | PRI | NULL    | auto_increment |

| k     | int(10) unsigned | NO   | MUL | 0       |                |

| c     | char(120)        | NO   |     |         |                |

| pad   | varchar(120)     | YES  |     | NULL    |                |

+-------+------------------+------+-----+---------+----------------+

mysql> desc select * from sbtest;

+----+-------------+--------+------+---------------+------+---------+------+---------+-------+

| id | select_type | table  | type | possible_keys | key  | key_len | ref  | rows    | Extra |

+----+-------------+--------+------+---------------+------+---------+------+---------+-------+

|  1 | SIMPLE      | sbtest | ALL  | NULL          | NULL | NULL    | NULL | 1000117 |       |

+----+-------------+--------+------+---------------+------+---------+------+---------+-------+

1 row in set (0.00 sec)

mysql> desc select count(*) from sbtest;

+----+-------------+--------+-------+---------------+------+---------+------+---------+-------------+

Color Wheel
Color Wheel

AI灰度logo或插画上色工具

下载

| id | select_type | table  | type  | possible_keys | key  | key_len | ref  | rows    | Extra       |

+----+-------------+--------+-------+---------------+------+---------+------+---------+-------------+

|  1 | SIMPLE      | sbtest | index | NULL          | k    | 4       | NULL | 1000117 | Using index |

+----+-------------+--------+-------+---------------+------+---------+------+---------+-------------+

1 row in set (0.00 sec)

mysql> select count(*) from sbtest order by pad;

+----------+

| count(*) |

+----------+

|  1000000 |

+----------+

1 row in set (0.51 sec)

mysql> show profile cpu,block io for query 17;

+----------------------+----------+----------+------------+--------------+---------------+

| Status               | Duration | CPU_user | CPU_system | Block_ops_in | Block_ops_out |

+----------------------+----------+----------+------------+--------------+---------------+

| starting             | 0.000073 | 0.000000 |   0.000000 |            0 |             0 |

| checking permissions | 0.000013 | 0.000000 |   0.000000 |            0 |             0 |

| Opening tables       | 0.000031 | 0.000000 |   0.000000 |            0 |             0 |

| System lock          | 0.000024 | 0.000000 |   0.000000 |            0 |             0 |

| init                 | 0.000026 | 0.000000 |   0.000000 |            0 |             0 |

| optimizing           | 0.000008 | 0.000000 |   0.000000 |            0 |             0 |

| statistics           | 0.000019 | 0.000000 |   0.000000 |            0 |             0 |

| preparing            | 0.000013 | 0.000000 |   0.000000 |            0 |             0 |

| executing            | 0.000011 | 0.000000 |   0.000000 |            0 |             0 |

| Sending data         | 0.510981 | 0.491925 |   0.018997 |            0 |             0 |

| end                  | 0.000025 | 0.000000 |   0.000000 |            0 |             0 |

| query end            | 0.000013 | 0.000000 |   0.000000 |            0 |             0 |

| closing tables       | 0.000026 | 0.000000 |   0.000000 |            0 |             0 |

| freeing items        | 0.000039 | 0.000000 |   0.000000 |            0 |             0 |

| logging slow query   | 0.000004 | 0.000000 |   0.000000 |            0 |             0 |

| logging slow query   | 0.000110 | 0.000000 |   0.000000 |            0 |             8 |

| cleaning up          | 0.000007 | 0.000000 |   0.000000 |            0 |             0 |

+----------------------+----------+----------+------------+--------------+---------------+

================有索引的情况下:=====================

alter table sbtest change pad pad varchar(60);

mysql> alter table sbtest add key(pad);

Query OK, 0 rows affected (7.60 sec)

Records: 0  Duplicates: 0  Warnings: 0

mysql> show index from sbtest;

+--------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

| Table  | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |

+--------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

| sbtest |          0 | PRIMARY  |            1 | id          | A         |     1000117 |     NULL | NULL   |      | BTREE      |         |               |

| sbtest |          1 | k        |            1 | k           | A         |           6 |     NULL | NULL   |      | BTREE      |         |               |

| sbtest |          1 | pad      |            1 | pad         | A         |         200 |     NULL | NULL   | YES  | BTREE      |         |               |

+--------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

varchar(60)

mysql> desc select count(*) from sbtest order by pad;

+----+-------------+--------+-------+---------------+------+---------+------+---------+-------------+

| id | select_type | table  | type  | possible_keys | key  | key_len | ref  | rows    | Extra       |

+----+-------------+--------+-------+---------------+------+---------+------+---------+-------------+

|  1 | SIMPLE      | sbtest | index | NULL          | pad  | 183     | NULL | 1000117 | Using index |

+----+-------------+--------+-------+---------------+------+---------+------+---------+-------------+

mysql> select count(*) from sbtest order by pad;

+----------+

| count(*) |

+----------+

|  1000000 |

+----------+

1 row in set (0.44 sec)

mysql> show profile cpu,block io for query 1

    -> ;

+----------------------+----------+----------+------------+--------------+---------------+

| Status               | Duration | CPU_user | CPU_system | Block_ops_in | Block_ops_out |

+----------------------+----------+----------+------------+--------------+---------------+

| starting             | 0.000115 | 0.000000 |   0.000000 |            0 |             0 |

| checking permissions | 0.000017 | 0.000000 |   0.000000 |            0 |             0 |

| Opening tables       | 0.000043 | 0.000000 |   0.000000 |            0 |             0 |

| System lock          | 0.000023 | 0.000000 |   0.000000 |            0 |             0 |

| init                 | 0.000038 | 0.000000 |   0.000000 |            0 |             0 |

| optimizing           | 0.000010 | 0.000000 |   0.000000 |            0 |             0 |

| statistics           | 0.000024 | 0.000000 |   0.000000 |            0 |             0 |

| preparing            | 0.000018 | 0.000000 |   0.000000 |            0 |             0 |

| executing            | 0.000015 | 0.000000 |   0.000000 |            0 |             0 |

| Sending data         | 0.445040 | 0.428935 |   0.015998 |            0 |             0 |

| end                  | 0.000023 | 0.000000 |   0.000000 |            0 |             0 |

| query end            | 0.000013 | 0.000000 |   0.000000 |            0 |             0 |

| closing tables       | 0.000028 | 0.000000 |   0.000000 |            0 |             0 |

| freeing items        | 0.000041 | 0.000000 |   0.000000 |            0 |             0 |

| logging slow query   | 0.000003 | 0.000000 |   0.000000 |            0 |             0 |

| logging slow query   | 0.000133 | 0.000000 |   0.001000 |            0 |             8 |

| cleaning up          | 0.000008 | 0.000000 |   0.000000 |            0 |             0 |

+----------------------+----------+----------+------------+--------------+---------------+

mysql> alter table sbtest change pad pad varchar(120);

Query OK, 1000000 rows affected (14.56 sec)

Records: 1000000  Duplicates: 0  Warnings: 0

mysql> show index from sbtest;

+--------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

| Table  | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |

+--------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

| sbtest |          0 | PRIMARY  |            1 | id          | A         |     1000117 |     NULL | NULL   |      | BTREE      |         |               |

| sbtest |          1 | k        |            1 | k           | A         |           6 |     NULL | NULL   |      | BTREE      |         |               |

| sbtest |          1 | pad      |            1 | pad         | A         |          24 |     NULL | NULL   | YES  | BTREE      |         |               |

+--------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

这里开始有区别了.Cardinality 从200降到24 

varchar(120) Cardinality =200

mysql> desc select count(*) from sbtest order by pad;

+----+-------------+--------+-------+---------------+------+---------+------+---------+-------------+

| id | select_type | table  | type  | possible_keys | key  | key_len | ref  | rows    | Extra       |

+----+-------------+--------+-------+---------------+------+---------+------+---------+-------------+

|  1 | SIMPLE      | sbtest | index | NULL          | pad  | 363     | NULL | 1000117 | Using index |

+----+-------------+--------+-------+---------------+------+---------+------+---------+-------------+

mysql> select count(*) from sbtest order by pad;

+----------+

| count(*) |

+----------+

|  1000000 |

+----------+

1 row in set (0.45 sec)

mysql> show profile cpu,block io for query 8;

+----------------------+----------+----------+------------+--------------+---------------+

| Status               | Duration | CPU_user | CPU_system | Block_ops_in | Block_ops_out |

+----------------------+----------+----------+------------+--------------+---------------+

| starting             | 0.000120 | 0.000000 |   0.000000 |            0 |             0 |

| checking permissions | 0.000017 | 0.000000 |   0.000000 |            0 |             0 |

| Opening tables       | 0.000046 | 0.000000 |   0.000000 |            0 |             0 |

| System lock          | 0.000028 | 0.000000 |   0.000000 |            0 |             0 |

| init                 | 0.000038 | 0.000000 |   0.000000 |            0 |             0 |

| optimizing           | 0.000011 | 0.000000 |   0.000000 |            0 |             0 |

| statistics           | 0.000023 | 0.000000 |   0.000000 |            0 |             0 |

| preparing            | 0.000018 | 0.000000 |   0.000000 |            0 |             0 |

| executing            | 0.000013 | 0.000000 |   0.000000 |            0 |             0 |

| Sending data         | 0.452434 | 0.437933 |   0.014998 |            0 |             0 |

| end                  | 0.000025 | 0.000000 |   0.000000 |            0 |             0 |

| query end            | 0.000010 | 0.000000 |   0.000000 |            0 |             0 |

| closing tables       | 0.000023 | 0.000000 |   0.000000 |            0 |             0 |

| freeing items        | 0.000033 | 0.000000 |   0.000000 |            0 |             0 |

| logging slow query   | 0.000003 | 0.000000 |   0.000000 |            0 |             0 |

| logging slow query   | 0.000098 | 0.000000 |   0.000000 |            0 |             8 |

| cleaning up          | 0.000007 | 0.000000 |   0.000000 |            0 |             0 |

+----------------------+----------+----------+------------+--------------+---------------+

这里也有区别了.有索引的情况下,

是0.44 pk 0.45s

=====================================================================================================

加到varchar(600)试下

mysql> alter table sbtest change pad pad varchar(600);

Query OK, 1000000 rows affected, 2 warnings (14.60 sec)

Records: 1000000  Duplicates: 0  Warnings: 2

mysql> desc select count(*) from sbtest order by pad;

+----+-------------+--------+------+---------------+------+---------+------+---------+-------+

| id | select_type | table  | type | possible_keys | key  | key_len | ref  | rows    | Extra |

+----+-------------+--------+------+---------------+------+---------+------+---------+-------+

|  1 | SIMPLE      | sbtest | ALL  | NULL          | NULL | NULL    | NULL | 1000117 |       |

+----+-------------+--------+------+---------------+------+---------+------+---------+-------+

1 row in set (0.01 sec)

mysql> select count(*) from sbtest order by pad;

+----------+

| count(*) |

+----------+

|  1000000 |

+----------+

1 row in set (0.50 sec)

600是0.5s....

本站声明:本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn

热门AI工具

更多
DeepSeek
DeepSeek

幻方量化公司旗下的开源大模型平台

豆包大模型
豆包大模型

字节跳动自主研发的一系列大型语言模型

通义千问
通义千问

阿里巴巴推出的全能AI助手

腾讯元宝
腾讯元宝

腾讯混元平台推出的AI助手

文心一言
文心一言

文心一言是百度开发的AI聊天机器人,通过对话可以生成各种形式的内容。

讯飞写作
讯飞写作

基于讯飞星火大模型的AI写作工具,可以快速生成新闻稿件、品宣文案、工作总结、心得体会等各种文文稿

即梦AI
即梦AI

一站式AI创作平台,免费AI图片和视频生成。

ChatGPT
ChatGPT

最最强大的AI聊天机器人程序,ChatGPT不单是聊天机器人,还能进行撰写邮件、视频脚本、文案、翻译、代码等任务。

相关专题

更多
全国统一发票查询平台入口合集
全国统一发票查询平台入口合集

本专题整合了全国统一发票查询入口地址合集,阅读专题下面的文章了解更多详细入口。

19

2026.02.03

短剧入口地址汇总
短剧入口地址汇总

本专题整合了短剧app推荐平台,阅读专题下面的文章了解更多详细入口。

27

2026.02.03

植物大战僵尸版本入口地址汇总
植物大战僵尸版本入口地址汇总

本专题整合了植物大战僵尸版本入口地址汇总,前往文章中寻找想要的答案。

15

2026.02.03

c语言中/相关合集
c语言中/相关合集

本专题整合了c语言中/的用法、含义解释。阅读专题下面的文章了解更多详细内容。

3

2026.02.03

漫蛙漫画网页版入口与正版在线阅读 漫蛙MANWA官网访问专题
漫蛙漫画网页版入口与正版在线阅读 漫蛙MANWA官网访问专题

本专题围绕漫蛙漫画(Manwa / Manwa2)官网网页版入口进行整理,涵盖漫蛙漫画官方主页访问方式、网页版在线阅读入口、台版正版漫画浏览说明及基础使用指引,帮助用户快速进入漫蛙漫画官网,稳定在线阅读正版漫画内容,避免误入非官方页面。

13

2026.02.03

Yandex官网入口与俄罗斯搜索引擎访问指南 Yandex中文登录与网页版入口
Yandex官网入口与俄罗斯搜索引擎访问指南 Yandex中文登录与网页版入口

本专题汇总了俄罗斯知名搜索引擎 Yandex 的官网入口、免登录访问地址、中文登录方法与网页版使用指南,帮助用户稳定访问 Yandex 官网,并提供一站式入口汇总。无论是登录入口还是在线搜索,用户都能快速获取最新稳定的访问链接与使用指南。

114

2026.02.03

Java 设计模式与重构实践
Java 设计模式与重构实践

本专题专注讲解 Java 中常用的设计模式,包括单例模式、工厂模式、观察者模式、策略模式等,并结合代码重构实践,帮助学习者掌握 如何运用设计模式优化代码结构,提高代码的可读性、可维护性和扩展性。通过具体示例,展示设计模式如何解决实际开发中的复杂问题。

3

2026.02.03

C# 并发与异步编程
C# 并发与异步编程

本专题系统讲解 C# 异步编程与并发控制,重点介绍 async 和 await 关键字、Task 类、线程池管理、并发数据结构、死锁与线程安全问题。通过多个实战项目,帮助学习者掌握 如何在 C# 中编写高效的异步代码,提升应用的并发性能与响应速度。

2

2026.02.03

Python 强化学习与深度Q网络(DQN)
Python 强化学习与深度Q网络(DQN)

本专题深入讲解 Python 在强化学习(Reinforcement Learning)中的应用,重点介绍 深度Q网络(DQN) 及其实现方法,涵盖 Q-learning 算法、深度学习与神经网络的结合、环境模拟与奖励机制设计、探索与利用的平衡等。通过构建一个简单的游戏AI,帮助学习者掌握 如何使用 Python 训练智能体在动态环境中作出决策。

3

2026.02.03

热门下载

更多
网站特效
/
网站源码
/
网站素材
/
前端模板

精品课程

更多
相关推荐
/
热门推荐
/
最新课程
关于我们 免责申明 举报中心 意见反馈 讲师合作 广告合作 最新更新
php中文网:公益在线php培训,帮助PHP学习者快速成长!
关注服务号 技术交流群
PHP中文网订阅号
每天精选资源文章推送

Copyright 2014-2026 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号