I have created MySQL Fuse *which allows community to build important
bookmarks across different areas of MySQL.*
Link : http://www.httpfuse.com/fuse/MySQL
WIth such bookmarks built by community on MySQL (i.e. MySQL Fuse) *it helps
each other ( and new users) to discover important bookmarks acro
Hi, I've been trying to find information on how myisam handles locks.
I though myisam had locking only on writes and not on reads. For some
reason and after a lot of digging i've been seeing that some
queries(albeit bad queries) cause other queries to hang even though
they are selects is th
From: Ananda Kumar [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 27, 2008 1:58 AM
To: Jerry Schwartz
Cc: [EMAIL PROTECTED]; mysql@lists.mysql.com
Subject: Re: Huge temporary file
do,
show varaibles like '%tmp%'.
show variables like '%tmp%';
| tmpdir| /tmp/
This i
you'll need to set the datetime function before presenting date/time to the user
http://www.w3schools.com/php/func_date_default_timezone_set.asp
Martin
__
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to th
Where can I find a "general log" if I've got one running? What's it's file
name, and where it is usually located?
Thanks,
Jesse
- Original Message -
From: Ananda Kumar
To: Jesse
Cc: MySQL List
Sent: Tuesday, August 26, 2008 8:03 AM
Subject: Re: Error stops replication
Hi All,
A small doubt.
In oracle we have something like
dbms_out.put_line('abc')..to display messages from plsql.
Do we have any thing similar to this, what is the way to display user
friendly message from PLSQL in mysql.
I am trying to write some stored proc's and wanted to display debug mes
Hi all,
I want to enable 'log_slow_queries' and 'log_queries_not_using_indexes'.
Enabling of two components will log all slow queris and queries not using
index in the log file. How much extra burden will be on the Production
server after enabling.
In docs, i have read that enabling log-bin makes