[Maria-discuss] Reqeust for SHOW FULL FIELDS FROM and virtual tables in MariaDB

2011-06-02 Thread Peter Laursen
Refer http://kb.askmonty.org/v/virtual-columns - the example CREATE TABLE table1 ( a INT NOT NULL, b VARCHAR(32), c INT AS (a MOD 10) virtual, d VARCHAR(5) AS (LEFT(b,5)) persistent); now SHOW FULL FIELDS FROM table1; Field Type Collation Null Key Default Extra Privileges Comment -- --

Re: [Maria-discuss] Reqeust for SHOW FULL FIELDS FROM and virtual tables in MariaDB

2011-06-02 Thread Arjen Lentz
Hi Peter, all > From: "Peter Laursen" > > Refer http://kb.askmonty.org/v/virtual-columns - the example > > CREATE TABLE table1 ( > a INT NOT NULL, > b VARCHAR(32), > c INT AS (a MOD 10) virtual, > d VARCHAR(5) AS (LEFT(b,5)) persistent); > > now > > SHOW FULL FIELDS FROM table1; > > Field Ty

Re: [Maria-discuss] Reqeust for SHOW FULL FIELDS FROM and virtual tables in MariaDB

2011-06-03 Thread Peter Laursen
I have a few more points to consider: CREATE TABLE table1 (as before); SET SQL_MODE = 'strict_all_tables'; INSERT INTO `test`.`table1`(`a`,`b`,`c`,`d`) VALUES ( '1','a',NULL,NULL); -- success SHOW WARNINGS -- empty set -- this is actually good, even a little inconsistent with what comes next. Bu

[Maria-discuss] New Knowledgebase Question: MariaDB xtradb installation problem

2011-06-03 Thread Daniel Bartholomew
Hello everyone, there's a new question in the Knowledgebase: http://kb.askmonty.org/v/mariadb-xtradb-installation-problem Thanks. -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

Re: [Maria-discuss] mariadb runs at lowest priority (nice -n 19) - PBXT code causing problems

2011-06-06 Thread Michael Widenius
Hi! > "Paul" == Paul McCullagh writes: Paul> The intension of this code was to set the priority of the current Paul> running thread only, not the entire program. Paul> If the code is not working in this manner, then there is no better Paul> solution that to disable it. Paul> However i

[Maria-discuss] Reqeust for SHOW FULL FIELDS FROM and virtual tables in MariaDB

2011-06-06 Thread Michael Widenius
Hi! > "Peter" == Peter Laursen writes: Peter> Refer http://kb.askmonty.org/v/virtual-columns - the example Peter> CREATE TABLE table1 ( Peter> a INT NOT NULL, Peter> b VARCHAR(32), Peter> c INT AS (a MOD 10) virtual, Peter> d VARCHAR(5) AS (LEFT(b,5)) persistent); Peter> now Peter> SHOW

Re: [Maria-discuss] Reqeust for SHOW FULL FIELDS FROM and virtual tables in MariaDB

2011-06-06 Thread Michael Widenius
Hi! > "Peter" == Peter Laursen writes: Peter> I have a few more points to consider: Peter> CREATE TABLE table1 (as before); Peter> SET SQL_MODE = 'strict_all_tables'; Peter> INSERT INTO `test`.`table1`(`a`,`b`,`c`,`d`) VALUES ( '1','a',NULL,NULL); -- Peter> success Peter> SHOW WARNINGS -

[Maria-discuss] Calculating Maximum Bytes Per Record

2011-06-07 Thread Jake Drew
*Hello, * * * *I have recently been doing some capacity planning exercises for a new database we are developing in MariaDB. One of the exercises I completed was to create a database with all tables loaded with maximum width records at 100,000, 500,000, and 1,000,000 records. I noticed that when I

Re: [Maria-discuss] XtraDB using the Windows Installer

2011-06-09 Thread Michael Widenius
Hi! > "Peter" == Peter Laursen writes: Peter> SHOW ENGINES; Peter> or Peter> SELECT * FROM information_schema.ENGINES; Peter> You will see "YES" in the 'support' column of the output for 'InnoDB. It is Peter> actually XtraDB, but it identifies itself as InnoDB (for portability and Pete

Re: [Maria-discuss] mariadb runs at lowest priority (nice -n 19) - PBXT code causing problems

2011-06-12 Thread Paul McCullagh
On Jun 6, 2011, at 11:23 AM, Michael Widenius wrote: Hi! "Paul" == Paul McCullagh writes: Paul> The intension of this code was to set the priority of the current Paul> running thread only, not the entire program. Paul> If the code is not working in this manner, then there is no bett

Re: [Maria-discuss] mariadb runs at lowest priority (nice -n 19) - PBXT code causing problems

2011-06-13 Thread Michael Widenius
Hi! > "Paul" == Paul McCullagh writes: >> Do you know of any system, except old obsolete linux systems, where >> one should >> use setpriority() to set the priority for a thread? Paul> I have done no research on this, so I think we should simply change Paul> the code to: Paul> if