82350 | NULL | NULL | YES | BTREE
| |
+++--+--+-
+---+-+--++--+
+-+
3 rows in set (0.00 sec)
T1 has 20,029 rows
T2 has 82350 rows
Many thanks to anyone who can offer any insight to this quandary.
Cheers
James Riordon
Hosting | Webdesign | PHP | DTP
http://www.outofcontrol.ca
homework and have spent
many many hours study the list, the documentation, searching the 'Net'
for more information, and I have not come up with a way to make our
machine more efficient. So, if anyone can suggest even the most obvious
of things to look at then I would be forever gratef
earching
the 'Net' for more information, and I have not come up with a way to
make our machine more efficient. So, if anyone can suggest even the
most obvious of things to look at then I would be forever grateful.
James Riordon
SysAdmin (at least for now...)
--
At 9:07 -0500 02/07/2002, Ken Menzel was thought to have said :
>Many of the questions on this list are answered by people like
>myself who are users of MySQL. We are busy trying to run our own
>servers and put food on the table. That being said, you are
>wondering why your question did no
Hi Again,
I have honed this question pretty well I think (MySQL 3.23.37):
I am using large-my.cnf as my my.cnf file. It is for servers with 512
MB of RAM from what I read. On our server that has 512MB of RAM I
notice in top the following:
10244 mysql 16 0 147M 147M 1684 S
earching
the 'Net' for more information, and I have not come up with a way to
make our machine more efficient. So, if anyone can suggest even the
most obvious of things to look at then I would be forever grateful.
James Riordon
SysAdmin (at least for now...)
--
Hi Again,
I have honed this question pretty well I think (MySQL 3.23.37):
I am using large-my.cnf as my my.cnf file. It is for servers with 512
MB of RAM from what I read. On our server that has 512MB of RAM I
notice in top the following:
10244 mysql 16 0 147M 147M 1684 S
At 9:07 -0500 02/07/2002, Ken Menzel was thought to have said :
>Many of the questions on this list are answered by people like
>myself who are users of MySQL. We are busy trying to run our own
>servers and put food on the table. That being said, you are
>wondering why your question did no
Hi,
I have a MySQL database that currently is used by about 8000 users.
I need to add an index to one of the fields in one of the tables to help
speed up a particular query being made to the MySQL database. I am a bit
nervous to do so in case I screw up. Mind you I have backed up the
At 15:07 +0800 03/28/2002, Sammy Lau was thought to have said :
>?http://www.mysql.com/doc/C/R/CREATE_INDEX.html
Granted, I should have looked before I spoke for the first question.
> > 2 - Do I have to do anything special like stop requests to the
>> server while I add the index.
>
demands and configurations. Does such a place exist.
Many thanks in advance for any help that anyone on the list can offer.
James Riordon
System Administrator
Amigo-3 Interactive Inc.
http://www.amigo-3.com/
-
Before
alot of the information being sent from MySQL to
PHP for processing is simply not getting used in the final output. If
this is the case then would that not show an in-efficient use of queries?
Many thanks in advance for any help.
James Riordon
System Administrator
Amigo-3 Interactive Inc.
http
At 22:35 -0800 01/21/2002, I whispered:
>On Mon, Jan 21, 2002 at 11:02:47PM -0500, James Riordon wrote:
> >
> >I have our new client up and running and have come upon another
>> question. When I get extended-status I get the following:
>>
>> | By
Hi,
I have two servers.
Server A:
Dual 1GHz processors
1GB of RAM
MySQL-Max 3.23.49a
PHP 4.2.1
Server B:
Single 1.7GHz processors
1.5GB of RAM
MySQL-Max 3.23.4
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[isamchk]
set-variable= key_buffer=128M
set-variable= sort_buffer=128M
set-variable= read_buffer=2M
set-variable= write_buffer=2M
[myisamchk]
set-variable= key_buffer=128M
set-variabl
ave come close to
exhausting all my possibilities through mysql at this point. Someone
suggested the Kernel, but I fear it is the lack of an extra processor.
J
>James Riordon wrote:
>>>Have you tried monitoring server B via 'top' or something and see what
>>>processes are tak
At 11:12 -0300 10/06/2002, I whispered:
>Maybe P4 1,7 mhz performs marginally better than a P3/1000Mhz, but ...
>
>My webserver have a P3/450Mhz with 384 MB Ram and a 10 Gb IDE drive :P I
>cant seem to get above 1.0 load average on the machine on normal use (I have
>average 10-30 people online si
4 (2.4.9-34)
I have also tried a machine with of similar build to Server B with a
freshly built kernel 2.4.18-10. Same results as Server B with the
2.4.9-34 kernel.
James
>
>James Riordon wrote:
>
>>Hi,
>>
>> I have two servers.
>>
>> Server A:
&g
At 15:53 +0100 10/06/2002, Andrew Braithwaite was thought to have said :
>Hi James,
>
>What kind of disks are in the old system and the new system (scsi or ide,
>any raid, what rpm do they have etc..?) I ask this because high cpu levels
>can be a symptom of a diskbound server...
>
>Try running
At 11:17 -0500 10/06/2002, I whispered:
> > -Original Message-
>> From: Robert H.R. Restad [mailto:[EMAIL PROTECTED]]
>> Sent: Sunday, October 06, 2002 9:04 AM
>> To: James Riordon; [EMAIL PROTECTED]
>> Subject: RES: Re: Server comparison running M
On Sunday, October 6, 2002, at 01:53 AM, James Riordon wrote:
>> Have you tried monitoring server B via 'top' or something and see what
>> processes are taking up CPU time and/or swapping.
>
>
> Hello,
>
> I have monitored top for a bit. It is definite
21 matches
Mail list logo
