On 7/1/05, Karthikeyan R <thegreatkarthik@xxxxxxxxx> wrote:
Hi all,
I am using MySQL database.
I have created a database which contains some 13 tables.
one of the table contains 13 lakhs rows.(table3 contains 13 lakhs rows)
When i issue the command "select * from table3;" in mysql its not all
showing anything.
I tried copying my-huge.cnf to my.cnf
I tried changing the table_cache, read_buffer but nothing helped me.
my server configuration is
Intel(R) Xeon(TM) CPU 3.06GHz with 2.4.21-4.ELsmp #1 SMP with 1 GB RAM
Possibly help me to retrieve the rows.
thanks in advance