Jump to content
The Uniform Server Community



Recommended Posts

I'm using uniserver for my local test server for my ecommerce software...xcart... Everything was working fine till yesterday while trying to import into the DB I get the following error:


INVALID SQL: 10001 : The size of the data package being transmitted is greater than maximum allowed by the server

SQL QUERY FAILURE:UPDATE xcart_sessions_data SET data=


I truncated all the jibber jabber out of it...


My php settings on uniserver are:


Max memory amount 256M

post_max_size = 32M

upload_max_filesize = 32M

max_allowed_packet = 32M



The file that I am trying to import is only 900KB...so I am confused as to where the problem lies...everyone tells me to put this line in my.ini file "max_allowed_packet = 32M"...Well there is no my.ini file on uniserver only php.ini and I put that line with in this file hoping that this would resolve my problem... Is there another config file???


Surly this is something that has come up before....thanks

Link to comment
Share on other sites

The file you are looking for “my.ini” is named my-small located in folder:

*\Uniform Server\udrive\usr\local\mysql\bin


Try the line in that file.


All the best

Ric :D

Link to comment
Share on other sites

  • 2 weeks later...

That's a tricky little file...I would have never guessed that to be the file I needed...


Question...I see two line in the file that is related to max_allowed_packet....what is the difference between the two...one was set by default at 1M while the other was at 16M.


Is there anything that I may want to change in there??? I have 4G of memory on here so I'm not sure what is best to change...




Link to comment
Share on other sites

Optimising is a complex area it’s not just a matter of allocating maximum memory for a particular application because this will impact on other application including the OS.


There is a lot of information on the Internet Google “optimize mysql memory size” take a look at these pages:


http://emergent.urbanpug.com/?p=61 and



These were taken at random, they highlight one significant point memory usage is dependant on the type of database you are using.


Take a look at the on-line MySQL manual; it has a search facility where you can search for max_allowed_packet, makes interesting reading:



What I am trying to say optimisation is not a yes no type answer it is dependant on a whole host of other things including the type of material you are serving to the end user.


All the best

Ric :)

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...