Fatal error: User 'madsoleh_drupal' has exceeded the 'max_questions' resource (current value: 50000) query: INSERT INTO watchdog

for instance powweb limits max questions to 50000 queries per hour per user for a database. A work around is to add the max usernames allowed per database (which is 3 I believe) edit the drupal CMS mysql login with a rotating mysql login script where it either chooses one of these usernames randomly to login to the database or a username in a set order to log in with an array. That way is increases your queries to 150,000 per hour. Unless you have well over 500 active users at once, that should get you by for an hour pretty good. But deffinatly right now, 50,000 isn't enough if you have 100 current users. Anything more than 500 users at once, you should be on dedicated hosting by now.

So, set up the extra usernames in your webhost, the most allowed.
Then, go into your "sites" folder within the drupal directory and open up settings.php. Locate the $db_url line and put in an array that replicates how the $db_url line is set. Here is a code snippet example

$db_user_array[] = 'mysql://username1:pass23@mysql16.powweb.com/database_drupal1'; //enter 1st user name 
$db_user_array[] = 'mysql://username2:pass23@mysql16.powweb.com/database_drupal1'; //enter 2nd user name 
$db_user_array[] = 'mysql://username3:pass23@mysql16.powweb.com/database_drupal1'; //enter 3rd user name
$db_url = $db_user_array[ rand( 0, ( sizeof($db_user_array) -1 ) ) ];

P.S.
Please send your visitors my way too :D www.thinkingpost.net I could use the traffic.

subscribing

I ran into this problem. It looks like the solution above may be from Drupal 6? Anyway, here it is for drupal 7.

First find the settings.php file which is in your sites->default folder. You need to find this part:

$databases = array (
  'default' => 
  array (
    'default' => 
    array (
      'database' => 'database',
      'username' => 'username',
      'password' => 'password',
      'host' => 'host',
      'port' => '',
      'driver' => 'mysql',
      'prefix' => '',
    ),
  ),
);

Replace that with this:

$user_password_array[] = array (
	'username' => 'username1',
	'password' => 'password'
);
$user_password_array[] = array (
	'username' => 'username2',
	'password' => 'password'
);
$user_password_array[] = array (
	'username' => 'username3',
	'password' => 'password'
);

$tmp_rand = rand(0, sizeof($user_password_array) - 1);

$databases = array (
  'default' => 
  array (
    'default' => 
    array (
      'database' => 'databasename',
      'username' => $user_password_array[$tmp_rand]['username'],
      'password' => $user_password_array[$tmp_rand]['password'],
      'host' => 'host',
      'port' => '',
      'driver' => 'mysql',
      'prefix' => '',
    ),
  ),
);

This should help if you have a lot of traffic. In my case I ran into this on a new site I am developing while using feeds. I was uploading a lot of data. For me it is probably better to just wait or change the login to a different username.