Re: Major MySQL Revision Takes on NoSQL

2013-02-07 Thread Reindl Harald 


Am 08.02.2013 03:51, schrieb Peter Brawley:
> On 2013-02-07 8:29 PM, Daevid Vincent wrote:
>> http://adtmag.com/articles/2013/02/06/mysql-update.aspx
> 
> The headline is weirdly deceptive. Mebbe they thought the headline would draw 
> eyes to their ads.
> 
> This edition of MySQL is less like NoSQL, and more determinedly relational, 
> than any before.
> 
> It'd be more accurate to say that Monty & David anticipated NoSQL by a 
> decade. The early editions of MySQL, with no
> ACID compliance, no foreign keys, no transactions, were more like NoSQL than 
> any version of MySQL released since 2004.

much more interesting:

>> This release promises to crank up query execution times with pre-execution
>> subqueries. Diagnostics are improved with EXPLAIN for INSERT, UPDATE, and
>> DELETE operations, and the ability to output in JSON. And a new Optimizer
>> Traces tool allows users to track the optimizer decision-making process

does this also affect MyISAM or is the engine only a unloved child
since the switch to innodb as default engine?



signature.asc
Description: OpenPGP digital signature

Re: Major MySQL Revision Takes on NoSQL

2013-02-07 Thread Peter Brawley 

On 2013-02-07 8:29 PM, Daevid Vincent wrote:

http://adtmag.com/articles/2013/02/06/mysql-update.aspx


The headline is weirdly deceptive. Mebbe they thought the headline would 
draw eyes to their ads.


This edition of MySQL is less like NoSQL, and more determinedly 
relational, than any before.


It'd be more accurate to say that Monty & David anticipated NoSQL by a 
decade. The early editions of MySQL, with no ACID compliance, no foreign 
keys, no transactions, were more like NoSQL than any version of MySQL 
released since 2004.


PB






--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Major MySQL Revision Takes on NoSQL

2013-02-07 Thread Daevid Vincent 
http://adtmag.com/articles/2013/02/06/mysql-update.aspx

Problems compiling 5.6.10 under CygWIN for Windows

2013-02-07 Thread Michael Steele 
I'm using CygWIN to compile MySQL 5.6.10 for Windows. Using the source code
(Generic Linux (Architecture Independent), Compressed TAR Archive) Version
5.6.10.

 

I have no problems compiling  (Generic Linux (Architecture Independent),
Compressed TAR Archive) Version 5.5.29 source code.

 

This is the output.

 

[ 27%] Building CXX object
storage/innobase/CMakeFiles/innobase.dir/fts/fts0que.cc.o

/cygdrive/e/cygwin/mysql-5.6.10/storage/innobase/fts/fts0que.cc: In function
`dberr_t fts_query_phrase_search(fts_query_t*, const fts_string_t*)':

/cygdrive/e/cygwin/mysql-5.6.10/storage/innobase/fts/fts0que.cc:2359:
warning: 'token' might be used uninitialized in this function [ 27%]
Building CXX object
storage/innobase/CMakeFiles/innobase.dir/fts/fts0sql.cc.o

[ 27%] Building CXX object
storage/innobase/CMakeFiles/innobase.dir/fts/fts0tlex.cc.o

[ 27%] Building CXX object
storage/innobase/CMakeFiles/innobase.dir/handler/ha_innodb.cc.o

In file included from
/cygdrive/e/cygwin/mysql-5.6.10/storage/innobase/include/fts0priv.h:647,

 from
/cygdrive/e/cygwin/mysql-5.6.10/storage/innobase/handler/ha_innodb.cc:95:

/cygdrive/e/cygwin/mysql-5.6.10/storage/innobase/include/fts0priv.ic: In
function `int fts_write_object_id(ib_id_t, char*)':

/cygdrive/e/cygwin/mysql-5.6.10/storage/innobase/include/fts0priv.ic:38:
error: expected `)' before "PRIx64"

/cygdrive/e/cygwin/mysql-5.6.10/storage/innobase/include/fts0priv.ic:38:
warning: conversion lacks type at end of format

/cygdrive/e/cygwin/mysql-5.6.10/storage/innobase/include/fts0priv.ic:38:
warning: too many arguments for format

/cygdrive/e/cygwin/mysql-5.6.10/storage/innobase/include/fts0priv.ic:38:
warning: conversion lacks type at end of format

/cygdrive/e/cygwin/mysql-5.6.10/storage/innobase/include/fts0priv.ic:38:
warning: too many arguments for format

/cygdrive/e/cygwin/mysql-5.6.10/storage/innobase/include/fts0priv.ic: In
function `ulint fts_read_object_id(ib_id_t*, const char*)':

/cygdrive/e/cygwin/mysql-5.6.10/storage/innobase/include/fts0priv.ic:51:
error: expected `)' before "PRIx64"

/cygdrive/e/cygwin/mysql-5.6.10/storage/innobase/include/fts0priv.ic:51:
warning: conversion lacks type at end of format

/cygdrive/e/cygwin/mysql-5.6.10/storage/innobase/include/fts0priv.ic:51:
warning: too many arguments for format

/cygdrive/e/cygwin/mysql-5.6.10/storage/innobase/include/fts0priv.ic:51:
warning: conversion lacks type at end of format

/cygdrive/e/cygwin/mysql-5.6.10/storage/innobase/include/fts0priv.ic:51:
warning: too many arguments for format

/cygdrive/e/cygwin/mysql-5.6.10/storage/innobase/handler/ha_innodb.cc: In
function `int innobase_close_connection(handlerton*, THD*)':

/cygdrive/e/cygwin/mysql-5.6.10/storage/innobase/handler/ha_innodb.cc:3733:
error: expected `)' before "PRIu64"

/cygdrive/e/cygwin/mysql-5.6.10/storage/innobase/handler/ha_innodb.cc:3735:
warning: spurious trailing `%' in format

/cygdrive/e/cygwin/mysql-5.6.10/storage/innobase/handler/ha_innodb.cc:3735:
warning: too many arguments for format

/cygdrive/e/cygwin/mysql-5.6.10/storage/innobase/handler/ha_innodb.cc: In
function `dberr_t calc_row_difference(upd_t*, uchar*, uchar*, TABLE*,
uchar*, ulint, row_prebuilt_t*, THD*)':

/cygdrive/e/cygwin/mysql-5.6.10/storage/innobase/handler/ha_innodb.cc:6855:
error: expected `)' before "PRIu64"

/cygdrive/e/cygwin/mysql-5.6.10/storage/innobase/handler/ha_innodb.cc:6857:
warning: spurious trailing `%' in format

/cygdrive/e/cygwin/mysql-5.6.10/storage/innobase/handler/ha_innodb.cc:6857:
warning: too many arguments for format

/cygdrive/e/cygwin/mysql-5.6.10/storage/innobase/handler/ha_innodb.cc:6867:
error: expected `)' before "PRIu64"

/cygdrive/e/cygwin/mysql-5.6.10/storage/innobase/handler/ha_innodb.cc:6873:
warning: spurious trailing `%' in format

/cygdrive/e/cygwin/mysql-5.6.10/storage/innobase/handler/ha_innodb.cc:6873:
warning: too many arguments for format

storage/innobase/CMakeFiles/innobase.dir/build.make:1023: recipe for target
`storage/innobase/CMakeFiles/innobase.dir/handler/ha_innodb.cc.o' failed

make[2]: ***
[storage/innobase/CMakeFiles/innobase.dir/handler/ha_innodb.cc.o] Error 1

CMakeFiles/Makefile2:755: recipe for target
`storage/innobase/CMakeFiles/innobase.dir/all' failed

make[1]: *** [storage/innobase/CMakeFiles/innobase.dir/all] Error 2

Makefile:146: recipe for target `all' failed

make: *** [all] Error 2

 

Best regards,

Michael

Re: MySQL and Active Directory

2013-02-07 Thread Fabricio Archanjo 
Wayne,

You going to need a MySQL Enterprise version, This version there's a pam
connection, then you can use libpam-ldap/nss-ldap to authenticate via
Active Directory.


Thanks,
Fabricio


On Mon, Feb 4, 2013 at 5:40 PM, Wayne Leutwyler wrote:

> List,
>
> Has anyone has any success integrating MySQL on Linux with Active
> Directory?
>
> Walter "Wayne" Leutwyler, RHCT
> Sr. MySQL Database Administrator
> Mobile: 614 519 5672
> Office: 614 889 4956
> E-mail: wayne.leutwy...@gmail.com
> E-mail: wleut...@columbus.rr.com
> Website: http://penguin-workshop.dyndns.org
>
> "Courage is being scared to death, but saddling up anyway." --John Wayne
>
>