it should not cause any issues, unless your passing too many values in id
in(1,2,...n).
Are the indexes present.
On 11/10/08, Alex K [EMAIL PROTECTED] wrote:
Hello,
It seems to me that the statement id in (id1, id2 ... idn) is much
slower than id=id1 or id=id2 ... or id=idn or I am doing
Hi Ananda,
Indexes are present. I'm passing no more 10 values.
Alex
2008/11/10 Ananda Kumar [EMAIL PROTECTED]:
it should not cause any issues, unless your passing too many values in id
in(1,2,...n).
Are the indexes present.
On 11/10/08, Alex K [EMAIL PROTECTED] wrote:
Hello,
It seems
can u please show me the explain plan for this sql and also the table
structure
explain select statement
desc table_name
On 11/10/08, Alex K [EMAIL PROTECTED] wrote:
Hi Ananda,
Indexes are present. I'm passing no more 10 values.
Alex
2008/11/10 Ananda Kumar [EMAIL PROTECTED]:
it
Hi All,
On friday we released the second Beta version of PBXT. PBXT is a
transactional storage engine for MySQL 5.1 and 6.0. You can find out
more about the engine at http://www.primebase.org.
PBXT is pluggable, so it can be built separately from the MySQL tree,
and loaded dynamically at
Hello,
It seems to me that the statement id in (id1, id2 ... idn) is much
slower than id=id1 or id=id2 ... or id=idn or I am doing something
wrong?
Thank you,
Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Here we go:
http://pastebin.com/m2439985d
replace $company_ids by list of ids from 'companies'
replace $neg_company_ids by -1 * $company_ids
replace $location_ids by list of location ids from 'locations'
replace $all_company_ids by list of ids from 'all_companies'
The reason why I'm doing
Hi.
One client from my shared hosting periodically informs me about an
error:
DBI connect('database,...)
failed: Can't create a new thread (errno 12); if you are not out of
available memory, you can consult the manual for a possible OS-dependent
bug at ...
There's nothing suspicious in the
I've been having the same trouble in a Xen virtual machine. After about
an hour and a half, mysql will be consuming 100% of cpu. There is
nothing wrong with the tables. I'm assuming its a dynamic vs. fix
amount of memory available to mysql. I'm guaranteed x amount of ram,
but that might
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
This mailing list has a stupid configuration. Pressing the answer
button, the message goes to the sender not to the list :-(
- Original-Nachricht
Betreff: Re: Is it a bug or my mistake in server configuration?
Datum: Mon, 10 Nov
I am really really new to sql,please forgive my
ignorence.
here is my problem
I have this table named mis_outtrack
desc mis_outtrack;
+-+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
This Thursday (November 13, 2008), Martin MC Brown will give an
overview of MySQL on openSolaris. MC is an expert on MySQL and Solaris,
and has helped the openSolaris team to port MySQL to that platform. The
session will start at 14:00 UTC/BST (15:00 CET).
MySQL University is an educational
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Curtis Maurand schrieb:
I've been having the same trouble in a Xen virtual machine. After about
an hour and a half, mysql will be consuming 100% of cpu. There is
nothing wrong with the tables. I'm assuming its a dynamic vs. fix
amount of
This mailing list has a stupid configuration. Pressing the answer
button, the message goes to the sender not to the list :-(
Hint - use Reply to All - it's not specific to this mailing list. :-)
Regards,
Andy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Helllo Supratim,
does each pub_code appear maximum three times in the table?
2008/11/10, Supratim Bandyopadhyaya [EMAIL PROTECTED]:
I am really really new to sql,please forgive my
ignorence.
here is my problem
I have this table named mis_outtrack
desc mis_outtrack;
Hit 'Reply to All' instead of reply.
On Mon, 2008-11-10 at 18:39 +0100, Uwe Kiewel wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
This mailing list has a stupid configuration. Pressing the answer
button, the message goes to the sender not to the list :-(
-
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Andy Shellam schrieb:
This mailing list has a stupid configuration. Pressing the answer
button, the message goes to the sender not to the list :-(
Hint - use Reply to All - it's not specific to this mailing list. :-)
It dosn't make sense
Hi All,
I have used MySQL 5.1.29 and I would like to ask a question related to InnoDB
and row_format=COMPACT and OPTIMIZE
Why when trying to run OPTMIZE on InnoDB table with row_format=compact
it displays Table does not support optimize, doing recreate + analyze instead
?
Make sure the script or application querying the database is closing
connections when it has finished with them. Theres an awful lot of badly
coded scripts out there, especially php scripts, which keep the
connections to the server open and eating away at server resources long
after they could
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
John Daisley schrieb:
Hit 'Reply to All' instead of reply.
Is is okay for you the have your answers twice? If I post to a list, I
read that list. So there is no need to have the ansers at the list and
in my inbox
Uwe
-BEGIN PGP SIGNATURE-
On Mon, Nov 10, 2008 at 06:36:34PM +0100, Uwe Kiewel wrote:
Alexey Vlasov schrieb:
open files (-n) 1024
just a shot to the blue:
can you count your open files with lsof?
# lsof -u mysql | wc -l
1719
I doubt that the problem is in that otherwise every second user
Ok, I'm a little new a this, so be gentle!! :)
I was looking into the InnoDB engine for some tables I have, and would like
to use the PK/FK on some of the data.
It appears that the PK/FK is mainly used for updating/deleting data,
correct? I can't use it to retreive data from multiple tables
Hello Steve,
Ok, I'm a little new a this, so be gentle!! :)
I was looking into the InnoDB engine for some tables I have, and would
like
to use the PK/FK on some of the data.
It appears that the PK/FK is mainly used for updating/deleting data,
correct? I can't use it to retreive data from
22 matches
Mail list logo