wordpress mu由于每建立一个新的用户都会自动建立十多张表，因此当注册大量用户的时候会建立非常多的表，引起系统的性能出现问题，我这里写了一段脚本，可以将wordpress mu中的不活动用户（从没有发布文章的用户）进行删除，以节约系统资源。php脚本源代码如下：
<?php
&mysql_host = "localhost";
&mysql_user = "root";
&mysql_pass = "";
&mysql_db = "wordpress";
&mysql_mylink = mysql_connect(&mysql_host, &mysql_user, &mysql_pass)
or die ("cannot make the connection");
mysql_select_db(&mysql_db, &mysql_mylink)
or die ("cannot connect to the database");
&strsql="select * from wp_blogs where blog_id>2 ";
&rs_query = mysql_query(&strsql);
&alls=mysql_num_rows(&rs_query);
while ((&rs = mysql_fetch_array(&rs_query))) {
extract(&rs);
&blogid=&rs["blog_id"];
&query2 = "select * from wp_".&blogid."_posts ";
&result = mysql_query(&query2);
&num= mysql_num_rows(&result);
//print #
if (&num<=2) {
print "drop table if exists wp_".&blogid."_comments;";
print "drop table if exists wp_".&blogid."_links ;";
print "drop table if exists wp_".&blogid."_options ;";
print "drop table if exists wp_".&blogid."_postmeta ;";
print "drop table if exists wp_".&blogid."_posts ;";
print "drop table if exists wp_".&blogid."_terms ;";
print "drop table if exists wp_".&blogid."_term_relationships ;";
print "drop table if exists wp_".&blogid."_term_taxonomy ;";
print "delete from wp_blogs where blog_id=".&blogid.";";
}
}
mysql_close ();
?>
由此看出，wordpress mu使用起来实在不怎么样，多表结构设计的可能有问题，会带来很多麻烦。
