MySQL/InnoDB Performance Talk

Grok Headline matches for MySQL/InnoDB Performance Talk

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

Prescott: let us talk performance

Prescott: let us talk performance 01/08/2004 08:17 PM

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.

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...

MySQL Talk Ideas Needed

MySQL Talk Ideas Needed 02/10/2004 02:49 AM
Well, the deadline for talk submissions at the annual O'Reilly Open Source Convention just passed (I hadn't noticed--I blame being busy). It's in Portland again this year, in late July. The folks at O'Reilly have asked me for talk ideas, so I figured I'd pose the question to anyone reading this who might have an opinion on the matter. If you were going to be at OSCON this year, what MySQL talks would you most like to see? What topics...

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...

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...

PHPCon Returns: The Scaling PHP/MySQL
Talk

PHPCon Returns: The Scaling PHP/MySQL
Talk 10/31/2002 09:20 AM

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

InnoDB Multiple Tablespaces and
Compressed Tables

InnoDB Multiple Tablespaces and
Compressed Tables 04/15/2004 10:15 AM
Notes from Heikki Tuuri's InnoDB Multiple Tablespaces and Compressed Tables talk at the 2004 MySQL User's Conference... Heikki spent quite some time as an academic doing math and later computer science. He wrote the first line of code in 1994 and was trying to figure out why relational databases were so slow. Five years later he had 110,000 lines of code and could run a TPC-C benchmark. He met Monty in 2000. Work in the InnoDB/MySQL interface began shortly after...

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)..."

Lets Talk Computers: Chris Repetto from
Intuit and Luke Chung from FMS featured
on this week's Let's Talk Comp

Lets Talk Computers: Chris Repetto from
Intuit and Luke Chung from FMS featured
on this week's Let's Talk Comp 08/28/2004 02:46 PM
Investors Business Daily Aug 28 2004 6:33PM GMT

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..."

Modern Day “Dr. Doolittle”, Joy Turner,
Debuts on Internet Talk Radio Network
VoiceAmerica Radio with Show Talk With
Your Animals

Modern Day “Dr. Doolittle”, Joy Turner,
Debuts on Internet Talk Radio Network
VoiceAmerica Radio with Show Talk With
Your Animals 01/04/2005 04:14 AM
The new radio show dedicated to helping people learn how to communicate effectively with their animals, airs at a new time starting on January 7, 2005 on VoiceAmerica. [PRWEB Jan 4, 2005]

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.

PR: Zend Brings Performance Management
to PHP With New Zend Performance Suite

PR: Zend Brings Performance Management
to PHP With New Zend Performance Suite 11/03/2002 08:19 AM
Product Enables PHP-enabled Enterprises To Achieve Dramatic Server Performance Improvement and Decrease Total Cost of Ownership

To talk or not to talk - that is the
question

To talk or not to talk - that is the
question 08/09/2004 05:44 AM
What's the future of in-flight mobile comms?

Dynamically Typed: Walk the walk vs.
talk the talk

Dynamically Typed: Walk the walk vs.
talk the talk 09/10/2004 07:30 AM
About two years ago you may remember we were in the throes of the SOAP revolution. "Web services everywhere!" was the cry and have to confess I'm one of those guilty of having gone for it, for a while. There were going to be these giant UDDI servers that would aggregate everyone's web services and the Internet would never look the same again...

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: PHP and MySQL Get a Little Closer

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

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..."

Performance PCs

Performance PCs 12/31/2004 02:03 AM
PC Authority Dec 31 2004 6:44AM GMT

64-bit vs 32-bit AMD Performance

64-bit vs 32-bit AMD Performance 04/28/2004 05:52 AM

Can We Talk?

Can We Talk? 03/13/2003 10:23 AM
Andrew Barnett wants to talk to you.

You Too Can Talk to Your Car

You Too Can Talk to Your Car 09/01/2004 08:37 PM
Internet News Sep 2 2004 0:05AM GMT

Talk, talk

Talk, talk 08/01/2004 03:24 AM
InternetRetailer.com Aug 1 2004 7:14AM GMT

How NOT to Talk!

How NOT to Talk! 07/23/2004 11:41 AM
Conversational Terrorism, or How NOT to Talk! .. Cheap tricks for discussions .. Business Meeting Strategies .. Conversational Cheap Shots .. Coversation .. clear

vandruff.com/art_converse.html
track this site | 4 links

[H]ard Talk

[H]ard Talk 04/01/2005 02:15 PM
Computer Power User Apr 1 2005 6:40PM GMT

SOA Talk

SOA Talk 05/31/2004 02:05 PM
I’m listening to Steve Gillmor, Doc Searls, Jon Udell, Dana Gardner, and Dan Farber talk about SOA via “The Gillmor Gang” at ITConversat ions. Herewith some observations on the form and content...

Let's talk shall we?

Let's talk shall we? 03/13/2003 10:24 AM
My girl DJ has an excellent post going on right now. It's dealing alot with how the few jaded bitter...

Too much talk

Too much talk 06/21/2004 08:53 AM
So, it turned out that I ran really long last thursday, and didn't get to the talk I'd actually prepared for the night, which was a bit disappointing. Then my laptop died (again, dammit) so I've not been able to get an annotated version of the slides for the second presentation together for everyone to look at (since it's not like I'm going to be giving this presentation anywhere else anytime soon--not too many folks are that interested in some of the details of implementing a virtual machine). When I get the machine back, assuming it works this tine, I'll...

Naming for Performance

Naming for Performance 01/16/2004 01:02 PM

One of the not often discussed cause of slow performance is careless naming.

When you are naming a method that does more than get or set some value, try to avoid a name that might mislead the caller into calling it multiple times instead of saving it to a local variable.  For example, if a method is named GetTopicName, the caller is not going to expect it to search for the value and instantiate many objects in the course of doing so.  Instead use a name that implies and warns the caller about the cost of the method, like FindTopicName or CalcPrime.

When using a language that supports properties like C#, try not to turn heavy methods into properties.  Property getters and setters should be light operations.  If you have to, then try to precalculate the value and update on change via event handlers.  Failing that, try to warn the developer using documentation so the developer can use the property accordingly.

One caveat: Guidelines are not meant to be straightjackets.  Don't do it if you can't do it.

Q&A: Performance + Art from Microsoft

Q&A: Performance + Art from Microsoft 07/08/2004 03:37 PM
Today marks the debut of a collection of trendsetting new input devices from Microsoft, including a new mouse conceived by Philippe Starck - an interior and industrial designer and architect known worldwide for bringing cutting-edge design to everyday products. Starck's award-winning work centers around a core philosophy focused on delivering extraordinary design in everyday objects. This vision has changed the way people perceive their juicer, hotel room, toothbrush, chair and even tape dispenser.

Flex Performance Brief

Flex Performance Brief 05/31/2004 03:36 PM
Compare the numbers for benchmark tests between a JSP and MXML application.

Eclipse performance.

Eclipse performance. 03/12/2003 10:29 AM

eclipse.exe -vmargs -Xverify:none -XX:+UseParallelGC -XX:PermSize=20M 

 -XX:MaxNewSize=32M -XX:NewSize=32M -Xmx96m -Xms96m

Sosume applies some new GC configuration settings, written about in JavaWorld and recommended for Netbeans to improve Eclipse performance in his post: Improving Eclipse performance by using vm arguments. I'm trying these settings myself now, but with -Xmx256m.

Other News: Mac OS X Performance

Other News: Mac OS X Performance 06/04/2004 10:56 AM
Kernelthread analyzes 10 Mac OS X performance optimizations.

Getting Disk Performance

Getting Disk Performance 09/23/2004 05:52 PM

Grok Description matches for MySQL/InnoDB Performance Talk
GrokA matches for MySQL/InnoDB Performance Talk

Compiere on Postgres/MySQL

Compiere on Postgres/MySQL 11/03/2003 08:52 AM

CodeMeX postgres-mySQL PHP Portal

CodeMeX postgres-mySQL PHP Portal 12/13/2003 10:33 AM
Estado del proyecto.

Generate Dynamic Content With Tomcat and
MySQL

Generate Dynamic Content With Tomcat and
MySQL 09/27/2002 02:32 PM
This article shows you how to create an application that demonstrates how Apache Tomcat and MySQL can communicate with one another, and it also gives you a very useful and reusable tool that handles most of the database work for you.

developerWorks: Generate Dynamic Content
with Tomcat and MySQL

developerWorks: Generate Dynamic Content
with Tomcat and MySQL 09/20/2002 05:04 AM
"Companies like doubleclick.net have made a lot of money serving banner ads on the Web. The service they provide is great, but why pay for something you can do yourself? In this article, enterprise Java consultants Javid Jamae and Kulvir Bhogal demonstrate how to create rotating banner ads using an all open-source environment: Apache Tomcat, MySQL, and the MM MySQL JDBC driver. First, they'll walk you through the necessary setup in Tomcat and MySQL, and then show you how to install the MM MySQL JDBC driver to allow a Java servlet running in Tomcat to communicate with MySQL..."

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...

MySQL Introduces Transaction System as
Standard

MySQL Introduces Transaction System as
Standard 10/16/2002 08:38 AM

Poor Passwords Exploited by MySQL Bot

Poor Passwords Exploited by MySQL Bot 02/01/2005 09:06 PM
Weak passwords chosen by people who should know better -- system administrators -- are the target of a new worm called MySQL bot.

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

Building MySQL snapshots on Debian
testing

Building MySQL snapshots on Debian
testing 12/02/2002 01:17 PM
I used to build nightly snapshots of the MySQL development trees (both 3.23 and 4.0) on both FreeBSD an Debian. But I stopped that a month or two back while I was debugging more important stuff. I recently decided to...

MySQL Gets Functions in Java

MySQL Gets Functions in Java 12/19/2003 03:39 PM
Java Coward writes "Eric Herman and MySQL's Brian "Krow" Aker have released code to allow the DBMS MySQL to run Java natively inside of the database. The code ...

Java, day #3: JDBC, MySQL, and a Rant

Java, day #3: JDBC, MySQL, and a Rant 12/23/2002 02:48 AM
Well, it's not really day #3. But I've spent a fair amount of time on Friday and over the weekend reading a copy of "The Java Programming Language" to refresh my memory on all this new-fangled Java stuff. I decided...

Java DBMS functions for MySQL 0.2

Java DBMS functions for MySQL 0.2 12/22/2003 05:21 PM
Provides Java DBMS functions for MySQL

Java DBMS functions for MySQL 0.1

Java DBMS functions for MySQL 0.1 12/19/2003 11:39 AM
Provides Java DBMS functions for MySQL

Developer.com: Binding to MySQL in Java
Studio Creator

Developer.com: Binding to MySQL in Java
Studio Creator 06/24/2005 10:02 PM
"Creating database-driven apps requires a database, and that requires data. This makes it necessary to create schemas and populate them with some sample data..."

XAO-MySQL-1.01

XAO-MySQL-1.01 11/13/2003 12:45 AM

MySQL/InnoDB Performance Talk

The following phrases have been identified by the grok system as matching this entry: hibernate mysql slow performance hibernate mysql innodb slow queries postgres "load testing" tutorial innodb myisam benchmarking mysql innodb and hibernate transaction tomcat openbsd mysql php jcs mysql 4.1 "poor performance" sony cybershot 4.1downloads java performance solaris 1.4.1 slow mysql performance tuning mtop