hello, you can not simultaneously fix two deamons to a data directory. a
mysql daemon always has exclusive access to the data directory.
Am 10.06.2010 07:09, schrieb camelia botez:
and use
the same data bas
--
S&P data GmbH
T 06131 218111
F 06131 218112
E schackenb...@termindoc.de
W www.termi
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
We have 2 mysql servers - one active , second standby.
The data base is on nsf storage file system mounted on the active server.
We want to turn on active the second server and to be able to use both
servers with the same nfs mounted data base.
Just n
Absolutely. You don't want to obscure the cause by just throwing more
hardware at things.
That approach just buys you time until a bigger pile hits the fan if
the underlying issue remains unresolved.
At the same time, though, 8 MB production innodb buffer pool
allocation should be fairly high on th
This is awhile ago, but I seem to recall it just dumping loads of
stuff into System32
On Wed, Jun 9, 2010 at 11:43 AM, Jerry Schwartz wrote:
> The Windows ODBC connector does have a logging function. It's in the
> "Details", on the "Debug" tab.
>
> Unfortunately, I haven't been able to figure out
On Wed, Jun 9, 2010 at 8:04 PM, Kyong Kim wrote:
> If the memory is available, why not use it? It seems like the default
> buffer pool size out of the box was just never changed.
Agreed, of course, but if something happens on a system that is out of
the ordinary, it's very good practice to hunt t
On Tue, Jun 8, 2010 at 10:57 PM, Machiel Richards wrote:
> Good morning all
>
>
>
> I would like to try and find out how you can see what is using the
> query cache.
>
>
>
> My reason for asking is the following:
>
>
>
> On one of our client databases, the quer
Thanks Paul
you opened my eyes !!!
On Wed, Jun 9, 2010 at 2:27 PM, Paul DuBois wrote:
>
> On Jun 9, 2010, at 11:59 AM, Darvin Denmian wrote:
>
>> Hello !
>>
>> Is there some diference between : FLUSH LOCAL LOGS and FLUSH LOGS ?
>
>
> Yes. http://dev.mysql.com/doc/refman/5.1/en/flush.html says:
>
On Jun 9, 2010, at 11:59 AM, Darvin Denmian wrote:
> Hello !
>
> Is there some diference between : FLUSH LOCAL LOGS and FLUSH LOGS ?
Yes. http://dev.mysql.com/doc/refman/5.1/en/flush.html says:
"
By default, FLUSH statements are written to the binary log so that they will be
replicated to re
Ok now
-Original Message-
From: Darvin Denmian [mailto:darvin.denm...@gmail.com]
Sent: Wednesday 09 June 2010 19:00
To: mysql@lists.mysql.com
Subject: FLUSH LOCAL LOGS
Hello !
Is there some diference between : FLUSH LOCAL LOGS and FLUSH LOGS ?
Thanks
--
MySQL General Mailing List
Fo
Hello !
Is there some diference between : FLUSH LOCAL LOGS and FLUSH LOGS ?
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Thanks all for the replies, I seemed to have figured out why this was empty...
they gave me the wrong data to load into the test database and queries into it
found no matches... I assumed that would be the problem and they are sending
new data... however, I am going to try and get the debug log
The Windows ODBC connector does have a logging function. It's in the
"Details", on the "Debug" tab.
Unfortunately, I haven't been able to figure out where it puts the log file
even after doing a full scan of my hard drive. I searched for myodbc.*, and
didn't find anything that looked like a log
MySQL University: Securich - Security Plugin for MySQL
http://forge.mysql.com/wiki/Securich_-_Security_Plugin_for_MySQL
This Thursday (June 10th, 14:00 UTC), Darren Cassar will rerun his
February 25 presentation of Securich - Security Plugin for MySQL.
(Recording of the session failed in February;
binlogs only contain data modifications, it won't show you the SELECT
queries; I don't think that path is worth your time for the problem at
hand. I suggest you explicitly enable the gebneral query log and
restart if need be.
- md
On Wed, Jun 9, 2010 at 9:47 AM, Anirudh Sundar wrote:
> Michael
Michael is right. But sometimes General log is not enabled and if that is
the case then you need to refer to the "Binary" logs.
But you cannot read the contents of the binlog just like that. You need to
convert that to a readable format.
mysqlbinlog bin.10001 > /tmp/read_bincontent.log
Cheers,
A
Hi list,
I'm migrating a Java application from it's local MySQL server (5.0) to
a remote 5.1 server. I've transferred the data and slaved the new
server to keep it in sync, but when I try to switch out the datasource
(that is, just change from localhost to the remote server), the
application refus
You have 2 options here. The Mysql General Query Log
http://dev.mysql.com/doc/refman/5.1/en/query-log.html
Alternatively, if it's windows ( I ask because of the ODBC connector)
and it's easier for you,
I haven't done windows in awhile, but I suspect you might find what
you want via that connecto
Ladies, gentlemen,
Upscene Productions is proud to announce the next
version of the popular multi-DBMS development tool:
" Database Workbench 4.0.2 Pro "
Version 4 introduced full Unicode support, 4.0.2 fixes some issues
found in that initial release, like ODBC connectivity issues, BLOBs
taki
Hi,
I'm a real newb at admining MySQL.We have a customer that uses our software
that scripts queries and they are using a MySQL backend.
They have sent us a test script and their database and I have setup a test
server, loaded the data setup an ODBC connection and this all works fine.
The
19 matches
Mail list logo
