Joris Kinable schrieb:
Optimize query
I've got one query, which I would like to improve a lot since it takes
very long (>24 hours) to execute. Here is the idea:
1. Take the table (other rows in this
table are not mentioned for clearity) and remove all duplicate
tuple's. This is done by subquery
Mark Kozikowski a écrit :
Hello all,
I have been using MySQL for about 5 years now in a company project.
I store a lot of data, very rapidly into the database.
Presently, I am having a problem where the MySQL server appears to
be denying a connection when I reach a database size of about
10
HI Mark,
What is the error your seeing the error log file, can u please let us know.
regards
anandkl
On Jan 21, 2008 2:27 PM, Mark Kozikowski <[EMAIL PROTECTED]> wrote:
>
>
> Hello all,
>
> I have been using MySQL for about 5 years now in a company project.
>
> I store a lot of data, very rapidl
On Tue, 2008-01-22 at 11:23 +1100, Chris wrote:
> > Why is it saying 'Impossible WHERE noticed after reading const tables'?
>
> http://dev.mysql.com/doc/refman/4.1/en/explain.html
> MySQL has read all const (and system) tables and notice that the WHERE
> clause is always false.
>
> ie - no rows
Daniel Kasak wrote:
Greetings.
I have a script which seems to be bringing our server to its knees.
I've isolated one query which is doing it:
delete from TelecomAccountPosting where LocID = 19014 and InvDate =
'20080115';
I have an index which covers both LocID and InvDate:
CREATE TABLE `Tel
Greetings.
I have a script which seems to be bringing our server to its knees.
I've isolated one query which is doing it:
delete from TelecomAccountPosting where LocID = 19014 and InvDate =
'20080115';
I have an index which covers both LocID and InvDate:
CREATE TABLE `TelecomAccountPosting` (
Hello all,
I have been using MySQL for about 5 years now in a company project.
I store a lot of data, very rapidly into the database.
Presently, I am having a problem where the MySQL server appears to
be denying a connection when I reach a database size of about
10 billion bytes.
I am runnin
Optimize query
I've got one query, which I would like to improve a lot since it takes
very long (>24 hours) to execute. Here is the idea:
1. Take the table (other rows in this
table are not mentioned for clearity) and remove all duplicate
tuple's. This is done by subquery 'filter'.
2. The same qu
Hi,
I have a problem with "aes_encrypt/aes_decrypt" methods. Although it seems
to work fine when encrypting/decrypting text, I am unable to encrypt/decrypt
binary data correctly (ex: a PDF file stored in the database). It seems
that the decrypted result is only partially decrypted or maybe corr
Hi everyone,
Is anyone has experience running MySQL 5.0.41 on FreeBSD 7.0-RC1 AMD64?
If you do would you be able to comment on MySQL performance, possible
advantages and problems?
Regards,
--
Mikhail Berman
Shawn Green wrote:
What you might be seeing is the "purge" process of the InnoDB engine.
http://dev.mysql.com/doc/refman/5.0/en/innodb-parameters.html#option_mysqld_innodb_max_purge_lag
and from
http://dev.mysql.com/doc/refman/5.0/en/innodb-multi-versioning.html
>>In a scenario where the use
> use UTF-8 for text files
> use SET NAMEs to correctly MySQL what charset you are using
>
>
>
> --
> Sebastian
[JS] You are correct. The results were very confusing, especially since the
visual difference between a hyphen (0x2D) and an N-quad (0x96). Also,
copying UTF-8 text to a command window s
I think this change will get you what you want:
SELECT comment_approved, COUNT(comment_agent)
from wp_comments
WHERE comment_agent LIKE '%Linux%' AND comment_approved=0
GROUP by comment_approved
andy
Mário Gamito wrote:
Hi,
I'm trying to get a single number out of a SELECT statement:
SEL
Hello Ben,
Ben Clewett wrote:
No worries :)
> Good luck with your problem!
Apparently not, since no member of the MySql team wants to tell me and
this mailing list what scenario's will cause a low-load MySql system
lock at 100% CPU for hours on end.
Another of my servers has just entered
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf Of Baron Schwartz
> Sent: Friday, January 18, 2008 2:33 PM
> To: Jerry Schwartz
> Cc: mysql@lists.mysql.com
> Subject: Re: Handling Special Characters
>
> Jerry,
>
> On Jan 18, 2008 2:27 PM, Jerry Schwartz <[EMAIL PROTECTED]>
> wrote:
The test box doesn't have incoming data when he's taking the snapshot. Lock
the production database while taking snapshot and setting up replication or
you will have this problem. I've tried all the methods (snapshot, dump,
hotcopy etc) and the issue is always the same. You can't bootstrap
replicat
I am looking to retest the code using the mysql command line interpretor
instead of the Browser GUI in case the issue is with that.
Thx for your comments.
Kerry
-Original Message-
From: Martin Gainty [mailto:[EMAIL PROTECTED]
Sent: 18 January 2008 22:18
To: [EMAIL PROTECTED]; 'MySql'
Sorry the lines and error were "hidden" in my last message. The 3 lines
typed in the browser query are:
create temporary table ttable1 (select * from testnames where ref='ABCDE');
update ttable1 set ref='12345678';
select * from ttable1;
cursor on 1st line , click execute - no error
cursor on 2nd
Hi Michael,
I've tried your tip, but I get the error:
"#1054 - Unknown column 'ct_ct_comment_agent' in 'field list'"
Any ideas ?
Warm Regards,
Mário Gamito
Michael Cole wrote:
You have two rows the zero which has a single row and the other row
If the answer you are after is 48.
select sum(
Hi Sebastian,
Thank you for your answer.
I tried your way, but still, I get a column with two values:
|-
|COUNT(comment_agent)|
||
| 1|
--
| 47|
--
What I need is just the 47.
An
I have used the command below to change the file system permissions
chown -R mysql:mysql /data/mysql
On Jan 17, 2008 5:01 PM, Baron Schwartz <[EMAIL PROTECTED]> wrote:
> Have you checked filesystem permissions where InnoDB needs to create
> its files? And you're sure you've removed ALL of Inno
You have two rows the zero which has a single row and the other row
If the answer you are after is 48.
select sum(ct_ct_comment_agent) from (SELECT comment_approved,
COUNT(comment_agent) as ct_comment_agent from wp_comments WHERE
comment_agent LIKE '%Linux%' OR comment_approved=0 GROUP by
comme
Mário Gamito schrieb:
Hi,
I'm trying to get a single number out of a SELECT statement:
SELECT comment_approved, COUNT(comment_agent) from wp_comments WHERE
comment_agent LIKE '%Linux%' OR comment_approved=0 GROUP by
comment_approved
But instead i get two rows:
|
Hi,
I'm trying to get a single number out of a SELECT statement:
SELECT comment_approved, COUNT(comment_agent) from wp_comments WHERE
comment_agent LIKE '%Linux%' OR comment_approved=0 GROUP by comment_approved
But instead i get two rows:
|--
|comment_
bugger
- Code Editor enhancements (parameter insight, parenthesis highlighting)
- File Compare Tool
... and much more ...
Download a trial at: http://www.upscene.com/download.htm
What's new?: http://www.upscene.com/products/dbw/whatsnew30.htm
Full list of features and fixes: http://www.upscene.com/new
25 matches
Mail list logo
