flyoffacliff Posted November 5, 2013 Posted November 5, 2013 I was getting SQL error "1153 - Got a packet bigger than 'max_allowed_packet' bytes" on my old webhost and am looking to move here. What is the limit here?
Ice IT Support Posted November 5, 2013 Posted November 5, 2013 max_allowed_packets is set to 1 megabyte (or 1,048,576 bytes) on Stevie. I believe it is the same on Johnny. [Edit: Fixed typo.]
Excalibur Posted November 5, 2013 Posted November 5, 2013 If you have big query or blob, try to split query or use chunks, thats is betterchoice in frontend, even in meduim size DWH, if you still need to know that try next: show variables like 'max_allowed_packet'; Also try above here, personally I choose Stevie.
flyoffacliff Posted November 5, 2013 Author Posted November 5, 2013 I have Johny and I just tried that, it is only 1mb (1048576 B ). I need it set to at least 4mb for my website to work properly. Could you please raise this a little? Thank you.
flyoffacliff Posted November 5, 2013 Author Posted November 5, 2013 I am getting SQL error "1153 - Got a packet bigger than 'max_allowed_packet' bytes" on my website. You have the server limit set to 1mb (1048576 . It needs to be raised to 4mb or higher for my website to work correctly. Could you please change this? :)This is on server Johny. Thank you.
Ice IT Support Posted November 6, 2013 Posted November 6, 2013 This support request is being escalated to our root admin. Merged topics.
flyoffacliff Posted November 6, 2013 Author Posted November 6, 2013 This support request is being escalated to our root admin. Merged topics. Thank you. I really wanted an account on Stevie. But I am in a bad time-zone, so the daily limit is always expired by the time I wake up. If you could transfer my account to Stevie and raise the limit there, that would be great. If you would rather do it on Johny, that is okay too. Thank you so much.
Krydos Posted November 6, 2013 Posted November 6, 2013 Bother servers were set to the default value of 1048576 which is about 1 megabyte. I fixed your typo iceitsupport. Johnny is now set to 4999168 which is about 5 megabytes. Excalibur is correct though, it's probably best to try to break that down into smaller chunks. Keep in mind that we do monitor mysql usage and if you're causing high load your account will be suspended.
flyoffacliff Posted November 7, 2013 Author Posted November 7, 2013 Bother servers were set to the default value of 1048576 which is about 1 megabyte. I fixed your typo iceitsupport. Johnny is now set to 4999168 which is about 5 megabytes. Excalibur is correct though, it's probably best to try to break that down into smaller chunks. Keep in mind that we do monitor mysql usage and if you're causing high load your account will be suspended. Thank you so much. I will be using a modifed version of MyBB forum software for this website. The project involves creating hundreds of boards. Using the MyBB GUI is too slow, so I am adding them directly to the database using PHPMyAdmin. But the problem is that MyBB caches the lists of boards, and clearing the cache involves running this large query. How do I tell how much SQL data I have used?How much am I allowed to use?If I go over the limit, will I get a warning before being suspended?
Krydos Posted November 9, 2013 Posted November 9, 2013 How do I tell how much SQL data I have used?http://johnny.heliohost.org:2082/frontend/x3/sql/index.htmlHow much am I allowed to use?500 MB if you don't upload anything else to your account or have any mail in any of your boxes.If I go over the limit, will I get a warning before being suspended?If you use too much database space, no you just won't be able to add anything else.
flyoffacliff Posted November 10, 2013 Author Posted November 10, 2013 How do I tell how much SQL data I have used? http://johnny.heliohost.org:2082/frontend/x3/sql/index.html How much am I allowed to use? 500 MB if you don't upload anything else to your account or have any mail in any of your boxes. If I go over the limit, will I get a warning before being suspended? If you use too much database space, no you just won't be able to add anything else. Thank you. So it is just a storage limit. No bandwidth limit. Correct? Thank you.
Krydos Posted November 10, 2013 Posted November 10, 2013 There is no bandwidth limit for mysql or for http or ftp or pop3 or imap any other service. However, if you're transferring large amounts of data it causes load which we do monitor, and if you are causing enough load to adversely effect the other accounts that share your server then your account will be suspended to restore full functionality to everyone else. It isn't fair for one person on shared hosting to hog all the system resources.
Recommended Posts