Saturday, November 23, 2013

Re: "drop database" Command Kills CloudSQL Instance

Can you please elaborate on what do you mean by 'instance hangs'? You establish new connections? The already establish stopped working? If you have a working established connection you can use SHOW PROCESSLIST and SHOW ENGINE INNODB STATUS to take a look what is going on. Another good to keep in mind: dropping a database requires obtaining some a global lock on the whole table.

-- Razvan ME


On Sat, Nov 23, 2013 at 4:19 PM, <david.nielson@o3apps.com> wrote:
Recently, we created a new CloudSQL instance and are currently working through the configuration of a new GAE application. During the initial setup we have needed to drop the database and recreate it several times, however, each time we do the CloudSQL instance hangs and requires a full restart through the console.

Has anyone else encountered this issue? If so, what is the best course of action?

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/caae4c86-41f9-4faf-911b-9a7085f4204a%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%2BUvTg136cvs1iE73CRqe2xAKam%2BXVtVRAripFhEcfWGa055eg%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.

No comments:

Post a Comment