<?php
include 'Baiy/Baiy.php';
// 配置慢查询日志文件路径
$handle = @fopen("mysql_slow_query_log.log", "r");
$cmd = new cmd();
$i = 0;
while (!feof($handle)) {
$i++;
$buffer = fgets($handle, 4096);
$cmd->addOne($buffer);
if ($i % 2000 == 0) {
$cmd->addDb();
echo $i++ . "\n";
}
}
$cmd->addDb();
echo "ok";
class cmd
{
private $lists;
private $db;
private $addlists;
public function __construct()
{
$this->db = new \Baiy\Mysql(array("dbname" => 'test', "debug" => true));
}
public function addOne($str)
{
if (strpos($str, '# Time:') !== false || strpos($str, 'use ') !== false) {
return;
