Hi Gerald, Michael,
Gerald L. Clark wrote:
Never put MySQl data files on an NFS exported share.
Michael Dykman wrote:
This is a bit of a generalization, but file locks are known to be
pretty flakey and unreliable under NFS.. any kind of serious load
begs races conditions which file locks
Hi,
our scenario (was):
server1: 5.0.32-Debian_7etch1-log
server2: 5.0.32-Debian_7etch1-log
Hardware-wise (attention, Vmware, see below) they're equal: ~1GHz CPU at at
minimum 2GB ram.
Suddenly about 4 to 6 weeks ago, server1 started getting serious problems with
spontaneous corrupted
not sure about it's CPU performance, but the
information I've is that when connections start hanging and the effect
basically multiplies, the CPU load goes aup.
Does this sound like a possible bottleneck?
thanks,
- - Markus
Markus Fischer wrote:
Hi,
I'm using phorum [1] and made some custom
Hi,
I'm using phorum [1] and made some custom queries against their
database. My query looks like this:
SELECT
message_id, subject, datestamp, forum_id, thread
FROM
phorum_messages
WHERE
forum_id IN (1, 2, 3, 4) AND parent_id = 0 AND
thread != 0 AND status = 2 AND closed = 0
ORDER BY
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
I'm having trouble with the following:
In the MySQL 4 database I had the following values in an unique varchar
and there was no problem:
Gross
Groß
(the latter has the german sharp s character)
Now whenever I import this into the MySQL5
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
we've enabled /var/log/mysql.log on our server (5.0.24a on Debian
testing). However I only want to log commands from certain application,
or better say, certain users.
When I look at some log output, it looks like this:
060919 9:53:38
15945
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Markus Fischer wrote:
Before I re-invent the wheel I'ld like to know if there are tools/helper
like this available ... ?
Being impatient and in need of this I've written my own version. Maybe
it is valuable to others.
http://markus.fischer.name
folks whose names are
_ _ bersee
So there's still a margin for error.
Unfortunately, there's no special case for hey, when you're looking
at LIKE, I want to define that x=y -- particularly when x and y have
differing #'s of characters.
-Sheeri
On 3/22/06, Markus Fischer [EMAIL PROTECTED
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
what is the best way to match german umlauts like 'ä' also their
alternative writing 'ae'?
For example I'm searching for übersee and I also want to find the word
uebersee in the database. The words are actually names of persons.
One possibility
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
is there, performance wise, any difference whether I create one index
for multiple fields or each field with its own index? I'm running 4.0.16.
thx,
- - Markus
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2.1 (MingW32)
Comment: Using GnuPG
/refman/5.0/en/indexes.html
http://dev.mysql.com/doc/refman/5.0/en/multiple-column-indexes.html
http://dev.mysql.com/doc/refman/5.0/en/mysql-indexes.html
Markus Fischer пишет:
Hi,
is there, performance wise, any difference whether I create one index
for multiple fields or each field with its
Egor Egorov wrote:
Bug filled: http://bugs.mysql.com/bug.php?id=5784
Thank you!
Nice, thanks to you too ;-)
regards,
- Markus
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
Egor Egorov wrote:
Can you create a test case? I.e. a .sql file which is supposed to drop the
table well but instead fails?
This will help us determine if it's a bug and fix if it is.
Thanks, this hit a pretty interesting nail for me: I can dump it, but I can't load
the dump into the
Hi,
Egor Egorov wrote:
Can you create a test case? I.e. a .sql file which is supposed to drop the
table well but instead fails?
Nevermind my last post, I found the workaround to disable foregin_key_checks
during import; interesting.
Here is a small example:
set foreign_key_checks=0;
CREATE
Hi,
I've a problem that I can't drop a certain table, always get back the error unknown
table.
Version: 4.0.21 (Debian Testing)
Table-Type: InnoDB
mysql show tables;
[...]
| produkt_kategorie|
mysql drop table produkt_kategorie;
ERROR 1051: Unknown table 'produkt_kategorie'
The
Hi,
On Tue, Dec 16, 2003 at 10:23:05PM +1100, Chris Nolan wrote :
How heavy is your usage of TEMPORARY TABLES? I don't use them much
myself, but I'm sure that the others on the list will have something
to say in that regard.
Here are the relevant numbers:
Created_tmp_disk_tables
On Tue, Dec 16, 2003 at 10:38:14AM -0600, Dan Nelson wrote :
In the last episode (Dec 16), Markus Fischer said:
I'm investigating a performance problem with mysql server set up. The
server is running linux with 1GB ram. I'ld like to tune the
configuration of the server to use as much RAM
On Thu, Dec 18, 2003 at 10:37:46AM -0600, Dan Nelson wrote :
In the last episode (Dec 18), Markus Fischer said:
On Tue, Dec 16, 2003 at 10:38:14AM -0600, Dan Nelson wrote :
Raising sort_buffer_size and join_buffer_size may also help if your
queries pull a lot of records.
From
Hello,
I'm investigating a performance problem with mysql server set up.
The server is running linux with 1GB ram. I'ld like to tune the
configuration of the server to use as much RAM as possible without
swapping to the disc because of the big slow down.
The current
[Please CC: directly to me, I'm not subscribed]
Hi,
maybe a pointer to the documentation is sufficient, but does
mysqld uses linux-threads or processes?
And is there way to control them? After I start up mysqld I
see 3 processes with ps. After some time (e.h. 12 hours)
: Joseph Bueno [EMAIL PROTECTED]
To: Markus Fischer [EMAIL PROTECTED]
mysqld uses threads (you already found the right documentation).
How long is the life-time of a connection if there's no
request comming anymore? The mysqld is acesssed with PHP and
I'm using normal mysql_connect
On Mon, Jan 14, 2002 at 03:03:11PM +0200, Sinisa Milivojevic wrote :
Markus Fischer writes:
Does someone know if there's a native C# implementation
available OR a wrapper around libmysqlclient for C#?
As far as I know, no not yet.
Ok, thx.
But we are preparing our strategy
[Please CC me, I'm not subscribed]
Does someone know if there's a native C# implementation
available OR a wrapper around libmysqlclient for C#?
thx,
Markus
-
Before posting, please check:
(!). So, e.g., if you have all temperature lows in
one row, how can I retrieve the data in form of one column?
How about CONCAT'enating all ?
SELECT CONCAT( id, ' ', temp1, ' ', temp2) as allinone FROM Temp WHERE php meets zimt
m.
--
Markus Fischer, http://josefine.ben.tuwien.ac.at
24 matches
Mail list logo