问题描述
我的 Symfony 页面并不太慢(加载时间大约为 400 毫秒)，但考虑到它只是一个带有基本身份验证的简单 hello world 页面这一事实，它的加载时间应该不到 100 毫秒.当我进入分析器时，我看到:
My Symfony page isn't too slow (it loads in about 400 ms) but considering the fact that it's just a simple hello world page with basic authentication, it should be loading in less than 100 ms. When I enter the profiler, I see this:
请注意，它只显示防火墙"250 毫秒.我认为防火墙只是负责将用户排除在页面的某些区域之外 - 我无法想象花费的时间超过几毫秒加上从数据库中获取用户信息所需的时间(在这种情况下是61 毫秒).
Notice it just says "Firewall" for 250 ms. I thought the firewall was just responsible for keeping users out of certain areas of the page - I can't imagine that taking any longer than a few milliseconds plus the time it takes to fetch the user information from the database (which in this case is 61 ms).
有人能解释一下防火墙的实际作用吗?如果您有任何关于如何提高防火墙性能的一般性建议，我们将不胜感激.
Could somebody explain what the firewall actually does? If you have any general pointers on how to increase the firewall performance as well that would be greatly appreciated.
注意:我当然在谷歌上搜索过这个，我想预先指定我是通过 IP 地址而不是主机名连接到 MySQL 数据库.这似乎是我能找到的所有其他缓慢的 Symfony 防火墙的问题.
Note: I have Googled this of course, and I want to specify up front that I'm connecting to the MySQL database by IP address, not host name. This seemed to be the issue for every other case of slow Symfony firewall I could find.
我的项目中可能相关的一些资源:
Some resources from my project that could be relevant:
- security.yaml
- routing.yaml
- Astrups/SpectacleBundle/Entity/User.php
- Astrups/SpectacleBundle/Service/Sha1Salted.php
推荐答案
唉，结果证明 Rawdreeg 是部分正确.我制作了一个 20 行的 PHP 脚本来分析连接到我的 MySQL 服务器所需的时间:
Alas, it turns out Rawdreeg was partly right. I made a 20 line PHP script to profile how long it takes to connect to my MySQL server:
<?php
$time = microtime(true);
$con = new PDO(...);
$connect_time = microtime(true);
$result = $con->query('SHOW TABLES');
$query_time = microtime(true);
var_dump($result->fetchAll(PDO::FETCH_ASSOC));
$time_con = ($connect_time - $time) * 1000;
$time_query = ($query_time - $connect_time) * 1000;
echo "Connection took $time_con ms
";
echo "Query took $time_query ms
";
输出是:
Connection took 230.18503189087 ms
Query took 64.532995223999 ms它完美地填补了Symfony分析器的空白.好消息是，当我的应用程序上线时，它将通过套接字连接到本地的 MySQL 服务器，所以它可能会非常快！但是，除了在本地镜像 MySQL 服务器之外，我在开发过程中对速度几乎无能为力.
Which fills the blanks of the Symfony profiler perfectly. The good news is that when my application goes live, it will connect to the MySQL server locally by socket, so it'll probably be blazing fast! There is little I can do about the speed during the development though, other than mirroring the MySQL server locally.
所以总结一下答案；Symfony 防火墙最初创建与 MySQL 数据库的连接，在我的情况下，该连接非常慢.就我而言，MySQL 连接时间占防火墙分析时间的 80% 以上.
So to summarize the answer; the Symfony firewall initially creates the connection to the MySQL database, and in my case, that connection is quite slow. The MySQL connection time accounts for over 80% of the firewall's profiled time in my case.
注意:我已经通过 IP 地址连接到 MySQL 服务器，并且我已经将 skip-name-resolve 添加到 MySQL 配置中，但无济于事.
Note: I'm already connecting to the MySQL server by IP address, and I've added skip-name-resolve to the MySQL configuration to no avail.
这篇关于Symfony 防火墙在做什么需要这么长时间?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，WP2