Sujay ,
> Tables : 1 (only 1) ::: Innodb or Myisam ?
I see lots of updates happening on that table so , how frequent do you
defragment the table .
--
Thanks
Praj
On Mon, 9 Jan 2006 01:46:39 -0800
Sujay Koduri <[EMAIL PROTECTED]> wrote:
>
> I am giving the system configuration which we are u
Hi Sujay,
Can you please post details like the my.cnf configs, how is the
load on system like cpu, memory, disk usage etc.
Thanx in advance
--Alex
On Mon, 09 Jan 2006 15:16:39 +0530, Sujay Koduri <[EMAIL PROTECTED]> wrote:
I am giving the system configuration which we are using to
I am giving the system configuration which we are using to run MySQL.
2-CPU 4G RAM, SAN filesystem.
MySQL version : 4.14 (INNODB)
OS : RHEL - 3
Amount of Data : 200G
No of Rows : 278 million approximately (Every day 2.5-3 million rows gets
added)
Transaction rate : 300-400 reads/sec, 110-120 upda
Hi Vishwas
These and many other answers can be found here :
http://dev.mysql.com/doc/refman/5.0/en/what-is.html
There is no practical limitation on the row size apart from the number
of fields x the size of these fields. eg. 1000 fields of varchar(255) or
larger will take up that space. I don't k
