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 lock
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 table
GB ram. I'm 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&
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 data
-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://mar
-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 Con
r "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]> wrote:
> Hi,
>
> what is the best way to match german um
-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 possib
re:
> http://dev.mysql.com/doc/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
-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
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?
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 TABLE
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 datab
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 ownersh
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
> > > qu
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
> > config
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
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 config
.
> From: "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
[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) I
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.
[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:
http://www.m
Does you /var/lib/mysql/mysql.sock exist ?
If not, try connecting through TCP/IP by removing localhost and writing
"127.0.0.1:3306"
- Markus
- Original Message -
From: "Daniel Goldin (E-mail)" <[EMAIL PROTECTED]>
To: "Mysql (E-mail)" <[EMAIL PROTECTED]>
Sent: Sunday, May 06, 2001 9:41 P
Try
mysql_connect( "localhost:/where/your/real/socket/path/is", ...
or
mysql_connect( "127.0.0.1:3306", .
And make sure mysqld is really running.
- Markus
- Original Message -
From: "Daniel Goldin (E-mail)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, May 06, 20
in one
> row) in one column (!). 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
26 matches
Mail list logo
