Mysql phpMyadmin超时问题 [英] Mysql phpMyadmin Timeout Question

问题描述

我在Mysql中有一个非常大的数据库.我需要以这种方式对其进行维护.例如其在Innodb中的约300,000条记录.

I have a very large database in Mysql. I need it to be maintained this way. for example its about 300,000 records in Innodb.

我将记录解析到数据库中，但是现在我需要通过将某些字段类型(例如，将long int转换为tinyint或其他类型)来对其进行优化.当我通过phpMyadmin运行此命令时，连接暂停6分钟后出现连接超时错误?.

I parsed the records into the database but now I need to refine it by converting some of the field types for example a long int to tinyint or something. When I run this through phpMyadmin the connection after 6mins halts and I get a connection timeout error?.

因为php向mysql发送了请求，所以mysql不应只是在做它的事情，直到完成为止?因此，即使php页面超时，它还会完成吗?.还是当连接超时时，Mysql才放弃请求吗?

Since php sent the request to mysql shouldn't mysql just be doing its thing no matter what until its done? so even if the php page times out it will it still get done?. Or when the connection times out does Mysql just give up on the request?.

我需要通过php在数据库上运行过滤器，我希望能够每30秒更新一次页面，并在继续搜索时找到新结果，但是如果用户离开，我仍然希望完成搜索，因为它为该用户创建了一个表.因此，如果他们运行查询并在返回浏览器时关闭浏览器，它将继续搜索吗?

I need to run a filter on the database through php and I want to be able to update the page every 30 seconds with new results it finds as its continuing its search , but if the user navigates away I would still like to finish the search as it creates a table for that user. So if they run a query and close their browser when they come back to it will it have continued with the search ?.

以前从来没有像这样的大数据库工作过，如果用户运行文本搜索，我会花很长时间.任何见解/技巧或指导将不胜感激.

Never worked with a big db like this before , if users run a textual search I know it will take a long time. Any insights /tips or guidance would be appreciated .

谢谢

推荐答案

通常，您也可以在服务器本身上使用mysql客户端.对于导入的大型数据库，它通常是我的最爱.

You can also generally use the mysql client on the server itself. It tends to be my favorite for imported large DBs.

mysql -u user -p -h localhost dbname < import.sql

或者在您的情况下转到命令提示符(与phpmyadmin中的SQL窗口相同:

Or in your case to get to the command prompt (same as the SQL window in phpmyadmin:

mysql -u user -p -h localhost dbname

这篇关于Mysql phpMyadmin超时问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！