致命错误:在 phpMyAdmin 中执行时间超过 30 秒

2022-01-05 00:00:00 database php mysql phpmyadmin

我有一个包含 650 万条记录的 MySQL 表.当我尝试从 phpMyAdmin 访问该表时，我得到:

I have a MySQL table which contains 6.5 million records. When I try to access that table from phpMyAdmin I get:

致命错误:C:xampp-newphpMyAdminlibrariesdisplay_tbl.lib.php 中的第 1457 行超过了 30 秒的最大执行时间.

Fatal error: Maximum execution time of 30 seconds exceeded in C:xampp-newphpMyAdminlibrariesdisplay_tbl.lib.php on line 1457.

我只是想查看记录，我没有做任何可能导致错误的查询.

I am just trying to view the records and I am not doing any query which might cause the error.

这个问题只出现在我的服务器上.而且我的本地机器没有服务器包含那么多的记录.

This problem is only in my server. And my local machine does not contain as many records as the server.

在我的 php.ini 中，我已经将最大执行时间设置为最大值.

In my php.ini I have already set the maximum execution time to maximum.

我该如何解决这个错误?

How do I fix this error?

推荐答案

添加这一行

$cfg['ExecTimeLimit'] = 6000;

到phpmyadmin/config.inc.php

并更改php.ini和my.ini

  • post_max_size = 750M
  • upload_max_filesize = 750M
  • max_execution_time = 5000
  • max_input_time = 5000
  • memory_limit = 1000M
  • max_allowed_pa​​cket = 200M(在 my.ini 中)

相关文章