[Help] PHPMyAdmin Help
#15

You need to enable the slow-query log for MySQL so I can see what could be wrong there.. You could also try running the query in phpMyAdmin under the SQL tab and see what it outputs.

Here's how to enable the slow-query in wamp:
Quote:
Originally Posted by Jesus-Blog
Although in hindsight this is DEAD easy, I’ve just had a bit of a hard time finding out how to do it, so I thought I’d make a quick post which will hopefully get indexed by ****** and save some other folk the hard time I had. Thoughtful, eh.

So, to enable the slow query log in WAMP is as simple as adding

log-slow-queries=PATH to your config file.

The config file is located in your wamp installation directory, under bin/mysql/mysql.version/my.ini

In there you will find an entry for standard logs, which will look something like log-error=c:/wamp/logs/mysql.log

Add the slow query flag, and change the log file name to something like log-slow-queries=c:/wamp/logs/mysqlslow.log

Restart wamp, and you’re done.
Reply


Messages In This Thread
[Help] PHPMyAdmin Help - by Stephano - 06.02.2013, 21:07
Re: [Help] PHPMyAdmin Help - by Kirollos - 06.02.2013, 22:05
Re: [Help] PHPMyAdmin Help - by Stephano - 07.02.2013, 01:02
Re: [Help] PHPMyAdmin Help - by 3ventic - 07.02.2013, 06:34
Re: [Help] PHPMyAdmin Help - by Cameltoe - 07.02.2013, 06:38
Re: [Help] PHPMyAdmin Help - by Stephano - 07.02.2013, 20:35
Re: [Help] PHPMyAdmin Help - by 3ventic - 08.02.2013, 06:05
Re: [Help] PHPMyAdmin Help - by Stephano - 08.02.2013, 22:01
Re: [Help] PHPMyAdmin Help - by Memoryz - 08.02.2013, 22:03
Re: [Help] PHPMyAdmin Help - by [MG]Dimi - 08.02.2013, 22:17
Re: [Help] PHPMyAdmin Help - by Stephano - 08.02.2013, 22:25
Re: [Help] PHPMyAdmin Help - by [MG]Dimi - 08.02.2013, 22:30
Re: [Help] PHPMyAdmin Help - by Stephano - 08.02.2013, 23:04
Re: [Help] PHPMyAdmin Help - by Stream - 18.02.2013, 07:53
Re: [Help] PHPMyAdmin Help - by 3ventic - 19.02.2013, 09:08
Re: [Help] PHPMyAdmin Help - by Stephano - 20.02.2013, 21:31

Forum Jump:


Users browsing this thread: 1 Guest(s)