Hi Friends,
I am facing problem while using MySQL in multi-threaded environment. I am
using C lang for developement.
I maintain MySQL connection pool between threads but with increase in number
of requests, it started reporting
following errors -
==
Server Errors
Sounds like your not using threaded libraries. Was mysql built
differently, or are you using a different RPM on this server?
Scott
On Tue, 2007-05-29 at 22:49 +0200, Quentin Gouedard wrote:
> No, I have just collectd+mrtg, but i don't even use them to monitor mysql.
> I launch mysql via /etc/i
No, I have just collectd+mrtg, but i don't even use them to monitor mysql.
I launch mysql via /etc/init.d/mysql start , and the script is the exact
same as on the other servers. Even just after startup there's already 15-20
processes created.
On 5/29/07, Geoffroy Cogniaux <[EMAIL PROTECTED]> wrot
Hello,
I have a long running query that generates a MySqlException due to the
query timing out. It takes about 55 seconds to run on our production
server. The MySqlException is NOT being trapped in my try/catch block.
Here is the error:
MySql.Data.MySqlClient.MySqlException was unhandled
M
Hi Ricardo,
Ricardo Conrado Serafim wrote:
Hi Group!
I've a doubt about indexes and I hope that you can help me.
If I've a table index with 5 columns (col_1,col_2,col_3,col_4,col_5) and
I do a query where the clause "where" use just col_1, col_2, col_4 and
col_5.
This query will use the in
Hi Bernd,
Bernd Jagla wrote:
Hi,
I have a problem with a very slow query that should be VERY fast.
> select * from tfbs_ecr t
[snip]
where ecr_id in
(301,302,316,323,345,346,351,362,363,364,380,411,413,451,464,466,470,471,481
,498,506,507,538,541,543);
=> returns 1167 rows within a few mil
Hi Group!
I've a doubt about indexes and I hope that you can help me.
If I've a table index with 5 columns (col_1,col_2,col_3,col_4,col_5) and
I do a query where the clause "where" use just col_1, col_2, col_4 and
col_5.
This query will use the index at least with the col_1 and col_2??
--
R
Hi,
I have a problem with a very slow query that should be VERY fast.
There are two tables:
CREATE TABLE `tfbs_mm`.`tfbs_ecr` (
`tfbs_id` int(10) unsigned NOT NULL,
`ecr_id` int(10) unsigned NOT NULL,
KEY `tfbs_id` (`tfbs_id`),
KEY `ecr_id` (`ecr_id`)
) ENGINE=MyISAM DEFAULT
Hi,
It looks like automatic start-up called by a monitoring process (Nagios,
...). Have you such tools on your servers ?
Geoffroy
-Message d'origine-
De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de Quentin
Gouedard
Envoyé : mardi 29 mai 2007 16:41
À : mysql@lists.mysql.c
Ok... just making sure. Spambots search mailing-lists often, I suppose?
signature.asc
Description: Digital signature
Yes. :)
And the one before it.
On May 29, 2007, at 2:14 PM, Glen Barber wrote:
Um... Did everyone get this message?
Quoting:
Dear Sirs,
We contacted you last week, because we would like to exchange
links with you.
We understand that there is often not enough time in the day for
everyth
Um... Did everyone get this message?
Quoting:
> Dear Sirs,
>
> We contacted you last week, because we would like to exchange links with you.
>
> We understand that there is often not enough time in the day for everything,
> but, I am sure you appreciate that getting targeted links to your webs
Ah ok I rechecked the documentation for BETWEEN which includes additional
information not mentioned on the type conversion page:
For best results when using BETWEEN with date or time values, you should use
CAST() to explicitly convert the values to the desired data type. Examples:
If you compare
Thanks for the replies all (and for the blog link - one to add to my feeds I
think).
Yes I spotted that adding the leading zero to the month yields the correct
result here, but I think I know why.
If you imagine BETWEEN using a string comparison here then the results for
with and without leading
Everything seems to go fine for me if I change the two 2007-3-23
to 2007-03-23.
Fred
-Original Message-
From: Rob Desbois [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 29, 2007 5:02 AM
To: mysql@lists.mysql.com
Subject: datetime type conversion problem
I am having issues with type conve
block subqueries? I do not think that one is possible in mysql (or any
other db IMO).
Also - I wonder why would you want to block subqueries but allow
normal queries - surely most (if not all) subqueries can be rewritten
using JOINs right.
Anoop
On 5/29/07, Ricardo Conrado Serafim <[EMAIL PROTE
Hi,
So I use mysql as the DB for a large site (up to 1 concurrent users at
peaks).
I have a front server as a reverse proxy and multiple (7) backend machines
serving the site.
Each machine has data strictly similar in nature and quantity.
On 6 of these machines, I have 1 single mysqld process
Thanks!!
It helps me a lot!! But now, I just need to know how I do to block
subqueries (if it's possible...)
Anoop kumar V escreveu:
http://dev.mysql.com/doc/refman/5.0/en/revoke.html
You can use:
REVOKE ALTER ROUTINE, CREATE ROUTINE, EXECUTE ON * TO USER;
Anoop
On 5/28/07, Rica
Hi Rob,
Rob Desbois wrote:
I am having issues with type conversion not working as expected per the
documentation.
I am using in MySQL 5.0.27 for x86/Windows.
The documentation at
http://dev.mysql.com/doc/refman/5.0/en/type-conversion.html states that for
comparison operators "If one of the argu
I'm not sure specifically why it's acting the way it is, but it looks
like it's converting your date strings slightly differently depending on
how you use them.
If you properly pad the month out in the two strings it seems to work.
SELECT '2007-05-24 00:00:00' BETWEEN ('2007-03-23' - INTERVAL
Why are you saving it as a LONGBLOB and not as TEXT data type?
[EMAIL PROTECTED] wrote:
> Hi,
>
> I am using tinymce to save news articles with very basic html styling in a
> database. This works well upto a point but when I get over a certain number
> of characters and then the 'you have an er
Hi,
[EMAIL PROTECTED] wrote:
Hi,
I am using tinymce to save news articles with very basic html styling in a
database. This works well upto a point but when I get over a certain number of
characters and then the 'you have an error in your SQL syntax' error. I am
saving in as a LONGBLOB so it
I am having issues with type conversion not working as expected per the
documentation.
I am using in MySQL 5.0.27 for x86/Windows.
The documentation at
http://dev.mysql.com/doc/refman/5.0/en/type-conversion.html states that for
comparison operators "If one of the arguments is a TIMESTAMP or
DATET
Hi,
I am using tinymce to save news articles with very basic html styling in a
database. This works well upto a point but when I get over a certain number of
characters and then the 'you have an error in your SQL syntax' error. I am
saving in as a LONGBLOB so it should not be a data type misma
I'll defer to you.
At 01:00 PM 5/28/2007, Baron Schwartz wrote:
>Dave Dyer wrote:
>>Thanks, it turns out you are exactly right. I rewrote
>>the query to keep the "on" immediately following the "left join"
>>and it now works as I wish.
>>I'll have to read up on "cross join", but if there
>>is a m
25 matches
Mail list logo
