Mysql 浅析行锁如何减少冲突提高性能

请求信息 : 2025-07-10 08:28:27 HTTP/2.0 GET : /home/article/detail/id/271711.html
运行时间 : 0.3117s ( Load:0.0142s Init:0.1080s Exec:0.1843s Template:0.0053s )
吞吐率 : 3.21req/s
内存开销 : 1,623.91 kb
查询信息 : 12 queries 0 writes
文件加载 : 18
缓存信息 : 5 gets 0 writes
配置加载 : 132
会话信息 : SESSION_ID=a9ujs4tut8kdu7g35lue3u3gl3

/www/wwwroot/www.chaojiit.com/index.php ( 1.30 KB )
/www/wwwroot/www.chaojiit.com/ThinkPHP/ThinkPHP.php ( 4.71 KB )
/www/wwwroot/www.chaojiit.com/ThinkPHP/Library/Think/Think.class.php ( 12.32 KB )
/www/wwwroot/www.chaojiit.com/ThinkPHP/Library/Think/Storage.class.php ( 1.38 KB )
/www/wwwroot/www.chaojiit.com/ThinkPHP/Library/Think/Storage/Driver/File.class.php ( 3.56 KB )
/www/wwwroot/www.chaojiit.com/Application/Runtime/common~runtime.php ( 76.63 KB )
/www/wwwroot/www.chaojiit.com/Application/Home/Conf/config.php ( 0.05 KB )
/www/wwwroot/www.chaojiit.com/ThinkPHP/Library/Behavior/ReadHtmlCacheBehavior.class.php ( 5.62 KB )
/www/wwwroot/www.chaojiit.com/Application/Home/Controller/ArticleController.class.php ( 6.10 KB )
/www/wwwroot/www.chaojiit.com/ThinkPHP/Library/Think/Model.class.php ( 67.27 KB )
/www/wwwroot/www.chaojiit.com/ThinkPHP/Library/Think/Db.class.php ( 5.70 KB )
/www/wwwroot/www.chaojiit.com/ThinkPHP/Library/Think/Db/Driver/Mysql.class.php ( 8.73 KB )
/www/wwwroot/www.chaojiit.com/ThinkPHP/Library/Think/Db/Driver.class.php ( 41.60 KB )
/www/wwwroot/www.chaojiit.com/ThinkPHP/Library/Think/Cache.class.php ( 3.84 KB )
/www/wwwroot/www.chaojiit.com/ThinkPHP/Library/Think/Cache/Driver/File.class.php ( 5.90 KB )
/www/wwwroot/www.chaojiit.com/Application/Runtime/Cache/Home/3c8a1a47a3534a7b1252c226abfc3928.php ( 15.77 KB )
/www/wwwroot/www.chaojiit.com/ThinkPHP/Library/Behavior/WriteHtmlCacheBehavior.class.php ( 1.43 KB )
/www/wwwroot/www.chaojiit.com/ThinkPHP/Library/Behavior/ShowPageTraceBehavior.class.php ( 5.27 KB )

[2] session_save_path(): open_basedir restriction in effect. File(/var/lib/php/session) is not within the allowed path(s): (/www/wwwroot/www.chaojiit.com/:/tmp/) /www/wwwroot/www.chaojiit.com/Application/Runtime/common~runtime.php 第 1 行.
[8192] Array and string offset access syntax with curly braces is deprecated /www/wwwroot/www.chaojiit.com/ThinkPHP/Library/Think/Cache/Driver/File.class.php 第 59 行.
[8] Undefined variable: user /www/wwwroot/www.chaojiit.com/Application/Runtime/Cache/Home/3c8a1a47a3534a7b1252c226abfc3928.php 第 35 行.
[8] Undefined variable: user /www/wwwroot/www.chaojiit.com/Application/Runtime/Cache/Home/3c8a1a47a3534a7b1252c226abfc3928.php 第 140 行.
[8] Trying to access array offset on value of type null /www/wwwroot/www.chaojiit.com/Application/Runtime/Cache/Home/3c8a1a47a3534a7b1252c226abfc3928.php 第 140 行.
[8] Undefined variable: user /www/wwwroot/www.chaojiit.com/Application/Runtime/Cache/Home/3c8a1a47a3534a7b1252c226abfc3928.php 第 141 行.
[8] Trying to access array offset on value of type null /www/wwwroot/www.chaojiit.com/Application/Runtime/Cache/Home/3c8a1a47a3534a7b1252c226abfc3928.php 第 141 行.
[8] Undefined variable: pinglun_list /www/wwwroot/www.chaojiit.com/Application/Runtime/Cache/Home/3c8a1a47a3534a7b1252c226abfc3928.php 第 150 行.
[8] Undefined variable: top_list /www/wwwroot/www.chaojiit.com/Application/Runtime/Cache/Home/3c8a1a47a3534a7b1252c226abfc3928.php 第 185 行.

SELECT `value` FROM `configuration` WHERE `name` = 'site_name' LIMIT 1 [ RunTime:0.0001s ]
SELECT * FROM `menu` WHERE `fid` = 0 AND `status` = 1 [ RunTime:0.0130s ]
SELECT * FROM `menu` WHERE `fid` = 1 AND `status` = 1 [ RunTime:0.0026s ]
SELECT * FROM `menu` WHERE `fid` = 2 AND `status` = 1 [ RunTime:0.0103s ]
SELECT * FROM `menu` WHERE `fid` = 3 AND `status` = 1 [ RunTime:0.0020s ]
SELECT * FROM `menu` WHERE `fid` = 4 AND `status` = 1 [ RunTime:0.0002s ]
SELECT * FROM `article` WHERE `id` = 271711 LIMIT 1 [ RunTime:0.0011s ]
SELECT * FROM `bloger` WHERE `id` = 268 LIMIT 1 [ RunTime:0.0002s ]
SELECT COUNT(*) AS tp_count FROM `article` WHERE `bloger_id` = 268 LIMIT 1 [ RunTime:0.0003s ]
SELECT `content` FROM `article_content` WHERE `article_id` = 271711 LIMIT 1 [ RunTime:0.0009s ]
SELECT `name` FROM `article_cate` WHERE `id` = 259 LIMIT 1 [ RunTime:0.0002s ]
SELECT * FROM `article` WHERE `bloger_id` = 268 ORDER BY view_count desc LIMIT 0,10 [ RunTime:0.0009s ]

Mysql 浅析行锁如何减少冲突提高性能

最近更新

热门博客

[ 申请 ]友情链接：