Huge db after several copies of the same blog
-
We’ve been using the version 1.0.2 to clone a “template” site with only 4 pages and 3 widgets. After approximately 150 copies, our database has 300.000 tables and 9Gb of data, which seems too much for 150 sites with 4 pages each.
It appears that with every copy we’re carrying the previous clones, creating a geometrical growth of the database via empty tables. As a result we’re seeing things like this in our server:
> -rw-r–r– 1 root root 998 Mar 4 06:40 wp_125____________posts.sql
> -rw-r–r– 1 root root 995 Mar 4 06:41 wp_125___________posts.sql
> -rw-r–r– 1 root root 1008 Mar 4 06:41 wp_125__________posts.sql
> -rw-r–r– 1 root root 985 Mar 4 06:42 wp_125_________posts.sql
> -rw-r–r– 1 root root 988 Mar 4 06:42 wp_125________posts.sql
> -rw-r–r– 1 root root 989 Mar 4 06:43 wp_125_______posts.sql
> -rw-r–r– 1 root root 994 Mar 4 06:44 wp_125______posts.sql
> -rw-r–r– 1 root root 997 Mar 4 06:44 wp_125_____posts.sql
> -rw-r–r– 1 root root 980 Mar 4 06:45 wp_125____posts.sql
> -rw-r–r– 1 root root 977 Mar 4 06:45 wp_125___posts.sql
> -rw-r–r– 1 root root 13204 Mar 4 06:46 wp_125__posts.sql
> -rw-r–r– 1 root root 11991 Mar 4 06:46 wp_125_posts.sqlDoes 1.0.3 fix this behaviour? Is there a way to clean our current database?
Thanks
- The topic ‘Huge db after several copies of the same blog’ is closed to new replies.