Planet MySQL

Displaying posts with tag: MySQL 5.1 (reset)

Jul

2008

Posted by Lewis Cunningham on Wed 23 Jul 2008 14:52 UTC
Tags:

postgres, MySQL 5.1, Open Source, database, mysql 6, fragmentation, Competition, comparison, fork, MySQL

Have you heard of Drizzle? It was announced at OSCON yesterday and is all over the blogosphere. From the Drizzle FAQ:

* So what are the differences between is and MySQL?

No modes, views, triggers, prepared statements, stored procedures, query cache, data conversion inserts, ACL. Fewer data types. Less engines, less code. Assume the primary engine is transactional.

Also from the FAQ is that, right now at least, there is no intention to make this run natively on windows and they make the point:

* "This is not a SQL compliant relational..."

Very true, and we do not aim to be that.

It is a fork of MySQL that takes it backward to pre-5.0 in features but hopefully greatly reduces the bugs and instabilities. I plan to look at it but I don't see …

[Read more]

Jul

2008

New Competition for MySQL’ers

Posted by Santo Leto on Fri 18 Jul 2008 23:40 UTC
Tags:

MySQL 5.1, contribution, 5.1 UCC, MySQLâ„¢, Competition, mysql Q.A., MySQL

I hear now about a new competition for the MySQL® Users. The ‘MySQL® 5.1 Use Case Competition’ has been just launched by the Community Team @ SUN|MySQL.

If you submit a MySQL® 5.1 Use Case Report to the Community Team by 31 August 2008 you will have a chance of winning:

1st-3rd prize: A MySQL Conference & Expo 2009 Pass, including a dinner with MySQL co-founder Michael “Monty” Widenius
4th-10th prize: MySQL® Community Contributor T-shirts
11th-20th prize: A Sakila mascot (MySQL®’s pet dolphin)

More information at http://forge.mysql.com/wiki/MySQL_5_1_Use_Case_Competition.

[Reminder for the Community Team: the page …

[Read more]

Jul

2008

RE: A bugs life

Posted by Santo Leto on Thu 17 Jul 2008 15:45 UTC
Tags:

MySQL 5.1, bugs, MySQLâ„¢, GA version

This is a short reply to Michael’s post “A bugs life”.

This bugs are still relevant for me:

Bug #9588 Support for ALTER (or CREATE OR REPLACE) PROCEDURE/FUNCTION <BODY>
Bug #18466 add REPLACE to CREATE FUNCTION, PROCEDURE, TRIGGER
Bug #33455 Can’t retrieve Routine Parameters if the user has limited privileges

In my dreamland they would be fixed before 5.1 reaches GA but I know that probably it is difficult to add such features in a RC version.

Questions. Do you plan to fix them? If yes, can I ask you when?

Thanks.

Jul

2008

LogFile Group creation - SQL Errors vs SQL Warnings

Posted by Santo Leto on Sat 12 Jul 2008 23:00 UTC
Tags:

MySQL 5.1, MySQL?, logfile group, mysql 6, sql errors, sql warnings

On Windows® - but I guess it’s the same on another O.S. that does not support cluster - I noticed the following behavior when trying to execute a CREATE LOGFILE GROUP syntax like this:

CREATE
LOGFILE GROUP `test`
ADD UNDOFILE ‘test’
INITIAL_SIZE = 33M
UNDO_BUFFER_SIZE = 8M
ENGINE = NDBCLUSTER;

In v.5.1.25-rc, v.5.1.24-rc and v.5.1.23-rc, only SQL warnings are shown:

mysql> CREATE
    -> LOGFILE GROUP `test`
    -> ADD UNDOFILE ‘test’
    -> INITIAL_SIZE = 33M
    -> UNDO_BUFFER_SIZE = 8M
    -> ENGINE = NDBCLUSTER;
Query OK, 0 rows affected, 2 warnings (0.01 sec)

mysql> SHOW WARNINGS;
…

[Read more]

Feb

2008

Reporting MySQL Internals with Information Schema plug-ins

Posted by Roland Bouman on Mon 11 Feb 2008 00:03 UTC
Tags:

MySQL 5.1, hacking, C/C++, Monty, source, MySQL information schema plugin, Savepoint, MySQL

Last week, I described how to use the MySQL plug-in API to write a minimal 'Hello world!' information schema plug-in. The main purpose of that plug-in is to illustrate the bare essentials of the MySQL information schema plug-in interface.

In this article, I'd like to take that to the next level and demonstrate how to write an information schema plug-in that can access some of the internals of the MySQL server. For this particular purpose, we will focus on a plug-in that reports all the SAVEPOINTs available in the current session. This …

[Read more]

Apr

2007

Monitoring OS statistics with INFORMATION_SCHEMA plugins

Posted by Mark Leith on Sun 29 Apr 2007 20:55 UTC
Tags:

MySQL 5.1, MySQL

With all the talk lately of the new INFORMATION_SCHEMA plugin API, I thought I’d have a go at making a couple. I’ve now made three different pluggable INFORMATION_SCHEMA tables - one that works from df -k - which will only work on UNIX like systems (other than AIX or HPUX) - and two which integrate the SIGAR library available from Hyperic.

I’ll post the df -k plugin in a couple of days, however I wanted to get the two I have created based on the SIGAR library ‘out to the world’ for some feedback on them! They are currently a very rough prototype (they need a little more work on return checking etc.!) - however they are currently functional.

There are two INFORMATION_SCHEMA tables within the plugin library - INFORMATION_SCHEMA.OS_STATUS and …

[Read more]

May

2006

Dynamic Logging Variables

Posted by Mark Leith on Fri 12 May 2006 16:10 UTC
Tags:

General, MySQL 5.1, MySQL

Finally!

ChangeSet
1.2396 06/05/12 12:50:50 gluh@eagle.intranet.mysql.r18.ru +12 -0
WL#3015: Logging Improvements - No Restarts(ver N3)
Added slow_query_log & general_log global upadatable variables.
Added slow-query-log & general-log startup options.
Added log_output, log_path, log_slow_queries_path global updatable variables.

http://lists.mysql.com/commits/6279

Now we can do things like “SET GLOBAL general_log = ON;” and “SET GLOBAL log_path=’/log/tmp.log’;”.

This has been something long requested so it’s great to see this slip in to the tree in time for 5.1!

May

2006

Dynamic Logging Variables

Posted by Mark Leith on Fri 12 May 2006 14:10 UTC
Tags:

General, MySQL 5.1, MySQL

Finally!

http://lists.mysql.com/commits/6279

Now we can do things like “SET GLOBAL general_log = ON;” and “SET GLOBAL log_path=’/log/tmp.log’;”.

This has been something long requested so it’s great to see this slip in to the tree in time for 5.1!

Apr

2006

MySQL User Conference

Posted by Mark Leith on Wed 19 Apr 2006 20:29 UTC
Tags:

General, MySQL 4.1, MySQL 5.0, MySQL 5.1, Oracle, MySQL

Long time no speak! Hey non-avid readers!

I’ve been keeping my head down lately working away in our support group, and haven’t had much time to get any tips down on my blog or even any thoughts in general.

Over the past few weeks I’ve been polishing up my presentation - MySQL for Oracle DBAs, which is on the last day - next Thursday, April 27th.

http://www.mysqluc.com/cs/mysqluc2006/view/e_sess/8465

If you’re reading this - and around at our user conference next week - seek me out and say “Hi!”.

I’ll work on a number of blog posts after the conference, which will give some of the information available in my presentation as well.

Look forward to saying “Hi!” to as many of you as possible!

Apr

2006

MySQL User Conference

Posted by Mark Leith on Wed 19 Apr 2006 18:29 UTC
Tags:

General, MySQL 4.1, MySQL 5.0, MySQL 5.1, Oracle, MySQL

Long time no speak! Hey non-avid readers!

I’ve been keeping my head down lately working away in our support group, and haven’t had much time to get any tips down on my blog or even any thoughts in general.

Over the past few weeks I’ve been polishing up my presentation - MySQL for Oracle DBAs, which is on the last day - next Thursday, April 27th.

http://www.mysqluc.com/cs/mysqluc2006/view/e_sess/8465

If you’re reading this - and around at our user conference next week - seek me out and say “Hi!”.

I’ll work on a number of blog posts after the conference, which will give some of the information available in my presentation as well.

Look forward to saying “Hi!” to as many of you as possible!

Top Authors

Oracle MySQL Blogs

Vendor Blogs

MySQL Links