Robidoux: Rumery: Sorry, I have no idea about that manual entry.
Rumery: Https://dev.mysql.com/doc/refman/5.5/en/problems-connecting.html
Rumery: Mariuscc, check these, but not sure if it can be solved “cleanly”
Nicolay: Mariuscc, make sure your host is correct for the account
Nicolay: Try a % in host field for now
Dulek: It’s for development only, so will not affect any user
Clyatt: Mariuscc: If you can connect with mysql cli from some host you should be able to connect with anything else from the same host
Mccrain: I’m connecting with mysql cli from the same host
Clyatt: Mariuscc: Then there is no MySQL related problem
Rumery: Do I understand it correctly that named parameters in prepared statements are only PDO or other connector thing and mysql supports only “positional” parameters?
Mattoon: Is there a function in mysql that returns the match string from a regex? I can’t find one. I want to look for strings starting “INSERT INTO blah” and return the table name, i.e. the third word
Walle: Stormes: Regexp Extract – http://thenoyes.com/littlenoise/?p=136
Verhey: Stormes: https://launchpad.net/mysql-udf-regexp
Rumery: Afaik nothing “native” – only rexeg version of LIKE is available in MySQL
Rumery: Do I understand it correctly that named parameters in prepared statements are only PDO or other connector thing and mysql supports only “positional” parameters?
Clyatt: Stormes: “the third word” can be extracted with SUBSTRING_INDEX by the way
Ikehara: Stormes: See http://dev.mysql.com/doc/refman/5.6/en/string-functions.html#function_substring-index
Bucklin: How do I check for progress of my query?
Korth: Is there a way to do that?
Lemp: At least to know which line it is processing out of how many
Sabagh: Gah, the readline on mycli is borken too
Rumery: Reller, afaik no, if you do “show processlist;” you can see some stages, but mostly the slow part will be on specific stage taking ages without any detailed info
Sabagh: Reller: no, nothing so simple as line by line process
Sabagh: After teh query has run you can get profiling information to get extended profiling you need to turn it on
Sabagh: Reller: can be usefull to see which stage your query is stuck
Rumery: Reller, there is usually no way to say how many it will need to process, and the “current one” is hard to define.
Sabagh: Or ‘waiting for table lock’
Sabagh: Tanj: what’s a goog test for rlwrap?
Sabagh: Reller: another trick it to examine your query before you run it
Tur: Rumery: Sorry, I have no idea about that manual entry.
Goldhorn: Reller: See http://dev.mysql.com/doc/refman/5.6/en/explain.html
Bridge: Reller: http://dev.mysql.com/doc/refman/5.6/en/execution-plan-information.html and http://dev.mysql.com/doc/refman/5.6/en/explain.html
Imig: What is the scope of “deterministic” in a function? Not expected to produce the same value in the same transaction but within the same statement?
Imig: I’m hunting a mysterious bug
Rumery: Imig, returning the same output for the same input? no side effects
Imig: It’s only doing selects but our automated tests fail occasionally and I’m trying to figure out why
Imig: It’s READS SQL DATA DETERMINISTIC
Oroak: Guys, anyone got 2 mins to help me understand what I am doing wrong?
Imig: The fun part is that the automated tests do tests in a random order with random id seeds so the order of the data may be involved
Clyatt: Imig: Reading SQL data contradicts deterministic
Kochan: Duh, such questions were obviously unnecessary according to tules :
Clyatt: Imig: deterministic means the returned value is always the same if the input parameters remains the same.