MySQL – How to Download Slow Query Log on Google Cloud SQL

google-cloud-sqlMySQLslow-log

I'm having a difficult time locating the log file to download. When running

show global variables like '%slow%';

I can see it is located

/mysql/logs/slow.log

When I log into the instance though that path doesn't exist. Any ideas?

This is through google cloud sql and using mysql as the db.

Best Answer

After a lot of digging I found an answer. It is not perfect as the quality of data may need some massaging, but it works.

gcloud logging read projects/yourproject/logs/cloudsql.googleapis.com%2Fmysql-slow.log --format json| jq -rnc --stream 'fromstream(1|truncate_stream(inputs)) | .textPayload' > slow-log-timestamp.log

Related Solutions

Mysql – Enable slow_query_log tries to write to slow_log.CSV

I did these steps :

set global slow_query_log=0;
remove the slow log file in system
set global slow_query_log=1;

it works fine, so I tried these steps:

mysql> set global slow_query_log=0;
Query OK, 0 rows affected (0.12 sec)

mysql> set global slow_query_log_file='/tmp/slow.log';
Query OK, 0 rows affected (0.10 sec)

mysql> set global slow_query_log=1;
Query OK, 0 rows affected (0.00 sec)

still works, and new slow log file is generated as /tmp/slow.log.

At last, the value of global variable log_output decides where to generate the general log and slow log's output, not the file format.

MySQL – Why Are Slow Queries Not Logging?

I think I got the answer:

You need to put those options under the [mysqld] section

[mysqld]
slow-query-log=1
slow-query-log-file=/var/logs/my.slow.log
long_query_time=1

and restart mysql

UPDATE 2013-03-05 16:36 EST

I don't know why this is still happening, but please try this:

service mysql stop
rm -f /var/logs/my.slow.log
touch /var/logs/my.slow.log
chown mysql:mysql /var/logs/my.slow.log
service mysql start

then run SELECT SLEEP(10); and see if it lands in /var/logs/my.slow.log

Best Answer

Related Solutions

Mysql – Enable slow_query_log tries to write to slow_log.CSV

MySQL – Why Are Slow Queries Not Logging?

UPDATE 2013-03-05 16:36 EST

Related Question