Try issuing
select @@sql_max_join_size
And also make a product from the number of rows from all the tables
involved in the join (with WHERE clause applied) and if it exceeds the
number given from the select I gave you above... then that's your
reason !
Also bare in mind that although you only r
Hi,
I would like to log the execution time for each query in my MySQL server
.Is there any possible way?
Please not that, the - log-slow-queries option will not suffice for my
requirement.
Thanks & Regards
Mukul Saha
___
Cognizant Technology Solutions
I used to use UltraEdit, but then switched to EditPlus because it can edit
remote files almost transparently. (Opening a file FTP's it down, you edit
local copy, Saving FTP's it back.)
FYI - UltraEdit can do this - It uses SFTP over SSH to edit remote files.
Works like a charm.
-Hank
mysql, q
Hi ,
I'm just behind a mulimedia database , that wanted to be online with WAP
contents. So , i decided to go ahead with mysql , and i installed mysql latest
5.0 in fedora core 5 with innoDB .upto now every thing success.
But , my worries is , how can i created huge mulimedia database wit
Hi all.
I have a long and complicated chain of queries in MS Access that I want
to port to using stored procedures & views.
What I'd like to do is something like:
1) stored procedures grabs original data set, and dumps into temporary
tables
2) I open a view, which is in turn based on other views
It appears that every time I start query the event or the data table
gets Locked.
Could this have any affect on why it takes so long to delete records.
Grasping at straws,
Thank you,
Raymond
mysql> show processlist;
+-+---+---+---+-
Dan: The options I specified are correct (according to the
documentation) to get a consistent non-blocking snapshot.
(--single-transaction disables --lock-tables, --opt is the default
behavior for mysqldump).
My question was more in the nature of will these options work in high
concurrency situa
Sorry Mark - I thought your question was more of a "does this seem
right" and "how do I" than a "something's wrong here" post.
I think your problem is coming in with the use of --opt. The article
you reference, where it says "This is an online, non-blocking backup",
makes no mention of --opt, wh
Hi Rick, all!
Rick Robinson wrote:
The documentation shows MySQL 5.0.23 as released on July 4 - but I do not see it on any mirror anywhere? Does anyone know where MySQL
5.0.23 is? Is it released, as the doc says? Is it being held until release 5.0.24?
The "release date" in the documentatio
Mark, that's the expected behavior of mysqldump with --opt and
--single-transaction; it locks all databases and all tables for the
duration of the dump, ensuring a consistent snapshot.
With a database this size (100 GB), it's an area where throwing
hardware at the problem may be your best bet. I
Hi folks,
I've recently tried to do a database backup on a database server that
has a fairly high concurrency rate (1000+ queries/sec) and have noticed
that the backup process seemed to deadlock the machine and I had to
resort to extreme measures to get the database back up (killed the
process
On 7/10/06, Kishore Kumar Barik <[EMAIL PROTECTED]> wrote:
Database Migration Error:
My database is stored in MSSQL Server 2000 in a standalone system in windows
authentication mode means without any username and password. I am writing my
whole process & problem if you people could solve my probl
Could the problem the Locked data table in this case?
mysql> show processlist;
+-+---+---+---+-+---
-+--+---
---+
| Id | User | Host
- Original Message -
From: "Miles Thompson" <[EMAIL PROTECTED]>
To:
Sent: Sunday, July 09, 2006 8:10 PM
Subject: Re: How to look for balanced parenthesis?
At 03:48 PM 7/9/2006, Rhino wrote:
- Original Message - From: "mos" <[EMAIL PROTECTED]>
To:
Sent: Sunday, July 09, 2
On 7/10/06, Kishore Kumar Barik <[EMAIL PROTECTED]> wrote:
< snip >
Please send me solution immediately.
anything else, your highness?
--
-jp
Chuck Norris got in touch with his feminine side, and promptly got her
pregnant.
The documentation shows MySQL 5.0.23 as released on July 4 - but I do not see
it on any mirror anywhere? Does anyone know where MySQL
5.0.23 is? Is it released, as the doc says? Is it being held until release
5.0.24?
Thanks for any update.
Regards,
R
--
MySQL General Mailing List
For lis
Best group member,
I did this query on a very small database. And it gave error with some
MAX_JOIN_SIZE error. I have never seen this, and how can I avoid this to
happen? Do I have too many joins in one query? Should I write the joins
differently?
++
SQL query:
SELE
Hi!
Vittorio Zuccalà wrote:
Hello,
i've two tables and they have the same field.
I'd like to make a select which take records in a table and after it
shows record in the other table
Read here: http://dev.mysql.com/doc/refman/5.0/en/union.html
in the same field...
It cannot be "the same",
From: Vittorio Zuccalà Sent: 10 July 2006 14:26
>
> Hello,
> i've two tables and they have the same field.
> I'd like to make a select which take records in a table and after it
> shows record in the other table
> in the same field...
>
> I try to explain:
>
> Table1
> FieldA - FieldB
> AAA123
Hello,
i've two tables and they have the same field.
I'd like to make a select which take records in a table and after it
shows record in the other table
in the same field...
I try to explain:
Table1
FieldA - FieldB
AAA123 - Cellular
BBB111 - PostIt
Table2
FieldA - FieldH
AAB111 - Dido
BGF145 -
Database Migration Error:
My database is stored in MSSQL Server 2000 in a standalone system in windows
authentication mode means without any username and password. I am writing my
whole process & problem if you people could solve my problem.
In Source Connection Parameter
Stored Connection : myL
I've had to delete large amounts of records from tables with over 200 millions records. You are correct in that you want to do it in
chunks. How you divide the deletes is up to you to decide. You would want to do it based on a indexed column, like a date, and
specify a range.
DELETE data
FROM da
[snip]
If I have a file that is in a spreadsheet format, how can I dump that
into a MySQL database, using PHP MyAdmin?
[/snip]
Using a LOAD DATA INFILE query.
http://www.google.com/search?hl=en&lr=&q=csv+to+mysql+phpmyadmin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
If I have a file that is in a spreadsheet format, how can I dump that into a
MySQL database, using PHP MyAdmin?
Thanks,
Nick
Is there a standard MySQL structure to represent vCards?
If so, are there programs to install vCard address lists
in a MySQL database?
I'm running Fedora-5 Linux, with KDE,
and am interested in translating the KAddressBook/kabc format
(used with kmail) to and from MySQL,
as automagically as possib
Hi,
We had an outage on our Mysql DB yesterday. Basically the Db was unusable
and we couldn't get a shell onto the host ('could not fork process').
OS: Red Hat Linux Advanced Server release 2.1AS/\m (Pensacola)/2.4.9-
e.3enterprise
Mysq: Ver 4.0.16-standard for pc-linux on i686
All Db's on host
The package you sent me was infected, so send me one by mail.Thank you:James
B.Runaku, P.O.Box 190-50100, Kakamega, Kenya.
mysql@lists.mysql.com wrote: The message contains Unicode characters and has
been sent as a binary attachment.
-
How low
> Is there somewhere I can find the exact differences between the contents of
> the
> 'essential' and 'complete' Windows MySQL distributions?
> I've tried the source code and searched all over the website but can't find
> it anywhere.
Ping!
_
"cumulative total index"
...
> > >SELECT SUM(amount) , DATE_FORMAT( `paymentDate` , '%Y-%m' ) FROM
> > >`payments` GROUP BY DATE_FORMAT( payments . date , '%Y-%m' )
.
> > >Is there any way to get a running cumulative total directly from mysql?
> > >Something like:
> > >
> > >amount | pay
Hi Mike, all!
mos wrote:
I have a complicated SQL statement with around a dozen
"if(this,val1,val2)" embedded in it and there are even nested If
clauses. I'm getting syntax errors because I'm not balancing the "( )"
properly. Is there any free software out there for Windows that I can
copy a
Thanks a lot!
- Original Message -
From: "paul rivers" <[EMAIL PROTECTED]>
To: "'古雷'" <[EMAIL PROTECTED]>;
Sent: Monday, July 10, 2006 11:41 AM
Subject: RE: May I create more than 200 databases for one mysqld?
> Yes, you can.
>
> Whether there are disadvantages depends mainly on how yo
31 matches
Mail list logo
