Right thanks for all the tips the 3 column index has done the job,
queries coming back in 0.7 secconds now which is just the job before
they get cached.
Don't know how I missed that one as it was abovious...i even tried
countyid and old...forgot about price..
John
--
MySQL General Mailing List
On Thu, 2004-11-11 at 15:51, mos wrote:
> John,
> Create a second table (MyISAM) but this time don't use compression
> on the table.
>
> create table newtable select * from oldtable;
>
Right will run that just now, good idea...just have to avoid the wife as
no doubt it will bog the sit
On Thu, 2004-11-11 at 15:45, Jigal van Hemert wrote:
> `price` is still in the ORDER BY, so removing it only from the WHERE clause
> will not help really.
No the query I ran didn't have an order by clause (sorry if the one I
pasted did..)
> - create an INDEX on the columns in the WHERE clause _an
On Thu, 2004-11-11 at 14:37, Andy Eastham wrote:
> Have you got a single multi-column index on countyid, price and old, or do
> you have individual indexes on each of these fields? The former would be
> much better.
Its a single column on countyid, when I ran a select and just used
countyid = in
mentioned in news_x_cat or not and if they don't have any data with in
news_x_cat I need this bit padded out with NULLs.
Any ideas where I am going wrong?
Cheers
John Wards
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysq
g way of doing it. I had a search on the mysql.com site but can't
find anything.
Any ideas?
Cheers
John Wards
SportNetwork.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
t; PHP Web Development.
Need to see you code before I could comment one way or the other.
Also this sounds like a PHP problem more than a MySQL one
Cheers
John Wards
SportNetwork.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
n query caching, that what I would recomend.
Cheers
John Wards
SportNetwork.net
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
Hmmm I would say other than upgrading your hardware try upgrading to mySQL 4.
and turn on query caching.
The difference it has made to our server is unbelivable!
We have found no problems with it so far.
John
-
Before posting,
ng an extra 1Gb of ram, before we take the chance and purchase the
> expensive PC800-RIMMS.
If you could provide me with your MySQL version and your OS I can advise a bit
more.
We had major problems with slow mysql up until a few days ago which we have
now solved, depending on your set
ing on.
I would say try installing linuxthreads then recompile your current version of
mySQL to have linuxthread support. If that doesn't work try upgrading to 4.
HTH
Cheers
John Wards
SportNetwork.net
-
Before posting, p
is
running about 20-30% on the same box. I achevied this by adding proper
indexes and also using sessions and cookies to store constantly used data.
> Upgrading from 3.23.43 (current version) to 4.x version will help?, any
> advice will help.
Query caching may help
Cheers
John Ward
On Thursday 20 Feb 2003 3:07 pm, Andrew wrote:
> Is there an equivalent lsit as this that also deals with PHP.
www.php.net have a look through their mailing lists. the General one is good
for tech questions.
> As a matter of interest can I have a show of hands for all those using PHP
> with MySQ
'story.longheadline' that
correlates with the "MAX(story.stid)"
Any clues? I'm lost
Cheers
John Wards
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://list
Yup I used repair table as well.
Also I have resarted mysql and that made no difference
John
- Original Message -
From: "Karthik" <[EMAIL PROTECTED]>
To: "John Wards" <[EMAIL PROTECTED]>
Sent: Thursday, September 05, 2002 11:11 AM
Subject: Re: Weird err
d.
I have tried explain, check and analyse and everything seems normal.
Any clues?
Cheers
John Wards
SportNetwork.net
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.co
wow...do you think this is real.we could all be rich!...:-P
- Original Message -
From: "James Kadeh" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 28, 2002 3:34 PM
Subject: JAMES KADEH mysql !
> mysql ,
>
> My dear,
>
> Good day, I wish to introduce
Is their anyway of finding out what queries are causing tmp tables to write
to disk?
Cheers
John Wards
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 21, 2002 3:40 PM
Subject: Re: Re: temp tables
> J
Ta,
But is it normal to have Temp table bigger than 10meg? And a lot of them?
Here is my latest data from STATUS
Created_tmp_disk_tables 46598
Created_tmp_tables 87839
Uptime 81773
And I have set tmp_table_cache to 10M
I know I could just up the tmp_table_size but I am more concerned about the
Hi,
MySQL is creating about 50% of temp tables on disk and this is with 10Meg of
temp table cache. Is this normal? and sould I up temp table cache further.
Below is the output from SHOW STATUS
Cheers
John Wards
SportNetwork.net
Var Name Value
Aborted_clients 19559
I am having problems with mysql loggin slow queries. I have set up mysql.sh
like this
log_dir=/home/admin/slow_slog.log
$bindir/safe_mysqld --datadir=$datadir --pid-file=$pid_file --log-slow-queri
es=$log_dir &
That is all I have changed and re started mysql. but no slow_slog.log file
has been
I have read somewhere that persistent connections in MySQL have a default
timeout of 8 hours. How would I reduce this?
Cheers
John Wards
SportNetwork.net
-
Before posting, please check:
http://www.mysql.com/manual.php
ile or the phorum message
board system.
Thanks in advance
John Wards
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thre
also some of the queries are copying to a tmp table and i know this aint
good! but I can't see the full query in show processlist how do you do this.
Cheers
John
- Original Message -
From: "John Wards" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesd
start!
Cheers
John Wards
SportNetwork.net
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTEC
s for any Help
John Wards
SportNetwork.net
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL P
26 matches
Mail list logo
