Re: [Maria-discuss] doubt about index

2015-06-25 Thread Roberto Spadim
but check my idea, for example... select some_fields... from table where (where 2,3,4,5,6+ index could be used) order by (where 1 index could be used) optimizer prefer the order by index, i want that optimizer ignore the order by index option (it doens't exists today) does it make sense? 2015-

Re: [Maria-discuss] doubt about index

2015-06-25 Thread Justin Swanhart
Ignore index Sent from my iPhone > On Jun 25, 2015, at 7:44 PM, Roberto Spadim wrote: > > could this be helped by a optimizer_switch to don't optimize using order by? > > 2015-06-23 10:18 GMT-03:00 Justin Swanhart : >> Hi, >> >> You can't fix that with a flag that says an index is unique. It

Re: [Maria-discuss] doubt about index

2015-06-25 Thread Roberto Spadim
could this be helped by a optimizer_switch to don't optimize using order by? 2015-06-23 10:18 GMT-03:00 Justin Swanhart : > Hi, > > You can't fix that with a flag that says an index is unique. It is a big > problem. Domas opened a bug on a variety of cases of it recently. > > On Mon, Jun 22, 20

Re: [Maria-discuss] FedereratedX ODBC Source

2015-06-25 Thread Darin Keever
Guillaume, I believe that was the first approach, but there was some limitation. I thought it was insert/updates, but from the look of features, that is available. It probably would not take much to move over to connect, though I know they have already developed quite a bit of tools based on the

Re: [Maria-discuss] Can't connect to local MySQL server through socket

2015-06-25 Thread Sylvain Raybaud
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 25/06/2015 14:42, Guillaume Lefranc wrote: > Well, if you had said that your shell was busybox in the first > place, that would have saved us a lot of time... :-) It's not my shell, my shell is regular bash, but many other tools, yes. Connecting t

Re: [Maria-discuss] Can't connect to local MySQL server through socket

2015-06-25 Thread Guillaume Lefranc
Well, if you had said that your shell was busybox in the first place, that would have saved us a lot of time... :-) 2015-06-25 14:41 GMT+02:00 Sylvain Raybaud < sylvain.rayb...@green-communications.fr>: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Guillaume, > > On 25/06/2015 13:40, Guil

Re: [Maria-discuss] Can't connect to local MySQL server through socket

2015-06-25 Thread Sylvain Raybaud
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Guillaume, On 25/06/2015 13:40, Guillaume Lefranc wrote: > Just a suggestion, you can try adding "set -x" to > /usr/bin/wsrep_sst_rsync, so the script will dump its output in the > log. You should be able to know where it hangs precisely then. It gi

Re: [Maria-discuss] Can't connect to local MySQL server through socket

2015-06-25 Thread Guillaume Lefranc
Sylvain, I don't know much what buildroot does, so I don't know if you're hitting any limitation that buildroot might have. Just a suggestion, you can try adding "set -x" to /usr/bin/wsrep_sst_rsync, so the script will dump its output in the log. You should be able to know where it hangs precisel

Re: [Maria-discuss] Can't connect to local MySQL server through socket

2015-06-25 Thread Sylvain Raybaud
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi I'll try hard to fix the problem with rsync, even if I switch to mysqldump or xtrabackup-v2 in the future. Some context : mariadb and galera are built in buildroot and run on raspberry pis (ARMv6). Mariadb is started manually. I fixed the config f