id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc	focuses
41321	WP won't handle MySQL max_queries_per_hour limit on page load	ledgr		"When mysql max_queries_per_hour is reached queries fail at the beginning of page load and WordPress fails with wrong(?) error output.


{{{
Warning: mysqli_set_charset(): Error executing query in /storage/ssd3/843
/1561843/public_html/wp-includes/wp-db.php on line 824

Warning: Cannot modify header information - headers already sent by (output 
started at /storage/ssd3/843/1561843/public_html/wp-includes/wp-db.php:824) in 
/storage/ssd3/843/1561843/public_html/wp-includes/pluggable.php on line 1210
}}}


And this is example of error if limit is reached in the middle of page load:


{{{
WordPress database error: [User 'id1561843_wp_ac6601cd835' has exceeded the 'max_queries_per_hour' resource (current value: 100)]
SELECT option_value FROM wp_options WHERE option_name = '_site_transient_update_plugins' LIMIT 1

WordPress database error: [User 'id1561843_wp_ac6601cd835' has exceeded the 'max_queries_per_hour' resource (current value: 100)]
SELECT option_value FROM wp_options WHERE option_name = '_site_transient_update_themes' LIMIT 1

WordPress database error: [User 'id1561843_wp_ac6601cd835' has exceeded the 'max_queries_per_hour' resource (current value: 100)]
SELECT option_value FROM wp_options WHERE option_name = '_site_transient_update_core' LIMIT 1

WordPress database error: [User 'id1561843_wp_ac6601cd835' has exceeded the 'max_queries_per_hour' resource (current value: 100)]
SELECT comment_approved, COUNT( * ) AS total FROM wp_comments GROUP BY comment_approved 
}}}

To replicate do:


{{{
update mysql.user set max_questions=100, max_updates=100 where user='id1561843_wp_ac6601cd835';
flush privileges;
}}}
"	defect (bug)	closed	normal		Database		normal	duplicate