mySQL max packet allowed

[socialcesspool]

Hello, i am getting an error with mySQL. I need to increase the "max packet allowed" to something higher. Drupal has a pretty large database once you get alot of modules installed, and it causes this error.

Thanks for your time.

----------------------------------------

Warning: MySQL server has gone away query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp)

VALUES (1, 'php', '<em>MySQL server has gone away\nquery: UPDATE cache SET data =&amp;#039;a:4....

in C:\xampp\htdocs\studentindia\includes\database.mysql.inc on line 172

Solution:

The error is because max packet allowed by mysql has been exceeded.You need to change it.This generally happens whan the table size becomes very large. Therefore, do the following to solve it:

i) Go to xampp\mysql\bin

ii) open my.cnf

iii)change the Max packet Allowed = 64M instead of 8M.

 

[xav0989]

The way you present it, it looks like it's a problem with your personal xampp MySQL that needs to get a higher packet number.

 

[socialcesspool]

So...any admins gonna help me?

Yeah i gave that for the sake of the admin knowing where to look to find the sql conf. My error is the exact same thing.

For the record, you must increase this by default in order to run Drupal. Since its a complex app with alot of database tables, the default setting wont cut it. As soon as you start giving Drupal some modules, it gives this error and renders the site almost useless.

I would like to continue my hosting here, eventually buying a plan, but if there is no support and no one even attempts to help me, then i will move on to a more reliable solution.

PS: If you are trying to run a server able to handle fantastico (and its many database intensive apps) then you must prepare your default systems to handle them. This is the modern internet, not 1995 anymore - 8mb is nothing for a database intensive portal. 10x the size (80mb) is preferable

 

[ah-blabla]

Re: So...any admins gonna help me?

PS: If you are trying to run a server able to handle fantastico (and its many database intensive apps) then you must prepare your default systems to handle them. This is the modern internet, not 1995 anymore - 8mb is nothing for a database intensive portal. 10x the size (80mb) is preferable

From what I know no-one has had similar problems with database connections, I also doubt / should warn you, that the admins probably aren't going to change the settings, especially since server resources are limited, and this is one user that is experiencing the problem. Try check what modules you are using / don't need, and thin your site down that way, but don't bargain on the server settings being changed.

Yeah i gave that for the sake of the admin knowing where to look to find the sql conf. My error is the exact same thing.

It's a GNU/Linux server here, so things are going to be in a rather different place. And the admins are quite knowledgeable. That you're getting the problems on your local pc suggests that it's the software you're using that is too resource intensive, and not a bad server configuration, since generally XAMPP is configured sensibly.

 

[socialcesspool]

1. i am NOT getting this error on a local pc because my local PC's are set up correctly. Why would i be posting on an x10 forum if this was on my local pc??????? This error is due to an improperly configured SQL server. Yes the path in xampp is different, but the rest is the same.

2. this is common with many database intensive apps due to the large table sizes or many users.

3. ive installed Drupal many many times, and i know what it needs and how it should act

4. i run both windows and linux servers -- its an extremely easy fix in both. all you do is change the "8" to something higher.

5. if they cant support the apps they give you to install by default there is something wrong with the picture here. Drupal 6.14 is in Fantastico. Im guessing stuff like Twiki and Joomla encounter the same wall once you get them rolling with your data, users, and content.

Drupal docs clearly state:
"When using Drupal 5.x or later, particularly with contributed modules, it may be necessary to set the system variable max_allowed_packet to at least 16M"

 

[Livewire]

5. if they cant support the apps they give you to install by default there is something wrong with the picture here. Drupal 6.14 is in Fantastico. Im guessing stuff like Twiki and Joomla encounter the same wall once you get them rolling with your data, users, and content.

Drupal docs clearly state:
"When using Drupal 5.x or later, particularly with contributed modules, it may be necessary to set the system variable max_allowed_packet to at least 16M"

Fantastico is not supported directly by x10; it's something that comes with cPanel, and x10 can't remove/add applications to it. That's the problem there; the other problem is the High Resource Usage section in the TOS - if they set it to 16M, you may very quickly end up getting suspensions for HRU instead.

Not saying it's a guarantee you'd get an HRU suspension, but it's entirely possible.

 

[descalzo]

1. The current setting for max_allowed_packet on my account on Chopin is 16777216. Not 8M.

 

[Corey]

The max packet size is 16M and will not be raised at this time.