12 useful MySQL configuration variables that will improve performance

Topics:: Database Management

Tags:: Configuration Variable,; Data Management,; Databases,; Enterprise Software,; MySQL,; Open Source,; Performance,; Software

Source:: TechRepublic

FREE Registration is required

Overview: The default MySQL server settings are optimized for most common uses and for most installations these settings will work just fine as is. However, because MySQL is so open, it's fairly easy for you to further fine-tune MySQL's default settings to obtain even greater performance and stability, and to better match the needs of your particular enterprise. In this download, we list some of the most useful MySQL configuration variables, including buffer settings, query cache configurations, and binary logging. For each configuration variable we tell you what functions it performs and suggest how you should use it.Which MySQL configuration variables did you have to adjust in your latest installation? What other configuration settings should we include in the download?

(Is this item miscategorized? Does it need more tags? Let us know.)

People who downloaded this item also downloaded

	10 secret MySQL client startup options you should know
	MySQL 5.0 Stored Procedures: MySQL 5.0 New Features Series - Part 1
	MySQL 5.0 Quick Guide
	A Practical Guide to Migrating to MySQL 5.0
	MySQL Administrator Best Practices

Top results from Database Management

Receive Email Updates when new items are added to this category

	10+ reasons to use Access (and a few reasons not to)
	10+ tips for upsizing an Access database to SQL Server
	How do I... Identify and delete duplicates from SQL Server tables?
	IT Hiring Kit: Oracle Database Administrator
	IT Hiring Kit: SQL Server Database Administrator

» View all Database Management listings

SponsoredWhite Papers, Webcasts, and Downloads

Premier Vendor Content Whitepapers, webcasts & resources from our Power Center Sponsors

Returning users: Log In Here!

Already registered on BNET, TechRepublic, or ZDNet? Simply log in.

Free Membership: Sign Up Now!

Sign up for a free membership today and get instant and unlimited access to one of the largest databases of white papers, webcasts, and casestudies anywhere. Your FREE membership allows you to:

Download an unlimited amount of content, including classic and current white papers, case studies, webcasts and more
Track content on your chosen topics of interest
Receive targeted email alerts when your favorite content is added
Save content for future reading
Receive our member newsletter

When you register to access this library, you become a member of TechRepublic. In addition, you allow us to share your information with companies that produce products or services featured in the library--so that such companies may contact you with information and offers regarding their products and services. This enables us to keep the library a free service. As a library registrant, you will receive a complimentary subscription to the TechRepublic member newsletter. You can unsubscribe from this newsletter at any time. By clicking the Sign up button, you indicate that you agree to our Terms and Conditions and have read and understand our Privacy Policy.