CakePHP 重新连接到数据库

2021-12-21 00:00:00 timeout mysql cakephp

我有一个脚本可以将一个对象插入到数据库中，然后我还要插入 20 000 个其他小对象.所以我将其他对象保存到一个数组中，然后再保存.

I have a script that inserts an object into the database and then I have like 20 000 other little objects to be inserted. So I save the other objects into an array and save them afterwards.

但是服务器说MySQL服务器已经消失了"

But the server sais "MySQL Server has gone away"

我可以以某种方式重新连接到数据库吗?或者我可以在插入大对象并收集所有小对象后重新连接吗?

Can I reconnect in some way to the database? Or can I disconnect after inserting the big object and after collecting all the small object to reconnect?

推荐答案

你可以在你的模型中.

$this->ModelName->getDatasource()->disconnect(); 
    //do stuff
$this->ModelName->getDatasource()->connect();

相关文章