RE: Performance Tweaking

RE: Performance Tweaking

 

  

To All,
There is a "buzz" in the IT arena in the states of Florida and Georgia. I have received many phone calls and emails asking about the book: "SQL Cookbook" by Anthony Molinaro. Below is my response to these phone calls
and emails.

The book: "SQL Cookbook" by Anthony Molinaro, is an outstanding book. It is a book long overdue. Anthony provides solutions to everyday, real world problems with straight SQL for 5 databases: Oracle, DB2, SQL Server,
PostgresSQL, and MySQL. I have also run some of his solutions in Sybase and Microsoft Access databases and those solutions worked, also. Next, I decided to run some of his code in Crystal Reports and Impromptu and
that worked, also.

I recommend this book for all Developers, DBAs, Database Architects, SQL Programmers, SQL Experts, Report Writers, Power Users, and anyone who wishes to enhance and increase their knowledge in writing SQL. This is
a "must have" book.

For further info, visit the Amazon.com site (see link below). Also, you may order this book through your local bookstore. I ordered my copy of this book via the Borders bookstore here in Tallahassee, Florida.







Please take a few minutes to provide feedback on the quality of service you received. The Department of Education values your feedback as a customer. Commissioner John L. Winn is committed to continuously assessing and improving the level and quality of services provided to you by Department staff. Simply use the link below. Thank you in advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]




-----Original Message-----
From: Joe Proctor
[mailto:mysqldba-ezmlmshield-x58846866.[Email address protected]
Sent: Wednesday, June 21, 2006 2:57 PM
To: LazyDBA Discussion
Subject: Performance Tweaking


I have MySQL 4 running on a windows 2000 server with IDE drives. I'd
like some tips for basic performance tweaks and things to look for.
Nothing is really wrong with my setup, but I feel it could be better.

Even some good MySQL tweaking websites you know would be good.

Joe Proctor
Systems Administrator
REGISTRAT(r), Inc.
859-223-4334 x463



NOTICE: The information contained in this electronic mail transmission
is intended by REGISTRAT(r), Inc. for the use of the named individual or
entity to which it is directed and may contain information that is
privileged or otherwise confidential. It is not intended for
transmission to, or receipt by, anyone other than the named addressee
(or person authorized to deliver it to the named addressee). It should
not be copied or forwarded to any unauthorized persons. If you have
received this electronic mail transmission in error, please delete it
from your system without copying or forwarding it, and notify the sender
of the error by reply email or by calling REGISTRAT(r), Inc. at +1 859
223 4334 (collect), so that our address record can be corrected




---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mysqldba-[Email address protected]
Website : http://www.LazyDBA.com

MySQL LazyDBA home page