Re: Database slows down when mass users logging on

Hey, As per you config in my.cnf there has to be two logs > log_error = /var/log/mysql_error.log > log-slow-queries = /var/log/mysql_slow_queries.log We have to have that info in error log to hunt down the issue. Also if possible obtain the messages from /var/log/messages (these are kern

Re: Database slows down when mass users logging on

If you are knowledgeable about the application and know which tables are frequently accessed during the time of crash, you can send the create statements used to create those tables. Also any indexing and how many rows are in the table will also help. In my opinion over a hundred tables for an app

Re: Database slows down when mass users logging on

I would suggest looking at the slow query log first and figure out what queries were taking long when the crash occurs at heavy concurrent usage, and then try to optimize those queries, it might a world of difference, also since you have only 1GB ram , try decreasing the sort_buffer_size, read_buff

Re: Database slows down when mass users logging on

Hi Alex There are over a hundred tables for the site, and those that are related to this query are probably about 15-30. Do you want the CREATE TABLE syntax for all of them? Funnily enough, the file /var/log/mysql_error.log doesn't exist .. I'm using myISAM tables, yes. On 04/01/06, Alex <[EMA

Re: Database slows down when mass users logging on

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: Sorry I also forgot to ask - when you say the tables, did you want the table structu

Re: Database slows down when mass users logging on

Hi, Please provide the log extracts from /var/log/mysql_error.log in your box when the crashes occurred and also you havent mentioned the table types thats you are using. MyISAM tables are the deafult for your configuration. This table type is not recommeded for highly concurrent usag

Re: Database slows down when mass users logging on

Sorry I also forgot to ask - when you say the tables, did you want the table structure? There are quite a few tables, perhaps I should just send the tables that are read and written to often when a user hits a page? On 04/01/06, Alex <[EMAIL PROTECTED]> wrote: > Hi, > >Please provide detail

Re: Database slows down when mass users logging on

Hi Alex Thanks for this, and sorry for the late reply. That was the entire my.cnf file in my last email. This is from SHOW VARIABLES in mysql. +-+--+ | Variable_name | Value

Re: Database slows down when mass users logging on

Hi, 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 On Wed, 04 Jan 2006 06:11:24 +0530, Jonathan Chong <[EMAIL PROTECTED]> wrote: Hi everyone I run a relatively popular forum that get

Database slows down when mass users logging on

Hi everyone I run a relatively popular forum that gets overloaded on match days. On normal days, the site is coping fine, but when there are plenty of users on the forum (about 50-70 odd) the load goes up and the site crawls, before crashing, and the server rebooted The forum software is phpBB.