1/06, Alex <[EMAIL PROTECTED]> wrote:
> the table type whether it is myisam or innodb. create table statements are
> preferred when you have slow query issues.
>
> --Alex
>
>
> On Wed, 04 Jan 2006 15:57:06 +0530, Jonathan Chong <[EMAIL PROTECTED]>
> wrote:
>
>
Please provide details like what tables are you using, the entire my.cnf
> and the information from the mysqld.err when the crashes occurred.
>
>
> --Alex
--
Jonathan Chong
http://www.arsenal-now.com/
http://www.arsenal-mania.com/
http://www.ashburrn.com/
http://www.jonathan-chong.com/
--
information from the mysqld.err when the crashes occurred.
>
>
> --Alex
>
>
> On Wed, 04 Jan 2006 06:11:24 +0530, Jonathan Chong <[EMAIL PROTECTED]>
> wrote:
>
> > Hi everyone
> >
> > I run a relatively popular forum that gets overloaded on match days.
any ideas I can try
out, I'd appreciate it if you could please let me know.
I can provide more stats if necessary!
Thanks in advance.
--
Jonathan Chong
http://www.arsenal-now.com/
http://www.arsenal-mania.com/
http://www.ashburrn.com/
http://www.jonathan-chong.com/
--
MySQL General Mailing
tables during I/O access.
I'm running an AMD64 3000+ with 1GB of memory.
--
Jonathan Chong
http://www.arsenal-now.com/
http://www.arsenal-mania.com/
http://www.ashburrn.com/
http://www.jonathan-chong.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
ite a parse script to do this for me?
Another option would be to have a snapshot_id column in every table,
but is slightly more messy from my point of view.
Please let me know your thoughts, thanks.
--
Jonathan Chong
http://www.arsenal-now.com/
http://www.arsenal-mania.com/
http://www.ashburrn.com/
