I've started logging each page request made to my site as an entry in
a MySQL table. I get about 5000 page requests per day, and I wonder
if I'm asking to much of MySQL. Is there a limit on how big a table
can be? Other considerations?
- Grant
--
gentoo-user@gentoo.org mailing list
On Thursday 17 February 2005 12:18 pm, Grant wrote:
I've started logging each page request made to my site as an entry in
a MySQL table. I get about 5000 page requests per day, and I wonder
if I'm asking to much of MySQL. Is there a limit on how big a table
can be? Other considerations?
On Thu, 17 Feb 2005 10:18:02 -0800, Grant [EMAIL PROTECTED] wrote:
I've started logging each page request made to my site as an entry in
a MySQL table. I get about 5000 page requests per day, and I wonder
if I'm asking to much of MySQL. Is there a limit on how big a table
can be? Other
I've started logging each page request made to my site as an entry in
a MySQL table. I get about 5000 page requests per day, and I wonder
if I'm asking to much of MySQL. Is there a limit on how big a table
can be? Other considerations?
Are you serious? We log 4-7 million rows a day
Am Donnerstag, 17. Februar 2005 19:18 schrieb Grant:
I've started logging each page request made to my site as an
entry in a MySQL table. I get about 5000 page requests per day,
and I wonder if I'm asking to much of MySQL. Is there a limit on
how big a table can be? Other considerations?
Grant wrote:
I've started logging each page request made to my site as an entry in
a MySQL table. I get about 5000 page requests per day, and I wonder
if I'm asking to much of MySQL. Is there a limit on how big a table
can be? Other considerations?
Are you serious? We log 4-7 million rows a day
On Thursday 17 February 2005 12:31 pm, Grant wrote:
I'm very glad to hear that. What about performance issues? Will the
insert be slower as the table grows? That could be a problem.
If you use myisam, no, unless your deleting a lot.. if you use innodb and you
dont optimize it, its
I'm very glad to hear that. What about performance issues? Will the
insert be slower as the table grows? That could be a problem.
If you use myisam, no, unless your deleting a lot.. if you use innodb and you
dont optimize it, its possible..
So you're saying if I use the default MySQL
On Thursday 17 February 2005 02:25 pm, Grant wrote:
So you're saying if I use the default MySQL storage engine and don't
delete records, the size of the table will not affect the insert
performance?
Depends on how big the table gets.. This depends on hardware/fs types/memory
and a host of
On Thursday 17 February 2005 02:25 pm, Grant wrote:
So you're saying if I use the default MySQL storage engine and don't
delete records, the size of the table will not affect the insert
performance?
Grant,
Here is a excellent discussion, and its how we do things here so I know it
works
10 matches
Mail list logo