The following are from the InnoDB configuration page:
# Set buffer pool size to 50-80% of your computer's memory,
# but make sure on Linux x86 total memory usage is 2GB
*Warning:* On 32-bit GNU/Linux x86, you must be careful not to set
memory usage too high. |
glibc| may allow the process heap
Mayuran,
It depends on a bunch of things. What else is running on this server?
Does the distro you use have the ability to take advantage of all 16 gig
(ie if you have apache running, will it be stuck in the same 4 gig as
MySQL, or can it use the memory above the 4 gig limit).
How big is your
Hello.
I think, you should recreate an InnoDB tablespace on a new
server and import the data exported with mysqldump. If you
remove the database directory and InnoDB files, on startup
server recreates InnoDB tablespace and then you should be able
to import the data from the old server.
Hi,
I had got webserver with mysql 4.0.20 (if I remember well) compiled from
sources on slackware 9. Now, I've bought new machine, and I've installed
gentoo with mysql 4.0.22.
I've copied (in shell) datadir to new machine, preserving attributes.
Now, every of my innodb table in phpmyadmin is
Hi people,
Is there any way I can see how much space each database is using from the
innodb data file? Something showing how the space is divided among
the databases. Thanks.
sql,query
Alexander Varshavchick, Metrocom Joint Stock Company
Phone: (812)118-3322, 118-3115(fax)
Hi,
Is there any way to check whether I should add new datafile before my
database runs out of free space in the existing ones?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)