High Performance MySQL is Hot off the Press!

Grok Headline matches for High Performance MySQL is Hot off the Press!

Book Review: High Performance MySQL

Book Review: High Performance MySQL 07/27/2004 06:25 PM
"In the first chapters, the authors briefly review some basics of MySQL. The concepts they discuss are pertinent to database performance. Chapter 1 explains the configuration file my.cnf and how it can be set to improve a MySQL server. The authors also discuss the results of the SHOW VARIABLES statement and the SHOW PROCESSLIST statement so that an administrator can determine where the MySQL service is being slowed because of inefficiencies." Story

High Performance MySQL (the book) is
Shipping!

High Performance MySQL (the book) is
Shipping! 04/19/2004 04:32 PM
As noted on our site for the book, O'Reilly brought the first copies to the 2004 MySQL User's Conference in Orlando and it had sold out by the middle of the second day. Woohoo! Now Amazon reports that the book is shipping in 1-2 weeks (rather than being pre-order), and we even have our first customer review posted too. I read the front matter and first three chapters on the plane ride home last night, pen in hand. I didn't...

Comparing MySQL performance

Comparing MySQL performance 03/14/2005 05:31 PM
With the introduction of the 2.6 Linux kernel, FreeBSD-5-STABLE, Solaris 10, and now NetBSD 2.0, you might be wondering which of them offers superior database performance. In my previous article, I discussed the tools I chose to test these venerable operating systems and the methodology by which they were tested. The result is this MySQL performance comparison between OpenBSD 3.6; NetBSD 2.0; FreeBSD 5.3 and 4.10; Solaris Express (build 69); and Linux 2.4 and 2.6 (Gentoo-based). Read on for the results.

MySQL/InnoDB Performance Talk

MySQL/InnoDB Performance Talk 04/14/2004 10:28 AM
Some notes from Peter's MySQL/InnoDB Performance talk at the 2004 MySQL User's Conference... DBT2 Benchmark, http://sf.net/projects/osdldbt. He uses 2.4.21 kernel, no swap, and the ext3 filesystem. Runs benchmark, checks status output (SHOW STATUS or using mysqladmin), then begins tuning. First thing to do is enable the slow query log. Find queries in slow query log, run EXPLAIN on the slow queries, converting non-SELECTs to SEELCTs when needed. Index tweaking often follows. Check SHOW PROCESSLIST for slow queries too (I'd recommend...

Advanced SQL Tutorial and MySQL
Performance Workshop

Advanced SQL Tutorial and MySQL
Performance Workshop 07/28/2004 11:15 PM
Tuesday morning I stopped by a few minutes of Joe Celko's Advanced SQL Tutorial. Joe has an amazing knowledge of the SQL language, no doubt. Lots of arcane knowledge and references to "when we had the discussions in the SQL committee we did discuss that". But the tutorial was a bit too DBAish for me. By that I mean too much "this is how data should be neat" rather than "this is how you solve real business problems". While I...

Understanding real-time performance
statistics in MySQL

Understanding real-time performance
statistics in MySQL 05/24/2004 07:40 AM
CNET May 24 2004 11:47AM GMT

Microsoft High on Performance

Microsoft High on Performance 06/23/2004 07:19 PM
Microsoft will be joining the supercomputer game when it serves up new muscle.

High Performance PHP: Scalability

High Performance PHP: Scalability 07/02/2004 06:35 AM

High-Performance RF Transistors For 3G
Wireless

High-Performance RF Transistors For 3G
Wireless 01/27/2004 01:21 AM
3G Jan 27 2004 5:15AM GMT

Creating high performance teams

Creating high performance teams 12/31/2004 06:35 AM
Express Computer India Dec 31 2004 10:55AM GMT

OMUD High-Performance Driver

OMUD High-Performance Driver 05/29/2004 01:55 AM
Status

New High Performance ATI FireGL X1 & Z1
Drivers

New High Performance ATI FireGL X1 & Z1
Drivers 03/21/2003 01:35 PM

AMD Rolls Out New High-Performance Chip

AMD Rolls Out New High-Performance Chip 03/20/2003 01:05 PM
Number two chipmaker Advanced Micro Devices has added a new Athlon multiprocessor for servers and workstations to its lineup, saying the chip is its highest-performance multiprocessor to date.

Other News: High Performance Computing

Other News: High Performance Computing 05/17/2004 10:17 AM
Apple offers resources and information related to high-performance computing.

Sun revamps high-performance computing
group

Sun revamps high-performance computing
group 06/30/2004 02:49 PM
The top executive is out, as Sun continues its struggle with revenue declines and elusive profitability.

Apple Tries To Bite Into
High-Performance Market

Apple Tries To Bite Into
High-Performance Market 07/06/2004 12:19 AM
With the announcement that it is providing 1,566 servers to an Army supercomputer project, Apple is making a move into the high-performance computing market that may open new doors for the company. By Michael Hardy, Federal Computer Week (via MyAppleMenu)

EEAT High Performance Channel Protocol

EEAT High Performance Channel Protocol 09/20/2004 07:20 PM
New release :: maint-1.1.0

IBM Brings High-Performance Computing to
Houston

IBM Brings High-Performance Computing to
Houston 08/27/2004 01:39 PM
The company's third supercomputing center will focus on the energy industry.

"High Performance R Us," Says Apple
Developers Web Page

"High Performance R Us," Says Apple
Developers Web Page 05/18/2004 10:47 PM
By Vern Seward, Mac Observer (via MyAppleMenu)

MSDN TV: Using High Performance Features
in Visual C++

MSDN TV: Using High Performance Features
in Visual C++ 04/09/2004 03:57 PM
In this episode, learn how to make use of some new features added to Visual C++ in Visual Studio 2005 (formerly referred to as "Whidbey"). These include adding OpenMP to your application, optimizing your application with Profile-Guided Optimization, and lastly building a 64-bit application.

Microsoft Aims for High Performance
Computing

Microsoft Aims for High Performance
Computing 06/24/2004 11:20 PM
Nearly a year after Microsoft announced a collaborative relationship with the Cornell Theory Center, the software giant has confirmed that it is venturing into the Unix dominated world of high performance computing (HPC). A special distribution of Windows Server 2003 called Windows Server 2003, HPC Edition is being crafted to tackle intensive parallel computing workloads.

Microsoft tackles high-performance
computing

Microsoft tackles high-performance
computing 06/24/2004 07:31 PM
Infomatics Jun 24 2004 11:05PM GMT

High-performance computing critical,
study says

High-performance computing critical,
study says 09/24/2004 05:34 PM
CanadaIT.com Sep 24 2004 9:48PM GMT

Apple gets high performance computing
nods

Apple gets high performance computing
nods 11/14/2003 09:11 AM
HPCwire, which bills itself as "the global publication of record for High Performance Computing," noted Apple several times in its recently announced 2003 Readers Choice Awards.

HIgh Performance Web Services: One Fell
Swoop

HIgh Performance Web Services: One Fell
Swoop 08/15/2002 12:42 PM
State adds fragility and complexity to systems. All incoming requests have to find the right state. If the state is kept in memory, it is much harder to load balance across a cluster of machines, because there is no practical way to keep an identical synchronized image on all machines in a cluster. If the state is kept in a shared durable store (normally a database), then all the machines have to connect to it and it must log all changes to state, which takes time.

The way to avoid state is to provide all the information the client needs in one fell swoop. For example, if I ask my hospital for my medical record, I want to get my medical record as a single returned message. I don't want to get back an object with "property getters" and "property setters" that I call for each interesting piece of information such as my name or Social Security number or birth date. -- Adam Bosworth

"zeldman.mama"

Apple Gets High Performance Computing
Nods

Apple Gets High Performance Computing
Nods 11/14/2003 10:15 AM
HPCwire, which bills itself as "the global publication of record for High Performance Computing," noted Apple several times in its recently announced 2003 Readers Choice Awards. By Peter Cohen (MacCentral via MyAppleMenu)

Prestigio Announces Release of New High
Performance Notebooks

Prestigio Announces Release of New High
Performance Notebooks 06/24/2004 03:00 AM
Prestigio, one of the most dynamically developing international manufacturers of LCD displays, mobile computers, plasma and LCD TVs, has announced the release of its new mobile computers of Prestigio Nobile series. [PRWEB Jun 24, 2004]

TowardEX Develops High Performance IP
Routing Technology

TowardEX Develops High Performance IP
Routing Technology 09/15/2004 04:21 AM
New software allows an Intel based PCI-x server platform to achieve routing of one million packets per second over Gigabit Ethernet. [PRWEB Sep 15, 2004]

Intel delays launch of high-performance
chip

Intel delays launch of high-performance
chip 07/30/2004 11:53 AM
MSNBC Jul 30 2004 3:35PM GMT

Apple adds High Performance Computing
Web page

Apple adds High Performance Computing
Web page 05/17/2004 11:52 AM
Apple has a new Web page for high performance computing...

Regaining America's Leadership in
High-Performance Computing

Regaining America's Leadership in
High-Performance Computing 07/20/2004 02:58 PM
ORNL Review Jul 20 2004 7:20PM GMT

NVIDIA GeForce 6600GT: high performance
for the rest of us?

NVIDIA GeForce 6600GT: high performance
for the rest of us? 09/07/2004 10:10 PM
How fast? The card keeps up with big brother in an astounding way, although just how astounding it is depends on which benchmark methods are used and which reviews you read.

Microsoft developing High Performance
version of Windows

Microsoft developing High Performance
version of Windows 06/24/2004 10:44 PM
Microsoft's "Data Center" version of Windows Server 2003 is aimed at high performance servers that run up to 64 processors on a single "system," but now Microsoft is turning its attention to parallel computing.

Alienware Intros Ultra High Performance
Computers

Alienware Intros Ultra High Performance
Computers 06/03/2004 06:41 PM

SearchDatabase: Red One Flying High with
MySQL

SearchDatabase: Red One Flying High with
MySQL 06/28/2004 06:10 PM
"With limited funding, Roger Holden's database decisions were limited when he decided to start airline flight tracking company, Red One Aviation..."

Myricom Unites High-Performance
Computing and 10-Gigabit Ethernet.

Myricom Unites High-Performance
Computing and 10-Gigabit Ethernet. 06/22/2005 02:39 AM
Myricom Unites High-Performance Computing and 10-Gigabit Ethernet. Myrinet-10G finally appears. They were smart to use the CX4 PHY; an $800 Myri-10G NIC is a much better deal than a $2000 Ethernet NIC, but it's still not competitive with Infiniband.

3D Performance with Battlefield 2 Demo:
Part 1 High-end Cards @ FiringSquad

3D Performance with Battlefield 2 Demo:
Part 1 High-end Cards @ FiringSquad 06/17/2005 03:45 PM

Kontron: high-performance PICMG 1.0
single board computer

Kontron: high-performance PICMG 1.0
single board computer 05/05/2004 09:21 PM
ECE May 6 2004 0:55AM GMT

News: IBM eyes industrial use for
high-performance Cell chip

News: IBM eyes industrial use for
high-performance Cell chip 03/31/2005 02:40 PM
IBM Corp.'s design services unit has begun promoting the new Cell microprocessor, developed together with Sony Corp. and Toshiba Corp., to potential users outside of the consumer electronics industry in which the chip is likely to first appear.
Grok Description matches for High Performance MySQL is Hot off the Press!
GrokA matches for High Performance MySQL is Hot off the Press!

If you've managed to get InnoDB working
with MySQL ...

If you've managed to get InnoDB working
with MySQL ... 03/13/2003 10:22 AM

If you've managed to get InnoDB working with MySQL under X, I'd very much like to talk to you. I've created a my.cnf file in /usr/local/mysql/data/ with the following:

# mysqld configuration file for InnoDB tables
[mysqld]
innodb_data_file_path=ibdata1:50M;ibdata2:50M
innodb_data_home_dir=/usr/local/mysql/data

and that looks correct to me but either it isn't or MySQL is ignoring the file completely or I've missed a step in getting InnoDB installed properly. I'm stumped so if you've got any ideas, I'd really like to hear them. Discuss

2:56 AM | Chris Cummer

EnGarde Secure Linux Advisory: MySQL,
MySQL-client, MySQL-shared, mod_php, php

EnGarde Secure Linux Advisory: MySQL,
MySQL-client, MySQL-shared, mod_php, php 12/16/2002 04:17 PM
"Stefan Esser from the PHP.net project discovered two vulnerabilities in MySQL which range from crashing the server to executing arbitrary code as the user under which the MySQL daemon runs (mysql)..."

SearchEnterpriseLinux: MySQL CEO: Open
Source MySQL Will Rise, Legal Foes Will
Fall

SearchEnterpriseLinux: MySQL CEO: Open
Source MySQL Will Rise, Legal Foes Will
Fall 02/01/2005 09:06 PM
"None of the legal attacks on open source or Linux have been successful. None of that stuff has gone anywhere. That's the biggest story..."

MySQL: MySQL Administrator Announced

MySQL: MySQL Administrator Announced 01/22/2004 10:26 AM
In a startling new note from the MySQL development team, information about their newest application has been posted on their site.

MySQL: MySQL Administrator Now Availible

MySQL: MySQL Administrator Now Availible 02/12/2004 10:10 AM
In a new note passed along to me from MarkL this morning, there's some new information about the admin tool that the MySQL folks have created.

Beginner MySQL Tutorial

Beginner MySQL Tutorial 06/14/2002 06:13 AM
A couple of years ago, I was doing some work for a client. They wanted to use a database on their site and bad news was I did not know how to accomplish this without the help from an outsider. I also did not make that money from the job...

Building MySQL with LinuxThreads on
FreeBSD

Building MySQL with LinuxThreads on
FreeBSD 01/23/2003 06:05 PM
This has come up a lot recently. I have several messages in my INBOX where people as asking for my secret recipe for properly building MySQL with LinuxThreads on FreeBSD. I don't have much time right now to explain how...

MySQL and ALTER TABLE, How?

MySQL and ALTER TABLE, How? 10/02/2002 09:26 AM

Introduction to MySQL Cluster

Introduction to MySQL Cluster 04/14/2004 03:51 PM
Notes from the Introduction to MySQL Cluster talk at the 2004 MySQL User's Conference... First we're seeing an overview of the NDB architecture. If you've never seen it before, think "Oracle RAC without shared storage" and you're 95% of the way there. The core NDB engine is a new storage engine inside MySQL. It provides transactions, replication, on-line backups, crash recovery, hash and tree indexes, on-line index builds, auto-detection of a failed node and re-sync when it comes back up....

PHP Magazine: XUL and MySQL Cluster at
NYPHP

PHP Magazine: XUL and MySQL Cluster at
NYPHP 08/27/2004 01:35 PM
In a post from PHP Magazine today, there's mention of an interesting discussion that was had at the latest NYPHP meeting concerning the accessing of the NDB Cluster native API directly from PHP.

MySQL Cluster Debuts (NewsFactor)

MySQL Cluster Debuts (NewsFactor) 04/15/2004 03:54 PM
NewsFactor - MySQL AB has launched MySQL Cluster, a new open-source database-clustering technology for applications requiring continuous availability. The product delivers 99.999 percent, or five nines, availability using a parallel server architecture.

Oracle VP: MySQL Cluster Not a Threat

Oracle VP: MySQL Cluster Not a Threat 04/15/2004 12:55 PM
Ken Jacobs, Oracle's vice president of product strategy, says MySQL Cluster 'will not change the competitive landscape' and that the company is trying to address shortcomings by acquiring a third-party technology.

MySQL Cluster High Availability Features

MySQL Cluster High Availability Features 04/14/2004 05:21 PM
Notes from the MySQL Cluster High Availability Features talk at the 2004 MySQL User's Conference... Redundancy between nodes via heartbeat. Redundancy between clusters via replication. In other words, NDB provides local and global redundancy. System recovery for a full-scale shutdown. Hot backup and restore. The architecture in general was designed to eliminate single points of failure. Lots of diagrams illustrating recovery in various failure scenarios that I can't ASCII copy too easily. Doh!...

MySQL: MySQL 5.0.0 Has Been Released

MySQL: MySQL 5.0.0 Has Been Released 12/26/2003 07:47 PM
"MySQL 5.0.0, a new version of the popular Open Source/Free Software Database Management System, has been released..."

MySQL: MySQL 4.0.20 Released

MySQL: MySQL 4.0.20 Released 05/20/2004 06:59 PM
"MySQL 4.0.20, a new version of the popular Open Source/Free Software Database Management System, has been released..."

MySQL: PHP and MySQL Get a Little Closer

MySQL: PHP and MySQL Get a Little Closer 02/18/2003 04:17 PM

Clockwatchers Web Hosting - MySQL
Tutorial - Import & Export Database

Clockwatchers Web Hosting - MySQL
Tutorial - Import & Export Database 05/24/2004 12:12 AM
How to import or export a MySQL database

clockwatchers.com/mysql_dump.html
track this site | 4 links

MySQL and Perl for the Web

MySQL and Perl for the Web 04/26/2004 03:49 PM

PERL/MYSQL/C programmer

PERL/MYSQL/C programmer 03/22/2005 04:32 PM
VIVA USA INC - United States, IL, Chicago (2005-03-19)

Perl/mySQL Web Developers

Perl/mySQL Web Developers 02/12/2004 03:19 PM
Agorist.net - Cyprus, Limassol (2004-02-12)

Perl/MySQL Web Developer

Perl/MySQL Web Developer 12/02/2003 01:58 AM
Express Logistics Systems Corp. - United States, CA, Fremont (2003-11-26)

Perl/MySQL/XML Web developer

Perl/MySQL/XML Web developer 06/28/2004 01:03 PM
Axis Sistemas - Venezuela, Carabobo, Valencia (2004-06-28)

Perl, MySQL Developer

Perl, MySQL Developer 01/26/2004 01:53 PM
LogicNow LTD - United Kingdom, ESSEX (2004-01-26)

Perl/MySQL programmer for Y! Finance

Perl/MySQL programmer for Y! Finance 12/29/2004 10:19 PM
Yahoo - United States, CA, Sunnyvale (2004-12-29)

MySQL/Perl Senior Consultant

MySQL/Perl Senior Consultant 01/06/2005 08:10 PM
MySQL - United States, California, Cupertino (2005-01-06)

PERL ,MySQL, Linux Developer

PERL ,MySQL, Linux Developer 02/10/2004 02:50 AM
HRsmart - United States, TX, Dallas (2004-02-02)

PHP/Perl/MySQL Programmer for Small ISP

PHP/Perl/MySQL Programmer for Small ISP 11/10/2003 11:32 PM
Peak Internet Solutions - United States, CO, Woodland Park (2003-11-08)

Perl/mySQL Application Programmer

Perl/mySQL Application Programmer 09/15/2004 11:53 AM
Softwyre - United States, AR, Little Rock (2004-09-15)

High Performance MySQL is Hot off the Press!

The following phrases have been identified by the grok system as matching this entry: mysql legacy load balancing perl cron mysql check table innodb tutorial xsan innodb balanceng zeus mysql vrrp failover mysql "freebsd 5" ndb cluster