Hi,
You need do a INDEXING on database. using EXPALIN sql command you can find
out how
much time it takes and how much rows it has searched.
for example
mysql>explain select username from yahoo where phoneno = '5782716';
you will see rows, if the value in rows higher than one, then you need to
do indexing
using ALTER command you can do INDEXING of tables accordingly
Rgds
Jai
----- Original Message -----
From: Anilkumar <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, December 21, 2002 1:08 PM
Subject: [LIH]slow mysql
> Dear All,
> I have Redhat Linux 7.2 installed with two hard Disk
> one hard disk is having, installation, and other partitions
> and othe harddisk used exclusive for stroring file. both the hard disk is
> having capacity of 40 GB
> RAM is 512 MB.
>
> i am using that for storing of files and mysal database server. i have
only
> one database in which biggest file is 200 MB.
> now the second partition is using 6 GB files. now mysql server is very
> slow. select query takes lots of time.
>
> i want to speed up mysql so it can run fast. i have ram of 512 is there
any
> way in which i can allocate around 256 MB ram for mysql so mysql run
> faster. now i am starting mysql with init command file
> /etc/rc.d/init.d/mysql
>
> my Server/mysql slowed down after adding second hard disk and uploading
6GB
> of data. what will be the solutions for faster access of server.
>
> Anil
>
>
>
> -------------------------------------------------------
> This SF.NET email is sponsored by: The Best Geek Holiday Gifts!
> Time is running out! Thinkgeek.com has the coolest gifts for
> your favorite geek. Let your fingers do the typing. Visit Now.
> T H I N K G E E K . C O M http://www.thinkgeek.com/sf/
> _______________________________________________
> linux-india-help mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/linux-india-help
>
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
linux-india-help mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/linux-india-help
