Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 16

Displaying posts with tag: MySQL 5.0 (reset)

MySQL 5.0.96 is Now Available (for 5.0 Users)
+1 Vote Up -0Vote Down

This is just a post to let you 5.0 users know that 5.0.96 is now available.

You may have read about some of the security bugs fixed in the recent 5.0.95, and now 5.0.96 is available (it’s been nearly 9 months since 5.0.94 was released – so this is quite a lot of activity as far as 5.0 is concerned).

So if for some reason you’re still running MySQL 5.0, you should at least upgrade to the latest 5.0.96.

The upgrade process should be smooth and simple if you’re already running 5.0 (just be safe and backup your data first though).

You can download 5.0.96 from here:

http://downloads.skysql.com/archive/index/p/mysql/v/5.0.96

And if you’re interested in the 5.0 changelogs, I have direct links to them here (just look for MySQL 5.0):

  [Read more...]
MySQL User Conference
Employee +0 Vote Up -0Vote Down

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!

MySQL User Conference
Employee +0 Vote Up -0Vote Down

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!

MySQL 5.0 downloads pass 1 Million
+0 Vote Up -0Vote Down
wow. The MySQL 5.0 download count has passed 1 Million already. You like us! You really like us! :)
Stripping Digits - The benefits of Benchmarking and Profiling
Employee +0 Vote Up -0Vote Down

Carsten Pedersen (Certification Manager of at MySQL AB) read my entry about stripping digits, and has done a good write up here on how this function could be improved, a great deal.

Have a read of Carstens link, and my previous entry if you didn’t catch it, before we progress.

As you see, I mentioned that “it performed fairly well”, but I admit given the nature of the request (a quick IRC question) I didn’t run a benchmark on it compared to something like Carsten’s REPLACE solution. I actually went with the REGEXP as the original question was actually something along the lines of “If I have a string such as “joe123″ how I can I strip the digits from the end to return just “joe”. I wrote the quick function as an example of what you can do in 5.0, as the user was still 4.x

  [Read more...]
Stripping Digits - The benefits of Benchmarking and Profiling
Employee +0 Vote Up -0Vote Down

Carsten Pedersen (Certification Manager of at MySQL AB) read my entry about stripping digits, and has done a good write up here on how this function could be improved, a great deal.

Have a read of Carstens link, and my previous entry if you didn’t catch it, before we progress.

As you see, I mentioned that “it performed fairly well”, but I admit given the nature of the request (a quick IRC question) I didn’t run a benchmark on it compared to something like Carsten’s REPLACE solution. I actually went with the REGEXP as the original question was actually something along the lines of “If I have a string such as “joe123″ how I can I strip the digits from the end to return just “joe”. I wrote the quick function as an example of what you can do in 5.0, as the user was

  [Read more...]
Stripping digits
Employee +0 Vote Up -0Vote Down

We had a question in #mysql on freenode yesterday, asking if there was a function to strip digits from a string. The answer is of course - not natively.

I’ve been playing around with Functions and Stored Procedures a bit lately though, trying to familiarise myself with the MySQL implementation fully, and wrote this quick function which does the job, although only in 5.0:

DELIMITER //
 
DROP FUNCTION strip_digits //
 
CREATE FUNCTION strip_digits (str VARCHAR(50))
  RETURNS VARCHAR(50)
  BEGIN
    DECLARE sub_start INT DEFAULT 0;
    DECLARE res VARCHAR(50) DEFAULT '';
    
    WHILE sub_start < LENGTH(str)+1 DO
    
     IF











  [Read more...]
Stripping digits
Employee +0 Vote Up -0Vote Down

We had a question in #mysql on freenode yesterday, asking if there was a function to strip digits from a string. The answer is of course - not natively.

I’ve been playing around with Functions and Stored Procedures a bit lately though, trying to familiarise myself with the MySQL implementation fully, and wrote this quick function which does the job, although only in 5.0:

DELIMITER //

DROP FUNCTION strip_digits //

CREATE FUNCTION strip_digits (str VARCHAR(50))
RETURNS VARCHAR(50)
BEGIN
DECLARE sub_start INT DEFAULT 0;
DECLARE res VARCHAR(50) DEFAULT '';

WHILE sub_start

IF SUBSTRING(str,sub_start,1) REGEXP '[[:alpha:]]' THEN
SET res = CONCAT(res,SUBSTRING(str,sub_start,1));
END IF;

SET sub_start = sub_start + 1;

END WHILE;
RETURN res;








  [Read more...]
MySQL 5.0 - Triggers
Employee +0 Vote Up -0Vote Down

One of the major new pieces of functionality within the 5.0 release of MySQL is something called “Triggers”. Triggers are objects that are related to tables which are executed, or to show where their orginial name came from “fired”, when a triggering event is performed against its associated table. These events are those statements that modify the data within the table that the trigger is associated with - INSERT, UPDATE or DELETE - and can be fired either BEFORE or AFTER row the row is modified - or indeed both.

Triggers are very much like stored procedures, as if you want to execute multiple actions when a trigger is fired you can encapsulate these within a BEGIN … END construct. They also have a couple of extra keywords - OLD and NEW- which refer to the values of the columns before and after the statement was processed, respectively. INSERTs only allow NEW (as no value

  [Read more...]
MySQL 5.0 - Triggers
Employee +0 Vote Up -0Vote Down

One of the major new pieces of functionality within the 5.0 release of MySQL is something called “Triggers”. Triggers are objects that are related to tables which are executed, or to show where their orginial name came from “fired”, when a triggering event is performed against its associated table. These events are those statements that modify the data within the table that the trigger is associated with - INSERT, UPDATE or DELETE - and can be fired either BEFORE or AFTER row the row is modified - or indeed both.

Triggers are very much like stored procedures, as if you want to execute multiple actions when a trigger is fired you can encapsulate these within a BEGIN … END construct. They also have a couple of extra keywords - OLD and NEW- which refer to the values of the columns before and after the statement was processed, respectively. INSERTs only allow NEW (as no value

  [Read more...]
MySQL 5.0 - Source Documentation
Employee +0 Vote Up -0Vote Down

Wow what a hectic month - just logged on and noticed I haven’t updated the site in a month! I have a part done entry on triggers that I haven’t had time to finish yet, look out for that in a couple of days. Work has been hectic, a lot of work going in to the MySQL Module of NORAD (a system/database monitoring tool that we distribute.. But that’s a story for another day), which I’m responsible for building the collections / window definitions for at the moment.

One of the windows I was building today was for “Open Tables” - sourced from SHOW OPEN TABLES; - yet I wasn’t entirely sure on what all of the output meant. Specifically “Name_locked”. The documentation doesn’t comment on this at all (the documentation for SHOW OPEN TABLES is particularly poor, even noting a “Comment” field that simply doesn’t exist (on 4.1 at least).

  [Read more...]
MySQL 5.0 - Source Documentation
Employee +0 Vote Up -0Vote Down

Wow what a hectic month - just logged on and noticed I haven’t updated the site in a month! I have a part done entry on triggers that I haven’t had time to finish yet, look out for that in a couple of days. Work has been hectic, a lot of work going in to the MySQL Module of NORAD (a system/database monitoring tool that we distribute.. But that’s a story for another day), which I’m responsible for building the collections / window definitions for at the moment.

One of the windows I was building today was for “Open Tables” - sourced from SHOW OPEN TABLES; - yet I wasn’t entirely sure on what all of the output meant. Specifically “Name_locked”. The documentation doesn’t comment on this at all (the documentation for SHOW OPEN TABLES is particularly poor, even noting a “Comment” field that simply doesn’t exist (on 4.1 at least).

  [Read more...]
MySQL 5.0 - INFORMATION_SCHEMA (cont?d)
Employee +0 Vote Up -0Vote Down

I mentioned “fuzzy foreign key” matches in my post the other day, and thought that I’d give it a crack tonight. The aim of the fuzzy match is to try and find relationships when a) They are InnoDB and haven’t been created or b) Foreign keys are not avilable to the storage engine that is being used.

Most DBA’s will know their schemas pretty well, this however should be pretty handy for consultants or anyone starting fresh at a new job / on a new database etc.

It should be noted that this will only “fuzzy” match against a schema that follows strict naming conventions - Where the tablename and “id” is used for the primary key column, and the same name is used for the foreign key in the child table. For instance, given the following example tables:


mysql> desc company;
  [Read more...]
MySQL 5.0 - INFORMATION_SCHEMA (cont?d)
Employee +0 Vote Up -0Vote Down

I mentioned “fuzzy foreign key” matches in my post the other day, and thought that I’d give it a crack tonight. The aim of the fuzzy match is to try and find relationships when a) They are InnoDB and haven’t been created or b) Foreign keys are not avilable to the storage engine that is being used.

Most DBA’s will know their schemas pretty well, this however should be pretty handy for consultants or anyone starting fresh at a new job / on a new database etc.

It should be noted that this will only “fuzzy” match against a schema that follows strict naming conventions - Where the tablename and “id” is used for the primary key column, and the same name is used for the foreign key in the child table. For instance, given the following example tables:

<code>&lt;blockquote&gt;<br />
mysql&gt; desc company;<br />
  [Read more...]
MySQL 5.0 - INFORMATION_SCHEMA
Employee +0 Vote Up -0Vote Down

Arjen Lentz (”Community Relations Manager” for MySQL AB) posted “The MySQL 5.0 Beta Challenge” on his blog today - so in the spirit of community I decided to give it a crack, by putting together some posts on the new features of MySQL 5.0 up here to my humble blog. Who knows - I may win a mug! Then I can have a list of ALL the people to bug over at MySQL AB!

I’m a DBA at heart, so whilst I’ll take a look at the new features that are available for developers, I’m going to start from the DBA tack, and take a look at INFORMATION_SCHEMA.

So what is the INFORMATION_SCHEMA? Those that have used other RDBMS’ in the past will recognize it as MySQL’s “Data Dictionary”. An RDBMS Data Dictionary is a collection of tables or views (that appear as tables), that utilize the

  [Read more...]
MySQL 5.0 - INFORMATION_SCHEMA
Employee +0 Vote Up -0Vote Down

Arjen Lentz (”Community Relations Manager” for MySQL AB) posted “The MySQL 5.0 Beta Challenge” on his blog today - so in the spirit of community I decided to give it a crack, by putting together some posts on the new features of MySQL 5.0 up here to my humble blog. Who knows - I may win a mug! Then I can have a list of ALL the people to bug over at MySQL AB!

I’m a DBA at heart, so whilst I’ll take a look at the new features that are available for developers, I’m going to start from the DBA tack, and take a look at INFORMATION_SCHEMA.

So what is the INFORMATION_SCHEMA? Those that have used other RDBMS’ in the past will recognize it as MySQL’s “Data Dictionary”. An RDBMS Data Dictionary is a collection of tables or views (that appear as tables), that utilize the

  [Read more...]
Showing entries 1 to 16

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.