每小时清空一个MySQL表

本文介绍了每小时清空一个MySQL表的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我有一个用PHP Ajax和MySQL编写的聊天脚本.它将消息记录在表"usermsg"上.

I have a chat script written on PHP Ajax and MySQL. It keeps the message logged on a table "usermsg".

我的问题是我只有一个100mb的MySQL数据库，并且我无法保留所有消息，因为我有55个用户，并且数据库配额不足以存储所有消息，当聊天记录满时，我的聊天会自动停止. 因此，每当我觉得它快满了时，我都会从PhpMyAdmin执行truncat. 我想做的是以某种方式每小时执行一次truncat，以便每小时可以清除一次我的表.

My problem is that I have only a MySQL db of 100mb and I can't keep all the messages, as I have 55 users and my db quota is not enough to stock all and when it's full my chat stops automatically. So I perform truncat from PhpMyAdmin each time I feel that it is almost full. What I want to do is somehow perform truncat hourly so it can clear my table every hour.

有人可以提供有关PHP脚本的帮助吗?谢谢.

Can somebody help with a PHP script or something to do that? Thanks.

推荐答案

使用cronjobs每小时执行一次php或使用mysql事件来完成此任务

Use cronjobs to execute the php for an hourly or use mysql events to achieve this task

方法1:

创建一个php并为其执行cron作业

create a php and do cron jobs for it

<?php // write database connection code mysqli_query("TRUNCATE TABLE tablename"); ?>

并在cron中调用此php

and call this php in cron

php /path/to php file

方法2:

创建mysql EVENT.授予对表

create mysql EVENT. give privilege to accesss event for table

SET GLOBAL EVENT_SCHEDULER = ON; CREATE EVENT e_truncate ON SCHEDULE EVERY 1 HOUR DO TRUNCATE TABLE tablename