High Performance MySQL (the book) is Shipping!
Grok Headline matches for High Performance MySQL (the book) is Shipping!
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 is Hot off the
Press!
High Performance MySQL is Hot off the
Press!
04/12/2004 02:22 AM If you happen to wander by The O'Reilly and Associates web site soon,
you'll notice a new book featured in the "Hot off the Press" section
of the home page: High Performance MySQL is an insider's guide to the
poorly documented issues of MySQL reliability, scalability, and
performance. The book gives in-depth coverage of MySQL indexing and
optimization so you can make better use of these key features. You'll
learn practical replication, backup, and load-balancing strategies
with information that...
Comparing MySQL performance
Comparing MySQL performance
03/14/2005 05:31 PMWith 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 AMSome 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 PMTuesday 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 AMCNET May 24 2004 11:47AM GMT
Web Database Applications with PHP and
MySQL: A Book Review
Web Database Applications with PHP and
MySQL: A Book Review
06/26/2002 01:02 PMA useful book that offers a lot of varied information in one place for
updating your skills.
Book Review: Mastering phpMyAdmin for
Effective MySQL Management
Book Review: Mastering phpMyAdmin for
Effective MySQL Management
12/17/2004 06:23 PMThis well-written book by one of the leaders of the phpMyAdmin
community covers a lot of ground--and might get you interested in
working on the project.
Microsoft High on Performance
Microsoft High on Performance
06/23/2004 07:19 PMMicrosoft 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 AMCreating high performance teams
Creating high performance teams
12/31/2004 06:35 AMExpress Computer India Dec 31 2004 10:55AM GMT
AMD Rolls Out New High-Performance Chip
AMD Rolls Out New High-Performance Chip
03/20/2003 01:05 PMNumber 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 AMApple offers resources and information related to high-performance
computing.
OMUD High-Performance Driver
OMUD High-Performance Driver
05/29/2004 01:55 AMStatus
High-Performance RF Transistors For 3G
Wireless
High-Performance RF Transistors For 3G
Wireless
01/27/2004 01:21 AM3G Jan 27 2004 5:15AM GMT
New High Performance ATI FireGL X1 & Z1
Drivers
New High Performance ATI FireGL X1 & Z1
Drivers
03/21/2003 01:35 PMApple Tries To Bite Into
High-Performance Market
Apple Tries To Bite Into
High-Performance Market
07/06/2004 12:19 AMWith 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)
HIgh Performance Web Services: One Fell
Swoop
HIgh Performance Web Services: One Fell
Swoop
08/15/2002 12:42 PMState 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"
MSDN TV: Using High Performance Features
in Visual C++
MSDN TV: Using High Performance Features
in Visual C++
04/09/2004 03:57 PMIn 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.
IBM Brings High-Performance Computing to
Houston
IBM Brings High-Performance Computing to
Houston
08/27/2004 01:39 PMThe company's third supercomputing center will focus on the energy
industry.
EEAT High Performance Channel Protocol
EEAT High Performance Channel Protocol
09/20/2004 07:20 PMNew release :: maint-1.1.0
Microsoft Aims for High Performance
Computing
Microsoft Aims for High Performance
Computing
06/24/2004 11:20 PMNearly 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.
High-performance computing critical,
study says
High-performance computing critical,
study says
09/24/2004 05:34 PMCanadaIT.com Sep 24 2004 9:48PM GMT
Apple Gets High Performance Computing
Nods
Apple Gets High Performance Computing
Nods
11/14/2003 10:15 AMHPCwire, 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)
Apple gets high performance computing
nods
Apple gets high performance computing
nods
11/14/2003 09:11 AMHPCwire, 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 R Us," Says Apple
Developers Web Page
"High Performance R Us," Says Apple
Developers Web Page
05/18/2004 10:47 PMBy Vern Seward, Mac Observer (via MyAppleMenu)
Microsoft tackles high-performance
computing
Microsoft tackles high-performance
computing
06/24/2004 07:31 PMInfomatics Jun 24 2004 11:05PM GMT
Sun revamps high-performance computing
group
Sun revamps high-performance computing
group
06/30/2004 02:49 PMThe top executive is out, as Sun continues its struggle with revenue
declines and elusive profitability.
Alienware Intros Ultra High Performance
Computers
Alienware Intros Ultra High Performance
Computers
06/03/2004 06:41 PMMicrosoft developing High Performance
version of Windows
Microsoft developing High Performance
version of Windows
06/24/2004 10:44 PMMicrosoft'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.
Apple adds High Performance Computing
Web page
Apple adds High Performance Computing
Web page
05/17/2004 11:52 AMApple has a new Web page for high performance computing...
Prestigio Announces Release of New High
Performance Notebooks
Prestigio Announces Release of New High
Performance Notebooks
06/24/2004 03:00 AMPrestigio, 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]
Intel delays launch of high-performance
chip
Intel delays launch of high-performance
chip
07/30/2004 11:53 AMMSNBC Jul 30 2004 3:35PM GMT
TowardEX Develops High Performance IP
Routing Technology
TowardEX Develops High Performance IP
Routing Technology
09/15/2004 04:21 AMNew 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]
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 PMHow 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.
Regaining America's Leadership in
High-Performance Computing
Regaining America's Leadership in
High-Performance Computing
07/20/2004 02:58 PMORNL Review Jul 20 2004 7:20PM GMT
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..."
Crellon: high-performance PowerPC
industry pack carrier
Crellon: high-performance PowerPC
industry pack carrier
09/01/2004 07:41 AMECE Sep 1 2004 12:29PM GMT
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 PMGrok Description matches for High Performance MySQL (the book) is Shipping!
GrokA matches for High Performance MySQL (the book) is Shipping!
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)..."
Managing and Using MySQL
Managing and Using MySQL
02/24/2003 08:37 PMIf you are a person that use MySQL and usually has to take care of
both the programming and the database management tasks, this book may
be ideal for you. It provides a very light reading that can give you a
quick overview of most of the relevant issues that you need to learn
to get your MySQL based database applications working conveniently.
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 AMIn 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 AMIn 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.
MySQL: PHP and MySQL Get a Little Closer
MySQL: PHP and MySQL Get a Little Closer
02/18/2003 04:17 PMMySQL: 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..."
Using MySQL from PHP
Using MySQL from PHP
03/06/2004 02:00 AM
One of PHP's prime benefits is its close integration with
databases, especially MySQL. Having explained the basics of MySQL,
John Coggeshall turns his attention to demonstrating how to use MySQL
from PHP.
PHP vs mysql
PHP vs mysql
10/02/2002 01:58 PMMySQL Log
MySQL Log
09/28/2002 03:31 AMAdd and show the log provide by other classes such as MySQL Connection
and MySQL Recordset
MySQL 5.0
MySQL 5.0
12/29/2003 11:50 PMChanges in
release 5.0.0 (Development): MySQL has released an alpha of
version 5.0. They include support for stored procedures, but no views
yet.
C
lick here to comment on this entry
MySQL 4.1.1 Now Available!
MySQL 4.1.1 Now Available!
12/07/2003 12:48 PMMySQL's newest offering, MySQL 4.1.1, has been released. Their second
alpha development release for the current version is now available in
source/binary for the major platforms. There are new features galore,
a more secure authentication scheme and support of multiple table
spaces by MySQL's transa
MySQL to XML - XML to MySQL
MySQL to XML - XML to MySQL
10/02/2002 06:05 PMInsert XML in MySQL and export MySQL to XML. The class XMLFile and my
other class such as MySQL Connection, MySQL RecordSet and MySQL Log
are required.
TCB-mysql-0.2
TCB-mysql-0.2
05/26/2004 04:50 PMMySQL 4.0.18
MySQL 4.0.18
05/06/2004 06:50 PMThe worlds most widely used open source database.
Use MySQL.
Use MySQL.
03/11/2003 10:45 AMIf you’re using Movable Type, use MySQL. If you have something
against MySQL, use something else, but don’t use DB files. Note:
Here comes the rant....
God Uses MySQL
God Uses MySQL
11/10/2003 11:40 PM There was a lot of reaction to my recent post about MySQL at Sabre,
most of which I don't have the time or interest to respond to. Too
many people just Don't Get It and Never Will. But I was inspired to
visit the church sign generator and make the image you see with this
post. I think it's amusing. :-) Anyway, life would be so much easier
if people stopped trying to think of MySQL in terms of...
MySQL GOES GPL
MySQL GOES GPL
06/12/2002 06:22 AM"We have always considered ourselves committed members of the Open
Source and Free Software communities," said Monty Widenius, project
leader on MySQL. Moving to the GNU General Public License (GPL) is a
way to show this". It is the latest beta (version 3.23.19) and all new
releases that is being GPLed.
XAO-MySQL-1.01
XAO-MySQL-1.01
11/13/2003 12:45 AMMySQL 4.0.16 now available!
MySQL 4.0.16 now available!
11/05/2003 10:36 PMMySQL AB, developer of the world's most popular open source database,
has released 4.0.16, the current production release of MySQL. Users
with previous versions are encouraged to download this release.
MySQL-Easy-1.25.1
MySQL-Easy-1.25.1
12/30/2004 07:50 PMCooking with MySQL
Cooking with MySQL
11/21/2002 08:14 PM
Paul DuBois has selected sample recipes from the hundreds you'll
find in his book, MySQL Cookbook. In this first in a three-part series
showcasing these sample recipes, find out how to interpret results
from summaries and NULL values and how to identify duplicates in a
table or record.
MySQL 4.0.21 (Production (4.0.x))
MySQL 4.0.21 (Production (4.0.x))
09/10/2004 05:39 AMA fast SQL database server.
MySQL and OS X Revisited
MySQL and OS X Revisited
11/23/2002 10:02 AMvia Apple's Internet Developer: "In this article I'll give you an
overview of MySQL's features and drawbacks, show you how...
Interface MySQL with C
Interface MySQL with C
01/08/2004 08:12 PMUnix Review tells us about talking to MySQL with C."The reliability
and longevity of the C programming language coupled with the stability
of MySQL make them a strong pair for system database management. In
last month's MySQL column, I went over the basics of developing a Perl
interface to MySQl. Before that, I covered PHP with MySQL. This month,
I will discuss building an interface to MySQL with C."
Why not leave MySQL alone?
Why not leave MySQL alone?
01/08/2004 07:14 PMA war very vivid discussion is raging over at Sterling's blog about
MySQL licensing. I have, in the past, voiced my opinions on the matter
as well (see here for a few random samples).I think it's time for the
community...
MySQL C API C++ wrapper 1.2
MySQL C API C++ wrapper 1.2
06/11/2004 04:06 PMAnother MySQL C API C++ wrapper.
MySQL-Sync
MySQL-Sync
01/06/2004 11:48 AMOfficial Homepage
DBD-mysql-2.9006
DBD-mysql-2.9006
04/04/2005 02:32 AM High Performance MySQL (the book) is Shipping!