Re: generic remote command/script for monitoring MySQL instance health

Sven -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

generic remote command/script for monitoring MySQL instance health

Hi folks I am searching for a generic command to monitor that MySQL instance is up and running. I don't have any know-how about the schema of the DB. kind regards Sven Aluoor -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

FULLTEXT + InnoDB = grounded?

can workaround with MyISAM, but if the feature is no longer on the list, then it would be better to choose another more cumbersome approach or switch the db entirely. Many thanks for a short update. Cheers, -sven -- MySQL General Mailing List For list archives: http://lists.mysql.com

UTF-8 collation problem with greek extended characters

is set utf8_unicode_ci. Is there anything I can do to have MySQL distinguish these characters? (mysql --version is Ver 14.7 Distrib 4.1.22, for apple-darwin8.8.1 (i686) using EditLine wrapper) Thanks in advance! -- sven fuchs fon: +49 (58 45) 98 89 58 artweb design

Re: UTF-8 collation problem with greek extended characters

answer and asking Google I've already seen that MySQL knows DISTINCT BINARY also. Thanks a million, Chris! -- sven fuchs fon: +49 (58 45) 98 89 58 artweb design fax: +49 (58 45) 98 89 57 breite straße 65www: http://www.artweb-design.de de

Foreign keys - No action - Errors

on MySQL , a lot of books and the manual but I cant get any answer. Thanks for any answer wich will solve my problem. Sven Åke Johansson [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]

ON DUPLICATE KEY UPDATE and AUTO_INCREMENT columns

and always get the id of the entry? Sven -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ON DUPLICATE KEY UPDATE and AUTO_INCREMENT columns

I want. I need the ID of the row just inserted (for referencing it from another table). If I select the max(id), then one the hand someone might have added another row in the meantime and on the other hand is still don't get the ID value in the ON DUPLICATE KEY UPDATE case ... Sven -- MySQL

help!!!!!!!!!!

Warning: mysql_query() [http://www.mysql.com/doc]: Your query requires a full tablescan (table bb1_designelements, 78 rows affected). Use EXPLAIN to optimize your query. I get this error on every products i tested

Trouble with prepared select statements with parameters in where clause

the statement */ if (mysql_stmt_close(stmt)) { fprintf(stderr, failed while closing the statement\n); fprintf(stderr, %s\n, mysql_stmt_error(stmt)); exit(0); } return 0; } -- -Trigital- Sven Riedel . Tel: +49 511 1236364 . Fax: +49 511 1690746 . email: [EMAIL PROTECTED

RE: Foreign Key Reference to a VARCHAR

those four-byte sequences: Will that be implemented _after_ MySQL gets longer VARCHAR columns? If not, a new version with four-byte sequences would not be able to handle my tables anymore, right? - Maybe you should change the error message in SHOW INNODB STATUS ;) Thanks again, Sven

RE: Foreign Key Reference to a VARCHAR

-001F: 0xxx 10xx 10xx 10xx U-0020 - U-03FF: 10xx 10xx 10xx 10xx 10xx U-0400 - U-7FFF: 110x 10xx 10xx 10xx 10xx 10xx (http://www.cl.cam.ac.uk/~mgk25/unicode.html) Anyway... 65,536 is enough for me :) Sven

Foreign Key Reference to a VARCHAR

-linux (debian 3.0 woody) Sven Schlund + Partner AG Brauerstraße 48 76135 Karlsruhe Dipl.-Inf. Sven Woltmann [EMAIL PROTECTED] http://www.schlund.de -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Problems with MySQL 4.0.16

Hello, I am using MySQL 4.0.16 on Debian GNU/Linux at the moment. In this database there are over 4,5 Mio. entries! The Database crashs with follow errors: 031217 19:21:06 mysqld started /opt/lampp/sbin/mysqld: ready for connections. Version: '4.0.16-log' socket:

Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?

So far, it seems that MySQL, MaxDB, PostgreSQL, and Interbase/Firebird are possible candidates. Does anyone know why we should or should not use any of these? Does anyone know of other possibilities? I was very disappointed by Interbase/Firebird. It seemed to me like a MS-Access: a

Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?

I was very disappointed by Interbase/Firebird. It seemed to me like a MS-Access: a database-engine that works on regular files What gave you that idea? Firebird (and InterBase of course) use a at least 1 file per database, but that's all. Can you define regular files? My idea of Firebird is the

Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?

I set the isolation level to READ_REPEATABLE and use mysqldump | bzip2 to get the result. I've tested the restore and it's fine! So how does mysqldump handle binary data? If it does embed the data into the SQL-statement somehow, that's crap, since SQL-Statements are limited in length. -- MySQL

Switch rows and columns

displays only one row. So I`d like to display the query result as a vertical table If anybody knows a better way to do it, I`d really appreciate it Thanks for your help in advance. Best regards, Sven - Before posting, please

Query - Question

(.) : Two Points would give back 2.2. and 1.1. Three Points would give back 2.2.1. and 1.1.3. etc. I tried to use a REGEXP, but didnt succeed. Can you help? Gruß aus Essen Sven Schäfermeier ___ Klickmeister GmbH - Schuermannstrasse 39 - 45136

update multiple data sets

load a text file containing the names into my my query? 2. How do I have to build the update statement itself? Can I use some kind of variable? Thanks for your help in advance SVen - Before posting, please check: http

NEWBIE:select query and /

that problem would be very welcome. select name, surname, pemail, course from memberscopy where nation = '$f_nation' order by course Thanks for your help in advance, Sven - Before

update query

', children_names='$children_names', hobbies='$hobbies', membership='$membership', pcont='$pcont', lastup=now() where name = '$name' and surname = '$surname' Thanks for your help in advance, Sven

update query fails

='$membership', pcont='$pcont', lastup=now() where name = '$f_name' and surname = '$f_surname' The 2nd query works (for some fields only) on my local machine, but not on the ISP's server Thanks for your help. Sven

Re: UTF-8 national characters

better a download location) of all available UTF-8 national character sets and a small description on how to get them working as fast as possible? Thanks for your understanding and help, Sven On Thursday, May 16, 2002, at 08:40 AM, Roger Baklund wrote: * John D. Stein I can't seem to find

Re: INSERT INTO not working

1. delete any whitespaces between the column name and the = and the values. 2. try using columnname=value That works for me. On Thursday, May 16, 2002, at 09:59 AM, Daniel Lim wrote: Hi there, I have MySql version: 3.23.36 running on RedHat 7.1, it has been working

mixed up variables

. sven code: my $sth = $dbh-prepare( select * from memberscopy where name = '$f_name' and surname = '$f_surname' ); $sth-execute; #combine perl variables with data $sth-bind_col(1, \$u_id

Re: mixed up variables || solution found

Hi guys, just found a way that works, though it's not very elegant. (see below) and I do not know why it didn't work... Although it's working now, I'd still appreciate your comments. Regards, Sven code: while ( my ( $u_id, $u_surname, $u_name, $u_rank, $u_cname, $u_caddress

Replication

Hi ! Just read about the possibility of replicating two databses. Can you tell me how to do it or send me a (link to a) manual? Thanks, Sven On Monday, May 6, 2002, at 03:11 PM, Dicky Wahyu Purnomo wrote: On Mon, 6 May 2002 07:44:04 +0200 Ewan Sadie [EMAIL PROTECTED] wrote: I have installed

Re: MySQL on Mac OS X

on my box the following helped: (su to root) chown -R mysql /usr/local/mysql/var (check if this is the path to your mysql var ) (exit root) that should do it. also check in the user and host table if a connection from localhost is allowed for the specific user.. Cheers, Sven On Monday, May

newbie question:count() and display details

| | 1 | Maria | Austrian | Is there any way that I can get a line count of the result set and the details with onl one query? Thanks for your help! Sven - Before posting, please

Re: Cross server select into

an idea from a newbie, so do not put too much trust in it :) Sven On Monday, May 6, 2002, at 02:44 PM, Ewan Sadie wrote: I have installed MySQL on two of my MS-Proxy servers. I am logging all web browser logs to MySQL. I want to replicate the database to a central server where I can do queries

Transfer data/ Insert +select

me.hobbies, me.experi [..] from memberscopy me, priv_details pd where pd.id=me.id; What can i do? For help I would be really grateful!! Regards, Sven - Before posting, please check: http://www.mysql.com/manual.php (the manual

Poor Manual [Was: Why using filesort here?]

annotations that say in which version a feature was introduced (it's not nice to lookup every change in the ChangeLog). I suspected that the online version reflects the most recent stable not some development version. Regards Sven

Re: Poor Manual

On Sun, Apr 21, 2002 at 02:44:32PM +0200, Roger Baklund wrote: * Sven Huster This manual is f@#$% up, since it seems like there is no manual for stable versions online or at least some annotations that say in which version a feature was introduced (it's not nice to lookup every change

Service Control Manager

: 7031 Date: 4/14/2002 Time: 4:24:25 PM User: N/A Computer: SECRET Description: The MySql service terminated unexpectedly. It has done this 1 time(s). The following corrective action will be taken in 0 milliseconds: No action. Do you know what I can do to avoid this? Thanks Sven David

Why using filesort here?

the index without any additional sorting. btw: MySQL-3.23.49-max-log running on FreeBSD 4.4-RELEASE Thanks Regards Sven Huster - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

mysql daemon under macos X unstoppable?

this?? thanks a LOT for all help. Mit freundlichen Gruessen / Best regards Sven Hoffmann ___ thingk IT-Dienstleistungsgesellschaft mbH CAE-Support fuer EDS Informationstechnologie und Service GmbH Tel.: +49 33708-6-1465 Fax:+49 33708-6-3500 Email: [EMAIL

New world

Hello, I'm new in the world of MySQL and have a question: What Software can I use to programm MySQL clients for HTML(XML) or Java ? Is there a Software which is easy to use ? Thanks a lot for answering, Sven Hammann. - Before

gcc: can´t find executable

gcc can´t find executable. does anyone know some help for a beginner? thanx in advance sven MEGA Malereinkaufsgenossenschaft e.G. Sven Gauger, EDV-Abteilung Fangdieckstraße 45 22547 Hamburg office: 040 / 54004

Size of blobs?!

Hello! How do I get the size of a blob? I want to do something like this: SELECT * FROM blob_table WHERE size(blob_column) 1024; Best regards Sven -- --- ANDURAS AG - solutions for the NET http

NaN values displayed as 1.Q#NaN on Win32

are displayed as 1.Q#NaN. All normal double values work fine. (This has been observed with Window 98/NT and 2000). When I transfer the data back to Linux or Solaris they are still O.K. Does anybody know how to solve or workaround this problem ? Bye, Sven

Error 22 from isamchk and myisamchk

the db files to another computer (RedHat 6.2) isamchk doesn't complain but finds and repairs some errors. What is error 22 (Invalid argument?!) and how do I get around it? Sven M. Sorensen University of Southern Denmark - Before

Error 22 from isamchk and myisamchk

or repair. If I move the db files to another computer (RedHat 6.2 with mySQL 3.23.32) isamchk doesn't complain but finds and repairs some errors. What is error 22 (Invalid argument?!) and how do I get around it? Sven M. Sorensen University of Southern Denmark

RE: Enabling Logging of Slow Queries

i think the server does not run with privileges to write to /root regards Sven Huster Senior IT Systems Engineer Sven Huster Senior IT Systems Engineer -Original Message- From: Ryan Shrout [mailto:[EMAIL PROTECTED]] Sent: 30 August, 2001 20:51 To: [EMAIL PROTECTED] Subject

mysql died with innodb

= 1604185 K bytes of memory Hope that's ok, if not, decrease some variables in the equation 010615 08:09:27 mysqld ended System: FreeBSD 4.3-RELEASE MySQL: MySQL-Max-3.23.39 over nfs thanks regards Sven - Before posting, please

Re: auto_increment update

On Thu, Jun 14, 2001 at 07:30:01PM -0500, Paul DuBois wrote: *This message was transferred with a trial version of CommuniGate(tm) Pro* At 1:36 AM +0200 6/15/01, Sven Huster wrote: Hi there can i somehow easily recreate the auto_increment col if is was not correctly set? i just recognized

auto_increment update

regards Sven Huster - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail

RE: load-balancing with NFS

filer) regards Sven Huster Senior IT Systems Engineer -Original Message- From: Wouter de Jong [mailto:[EMAIL PROTECTED]] Sent: 13 June, 2001 10:21 To: [EMAIL PROTECTED] Subject: load-balancing with NFS *This message was transferred with a trial version of CommuniGate(tm) Pro

QS works if applied through phpMyAdmin but not from a PHP-Script

suggestions? Regards, Sven - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail

Re: Root password forgotten in MySQL

. Sandeep I think you can restart the server with --skip-grant-tables and change the password then. regards Sven Huster Senior IT Systems Administrator *BSD, Linux, Solaris - Before posting, please check: http

Re: Creating database

/Access_denied.html http://www.mysql.com/doc/G/R/GRANT.html Hope it helps regards Sven Huster Senior Unix System Administrator *BSD, Linux, Solaris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

mysql over nfs on netapp filer

Hi there, i anybody out there running mysql on a netapp filer as data storage? regards Sven Huster Senior Unix System Administrator *BSD, Linux, Solaris - Before posting, please check: http://www.mysql.com/manual.php

Re: mysql over nfs on netapp filer

Am 00:20 30.03.2001 schrieb Joshua Chamas: *This message was transferred with a trial version of CommuniGate(tm) Pro* Sven Huster wrote: Hi there, i anybody out there running mysql on a netapp filer as data storage? Yes, I've done this for a client from a linux server. Worked fine

Re: HASH tables...

application since 2 month, not temp tables. no problem so far. works quite stable and really fast. Sven Huster Senior Unix System Administrator *BSD, Linux, Solaris - Before posting, please check: http://www.mysql.com/manual.php

MySQL on NetApp Filer - Urgent Problem

cause everything else stays the same, but not more traffic on the db + if i switch the db of the cpu goes down to 1-5%. any ideas about this? MySQL server: FreeBSD 4-Stable regards Sven Huster Senior Unix System Administrator *BSD, Linux, Solaris

Re: MySQL on NetApp Filer - Urgent Problem

Sven Huster Senior Unix System Administrator *BSD, Linux, Solaris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail

Re: MySQL on NetApp Filer - Urgent Problem

Am 17:21 16.03.2001 schrieb Jeremy D. Zawodny: *This message was transferred with a trial version of CommuniGate(tm) Pro* On Fri, Mar 16, 2001 at 11:32:42AM +0100, Sven Huster wrote: Am 11:22 16.03.2001 schrieben Sie: *This message was transferred with a trial version of CommuniGate(tm) Pro

how do I contribute a binary distribution?

How do I post a new binary distribution for inclusion in the page http://www.mysql.com/downloads/mysql-3.23.html ? I would like to contribute a standard binary distribution for DEC OSF 4.0D (Alpha) [mysql-3.23.32-dec-osf4.0d-alphaev56]. Compiling mysql on this platform is a major pain,