Showing entries 32736 to 32745 of 44922
« 10 Newer Entries | 10 Older Entries »
Jul
17
2008
600X MySQL Performance Improvement with Kickfire
Posted by Kickfire Team Blog on Thu 17 Jul 2008 19:17 UTC
Tags:

As promised, in this post I will update on the performance improvements another Kickfire beta customer is seeing relative to its query response times.

The customer in question is a successful mid-sized company in the network management space. As part of their network management offering, they provide network monitoring and analysis capabilities. They are currently using MySQL as their backend database. The trouble they are having is that they can’t scale beyond about 50GB of data without impacting their monitoring and analysis performance. What this translates to is that their customers can’t use their solution to monitor more than 30 days worth of network traffic. While this is OK for some, others are clamoring for the ability to track and analyze up to three years of traffic and willing to pay significantly more to do so. Today, if they try to accomodate these customers, the queries end up taking hours to run which is unacceptably …

[Read more]
Jul
17
2008
CentOS 5 users beware - The shipped mysql client is broken
Posted by Justin Swanhart on Thu 17 Jul 2008 17:37 UTC

CentOS 5 ships with version 5.0.22 of MySQL, which has a number of issues, but I discovered a major one that I wasn't aware of until yesterday. There is a problem in the 5.0.22 client that causes empty strings, or strings consisting only of spaces to be displayed as NULL:
http://bugs.mysql.com/bug.php?id=19564


CREATE TABLE test.x1 (c char(10)) ENGINE=MYISAM;
INSERT INTO test.x1 values (' ');
INSERT INTO test.x1 values ('');


-- on a 5.0.22 client (/usr/local/mysql):
mysql> select * from test.x1;
+------+
| c    |
+------+
| NULL |
| NULL |
+------+
2 rows in set (0.00 sec)

-- on a 5.0.37 client (~/bin/mysql):
mysql> select * from test.x1;
+------+
| c    |
+------+
|      |
|      |
+------+
2 rows in set (0.00 sec)
Jul
17
2008
Could Google be stymied by a lack of openness?
Posted by The 451 Group on Thu 17 Jul 2008 17:10 UTC
Tags:

It seems almost churlish to wonder whether Google could be even more successful than it already is with a different strategy, but the company’s approach to open source and open development has come into focus in recent weeks.

On last week’s podcast we discussed whether the company should see the AGPL as more of an opportunity than a threat following Jay’s post about the company releasing more code under open source licenses.

Nik Cubrilovic over at TechCrunch, meanwhile, has written an interesting …

[Read more]
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]
Showing entries 32736 to 32745 of 44922
« 10 Newer Entries | 10 Older Entries »