- discuss - lists.mariadb.org

[Maria-discuss] Issues using the connect engine with ODBC on Linux
by eric hernandez 15 Oct '13

15 Oct '13

Hi, I am trying to use the "Connect" engine to read data from Microsoft SQL Server 2008 R2 from a linux based MariaDB instance. I am getting the following error. create table tablea ( -> id bigint(20) NOT NULL, ) -> engine=connect table_type=ODBC -> block_size=10 -> tabname='tablea' -> Connection='DSN=MSSQLTestServer' ERROR 1105 (HY000): Unsupported table type ODBC I have the underlying linux box talking fine to the "MSSQLTestServer" via odbc through the iSQL command. You can see here where i connect via isql from the command line with no issue isql -v MSSQLTestServer sa $sanitized +---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit | | | +---------------------------------------+ So odbc is installed and working properly on the linux box. Do you have any advice on how to get past this error? Thanks, -Eric

3 2

[Maria-discuss] New Question: I want to install mariadb5.5.33(with tokudb plugin) without 'apt-get install'
by AskMonty KB 12 Oct '13

12 Oct '13

Hello, A new question has been asked in "MariaDB FAQ" by frances714: -------------------------------- I want to install mariadb5.5.33(with tokudb plugin) without 'apt-get install' on debain 6 squeeze(i686), but there is only mariadb5.5.30(with tokudb plugin) for x86_64 on tokudb.org. So is there any method to install the mariadb(with tokudb plugin) on my computer? Thank you so much! -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/i-want-to-install-mariadb5533with-tokudb-plugin-wi…

1 0

[Maria-discuss] DELETE Operations in MariaDB 5.5.30 do not reduce size of table files
by Steve Afrin 09 Oct '13

09 Oct '13

To anyone who knows how the MyISAM engine works (or maybe this is independent of the DB engine), here’s my scenario: * I have a table with 180,000 rows * I delete 170,000 rows with a DELETE and subsequent COMMIT statement * The MYI table file is still the same size it was before the 170k rows were deleted I saw there’s an administrative PURGE command, but it looks like that is just for purging data from binary logs, if you’ve even turned on the option for keeping binary logs. In MariaDB 5.5.30 or later, how do I run a purge operation to compress the deleted rows of data out of my physical table files and cause the reindexing to happen for the data that is still in my tables? Thanks, Steve

2 1

[Maria-discuss] New Question: regarding seconds behind master variable in 10.0.4
by AskMonty KB 09 Oct '13

09 Oct '13

Hello, A new question has been asked in "MariaDB Documentation" by jaihind213: -------------------------------- hi we setup maria 10.0.4 for multisource replication. it was replicating from a percona 5.5 master. When we started replication, maria was a day behind its master. its working fine but we noticed this phenomenon: when we execute 'show all slaves status' consecutively the 'seconds_behind_master' flips from 0 to XXX and XXX to 0. XXX keeps decreasing though, which is good as its getting closer to the state of its master. But wanted to know why the 'seconds_behind_master' comes down to 0 then again sets to a positive number. Note: XXX is some positive number. Thanking you. vishnu rao -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/regarding-seconds-behind-master-variable-in-1004/

1 0

[Maria-discuss] Left Join Bug?
by Jamie Jackson 07 Oct '13

07 Oct '13

Hi Folks, I'm seeing a difference in a query result between MariaDB 5.5.32 and MySQL 5.1.69. I've distilled things down as far as I can get them, while still being able to reproduce the issue. Anything else I do to get the sample to make it smaller or more focused seems to make the issue disappear. The data: https://www.dropbox.com/s/m02sqjl2y2cq4ky/sampledump1.zip The query, and the results (and explains) in both MySQL and MariaDB: https://gist.github.com/jamiejackson/6829118 What's going on here? Is there an oustanding bug for this? Should I file a bug? Thanks, Jamie

2 2

[Maria-discuss] New Question: Migrating from MySQL 5.1.31-community >> MariaDB 5.5
by AskMonty KB 03 Oct '13

03 Oct '13

Hello, A new question has been asked in "Upgrading MariaDB" by flumpydog: -------------------------------- One of our internal development db servers is currently running MySQL 5.1.31-community on CentOS 5.9 as it suits are needs internally for testing only purposes of our sites. I would like to use this box to install and test MariaDB 5.5 on. What would be the best method to make this transition as smooth as possible? The MySQL rpm's are not the ones supplied by CentOS, but are from the MySQL site. Should I do a dump of all the databases on MySQL, remove all the MySQL rpm packages, install MariaDB 5.5 via yum and then do an import of the databases? Or will I have to install a prior release of MariaDB and upgrade from there? Also, all the tables are currently using the MyISAM storage engine. Just so I will have the best experience here and while I am experimenting, what storage engine would you recommend we try, Ari or? Some of these tables contain in excess of a million rows. Is there anything I should be aware of before converting tables? Thanks, Chuck -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/migrating-from-mysql-5131-community-mariadb-55/

1 0

[Maria-discuss] The MariaDB Foundation and MariaDB trademark?
by Jeremy Cole 02 Oct '13

02 Oct '13

While poking around on the various sites (discussed at length in previous threads) I was left wondering about the MariaDB trademark. I was under the impression this was going to be owned by and managed by the MariaDB Foundation. It seems like it was registered by Monty Program Ab though, and never transferred to or owned by MariaDB Foundation. So, after the acquisition it is now owned by SkySQL. The SkySQL site's "Trademarks" page<http://www.skysql.com/about/legal/trademarks>definitively confirms this with the text «The "MariaDB" trademark is wholly owned by SkySQL Corporation Ab and is a registered trademark in ...». So, I am left wondering what happened? Was my original understanding incorrect, or was this never properly followed through? While I would hope SkySQL is a good community member and would not do anything bad with the trademark, this does defeat a lot of the original idea with the foundation, by my understanding, and leaves a single commercial entity in more or less full control of MariaDB's future. Can anyone provide some insight? Regards, Jeremy

3 6

[Maria-discuss] New Question: yum Install on x86_64 CentOS 5.x
by AskMonty KB 02 Oct '13

02 Oct '13

Hello, A new question has been asked in "MariaDB community" by flumpydog: -------------------------------- I am attempting to install MariaDB on a x86_64 server running CentOS 5.9. I followed the instructions for "Installing MariaDB with yum", created the MariaDB.repo file, however when I run yum, it wants to install i386 rpm files and not x86_64. I even attempted to modify the MariaDB.repo file and use baseurl = http://yum.mariadb.org/5.5/centos5-amd64 , however this did not work. What can I do to correct this as I would like to do this all with yum. Thanks, Chuck -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/yum-install-on-x86_64-centos-5x/

1 0

[Maria-discuss] Fwd: [Dbmail] MariaDB and dbmail
by Reindl Harald 01 Oct '13

01 Oct '13

please can someone from the MariaDB developers MariaDB 5.5.32 is running here on test-machines this is todays feedback of the dbmail core-developer and beause more and more distributions including Fedora/OpenSuSE and AFAIK even RHEL7 switch to MariaDB this is a *serious* problem which is not what a "drop-in replacement" should do and a show-stopper rollout Fedora 19 at all in the near future > Anyway, MariaDB doesn't even pass the basic unit-tests > > Looks like this maybe libzdb related. The ordering of the query > retrieving mime parts is ok on the console, but *not* when looping > over the result in libzdb. > > MariaDB is *no-go* at this moment. Just what I experienced a year > ago or so. I'm sorry, but I don't think I'll hold 3.1.4 for that > not a regression at all. -------- Original-Nachricht -------- Betreff: Re: [Dbmail] MariaDB and dbmail Datum: Tue, 02 Apr 2013 19:47:15 +0400 Von: Sergej Pupykin <ml(a)sergej.pp.ru> An: DBMail mailinglist <dbmail(a)dbmail.org> At Thu, 20 Sep 2012 10:46:52 +0800, zamri <myzamri(a)gmail.com> wrote: > MariaDB is fully compatible with MySQL. Migration is done. So far so good. Phewww!... > > Now I need to do some research on tuning mariadb if needed. I found that after migration following SQL returns wrong sorted data: SELECT l.part_key, l.part_depth, l.part_order, l.is_header, DATE_FORMAT(ph.internal_date,GET_FORMAT(DATETIME,'ISO')), data FROM dbmail_mimeparts p JOIN dbmail_partlists l ON p.id = l.part_id JOIN dbmail_physmessage ph ON ph.id = l.physmessage_id WHERE l.physmessage_id = <ID> ORDER BY l.part_key,l.part_order ASC; however when I run it from command line it works well. Probably it does not fail always because of not all emails damaged. Not sure if it caused by migration to mariadb, but problem appeared near same time.

2 2

[Maria-discuss] 10.x Plans
by Roberto Spadim 01 Oct '13

01 Oct '13

Hi guys, it not a important thing, but could we add the MDEV or the issue track link to https://mariadb.com/kb/en/plans-for-10x/ for example MariaDB 10.0 partly sponsored features Features that are likely to be in 10.0 if we can get more sponsorships FB request: Better monitoring for replication (FB has patch; MP will add) (kristian) (for 5.5 or 10.0) ??? Aria: Concurrent UPDATE & DELETE. MWL#235 (Have partial sponsor) (monty) MDEV-23 Aria: Segmented key cache for Aria (By Igor for 10.0 or 10.1) MDEV-24 Aria: Fast next-not-same handler call (monty) (Target 10.0) MDEV-25 >From MySQL 5.6: Global transaction ID, so the slave state becomes recoverable, and facilitate automatic moving a slave to a new master across multi-level hierarchies. ??? and others.... -- Roberto Spadim

2 5