I’ve been running into CPU throttling issues on my server. When I analyze my mysql_slow_queries logs I find dozens and dozens of calls by Bad Behavior to “CREATE TABLE IF NOT EXISTS…” (via bb2_table_structure() in bad-behavior-mysql.php).
While the “IF NOT EXISTS” condition keeps it from creating the table over and over, it is still using system resources by checking every time a visitor hits my site. In the mediawiki version of Bad Behavior there is a CONSTANT (BB2_NO_CREATE) that can be set to tell it to skip the CREATE TABLE call.
Why is there no CONSTANT for the WordPress version and how can I prevent CREATE TABLE from being called needlessly over and over? We only need to CREATE TABLE once when the plugin is installed.
- The topic ‘CREATE TABLE called over and over and over’ is closed to new replies.