#4847 Some query take very long time

[JFDionne]

Hi, some query, like a simple Select * from TABLE GROUP BY Fields1,Fields2 take like 3-4 minutes to show, when it show up it write "Showing rows ... Query took 0.0418 seconds.)"

if I enable "profiling" on this query, I got errors:

Notice in ./libraries/sql.lib.php#420
Undefined index: time

Backtrace

./libraries/sql.lib.php#345: PMA_analyzeAndGetTableHtmlForProfilingResults(array)
./libraries/sql.lib.php#2033: PMA_getHtmlForProfilingChart(
NULL,
string 'Dispatch_Mysql',
array,
)
./libraries/sql.lib.php#2242: PMA_getQueryResponseForResultsReturned(
object,
array,
string 'Dispatch_Mysql',
string 'TC_Horaire',
NULL,
NULL,
object,
string './themes/pmahomme/img/',
string '30',
integer 25,
string 'SELECT * FROM TC_Horaire GROUP BY Numero,Type LIMIT 0, 25 ',
NULL,
NULL,
array,
NULL,
NULL,
string 'SELECT * FROM TC_Horaire GROUP BY Numero,Type',
NULL,
)
./import.php#717: PMA_executeQueryAndGetQueryResponse(
array,
boolean false,
string 'Dispatch_Mysql',
string 'TC_Horaire',
NULL,
string 'SELECT * FROM TC_Horaire GROUP BY Numero,Type ',
NULL,
boolean false,
NULL,
NULL,
NULL,
string 'tbl_structure.php',
string './themes/pmahomme/img/',
NULL,
NULL,
NULL,
string 'SELECT * FROM TC_Horaire GROUP BY Numero,Type ',
NULL,
NULL,
)

[Marc Delisle]

Your subject mentions 4.3.x, which is an outdated version.

[JFDionne]

My bad, I mean 4.4.1 versus 4.3.x

[Madhura Jayaratne]

The error you get while profiling has been fixed and will be part of 4.4.2 https://github.com/phpmyadmin/phpmyadmin/commit/c5260bb56d59fd78d51533f5763917817c1f7df6

[JFDionne]

do you think this error was making the query taking, like 3-4 minutes, to show?

[Marc Delisle]

Do you have access to CLI mysql to try this query on the same MySQL server?

[JFDionne]

Yes, and working fine, even with phpmyadmin version 4.3.x and less. That "problem" appear since 4.4 at my knowledge

[Marc Delisle]

Which MySQL server version?
Which extension (mysqli?)
Which PHP MySQL client library?
How many databases on this server?

[JFDionne]

mysql:

Server: ReGIM (BDC) (25.11.xxx.xxx via TCP/IP)
Server type: MySQL
Server version: 5.6.23 - MySQL Community Server (GPL)
Protocol version: 10
User: root@25.138.xxx.xxx
Server charset: UTF-8 Unicode (utf8)

web:
Apache/2.2.15 (Scientific Linux)
Database client version: libmysql - mysqlnd 5.0.11-dev - 20120503 - $Id: 3c688b6bbc30d36af3ac34fdd4b7b5b787fe5555 $
PHP extension: mysqli Documentation
PHP version: 5.6.8

I'm using phpmyadmin from a server and connect to a remote mysql via vpn ( I have multiple server configured into the config file)

I have 8 Database into this server including "mysql,information_schema and performance_schema"

I've included my config file in attachments on this post (I've only removed the server name and the IP)

[Alexander Schuch]

I observed the same, but I tracked it down to the SQL autocomplete feature and reported in in [#4858]. Can you check if this is what happens to you as well?

[JFDionne]

Hmm, I think you're right, it seem to be related to your [#4858] beacuse when I use the "search" button instead of using the sql query it seem to be more "ok"

[Alexander Schuch]

[#4858] has been fixed in 4.4.7. Do you still have the problem you observed before?

[JFDionne]

Nope still there :( And when I do an error into the query, it can take the same time to tell me I have an error.