gorman;500438 Wrote:
> Hi. I'm willing to do this, but you'll need to "hold my hand" in the
> process. Step by step procedures would be my friends.
To enable slow query logging in MySQL, first stop Squeezebox Server,
then find the my.tt file in the Squeezebox server installation
/server/MySQL/ folder. Add two lines to the my.tt file, making sure
they're in the [mysqld] section of the file:
Code:
--------------------
[mysqld]
...
log-slow-queries = "D:/logs/MySQL/slowquery.log"
long_query_time = 5
--------------------
Select a log name and directory that works for you. The second line
specifies the threshold, in seconds. Any queries that take longer than
this value will be logged. Restart Squeezebox Server and see whether
the log file you designated begins to grow. If it grows really fast you
may have to shut things down and increase the long_query_time so that
only the most problematic queries are logged. If it doesn't grow at all
then you can lower the time, but it probably means that the problem
isn't with the queries.
Make sure you remember to disable the logging after you've found the
problem. I just comment out the lines so that they're available for
future troubleshooting.
Code:
--------------------
#log-slow-queries = "D:/logs/MySQL/slowquery.log"
#long_query_time = 5
--------------------
While you're fiddling with my.tt, you may want to optimize MySQL a
little by giving it more memory to work with. See the following
thread:
http://forums.slimdevices.com/showthread.php?t=60682
--
JJZolx
Jim
------------------------------------------------------------------------
JJZolx's Profile: http://forums.slimdevices.com/member.php?userid=10
View this thread: http://forums.slimdevices.com/showthread.php?t=73010
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/beta
