Showing entries 32626 to 32635 of 44809
« 10 Newer Entries | 10 Older Entries »
Jul
17
2008
RE: A bugs life
Posted by Santo Leto on Thu 17 Jul 2008 15:45 UTC
Tags:

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

This bugs are still relevant for me:

  1. Bug #9588 Support for ALTER (or CREATE OR REPLACE) PROCEDURE/FUNCTION <BODY>
  2. Bug #18466 add REPLACE to CREATE FUNCTION, PROCEDURE, TRIGGER
  3. 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
17
2008
Why SQL_MODE is important? Part I
Posted by Ronald Bradford on Thu 17 Jul 2008 06:21 UTC

MySQL pre version 5.0 was very lax in it’s management of valid data. It was easy for data integrity to be abused if you knew how. The most common examples were truncations and silent conversions that if not understood could provide a serious data integrity issue.

In version 5.0, the introduction of SQL_MODE solved this problem. We will look at one example of how SQL_MODE can be enabled to provided improved data integrity.

You want to store the individual RGB (red/green/blue) decimal values of colors in a table. Each of these has a range from 0 to 255. You read that you can store 255 values in a TINYINT Integer data type, so you create a table like: 

DROP TABLE IF EXISTS color_to_decimal;
CREATE TABLE color_to_decimal(
name VARCHAR(20) NOT NULL PRIMARY KEY,
red    TINYINT NOT NULL,
green TINYINT NOT NULL,
blue   TINYINT NOT NULL); …
[Read more]
Jul
17
2008
Sun full of open source and skepticism
Posted by The 451 Group on Thu 17 Jul 2008 05:05 UTC
Tags:

Sun continues to take a performance pounding, and the rumors of replacements, layoffs and revamps are beyond swirling and now perpetuating skepticism of the company. It strikes me as odd that Sun, which has embraced open source and is also the defacto leading corporate open source software contributor, is continually dogged by doubts about its transitions and tenures despite well-respected technology and participation in open source. Part of this lies in the company’s continuing dichotomy in strategy — a reference to tepid support for Linux and continued preference for and focus on Solaris. This is a large part of Sun’s ‘handicap,’ IMHO when it comes to Linux and open …

[Read more]
Jul
17
2008
Sun Stock Prices
Posted by Ronald Bradford on Thu 17 Jul 2008 04:46 UTC

Sun Microsystem’s (NASDAQ:JAVA) hit a low this week of $8.71. There was a stronger rally and a close at $9.16 today. The financial times reports Sun Micro chief sees rays of hope, and Bloomberg Sun Rises After Fourth-Quarter Profit Tops Estimates.

I cashed out in March at $16.32, so that’s like a 50% drop in share price. I was lucky having been at MySQL long enough to have options to vest. Newer employees are not that lucky. I certainly hope MySQL Sun Employees get the Q4 weighted bonuses. (A structure I didn’t believe compensated with the old bonus structure).

I have been following more closely since Matt Asay’s comments …

[Read more]
Jul
17
2008
Are you sure you?re reading the second edition of High Performance MySQL?
Posted by Baron Schwartz (xaprb) on Thu 17 Jul 2008 04:15 UTC
Tags:

I have been getting a lot of comments and errata from people who seem to be mistakenly buying the first edition and believing it’s the second edition. A lot of the blame for this probably rests with Amazon, who did not distinguish between the two editions at all until the editor and I (among others) leaned on them persistently for about 6 weeks. I think some people are buying the second edition and getting the first edition.

I’ve even spoken to people in person who said “yeah, I’ve been reading it” and I give them a copy of the second edition to hold in their hands, and they go “whoa, that is like twice the size. I don’t have this edition at all.”

If you have any question at all, just look at the front cover. If you have the second edition, you will see it clearly in the upper right-hand corner of the cover, as shown in this picture:

I feel like a Microsoft Anti-Piracy Minion “educating” you about how to …

[Read more]
Jul
17
2008
MySQL releases with Percona patchsets
Posted by MySQL Performance Blog on Thu 17 Jul 2008 04:08 UTC

Percona has a strong team of MySQL developers and consultants on board, so we decided to prepare MySQL releases with our patches and third-party patches which we think are very useful. We actually use these internally and for our customers.

Current releases include:

  • microslow patch (enables microsecond resolution in slow logs)
  • execution plan (show info about query execution in slow log)
  • InnoDB statistic (show extended InnoDB usage during query execution in slow log)
  • Google's patches with user statistics, and statistics about tables and indexes usage

You can find more info about some of our patches here:
http://www.mysqlperformanceblog.com/2008/04/20/updated-msl-microslow-patch-installation-walk-through/
Some features were …

[Read more]
Jul
17
2008
Our booth is yours? Sun at OSCON
Posted by Colin Charles on Thu 17 Jul 2008 01:50 UTC
Tags:

Its worth noting that MySQL will have a big presence at OSCON 2008. All this, thanks to Sun, as Sun’s a fairly big sponsor (Platinum Sponsor), and we’ve got a humongous booth!

There are booth talks, that you must attend! They range from getting started with the MySQL Community, MySQL 5.1, MySQL Workbench, MySQL Cluster, and many more. Expect to see the schedule up at the booth (and yes I know, there are a whole heap of already interesting talks in the program, but a lot of the talks at the booth are also scheduled during breaks).

Today, I saw the ad copy, which reads “Our Booth is Your Booth”. “We have whiteboards, tables, electrical outlets and fresh coffee. Come to converse, share ideas, participate or simply to vegetate.”

Seriously, …

[Read more]
Jul
17
2008
Sun open booth at OSCON
Posted by Giuseppe Maxia on Thu 17 Jul 2008 00:09 UTC
Tags:

Going to OSCON? Sun Microsystems is a sponsor, and has a large booth area, all dedicated to you.

It is an unusual way of using open space. We welcome all visitors and encourage them to participate in our activities. There are presentations at almost any time, given by the makers of the open source products you use. And you can have a chance to chat with the very people who are shaping the open source world.

The booth talks include presentations and live demos on MySQL, OpenJDK, Glassfish, OpenSolaris, JCP, mobile and embedded technologies, and more.

The "more" part is up to you. Just drop by and ask for a demo …

[Read more]
Jul
17
2008
Are you sure you're reading the second edition of High Performance MySQL?
Posted by Baron Schwartz (xaprb) on Thu 17 Jul 2008 00:00 UTC

I have been getting a lot of comments and errata from people who seem to be mistakenly buying the first edition and believing it’s the second edition. A lot of the blame for this probably rests with Amazon, who did not distinguish between the two editions at all until the editor and I (among others) leaned on them persistently for about 6 weeks. I think some people are buying the second edition and getting the first edition.

Jul
16
2008
Error 153 when creating savepoints
Posted by Devananda van der Veen on Wed 16 Jul 2008 23:05 UTC
Tags:

One of our developers ran into the strangest error a few days ago, which neither the MySQL manual nor Google searching could find any information on. When he called certain stored procedures in a certain order, he got "Error 153 returned from storage engine." It's been reduced to a very simple test case, and a bug report has been filed. Here's the test case:

DROP TABLE IF EXISTS foo;
CREATE TABLE `foo` (
`a` int(11) NOT NULL auto_increment,
PRIMARY KEY  (`a`)
) ENGINE=InnoDB;

begin;
insert into foo values();
savepoint a1;
insert into foo values();
savepoint a2;
insert into foo values();
savepoint a1;
insert into foo values();
savepoint a2;
show warnings;
rollback;

The very last "savepoint" generates the warning "Got error 153 from storage engine". Any other MySQL'ers use savepoints and …

[Read more]
Showing entries 32626 to 32635 of 44809
« 10 Newer Entries | 10 Older Entries »