Re: Setting max_allowed_packet

One row with a column of 400M. Wow! Are you sure you really want that? :-) One workaround I would suggest is to use the IP connectivity [1].

[1] https://developers.google.com/cloud-sql/docs/external

-- Razvan ME

On Fri, Nov 22, 2013 at 12:03 AM, Gabriel Axel <guznik@gmail.com> wrote:

I currently have longtext fields of up to 400M, so mysqldump fails if I use lower max-allowed-packet value. Any way to overcome this?

On Friday, November 22, 2013 12:53:18 AM UTC+2, Razvan Musaloiu-E. wrote:

You hit the 16M limit for a line length. Can you chop that in smaller pieces? If you use a mysqldump --max-allowed-packet=16777216 things should work fine.

-- Razvan ME

On Thu, Nov 21, 2013 at 2:32 PM, Gabriel Axel <guz...@gmail.com> wrote:

Thanks. I started importing my database, the import ran for two and a half hours and then failed. I tried to repeat it and the same happened. I used mysqldump with the flags as described in the instructions, gzipped it and uploaded to gs://docollab-helper/dump.sql.gz . What went wrong?

On Thursday, November 21, 2013 5:48:54 PM UTC+2, Razvan Musaloiu-E. wrote:

I manually set the max_allowed_packet to 1073741824 for docollabapp:docollab. That's the max (reference).

-- Razvan ME

On Thu, Nov 21, 2013 at 7:35 AM, Gabriel Axel <guz...@gmail.com> wrote:

I understand that you removed the super privilege entirely. Can you please either enable it or set max_allowed_packet=999M on my instance
docollabapp:docollab ?

On Thursday, November 21, 2013 10:22:11 AM UTC+2, Gabriel Axel wrote:

Hello,

I'm trying so set max_allowed_packet by running the following command from the root user:
SET GLOBAL max_allowed_packet = 999*1024*1024
and I get this error:
Error Code: 1227. Access denied; you need (at least one of) the SUPER privilege(s) for this operation

I need this because my database stores longtext fields which cause import and insert/updates to fail without increasing max_allowed_packet.

Thanks.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/9dcfac85-c808-4c50-9176-feed1390692a%40googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/6e64f31f-bfdf-47e2-bacf-ce8b80dbe88a%40googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/619ba22b-d1f3-4c53-9cab-13255e7f197d%40googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CA%2BUvTg2WLXJAs%3DOmNWXx_Wdt%3DASVS8pWm78%3D-ZY08dqcMsGX-Q%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.