art...@gmail.com]
> Sent: Tuesday, September 24, 2013 1:44 PM
> To: shawn green
> Cc: mysql mailing list
> Subject: Re: Problem with having
>
> On Tue, Sep 24, 2013 at 9:05 AM, shawn green
> wrote:
>
> > Hello Larry,
> >
> >
> > On 9/23/2013 6:22 PM,
; -Original Message-
> From: Larry Martell [mailto:larry.mart...@gmail.com]
> Sent: Tuesday, September 24, 2013 1:44 PM
> To: shawn green
> Cc: mysql mailing list
> Subject: Re: Problem with having
>
> On Tue, Sep 24, 2013 at 9:05 AM, shawn green
> wrote:
>
> &
On Tue, Sep 24, 2013 at 9:05 AM, shawn green wrote:
> Hello Larry,
>
>
> On 9/23/2013 6:22 PM, Larry Martell wrote:
>
>> On Mon, Sep 23, 2013 at 3:15 PM, shawn green **
>> wrote:
>>
>> Hi Larry,
>>>
>>>
>>> On 9/23/2013 3:58 PM, Larry Martell wrote:
>>>
>>> On Mon, Sep 23, 2013 at 1:51 PM, Sukhj
Hello Larry,
On 9/23/2013 6:22 PM, Larry Martell wrote:
On Mon, Sep 23, 2013 at 3:15 PM, shawn green wrote:
Hi Larry,
On 9/23/2013 3:58 PM, Larry Martell wrote:
On Mon, Sep 23, 2013 at 1:51 PM, Sukhjinder K. Narula
wrote:
Hi,
In your second query, you seem to have MIN(date_time), but
On Mon, Sep 23, 2013 at 2:17 PM, Sukhjinder K. Narula
wrote:
> Hi,
>
> I see that. So the query seems to be picking the first entry out of the
> after grouping by a field and displaying it. And it seems to make sense
> since Having clause seems incomplete. I believe we need to complete the
> condi
On Mon, Sep 23, 2013 at 3:15 PM, shawn green wrote:
> Hi Larry,
>
>
> On 9/23/2013 3:58 PM, Larry Martell wrote:
>
>> On Mon, Sep 23, 2013 at 1:51 PM, Sukhjinder K. Narula
>> wrote:
>>
>> Hi,
>>>
>>> In your second query, you seem to have MIN(date_time), but you are
>>> talking about maximum. So
select recipe_id,max(maxdatetime) from data_csmeta group by recipe_id
having recipe_id=19166;
On Mon, Sep 23, 2013 at 4:15 PM, shawn green wrote:
> Hi Larry,
>
>
> On 9/23/2013 3:58 PM, Larry Martell wrote:
>
>> On Mon, Sep 23, 2013 at 1:51 PM, Sukhjinder K. Narula
>> wrote:
>>
>> Hi,
>>>
>>> I
Hi Larry,
On 9/23/2013 3:58 PM, Larry Martell wrote:
On Mon, Sep 23, 2013 at 1:51 PM, Sukhjinder K. Narula
wrote:
Hi,
In your second query, you seem to have MIN(date_time), but you are
talking about maximum. So your group by query is actually pulling the
minimum date for this recipe.
I pas
On Mon, Sep 23, 2013 at 1:51 PM, Sukhjinder K. Narula
wrote:
> Hi,
>
> In your second query, you seem to have MIN(date_time), but you are
> talking about maximum. So your group by query is actually pulling the
> minimum date for this recipe.
>
I pasted the wrong query in. I get the same results r
Hi,
In your second query, you seem to have MIN(date_time), but you are talking
about maximum. So your group by query is actually pulling the minimum date
for this recipe.
Regards.
On Mon, Sep 23, 2013 at 3:35 PM, Larry Martell wrote:
> I want to find the rows from a table that have the max date
Am 15.03.2012 17:31, schrieb Malka Cymbalista:
> We are running MySQL version 5.0.45 on a Linux machine. Most of our tables
> are MyIASM but we have recently installed drupal 7 and drupal 7 requires
> INNODB tables. Every now and then when we restart MySQL using the commands
> /etc/init.d/mys
* Martin Mueller [12 13:42]:
<..>
> In short, in my installation there seems a gap between mysql and mysql, and
> I can't find any good explanations for what I might have done wrong or how I
> could fix it.
>
> I'll be grateful for any help.
I am probably not going to be very useful, but
在 2011-10-31一的 16:18 +0530，nataraj 0102写道：
> Hello,
>
>
>
> I am using MYSQL database with Linux server.
>
> I have a problem with one table, when I tried to get the data from that
> table, I am getting error : “mysql error 4600: mysql server gone away.
>
> No connection, trying to re-connect”
In the last episode (Dec 20), Johnny Withers said:
> On Mon, Dec 20, 2010 at 11:52 AM, muhammad subair wrote:
> > I have table post (id INT and parent VARCHAR)
> >
> > +--+-+
> > | id | parent |
> > +--+-+
> > |1 | 0 |
> > |2 | 0 |
The sub-select only returns a single row, so IN(...) is only looking at a
single value in the list .. it doesn't "expand" to into IN (5,7,11).
On Mon, Dec 20, 2010 at 11:52 AM, muhammad subair wrote:
> I have table post (id INT and parent VARCHAR)
>
> +--+-+
> | id | parent
Hi Baron
This tool works better than mytop, you solved my problem, thanks a lot
Carlos
> Date: Tue, 17 Aug 2010 10:41:23 -0400
> Subject: Re: Problem with mytop
> From: ba...@xaprb.com
> To: mysql@lists.mysql.com
>
> Carlos,
>
> Have you tried innotop instead? I
Carlos,
Have you tried innotop instead? It's a better replacement for mytop.
(I wrote it.)
- Baron
On Tue, Aug 17, 2010 at 8:50 AM, Carlos Eduardo Caldi
wrote:
>
>
> If sombody can help me I'll be gratefull
>
> I have a problem with mytop1.6 on Mandriva 2010.1, when I install it on a
> Slave
On 7/8/2010 10:59 AM, John Nichel wrote:
Hi,
I'm hoping what I'm trying to do can be done, but I can't seem to find
the right syntax. I have the following query:
SELECT
... snipped ...
if(
(
selec
> -Original Message-
> From: Peter Brawley [mailto:peter.braw...@earthlink.net]
> Sent: Thursday, July 08, 2010 12:27 PM
> To: mysql@lists.mysql.com
> Subject: Re: Problem with IF() inside of a select statement
>
> >Is there a way I
> >can do a IF((SELECT
Is there a way I
can do a IF((SELECT.), expr2, expr3) and have expr2 populate with
whatever is returned from the select statement?
Yes, select if( (select count(*) from mytable ) > 100, 1, 0) works fine.
The alias inside your last If(...), though, is not visible outside its
parentheses;
alba.albetti wrote:
I've just installed MySQL on Windows 2000.
I've opened the MS-DOS windows and I've written
>C:\Programs\MySQL\...\bin\mysqladmin -u root -p password mysql2010
After the enter the prompt says >Enter password: and I've given and I
get
mysqladmin: connect to server at 'local
what is mysql2010, it it host name or password.
If password, there cannot be space for a password, it its host, then dont
use if u connecting from the server.
regards
anandkl
On Fri, Apr 9, 2010 at 2:06 AM, Michael Dykman wrote:
> If you want to specify the password itself on the command line
If you want to specify the password itself on the command line use
'--password' (double hyphen). '-p' requests interactive password
prompt.
- michael
On Thu, Apr 8, 2010 at 4:31 PM, Carsten Pedersen wrote:
> don't have a space between '-p' and 'password', i.e. -ppassword
>
> / Carsten
>
> alb
don't have a space between '-p' and 'password', i.e. -ppassword
/ Carsten
alba.albetti skrev:
I've just installed MySQL on Windows 2000.
I've opened the MS-DOS windows and I've written
>C:\Programs\MySQL\...\bin\mysqladmin -u root -p password mysql2010
After the enter the prompt says >Enter pa
At 09:02 AM 4/8/2010, alba\.albetti wrote:
I've just installed MySQL on Windows 2000.
I've opened the MS-DOS windows and I've
written >C:\Programs\MySQL\...\bin\mysqladmin -u root -p password mysql2010
After the enter the prompt says >Enter password: and I've given
and I get
mysqladmin: con
On Monday 11 January 2010 12:33, Mihamina Rakotomandimby wrote:
> (Correction, seel below)
>
> > Jørn Dahl-Stamnes :
> > > > I have checked the local DNS and 'r2-d2' and
> > > > 'r2-d2.dahl-stamnes.net' resovl to the same IP-addresse.
> > > > What's wrong?
> > >
> > > Reverse resolution?
> >
> > I
(Correction, seel below)
> Jørn Dahl-Stamnes :
> > > I have checked the local DNS and 'r2-d2' and
> > > 'r2-d2.dahl-stamnes.net' resovl to the same IP-addresse.
> > > What's wrong?
> > Reverse resolution?
> I have checked that, and reverse DNS is OK - both resolve to
> 192.18.2.22
I read you sol
> Jørn Dahl-Stamnes :
> > > I have checked the local DNS and 'r2-d2' and
> > > 'r2-d2.dahl-stamnes.net' resovl to the same IP-addresse.
> > > What's wrong?
> > Reverse resolution?
> I have checked that, and reverse DNS is OK - both resolve to
> 192.18.2.22
I read you solved your problem, but by "
On Monday 11 January 2010 09:55, Ananda Kumar wrote:
> use mysql;
> select * from user;
>
> see if you able to see 'r2-d2' entry in this table.
>
> also you can try this
>
> grant all on . to 'root'@'%' idenfified by
> 'secret-password';
I just found the cause of the problem... /etc/nsswitch.conf
use mysql;
select * from user;
see if you able to see 'r2-d2' entry in this table.
also you can try this
grant all on . to 'root'@'%' idenfified by
'secret-password';
regards
anandkl
On Mon, Jan 11, 2010 at 1:40 PM, Jørn Dahl-Stamnes
wrote:
> On Monday 11 January 2010 08:53, Mihamina Rakotoma
On Monday 11 January 2010 08:53, Mihamina Rakotomandimby wrote:
> > Jørn Dahl-Stamnes :
> > I have checked the local DNS and 'r2-d2' and 'r2-d2.dahl-stamnes.net'
> > resovl to the same IP-addresse.
> > What's wrong?
>
> Reverse resolution?
I have checked that, and reverse DNS is OK - both resolve
> Jørn Dahl-Stamnes :
> I have checked the local DNS and 'r2-d2' and 'r2-d2.dahl-stamnes.net'
> resovl to the same IP-addresse.
> What's wrong?
Reverse resolution?
--
Architecte Informatique chez Blueline/Gulfsat:
Administration Systeme, Recherche & Developpement
+26
On Sunday 10 January 2010 12:34, sureshkumar...@gmail.com wrote:
> Hi,
> The grant stmt has to be as below.
> Grant all on databasename.tablename to usern...@iporhostname identified by
> 'password';
>
> Use as above
> Grant stmt doesn't require a flush stmt.
Woops... Seems like the * in my first
Hi,
The grant stmt has to be as below.
Grant all on databasename.tablename to usern...@iporhostname identified by
'password';
Use as above
Grant stmt doesn't require a flush stmt.
Suresh Kuna
MySQL DBA
--Original Message--
From: Jørn Dahl-Stamnes
To: mysql@lists.mysql.com
ReplyTo: sq.
Hi John,
You can turn of name resolution by adding skip-name-resolve to the [mysqld]
section of your my.cnf file.
Regards,
Gavin Towey
-Original Message-
From: John Oliver [mailto:joli...@john-oliver.net]
Sent: Wednesday, September 16, 2009 4:24 PM
To: mysql@lists.mysql.com
Subject: Pro
Did you deleted the data dir (inside Program Files) after uninstall ?? i
think that is was not empty and when the new install tries to set up
finds it and get messy (maybe because the 32 and 64 bit issue).
Carlos
On 7/13/2009 11:07 PM, Edward Diener wrote:
I had previously installed the 64-b
Marco, all,
Marco Bartz wrote:
> I accidentally sent it before finishing...
>
> I am looking for a way to do the following with a single query:
>> SELECT `ID`, `Name`, `Interface`,
>> (SELECT count(*) FROM CONCAT('listings_', `ID`) WHERE `Status`='Active') as
>> `activeListings`
>> FROM `sites`
Marco Bartz wrote:
I accidentally sent it before finishing...
I am looking for a way to do the following with a single query:
SELECT `ID`, `Name`, `Interface`,
(SELECT count(*) FROM CONCAT('listings_', `ID`) WHERE `Status`='Active') as
`activeListings`
FROM `sites`
I am querying the
I accidentally sent it before finishing...
I am looking for a way to do the following with a single query:
> SELECT `ID`, `Name`, `Interface`,
> (SELECT count(*) FROM CONCAT('listings_', `ID`) WHERE `Status`='Active') as
> `activeListings`
> FROM `sites`
>
I am querying the sites table and I want
OK, Now I have gotten something...
[ '~/.tdphp-vserver/includes/10_electronica_admin.inc' ]
# while ($DB_list=db_fetch_array($DB_result)) {
#$output .= "\n";
while ($DB_list=db_fetch_array($DB_result)) {
print_r ($DB_list);
}
echo "\n";
exit();
--
Hi Krishna,
I use the script mysql_multi to stop and the start several, or all,
instances.
At the end, to work with more ease,
I will create scripts to connect to each instance
and in the script force the variable prompt at the connection
seems easy
Thanks for all !!!
Il
Hi Stefano,
I believe that, different mysql configuration file for different mysql
instance is a better idea. In your case, if any thing goes wrong with my.cnf
Then, it is going to effect all mysql instance (either restart mysql server
or any other way). It has a lots of disadvantages.
You might
Hi Krishna,
the problem is that you use --default-file on the command line and in
this mode it's working fine,
I also tried,
but I have the configuration of the variable "default-file" in the
general my.cnf and I enter in MySQL
in this way:
mysql --socket=/tmp/mysql50_SIA_SVILUPPO.sock
W
Hi Stefano,
I have tested. It's working fine without any issue.
Open mysql configuration(.cnf) file referencing to 1st mysql instance. Add
the below entires and restart the mysql server.
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
pro
Hi Krishna,
thanks for the your answer !!!
I have three different my.cnf for my three instances but one general
my.cnf to manage all instances,
my general my.cnf is:
[mysqld_multi]
mysqld = /opt/local/mysql50/bin/mysqld_safe
mysqladmin = /opt/local/mysql50/bin/mysqladmin
user = root
pas
prajapat...@gmail.com ("Krishna Chandra Prajapati") writes:
> You are running three mysql instance on single server. You can have three
> my.cnf say my.cnf, my1.cnf, my2.cnf with different port and socket and other
> information in them. In this way you can set the prompt for different
> instance.
Thanks for the all answers !!!
It's ok,
even if I have three different my.cnf for my three instances,
my general my.cnf is:
[mysqld_multi]
mysqld = /opt/local/mysql50/bin/mysqld_safe
mysqladmin = /opt/local/mysql50/bin/mysqladmin
user = root
password = mysys2008srv
log = /MYSQL/MYSQL_LOG/My
Stefano Elmopi wrote:
If I put the variable prompt in the general my.cnf, the prompt is
changed but for all instances.
If I put in the variable prompt in the my.cnf associated with the instance
in the [mysql] section, the prompt does not change.
This is because the client reads from my.cnf b
Ciao Stefano,
how do you connect to the different instances?
if you use different operating system users or different mysql home
directories
just put in the home directory of each user a .my.cnf file (or my.cnf in the
mysql home)
with just the prompt setting in the [mysql] section.
NOTE: in the
Hi Stefano,
You are running three mysql instance on single server. You can have three
my.cnf say my.cnf, my1.cnf, my2.cnf with different port and socket and other
information in them. In this way you can set the prompt for different
instance.
On Mon, Dec 22, 2008 at 3:46 PM, Stefano Elmopi
wrote:
Learnt!
On Wed, Oct 15, 2008 at 5:28 PM, philip <[EMAIL PROTECTED]> wrote:
> > Date: Tue, 14 Oct 2008 16:55:11 +0300
> > From: Olexandr Melnyk <[EMAIL PROTECTED]>
> > To: [EMAIL PROTECTED], mysql@lists.mysql.com
> > Subject: Re: Problem with GROUP BY
> >
> Date: Tue, 14 Oct 2008 16:55:11 +0300
> From: Olexandr Melnyk <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED], mysql@lists.mysql.com
> Subject: Re: Problem with GROUP BY
>
> http://jan.kneschke.de/projects/mysql/groupwise-max
>
> 2008/10/14 Peter Brawley <
http://jan.kneschke.de/projects/mysql/groupwise-max
2008/10/14 Peter Brawley <[EMAIL PROTECTED]>
> Philip
>
> mysql> SELECT number, MAX(event), name FROM info GROUP BY number;
>>
>
> For discussion & examples see "Within-group aggregates" at
> http://www.artfulsoftware.com/queries.php.
>
> PB
>
Philip
mysql> SELECT number, MAX(event), name FROM info GROUP BY number;
For discussion & examples see "Within-group aggregates" at
http://www.artfulsoftware.com/queries.php.
PB
-
philip wrote:
I created a table with,
CREATE TABLE info (
number INTEGER UNSIGNED,
event INTEGE
On Jun 24, 2008, at 2:57 AM, Gwynne Raskind wrote:
I'm having the issue with CREATE TABLE described by Bug #30513 (http://bugs.mysql.com/bug.php?id=30513
). To summarize, a table which previously existed, and then is
dropped by DROP TABLE IF EXISTS, becomes randomly unable to be
recreated. He
On Jun 24, 2008, at 10:13 AM, Rolando Edwards wrote:
My first impression is to say: "Sounds like the InnoDB internal data
dictionary still has the table recorded somewhere." According to
Page 566 Paragraph 3 of "MySQL Administrator's Guide and Language
Reference" (ISBN 0-672-32870-4),
"Inn
My first impression is to say: "Sounds like the InnoDB internal data dictionary
still has the table recorded somewhere." According to Page 566 Paragraph 3 of
"MySQL Administrator's Guide and Language Reference" (ISBN 0-672-32870-4),
"InnoDB always needs the shared tablespace because it puts its
-infoshop.com
www.giiexpress.com
www.etudes-marche.com
>-Original Message-
>From: Tim McDaniel [mailto:[EMAIL PROTECTED]
>Sent: Monday, April 28, 2008 12:19 PM
>Cc: mysql@lists.mysql.com
>Subject: RE: Problem with character set and connection collation
>
>On Mon, 28 Apr 2008, Jerry
On Mon, 28 Apr 2008, Jerry Schwartz <[EMAIL PROTECTED]> wrote:
A week or so ago I explored this in depth because I was having the
same problems. (It was affecting an English file that had some
Windows (CP-1252) characters that didn't directly map to UTF-8. That
message is at http://lists.mysql.co
A week or so ago I explored this in depth because I was having the same
problems. (It was affecting an English file that had some Windows (CP-1252)
characters that didn't directly map to UTF-8. That message is at
http://lists.mysql.com/mysql/212392. I didn't mention it in my posting, but
latin1 is
Hi Sulo,
Open the file you are importing as it is probably that it contains
references of another character set in the table creation. If so replace
that character set for '' or 'utf8'.
I hope it helps,
Leandro
sulochan acharya wrote:
Hello all,
here is my problem:
I am trying to set my
create/query/insert/update or execute?
>
> M--
> - Original Message -
> From: "Tomas Hylander" <[EMAIL PROTECTED]>
> To: "Martin Gainty" <[EMAIL PROTECTED]>
> Cc:
> Sent: Monday, November 26, 2007 1:38 AM
> Subject: Re: Problem with
From: "Tomas Hylander" <[EMAIL PROTECTED]>
To: "Martin Gainty" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, November 26, 2007 1:38 AM
Subject: Re: Problem with a Procedure
> Hi!
> I must say I cant see how this would help me. I know the tabels isnt
> empty since
Hi!
I must say I cant see how this would help me. I know the tabels isnt
empty since when running in query browsern I get a result.
There must be something else thats wrong..
...but thanks anyway!
/Hylsan
On Nov 23, 2007 4:43 PM, Martin Gainty <[EMAIL PROTECTED]> wrote:
>
> Tomas-
>
> I would ef
Tomas-I would effect a quick iterative check on the table(s) to see if they are
empty e.g.
SELECT count(trans2.nettovikt) from trans2;
(If recordcount>0) then
SELECT SUM(trans2.nettovikt) FROM trans2 INNER JOIN artikel on
trans2.artikel=artikel.artikel
(If recordcount>0) then
SELECT SUM(trans
From: B. Keith Murphy [mailto:[EMAIL PROTECTED]
> show slave status after it stops copying should give you some type of
> error information about the failure. What does it show?
In addition to the error, what do the following fields show?
Slave_IO_Running
Slave_SQL_Running
Seconds_Behind_Mast
Ryan,
show slave status after it stops copying should give you some type of
error information about the failure. What does it show?
Keith
Ryan Klein wrote:
I am having an issue that I cannot determine the cause. We have a
master server that is actually a production server and a slave server
On Thu, 25 Oct 2007, [EMAIL PROTECTED] wrote:
Not sure that I get the whole picture.
We have been running replication since about 4.0 and we have been through
several upgrades and are now at 5.0.27.
The 'show slave status' always gives us an accurate reflection of where it is
at which is us
Hello,
I found the solution by my own:
set meta-flag on
set convert-meta off
set output-meta on
Regards,
Spiker
--
GMX FreeMail: 1 GB Postfach, 5 E-Mail-Adressen, 10 Free SMS.
Alle Infos und kostenlose Anmeldung: http://www.gmx.net/de/go/freemail
--
MySQL General Mailing List
For list archiv
qt4x11 wrote:
Hi-
I'm using the command 'mysqlimport -u usr -ppassh -h mysqlserver -P 3306 -v
db --local $workdir/$filename'to import a table into mysql from a file
$filename.
The data in $filename looks something like:
test test
where there is a blank space between the two 'test's to represen
From: Frank Bottone [mailto:[EMAIL PROTECTED]
Sent: Monday, October 08, 2007 3:49 PM
To: Baron Schwartz
Cc: mysql@lists.mysql.com
Subject: Re: Problem with repeated replication corruption - Could not
parse relay log event entry
Baron,
Thanks for the quick response. I do have the binlogs still
Baron,
Thanks for the quick response. I do have the binlogs still on the
master, so I should be able to do that - however I saw a post somewhere
(lost the link at this time) saying that resetting the slave will drop
any temporary tables which could cause issues. I'm not sure at this
point if
Frank,
Frank Bottone wrote:
I've been having trouble with my master/slave server - recently I was
having a few repeated issues where the mysql slave would stop due to
"invalid sql syntax", but the queries executed fine on the master. I
would have to manually dig through the logs and then find
: 860.674.8341
www.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com
> -Original Message-
> From: John Trammell [mailto:[EMAIL PROTECTED]
> Sent: Monday, September 24, 2007 10:30 AM
> To: Critters; MySQL General
> Subject: RE: Problem with characters
>
> > From:
> From: Critters [mailto:[EMAIL PROTECTED]
> Sent: Monday, September 24, 2007 5:24 AM
> To: MySQL General
> Subject: Problem with characters
>
> I have a new setup with mySql version 4.1 and myODBC version 3.51
> running on Windows 2k3 standard
>
> In the database we have something like "And this i
I've found the following resources to be very helpful when dealing with
character set issues:
http://www.cs.tut.fi/~jkorpela/chars.html
http://www.joelonsoftware.com/articles/Unicode.html
HTH, HAND
JT
> -Original Message-
> From: Critters [mailto:[EMAIL PROTECTED]
> Sent: Monday, Septem
I'm noticing, that the problem lies with my server getting blocked,
because of too many bad tries.
Could that be, that after some time, this is not shown as an error
anymore, and the client just waits there forever?
It seems that I'm only getting blocked when the load is high on the
server. I'
Naz,
That query logic runs without a error on the server I have to hand
(5.0.37), but it has three issues:
(i) unless there is an exceptionless 1:1 relationship between
group_post_mod_option.option_id and group_post_mod_option.option_name,
results for the latter column will be meaningless be
Hello,
"I don't know how indexes work" is something I hear often. I will try
to answer in the form of a blog post when I have some time. It is too
complex to really answer in a short form, but basically an index is a
b-tree (look at wikipedia for a good explanation) built on top of the
tabl
Hi,
I've done some indexes in my tables and I solved my problem.
But I still confused with indexes. I created one multiple index with the
main 4 columns for mensagenspara's table. But it doesn't work. So, I created
one index with 3 columns and one for each column, wich give me 4 indexes,
and later
--
> From: Hugo Ferreira da Silva [mailto:[EMAIL PROTECTED]
> Sent: 15 August 2007 13:35
> To: mysql@lists.mysql.com
> Subject: Re: Problem with a complex query
>
>
> I found something weird.
> This is my query now
> --
> (SELECT
> m.codmensagem
: mysql@lists.mysql.com
Subject: Re: Problem with a complex query
I found something weird.
This is my query now
--
(SELECT
m.codmensagem,
m.codprioridade,
m.codusuario,
m.codmensagemoriginal,
m.codmensagempai,
m.assunto,
m.dataenvio,
m.horaenvio,
m.datalimite,
m.horalimite
I found something weird.
This is my query now
--
(SELECT
m.codmensagem,
m.codprioridade,
m.codusuario,
m.codmensagemoriginal,
m.codmensagempai,
m.assunto,
m.dataenvio,
m.horaenvio,
m.datalimite,
m.horalimite,
m.anexo,
m.tipo,
u.nome,
up.nome as nomepara,
mp.codrespondida,
mp
r you.
-Original Message-
From: Hugo Ferreira da Silva [ mailto:[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]> ]
Sent: 14 August 2007 19:19
To: mysql@lists.mysql.com
Subject: Re: Problem with a complex query
I've created an index with the statement
create index `usuario_pasta_situaca
> > MySQL doesn't seem to be very smart about queries involving OR and
> > things like <>. For me creating temporary tables or writing perl
> > scripts to do the job solved my particular problems. But I am working
> > with tables that don't change but have some 100,000,000 rows...
> >
> > I guess I
From explain you can see that your problem lies within the mensagens
table (the first entry from your explain query) where it says type:
ALL and rows 68337. This basically means that it is not using any
index for this table.
MySQL doesn't seem to be very smart about queries involving OR and
I've created an index with the statement
create index `usuario_pasta_situacao` on `mensagens` (codusuario, codpasta,
situacao);
And for mensagenspara table this index
create index `mensagem_usuario_pasta_situacao_idx` on `mensagenspara`
(codmensagem, codusuario, codpasta, situacao);
This is quer
what does explain tell you about the query?
I also think you should try a combined index with all three columns
that are used in one index. As far as I know only one index can be
used per query...
B
On Aug 14, 2007, at 1:26 PM, Hugo Ferreira da Silva wrote:
hum... I get it.
But in my que
hum... I get it.
But in my query, I look in 3 tables
FROM
mensagens m,
mensagenspara mp,
usuarios u,
usuarios up
WHERE
m.codmensagem = mp.codmensagem
AND u.codusaurio = m.codusuario
AND up.codusuario = mp.codusuario
m.codmensagem, u.codusaurio and up.codusuario are primary keys
mp.codusuario,
First of all, thanks for your attention guys,
Rhys, I've tried UNION and UNION ALL statements too, but I found some
problems when ordering the results. I've tried order in each query and at
end - (SELECT ...) UNION (SELECT ...) ORDER BY ... -, and result was poorly
than this query.
Martin, that i
Struggling with the Portuguese here but...
What kind of indexes do you have in place? Are the y appropriate?
I have had some success with removed or clauses from queries, creating a new
query and join them with a UNION ALL.
-Original Message-
From: Hugo Ferreira da Silva [mailto:[EMAIL
Maybe, it has to do with the TIMESTAMP behavior: whenever you insert a
TIMESTAMP value MySQL converts it to UTC and converts it back to local time (or
the time you entered).
To prevent this behavior you can
- change TIMESTAMP into DATETIME or
- "disable" it by adding this setting to the MY.INI
Hi Alessandro, all !
Baron Schwartz wrote:
Hello Allesandro,
Alessandro Agostini wrote:
[[...]]
Watching the table content, I see second record as:
032100, '2005-03-27 03:00:00', 0, '40.00', '0.000', '0.000', 0,
'0.00'
MySql change the time information of DATAORA field from "02:00:00"
Hello Allesandro,
Alessandro Agostini wrote:
Hi to all,
I have a strange error on using of timestamp data type.
See the follow table definition and insert command.
DROP TABLE IF EXISTS Storicocorrenti;
CREATE TABLE Storicocorrenti (
ID_LINEA mediumint(6) unsigned zerofill NOT NULL default '000
t with " indexes for the query"?
3) Im goint to try that.
4) Good Idea.
Thanks.
- Mensaje Original -
De: "Juan Eduardo Moreno" <[EMAIL PROTECTED]>
Para: "Patricio A. Bruna" <[EMAIL PROTECTED]>
Cc: mysql@lists.mysql.com
Enviados: martes 22 de mayo de
PROTECTED]>
Cc: mysql@lists.mysql.com
Enviados: martes 22 de mayo de 2007 13H31 (GMT-0400) America/Santiago
Asunto: Re: Problem with compex query
Hi Patricio,
Your explain is scary.No use of index...Please, ask to programers in order
to create some index in the schema.
Develo
Hi Patricio,
Your explain is scary.No use of index...Please, ask to programers in
order to create some index in the schema.
Development Server has the same version of MySQL production environment?.
4.0.18?
Resume:
1) Please check the version of mysql ( prod and development)
2) Please use i
Juan Eduardo,
Great to hear about you :)
One thing you must know is that i can run this query from a mysql client,
without the insert part.
The problem only happens when is run from the J2EE (Websphere - drp)
application.
I run the query as you asked, here are some results:
++-
Hi Patricio,
Some options are to prevent programmers/users make a "bad" queries into
the database' SQL_BIG_SELECTS = 0 | 1
The documentation say :
"If set to 0, MySQL will abort if a SELECT is attempted that probably will
take a very long time. This is useful when an inadvisable WHERE statemen
On my servers i'm using the 'user'@'localhost' for PHP apps.
running on the local web-server. Those users allocated for
web-apps can only connect to their specific DB from localhost.
On Tue, May 22, 2007 03:19, Miguel Cardenas wrote:
>> Localhost is indeed a special value that isn't include in '%'
1 - 100 of 939 matches
Mail list logo
