XAMPP 使用 PHP/MySQL 运行非常缓慢 [英] XAMPP Running really slowly with PHP/MySQL
问题描述
我的 Windows 7 计算机上安装了 XAMPP.
I've got XAMPP installed on my Windows 7 Computer.
我已经开发了一段时间，但我的开发已经停止，因为 XAMPP 渲染我的 PHP 页面 非常缓慢.
I've been developing on it for a while now but my development has come to a grinding halt because XAMPP is rendering my PHP pages really slowly.
它运行得太慢，以至于超过了我在 PHP.ini 文件中设置的 30 秒超时限制.
It's running so slowly, that it's exceeding the 30 second time-out limit that I've got set in the PHP.ini file.
我不知道是什么突然阻止了它正常运行.
I don't know what it could be that has all of a sudden prevented it from running properly.
我尝试了以下方法:
- 重新安装 XAMPP 并复制回我的 MySQL 数据库文件和网站文件
- 阅读文章后停用了我的防病毒软件/防火墙
但无济于事.
会不会是我的 MySQL 数据库损坏了?
Could it be that my MySQL database is corrupted?
并不是因为我的 MySQL 查询很慢，因为我的网站上有完全相同版本的代码.
It's not that my MySQL queries are slow, because I've got the exact same version of code live on my website.
我只是在寻找纠正它的建议，以便我可以继续开发.
I'm just looking for suggestions to rectify it so that I can continue the development.
这是 MySQL 错误日志的最后一点
111119 17:24:11 [注意] 插件FEDERATED"已禁用.111119 17:24:11InnoDB:InnoDB 内存堆被禁用 111119 17:24:11 InnoDB:Mutexes 和 rw_locks 使用 Windows 互锁函数 111119 17:24:11InnoDB:压缩表使用 zlib 1.2.3 111119 17:24:11 InnoDB:初始化缓冲池，大小 = 16.0M 111119 17:24:11 InnoDB:缓冲池初始化完成 111119 17:24:11 InnoDB:支持的最高文件格式是梭子鱼.111119 17:24:12 InnoDB:等待后台线程启动 111119 17:24:13 InnoDB:1.1.8 开始；日志序列号 1595675 111119 17:24:14 [Note] Event Scheduler: Loaded 0 events 111119 17:24:14 [Note]c:\xampp\mysql\bin\mysqld.exe:准备连接.版本:'5.5.16' 套接字:'' 端口:3306 MySQL 社区服务器 (GPL) 11111917:32:24 【注意】c:\xampp\mysql\bin\mysqld.exe:正常关机
111119 17:24:11 [Note] Plugin 'FEDERATED' is disabled. 111119 17:24:11 InnoDB: The InnoDB memory heap is disabled 111119 17:24:11 InnoDB: Mutexes and rw_locks use Windows interlocked functions 111119 17:24:11 InnoDB: Compressed tables use zlib 1.2.3 111119 17:24:11 InnoDB: Initializing buffer pool, size = 16.0M 111119 17:24:11 InnoDB: Completed initialization of buffer pool 111119 17:24:11 InnoDB: highest supported file format is Barracuda. 111119 17:24:12 InnoDB: Waiting for the background threads to start 111119 17:24:13 InnoDB: 1.1.8 started; log sequence number 1595675 111119 17:24:14 [Note] Event Scheduler: Loaded 0 events 111119 17:24:14 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections. Version: '5.5.16' socket: '' port: 3306 MySQL Community Server (GPL) 111119 17:32:24 [Note] c:\xampp\mysql\bin\mysqld.exe: Normal shutdown
111119 17:32:24 [注意] 事件调度器:清除队列.0 事件111119 17:32:24 InnoDB:开始关闭... 111119 17:32:25 InnoDB:关机完成；日志序列号 1595675 111119 17:32:25 【注意】c:\xampp\mysql\bin\mysqld.exe:关闭完成
111119 17:32:24 [Note] Event Scheduler: Purging the queue. 0 events 111119 17:32:24 InnoDB: Starting shutdown... 111119 17:32:25 InnoDB: Shutdown completed; log sequence number 1595675 111119 17:32:25 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete
111119 17:33:26 [注意] 插件FEDERATED"已禁用.111119 17:33:26InnoDB:InnoDB 内存堆被禁用 111119 17:33:26 InnoDB:Mutexes 和 rw_locks 使用 Windows 互锁函数 111119 17:33:26InnoDB:压缩表使用 zlib 1.2.3 111119 17:33:26 InnoDB:初始化缓冲池，大小 = 16.0M 111119 17:33:26 InnoDB:缓冲池初始化完成 111119 17:33:26 InnoDB:支持的最高文件格式是梭子鱼.111119 17:33:27 InnoDB:等待后台线程启动 111119 17:33:28 InnoDB:1.1.8 开始；日志序列号 1595675 111119 17:33:28 [Note] Event Scheduler: Loaded 0 events 111119 17:33:28 [Note]c:\xampp\mysql\bin\mysqld.exe:准备好连接.版本:'5.5.16' 套接字:'' 端口:3306 MySQL 社区服务器 (GPL)
111119 17:33:26 [Note] Plugin 'FEDERATED' is disabled. 111119 17:33:26 InnoDB: The InnoDB memory heap is disabled 111119 17:33:26 InnoDB: Mutexes and rw_locks use Windows interlocked functions 111119 17:33:26 InnoDB: Compressed tables use zlib 1.2.3 111119 17:33:26 InnoDB: Initializing buffer pool, size = 16.0M 111119 17:33:26 InnoDB: Completed initialization of buffer pool 111119 17:33:26 InnoDB: highest supported file format is Barracuda. 111119 17:33:27 InnoDB: Waiting for the background threads to start 111119 17:33:28 InnoDB: 1.1.8 started; log sequence number 1595675 111119 17:33:28 [Note] Event Scheduler: Loaded 0 events 111119 17:33:28 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections. Version: '5.5.16' socket: '' port: 3306 MySQL Community Server (GPL)
推荐答案
我曾经在 xampp 上使用 PHP 时遇到过同样的问题.一段时间后它开始变慢，没有任何原因(代码、mysql、apache 都很好).
I used to have the same issues with PHP on xampp. After a while it started slowing down, there was no reason for it (code, mysql, apache were all fine).
我让它工作的方式是通过 xampp 的命令行界面.我已经将网络接口从 v4v6 切换到 v4；那已经成功了，然后不久之后它又变慢了……所以将 v4 恢复到 v4v6 固定，但再次恶化.
The way I had gotten it to work was via xampp's command line interface. I had switched the networking interface from v4v6 to just v4; and that that had done the trick, then shortly after it slowed down again... so doing the v4 back to v4v6 fixed, but again worstened.
因此，在使用 xampp 多年后，我发现 wamp 效果最好，并且在 Windows 7 上没有问题.
So, after working with xampp for a number of years, I found that wamp worked best and has no issues on Windows 7.
下载wamp;它也只有 16mb(与 xampp 的 44mb 相比).http://wampserver.com/
Download wamp; it's only 16mb too (compared to xampp's 44mb). http://wampserver.com/
这篇关于XAMPP 使用 PHP/MySQL 运行非常缓慢的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
