Dyntex.net Support Centre: MySQL Reference Manual p.71

<< previous page -- table of contents -- next page >>

Chapter_1

Chapter_2

Chapter_3

Chapter_4

Chapter_5

Return to Table of Contents

Table of Contents
1. General Information
2. MySQL Installation
3. Tutorial Introduction
4. Database Administration
5. MySQL Optimisation
6. MySQL Language Reference
7. MySQL Table Types
8. MySQL APIs
9. Extending MySQL

Chapter 2: MySQL Installation 71 The ability of the kernel and/or the thread library to run many threads which ac- quire/release a mutex over a short critical region frequently without excessive context switches. In other words, if the implementation of pthread_mutex_lock() is too anx- ious to yield CPU time, this will hurt MySQL tremendously. If this issue is not taken care of, adding extra CPUs will actually make MySQL slower. General lesystem stability/performance. Ability of the lesystem to deal with large les at all and deal with them eciently, if your tables are big. Our level of expertise here at MySQL AB with the platform. If we know a platform well, we introduce platform-specic optimisations/xes enabled at compile time. We can also provide advice on conguring your system optimally for MySQL. The amount of testing of similar congurations we have done internally. The number of users that have successfully run MySQL on that platform in similar congurations. If this number is high, the chances of hitting some platform-specic surprises are much smaller. Based on the preceding criteria, the best platforms for running MySQL at this point are x86 with SuSE Linux 7.1, 2.4 kernel, and ReiserFS (or any similar Linux distribution) and SPARC with Solaris 2.7 or 2.8. FreeBSD comes third, but we really hope it will join the top club once the thread library is improved. We also hope that at some point we will be able to include all other platforms on which MySQL compiles, runs okay, but not quite with the same level of stability and performance, into the top category. This will require some eort on our part in cooperation with the developers of the OS/library components MySQL depends upon. If you are interested in making one of those components better, are in a position to in uence their development, and need more detailed instructions on what MySQL needs to run better, send an e-mail to internals@lists.mysql.com. Please note that the preceding comparison is not to say that one OS is better or worse than the other in general. We are talking about choosing a particular OS for a dedicated purposerunning MySQL, and compare platforms in that regard only. With this in mind, the result of this comparison would be dierent if we included more issues into it. And in some cases, the reason one OS is better than the other could simply be that we have put forth more eort into testing on and optimising for that particular platform. We are just stating our observations to help you decide on which platform to use MySQL on in your setup. 2.2.3 Which MySQL Version to Use The rst decision to make is whether you want to use the latest development release or the last stable release: Normally, if you are beginning to use MySQL for the rst time or trying to port it to some system for which there is no binary distribution, we recommend going with the stable release (currently version 3.23). Note that all MySQL releases are checked with the MySQL benchmarks and an extensive test suite before each release (even the development releases).

MySQL Reference Manual

Our Partners

SpiritHost - web hosting for spiritual and education sites
SpiritHit.com - Religious and Spiritual Portal

Return to Table of Contents	Back to top

Web Hosting: Manuals & FAQ's

1. Unix-Based Web Hosting
2. Unix Dedicated Servers
3. Windows Dedicated Servers
4. CuteFTP User’s Guide
5. CuteHTML User’s Guide
6. WS_FTP Pro User's Guide
7. Miva Order User's Guide
8. Miva Merchant User's Guide