Re: [Maria-discuss] Trouble getting MariaDB to start up

2014-04-01 Thread Daniel Black
- Original Message - > On 01/04/14 04:52, Daniel Black wrote: > > Start one of the nodes with service mysql bootstrap (to define the > > primary node). > > This is still failing for me. It's apparently not to do with the > clustering, but for some other reason I can't determine. With thi

[Maria-discuss] New Question: unable to upgrade from MariaDB 5.5 to MariaDB 10.0 using YUM

2014-04-01 Thread AskMonty KB
Hello, A new question has been asked in "MariaDB community" by cyberdomecyberdome: I created a file mariadb.repo and put in info for mariadb 10.0, when I run the command yum -y update or yum -y upgrade mariadb-server mariadb-client, Loaded plugins: langpacks, r

Re: [Maria-discuss] MariaDB subquery

2014-04-01 Thread James Qian Wang
Dear All, Here is another query (table structures are the same as my previous email): EXPLAIN EXTENDED SELECT IFNULL(CONCAT(t.sender, '|', t.msg), 'unknown') AS terminate, c.cid FROM `c_extra` x FORCE INDEX (`last_update`) INNER JOIN `c` c USING (`cid`) LEFT JOIN s_traces t ON(c.cid =

[Maria-discuss] Building on Windows with cmake 2.8.12.2 and Visul Studio 2012

2014-04-01 Thread Wes Bullard
I've been trying for a few days now first with 10.0.9 and now with 10.0.10 to build on windows x64 both by command line and in visual studio 2012. Straight building seems to go fine but if I try and build --target package or even --target msi I get errors about missing pdb files. This is both in R

Re: [Maria-discuss] Trouble getting MariaDB to start up

2014-04-01 Thread Jonathan Gazeley
On 01/04/14 04:52, Daniel Black wrote: As a quick look I'd start with wsrep_cluster_address containing the full addresses and pc.wait_prim=no. wsrep_cluster_address = gcomm://192.168.131.94,192.168.186.35,192.168.129.129?pc.wait_prim=no OK, I've changed this. having all the addresses and

[Maria-discuss] flush tables for export

2014-04-01 Thread Federico Razzoli
Hi list This is just a curiosity, but anyway: Of course I understand the need for the FLUSH ... FOR EXPORT syntax for InnoDB. But why does MyISAM support it? In which way is it better than WITH READ LOCK? Regards, Federico ___ Mailing list: https://