Michaël de Groot wrote:
Hi guys,
I have a question about index usage in MySQL.
I have a query:
MYSQL: ([EMAIL PROTECTED]) [webstats]> EXPLAIN SELECT sum(users) as
totaal_uniek,
page_id FROM webstats.stats_hour where page_id LIKE 'vipPage_%' and site =
'spelpuntVip' and date > 11663530
In the last episode (Jan 18), Miles Thompson said:
> The query displayed below performs flawlessly, except for these two records:
>
> 7364 M0174000250510 Invoice 2006-12-13 2006-12-13
> 2006-12-31
> 7365 M01740 002506 5 Invoice 2006-12-13
I optimized every table after I first imported the data. The tables
were probably in use, off and on for testing, for about a week after the
optimize table was ran on every table before I noticed this problem.
I'm not saying the problem didn't exist within that week, I'm just
saying I didn't notic
Please post to the list not to me personnally.
Original Message
Subject: RE: [PART 2/2] InnoDB - Different EXPLAINs for same query From:
"John Anderson" <[EMAIL PROTECTED]>
Date:Thu, January 18, 2007 10:24
To: "William R. Mussatt
If you have that short a script to test wit, try it from the command line.
Your HTML might be obscuring the error messages.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> From: Kay
I got it working perfectly on a Linux server, but my boss wants this
on a Windows IIS server.
The remote connection seems to be working now but I have another
problem now... the page is not doing anything - doesn't seem to be
connecting to the database, but I got no error messages
whatsoeve
The query displayed below performs flawlessly, except for these two records:
7364M0174000250510 Invoice 2006-12-13
2006-12-13 2006-12-31
7365M01740 002506 5 Invoice 2006-12-13 2006-12-13
2006-12-31
Here's the table structure
Just to toss something else in here. A lot of times you have a server
that you can connect to by ssh, but because of firewalls, can't access
mysql through. If you can, however, connect to the database through
ssh, you can do port forwarding. In *nix systems it should be something
like this:
Hi All,
This is a dump and simple question but I can't seem to get it to work.
How do I enable a user to be able to connect from a remost host using
MySQL Administrator? I added "%" but once signed in, I still can't
access the user panel in the administrator.
Thanks.
Kay
I don't know if I can
Hi All,
This is a dump and simple question but I can't seem to get it to
work. How do I enable a user to be able to connect from a remost
host using MySQL Administrator? I added "%" but once signed in, I
still can't access the user panel in the administrator.
Thanks.
Kay
--
MySQL Genera
2007/1/18, Nuno Oliveira <[EMAIL PROTECTED]>:
Hi, thanks for the reply (you should reply to the list also)
Heh, that was the default Gmail behaviour.
Do you mean that I should replace SELECT * FROM with SELECT field1,
[field2],[...] FROM?
It is generally a good pratice to keep away from
Dear List,
As recently as last Sunday January 14, 2007, we have enabled
replication between two servers in our organization.
The master server runs MySQL 4.1.10a, the slave runs 5.0.18.
Since then, we have had a number of interruptions in replication when
the slave server stopped replicating f
From Chris,
Do you mean that I should replace SELECT * FROM with SELECT field1,
[field2],[...] FROM?
Yes.
If so, I need to specify the table name like SELECT Clients.Name
correct?
You only need to do that when 2 tables have the same column name. In
general, though, it's good practice to al
> Do you mean that I should replace SELECT * FROM
> with SELECT field1, [field2],[...] FROM?
Yes.
> If so, I need to specify the table name like SELECT
> Clients.Name correct?
You only need to do that when 2 tables have the same column name. In
general, though, it's good practice to always in
Olexandr Melnyk wrote:
I din't know about listiтg multiple tables in the JOIN clause up to now,
but anyways it looks like QuoteId from the Products table is overriding
the same field from the Quotes table. Try to replace the asterisk with
an explicit list of fields you want to get.
Hi, th
From Davor:
Try this:
SELECT * FROM `Quotes` LEFT OUTER JOIN `Products`
ON (`Products`.`QuoteID`=`Quotes`.`QuoteID`)
LEFT OUTER JOIN `Clientes` ON
(`Clientes`.`ClientID`=`Quotes`.`ClientID`)
WHERE `Quotes`.`QuoteID`=6936
Dundo
Still the same... :(
When a QuoteID from Quotes is not available
I would like to do a SELECT that would return all the fields in the
'Quotes' table plus the client info and plus the product info but
only if available. If product info is not available I would like to
get a result having all 'Quotes' info and 'Clients' info.
My query is:
SELECT * FROM `Quote
Hi All,
I'm working on a Intranet database with a few tables to allow all
the workers from the company to access it.
However, I'm facing a problem with a QUERY. I've did try to use
JOIN but I'm not able to get the results I need...
I have 3 tables (concerning this problem):
Table 'Quotes'
Qu
Jason,
I assume that your principal databases are INNODB databases.
Regards
On 1/17/07, Jason J. W. Williams <[EMAIL PROTECTED]> wrote:
Hi Juan,
Just wanted to touchbase and see if you had any suggestions based on
the my.cnf and machine config. Thank you in advance.
Best Regards,
Jason
Hi guys,
I have a question about index usage in MySQL.
I have a query:
MYSQL: ([EMAIL PROTECTED]) [webstats]> EXPLAIN SELECT sum(users) as
totaal_uniek,
page_id FROM webstats.stats_hour where page_id LIKE 'vipPage_%' and site =
'spelpuntVip' and date > 1166353093 group by page_id ORDER BY
Hi Shain,
Shain Lee wrote:
Now , i have to think about any perfect load balancing method , i can't
duplicate the databse in another machine. It's directly conflict with serving
contents for each request.
Why not use replication? If you don't want to do it on application level
(seperate rea
Thanx for the information , but i wanted to go for a long term plan and for a
fixed solution. bcause little by little that load getting high.
please need some mysql expertise help.
Thank you,
Shaine.
Ady Wicaksono <[EMAIL PROTECTED]> wrote: Hi Lee
better you start to benchmark your system usin
22 matches
Mail list logo
