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

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

Appendix A: Problems and Common Errors 637 shell> perror 11 Resource temporarily unavailable The problem here is that mysqld is trying to keep open too many les simultaneously. You can either tell mysqld not to open so many les at once or increase the number of le descriptors available to mysqld. To tell mysqld to keep open fewer les at a time, you can make the table cache smaller by using the -O table_cache=32 option to safe_mysqld (the default value is 64). Reducing the value of max_connections will also reduce the number of open les (the default value is 90). To change the number of le descriptors available to mysqld, you can use the option --open- files-limit=# to safe_mysqld or -O open-files-limit=# to mysqld. See Section 4.5.6.4 [SHOW VARIABLES], page 257. The easiest way to do that is to add the option to your option le. See Section 4.1.2 [Option les], page 186. If you have an old mysqld version that doesn't support this, you can edit the safe_mysqld script. There is a commented-out line ulimit -n 256 in the script. You can remove the '#' character to uncomment this line, and change the number 256 to aect the number of le descriptors available to mysqld. ulimit (and open-files-limit) can increase the number of le descriptors, but only up to the limit imposed by the operating system. There is also a 'hard' limit that can only be overrided if you start safe_mysqld or mysqld as root (just remember that you need to also use the --user=... option in this case). If you need to increase the OS limit on the number of le descriptors available to each process, consult the documentation for your operating system. Note that if you run the tcsh shell, ulimit will not work! tcsh will also report incorrect values when you ask for the current limits! In this case you should start safe_mysqld with sh! A.3 Installation Related Issues A.3.1 Problems When Linking with the MySQL Client Library If you are linking your program and you get errors for unreferenced symbols that start with mysql_, like the following: /tmp/ccFKsdPa.o: In function `main': /tmp/ccFKsdPa.o(.text+0xb): undefined reference to `mysql_init' /tmp/ccFKsdPa.o(.text+0x31): undefined reference to `mysql_real_connect' /tmp/ccFKsdPa.o(.text+0x57): undefined reference to `mysql_real_connect' /tmp/ccFKsdPa.o(.text+0x69): undefined reference to `mysql_error' /tmp/ccFKsdPa.o(.text+0x9a): undefined reference to `mysql_close' you should be able to solve this by adding -Lpath-to-the-mysql-library -lmysqlclient last on your link line. If you get undefined reference errors for the uncompress or compress function, add -lz last on your link line and try again!

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