Kuebler: Odd. would of though the limit would prevent it reading all rows.
Dolson: Could be fault of phpmyadmin
Rumery: Would ORDER BY fix it?
Weslow: For fun add ORDER BY emp_no ASC before LIMIT. :-
Eychaner: Might I add, selecting all is what’s slowing it down, if i just select emp_no it returns in milliseconds. Rumery, PMA forces ORDER BY, so it’s already there.
Peaslee: EXPLAIN is not good at showing limit optimization
Schimandle: Delzer: what else does it enforce?
Rumery: By the estimated rows it seems like the limit optimization might not be used. but as Boleware says.
Rimkus: I have a single uniquely-named table on multiple servers, and want to replicate them all to a single instance, is that possible?
Lelonek: Boleware, just that really.
Chimeno: Delzer: We don’t answer phpMyAdmin questions. See: #phpmyadmin
Reifman: Take out all the PMA I put in any of my messages.
Frankford: Did you run EXPLAIN SELECT * FROM salaries where emp_no 1000 LIMIT 11
Rumery: Delzer, because there seems to be a separate index for emp_no so it can be used for the simpler query
Peat: Rumery, yeah but I thought if I’m doing WHERE PK getting the other data wouldn’t be THAT much slower
Rumery: Delzer, yes, I agree with it being quite slow
Kimbrell: Boleware, http://pastebin.com/NqtHeuFw
Navaretta: Can you execute your query in mysql client?
Micallef: I just figured XAMPP has some CLI access, I’ll try executing my queries in there
Janczewski: Https://gist.github.com/9776c9010a82db7d0acf
Fournier: PMA is the culprit, sorry.
Gottshall: Change the emp_no that you are testing
Cordrey: Https://gist.github.com/8ef2fc07ad2976222a79
Klecker: Ok, so all queries are fast
Perea: If you run the same query multiple times, it could be cached by query cache
Onstead: Hi guys. I’m seeing some odd behaviour with MySQL. I have a single instance behind an AWS ElasticLoadBalancer trying to get a load test done. Basically when the test runs I can see 1000 connections back up on the ELB. So I thought MySQL couldn’t accept anymore connections because it was busy. However, CPU is at 15% and memory isn’t really being touched. ALso, when I run mysqladmin -p -i1 extended grep Threads_running the count just reports 1 which I’m guess
Dorchy: Ing is the thread query. Does anybody know if there’s anything else I can check? Running out of ideas
Mackall: Basically, the application servers are taking upto 8 seconds to connect to MySQL
Lafavor: Tricks: See http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_max_connections
Rumery: Tricks, does your setting limit it to 1000 ?
Jurgensen: Rumery, it’s already set to 4000 which is probably too high
Ryckman: I’m wondering if the box is dodgy
Squiers: Is there a way to see rows_examined for queries that do not make the slow_log?
Gidwani: Session status or the general log
Encino: I’m setting up multiple instances with multiple cnf files, but can’t seem to set the root p***word, i’m trying this: /usr/bin/mysqladmin –defaults-file=/db/pg.cnf -u root p***word ‘poodoo’
Biren: Gidwani: general log doesnt have rows_examined
Ullum: Gidwani: Is there a way to enable that?
Foss: But ghetting errors about not connecting to the default socket i’ve set the configs to listen on tcp
Gidwani: It isn’t super valuable because your’e going to run the query again to get explain plans right?
Gidwani: I mean it is nice to have but since the slow query log is based on time you can kind of work around it
Gidwani: Https://dev.mysql.com/doc/refman/5.5/en/execution-plan-information.html
Story: Heyas : does anyone knows where are the JSON UDFs for MySQL 5.6? I can’t find them in labs.mysql.com