> I would like to log the execution time for each query in my MySQL server
> .Is there any possible way?
If you are using MySQL to serve an application, then it is advisable to do
the logging through the application scripts. For in most cases, you might
require more information other than time alo
in order to run benchmarks, it is useful to be able to
clear the buffer cache. i'm using innodb. is there a
way to clear the buffer cache, i.e., something equivalent
to oracle's "alter system flush buffer pool"?
thanks,
kevin
--
MySQL General Mailing List
For list archives: http://lists.mysql.c
At 06:18 PM 7/11/2006, you wrote:
My understanding is that SCSI has a faster transfer rate, for
transferring large files. A busy database needs really fast access,
for making numerous fast calls all over the disk. Two different,
unrelated things.
I am more than willing to be called Wrong, slappe
Hello,
I have solved this problem, thanks.
Regards
Willy
- Original Message -
From: Willy
To: mysql@lists.mysql.com
Sent: Wednesday, July 12, 2006 8:55 AM
Subject: datetime issue on MySQL 4.x
Hello,
I have a MyISAM table:
CREATE TABLE `dlr` (
`msisdn` varchar(20
Hello,
I have a MySQL 4.x installed, and I have a very high requests on this server,
it's about 1 - 5 requests/minutes. Any tips to tuning it? Many thanks
for any replies.
Regards
Willy
Hello,
I have a MyISAM table:
CREATE TABLE `dlr` (
`msisdn` varchar(20) NOT NULL default '',
`source` varchar(20) NOT NULL default '',
`operator_id` varchar(20) NOT NULL default '',
`sms_message` longtext NOT NULL,
`smsc_id` varchar(20) NOT NULL default '',
`sms_id` varchar(250) NOT NU
Hello everyone!
I've got a few questions regarding optimizing self-joins.
So I've got these three tables:
mysql> describe FieldName;
+-++--+-+-++
| Field | Type | Null | Key | Default | Extra |
+-+--
Greetings.
Continuing on from my previous question, I've discovered that I *can't*
create views which refer to temporary tables.
Is there any plan to drop this requirement?
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2
It's my understanding that the biggest remaining difference has to do
with SCSI having far superior command queueing capabilities --
although SATA's command queueing may have closed the gap somewhat --
which provides for much better real-world performance when you have
multiple database thr
On Tuesday, 11 July 2006 at 16:41:24 -0700, Chris White wrote:
> On Tuesday 11 July 2006 04:18 pm, Brian Dunning wrote:
>> My understanding is that SCSI has a faster transfer rate, for
>> transferring large files. A busy database needs really fast access,
>> for making numerous fast calls all over
> Brian Dunning wrote:
>
>> My understanding is that SCSI has a faster transfer rate, for
>> transferring large files.
>
> SCSI is better for EVERYTHING except your budget. Faster for large
> transfers, small transfers, seek times, and most especially it handles
> requests from multiple threads
Brian Dunning wrote:
My understanding is that SCSI has a faster transfer rate, for
transferring large files.
SCSI is better for EVERYTHING except your budget. Faster for large
transfers, small transfers, seek times, and most especially it handles
requests from multiple threads much better
On Tuesday 11 July 2006 04:18 pm, Brian Dunning wrote:
> My understanding is that SCSI has a faster transfer rate, for
> transferring large files. A busy database needs really fast access,
> for making numerous fast calls all over the disk. Two different,
> unrelated things.
>
> I am more than will
My understanding is that SCSI has a faster transfer rate, for
transferring large files. A busy database needs really fast access,
for making numerous fast calls all over the disk. Two different,
unrelated things.
I am more than willing to be called Wrong, slapped, and cast from a
bridge.
Hello to all,
I'm having some problems with the linux copy of mysql-workbench.
Great features and all, if I could get them to work.
What I'm trying to do is reverse-engineer a INNODB database I have
in mysql 5.0 on my local machine.
I go through the steps right to the end of the pr
When I try to retrieve all rows in the event table that are in a
particular range and then
try to determine if the cid is in the data table the join takes
forever.
So I tried just tried adding the table to see if the where clause was
slowing things down. Below is a portion on my session.
mys
Hello list,
we use MySQL 4.1.13 / InnoDB on Xeon em64t running Debian, kernel 2.6.8.
After a while, queries run slower and slower, although the CPU is >70% idle
and diskio is nearly zero. A simple select by primary key takes up to one
second. After doing a FLUSH TABLES the speed is up again.
I a
Brent Baisley wrote:
> There will always be new requests, but many times you can store data
> "vertically" in rows instead of "horizontally" in columns. You would
> need a "label" column to indicate what type of data the row contains.
> It's more work on the front end, but a lot more flexible. It's
Creating a huge media database and storing the media *inside* of mysql
is a big mistake.
Store the media in a filesystem. Store metadata about the media in mysql.
Good luck.
Peter
On 7/10/06, Shain Lee <[EMAIL PROTECTED]> wrote:
Hi ,
I'm just behind a mulimedia database , that wanted to be
As of Ultraedit version 12, it's not quite transparent, but it's
pretty close. If you Open a file from FTP (File menu option), and hit
save, it will automatically upload the file to the server. It's a
little slow on the save (as in hit save and count to 10), but it does
the job well.
Ultraedit
Just a shot in the dark...
how about : \T /home/karl/sql_log_$$
I believe, in bash, $$ will give you the pid of the process, so you
should
get a unique (somewhat) file name every time
>>>-Original Message-
>>>From: Karl Larsen [mailto:[EMAIL PROTECTED]
>>>Sent: Tuesday, July 11, 2006
On 7/10/06, Shain Lee <[EMAIL PROTECTED]> wrote:
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
Actually, you can log every query, with the general query log:
http://dev.mysql.com/doc/refman/5.0/en/query-log.html
be warned that enabling this is a good way to fill up your disks
though since it logs inserts and updates complete with data.
The general query log does not appear to log execution
I have found that \T /home/karl/sql_log will cause evcrything I do
to be saved in the file sql_log. Alas if I turn off mysql as I do daily,
the log is lost and I have to do it again.
Is there a way to get a log like this to be perminant :-)
Karl Larsen
--
MySQL General Mailing List
Fo
sorry if it's a stupid question, but just to cover the basics, you
remembered to flush privileges after adding it right?
-- James
On Jul 11, 2006, at 9:31 AM, John Doolan wrote:
Hi,
I have just installed mySQL version 5 and want to enable root access
from remote machines. However, the con
On 7/11/06, John Doolan <[EMAIL PROTECTED]> wrote:
Hi,
I have just installed mySQL version 5 and want to enable root access
from remote machines. However, the configuration tool fails when trying
to change the security settings with an error 2003. Apart from this it
is working fine (alongside
Hi,
I have just installed mySQL version 5 and want to enable root access
from remote machines. However, the configuration tool fails when trying
to change the security settings with an error 2003. Apart from this it
is working fine (alongside a version 4 server on the same machine). How
do I m
I have no long running transactions. I believe the deadlock to have been
caused by a high concurrency of transactions.
As soon as the backup started, mysqldump got the global lock, and seemed
to hang during the flush tables (while hundreds of other clients try to
execute queries).
Should be eas
5.0.22
-Original Message-
From: Dan Buettner [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 11, 2006 9:55 AM
To: Mark Steele
Cc: mysql@lists.mysql.com
Subject: Re: mysqldump with single-transaction with high-concurrency DB
Sorry Mark, appears you're right. --opt is the default now; didn'
Argh! I should stop writing emails this early in the morning - I always
miss something. I just noticed that, at the end of your first email, you
did say the backup process was stuck on "flush tables". The only way
that I can think of for this to happen is if another thread were holding
a table
Mark,
You're correct that "--single-transaction" does create a consistent
non-blocking read; I've used the same set of options
(--single-transaction --master-data=1 --all-databases) to create
point-in-time snapshots from which to create new replication slaves.
However... I have also seen beh
There will always be new requests, but many times you can store data "vertically" in rows instead of "horizontally" in columns. You
would need a "label" column to indicate what type of data the row contains. It's more work on the front end, but a lot more
flexible. It's a technique I use often, b
Sorry Mark, appears you're right. --opt is the default now; didn't
used to be, I don't think. Also, my experience with MyISAM is a total
lock on all tables across all databases during a mysqldump ... but you
are using InnoDB obviously. I think you're right in your reading of
the docs - that you
Brent Baisley wrote:
Changes to the database structure should be few a far between. If you
are finding you need to change the structure regularly, you should
probably look at a redesign.
This customer regularly request new things, so I cannot avoid changes
to the database structure.
MyISAM
Saha, Mukul (Cognizant) schrieb:
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
Hi,
Well there is no option for loggi
Changes to the database structure should be few a far between. If you are finding you need to change the structure regularly, you
should probably look at a redesign.
MyISAM locks the table when an insert/delete is occurring, during which time other requests are queue up. You can switch it to
In
Hello,
one of my customers has a database with about 1.7 million records
(52 fields, almost 1GB on amd64, MyISAM).
This database is running on Debian sarge with MySQL 4.0.24.
Changing the database structures and also large set of inserts/deletes
take too long to be acceptable on a productions s
At 12:36 AM 7/11/2006, you wrote:
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.
2006/7/10, Joerg Bruehe <[EMAIL PROTECTED]>:
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 fre
We have two networks which are very far apart in separate data centres
over 1,000 miles apart. Web servers are in both locations but our MySQL
db servers are in one. All web servers talk to those servers.
After debugging some problems with a counter field I discovered that
UPDATE statements fr
Здравствуйте, Kishore.
Вы писали 10 июля 2006 г., 16:52:29:
> 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
41 matches
Mail list logo
