Re: [Q] event for client?

on 2-d server. Changes go to the 1-st server by replication. And only then replication of this changes is done the cashes of data must be updated That is why I need the condition of changing some tables on 1-st table. Hi Andrey. Andrey Kotrekhov wrote: SQL Hello! Is there any way to inform

[Q] event for client?

second process? Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport тел. +380 562 34-00-44 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

SQL restore deleted records

. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport тел. +380 562 34-00-44 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SQL restore deleted records

. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport тел. +380 562 34-00-44 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mysql-4.1.8 library name bug

. Yes, this has been reported on this list a couple times already. Really baffling how this one made it out of QA. Thank you for your answer. Are there any plans to release snapshort bugfix? Josh On Thu, 23 Dec 2004 21:43:27 +0200 (EET) Andrey Kotrekhov [EMAIL PROTECTED] wrote: SQL Hello, All

Mysql-4.1.8 library name bug

4.1.7 compiled on the same PC at the same time with .so suffix in library names. Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport . +380 562 34-00-44 -- MySQL General Mailing List For list archives: http

Re: FreeBSD and MySQL - mysqld eats CPU alive

/[EMAIL PROTECTED] Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport . +380 562 34-00-44 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: FreeBSD and MySQL - mysqld eats CPU alive

because I need koi8 charset and etc... And I don't have any problem Andrey Kotrekhov [EMAIL PROTECTED] wrote: Did you compile mysql from source or you use precompiled binary package? I use mysql with different versions of FreeBSD without big problems. On FreeBSD, you can compile MySQL from ports. I have

[q] 4.1.2 Collation how to...

? Is this possible? May be it is bug? Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport . +380 562 34-00-44 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: collation problem

withanother charset as column 'price', but comparing two strings is possible only if they have identical charsets and collations . Thats all Andrey Kotrekhov wrote: . Andrey Kotrekhov wrote: SQL Hi, all! I have a problem after migration from 4.0.20 to 4.1.2 I have a table `analit

Re: FreeBSD 5.x

To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport . +380 562 34-00-44 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: FreeBSD 5.x

2004 ?. 16:09:38 EEST ?? DSA ? ID 663AF798 gpg: ?? ? ???: ?? ?? Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport . +380 562 34-00-44 -- MySQL General Mailing List

collation problem

) and (latin1_swedish_ci,COERCIBLE) for operation 'regexp' I can't find this in docs. I try to set LC_COLLATE in environtment variables like setenv LC_COLLATE ru_RU.KOI8-R But there isn't any result. What should I do? Best regards. ___ Andrey Kotrekhov [EMAIL

Re: MySQL and NPTL

archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport . +380 562 34-00-44 -- MySQL General Mailing List For list

Re: 4.0.X with 4.1.1

SQL Hi! Andrey Kotrekhov [EMAIL PROTECTED] wrote: SQL Hi, All! Is 4.1.1 replication compatible with 4.0.x? I have problem to replicate data from 4.0.17 to 4.1.1 show slave status show all are OK perlicate position and the exec position are the same. But if I update data

Re: 4.0.X with 4.1.1

For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport . +380 562 34-00-44 -- MySQL General Mailing List For list

Re: 4.0.X with 4.1.1

/ Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED

4.0.X with 4.1.1

. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport . +380 562 34-00-44 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Grant problem, existent grants ended to work (fwd)

working. Submitter-Id: submitter ID Originator:Andrey Kotrekhov Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis:existent grants ended to work Severity: serious Priority: high Category: mysql Class: sw-bug Release

Re: 100,000,000 row limit?

:http://lists.mysql.com/[EMAIL PROTECTED] Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport . +380 562 34-00-44 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Problem with replication

Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport . +380 562 34-00-44 -- MySQL General

Problem with replication

SQL Hi all! Nearly very night I have this problem. This query is done every 3 hours. But problem is happened only at 3:00 Both master and slave are 4 CPU (2 with HTT) computers. Both have mysql 4.0.16 And when I test table analit. There are many records which have the same conditions as in WHERE

Re: Repeated 100% CPU problem in FreeBSD

in the database which comes up clean. Any help would be appreciated. -- Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Best regards. ___ Andrey Kotrekhov

Re: SQL [Q] how to migrate 4.0 - 4.1

:http://lists.mysql.com/[EMAIL PROTECTED] Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport . +380 562 34-00-44 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: SQL [Q] how to migrate 4.0 - 4.1

. Andrey Kotrekhov [EMAIL PROTECTED] wrote: Hi, All. Other question is: Can I create case sensitive field with right ordering of national characters. Take a look at collation name: ci at the end of the collation name means case insensitive, cs - case sensitive, bin - binary

SQL [Q] how to migrate 4.0 - 4.1

on each field. I need old types on fields. How can I resolv this? Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport . +380 562 34-00-44 -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: SQL [Q] how to migrate 4.0 - 4.1

Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport . +380 562 34-00-44 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Best regards. ___ Andrey

Re: Replication question

SQL Andrey Kotrekhov [EMAIL PROTECTED] wrote: Sorry. I am wrong. Situation is worse. Both tables aren't replicate to the slave. But query try run it on slave :( slave: mysql-4.0.13 master: mysql-4.0.14 What replication options do you use? Full scheme

Replication question

? Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport . +380 562 34-00-44 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Replication question

tables A, B But slave has only A table The problem: query: UPDATE A,B SET A.a=B.a WHERE A.c=B.c; the result: crash replication on slave; Is it right? Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport

mysql 2 servers on 1 DB

regards. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport ÔÅÌ. +380 562 34-00-44 - Before posting, please check: http://www.mysql.com/manual.php (the manual

Re: mysql 2 servers on 1 DB

äÏÂÒÙÊ ÄÅÎØ. On Thu, Nov 14, 2002 at 02:44:47PM +0200, Andrey Kotrekhov wrote: Hi, All! sql Can I run 2 mysqld that use the same DB? Not replication , 1 DB on my HDD but 2 mysqld work with this DB. For example I have external RAID and I want decrease CPU usage. I run 2 mysqld

re: re: [Q] Replication temporary tables (fwd)

. AK What is the reason to replicate it? Andrey, you can use temporary tables in INSERT ... SELECT statement, in multi-table deletes etc. Thank you. I understand. Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport

re: [Q] Replication temporary tables (fwd)

a temporary table in one process, I can't use it in another. And after close connection table will destroy. What is the reason to replicate it? Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport ÔÅÌ. +380 562 34

[Q] Replication temporary tables (fwd)

sql,query Hello, All! Why is temporary tables replecated? Is it true? Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport ÔÅÌ. +380 562 34-00-44

[Q] about GRANT

Hello. In mysql tables Db, User, Host I can use templates as host ,for example. But can I use templates in tables_priv as table name? For example I want to set INSERT permission to H_% tables. How can I set it? Best regards. ___ Andrey Kotrekhov

Re: problem with libmysqlclient_r.so

. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport ÔÅÌ. +380 562 34-00-44 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: problem with libmysqlclient_r.so

libraries... -lstring - where can I find it? Is it -lmystrings ? Regards, Monty Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport ÔÅÌ. +380 562 34-00-44

Re: problem with libmysqlclient_r.so

äÏÂÒÙÊ ÄÅÎØ. Andrey Kotrekhov writes: Hi! % g++ -v Using builtin specs. gcc version 2.95.3 20010315 (release) [FreeBSD] And libstdc++ is include in compiller How can I see version of libstdc++ ? In /usr/src/contrib/libstdc++/Makefile.in I see VERSION = 2.10.0 INTERFACE = 3

Re: problem with libmysqlclient_r.so

. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport ÔÅÌ. +380 562 34-00-44 You have built it with debug on , so our debug caught some error caused by your program. If you link your program with our binary libmysqlclient_r, then if you run your program it will die

Re: problem with libmysqlclient_r.so

Hi! Andrey Kotrekhov writes: my program crash in another plase (gdb) bt #0 _db_enter_ (_func_=0x280fe4dc mysql_ping, _file_=0x280fdd48 libmysql.c, _line_=2248, _sfunc_=0xbfa87d3c, _sfile_=0xbfa87d40, _slevel_=0xbfa87d44, _sframep_=0xbfa87d48) at dbug.c:712 #1

Re: problem with libmysqlclient_r.so

. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport ÔÅÌ. +380 562 34-00-44 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: problem with libmysqlclient_r.so

PROTECTED] [EMAIL PROTECTED] - Original Message - From: Andrey Kotrekhov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, April 21, 2002 4:55 PM Subject: problem with libmysqlclient_r.so Hello, All! I have program which try to connect

Re: problem with libmysqlclient_r.so

äÏÂÒÙÊ ÄÅÎØ. Andrey Kotrekhov writes: Hello, All! I have program which try to connect to different mysql servers twice at the same time. When I use libmysqlclient.so sometimes one or two mysql connection freeze in mysql_real_connect But when I try to use libmysqlclient_r.so

problem with libmysqlclient_r.so

) p port $5 = 3306 (gdb) p socket_name $6 = 0x80c1bde (gdb) p client_flag $7 = 0 (gdb) OS FreeBSD 4.4-RC mysql version 3.23.42, but I try to use 3.23.49 with the same effect Will anybody help me? Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED

Re: FreeBSD+MySQL

Opened_tables stops increasing. We have table_cache=1024 Maybe this solve the problem. /var/db/mysql/my.cnf : [mysqld] set-variable = table_cache=512 -- Dan Nelson [EMAIL PROTECTED] Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED

Re: FreeBSD+MySQL

) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Best regards. ___ Andrey

RE: --How to dump only table structure with MySQLDump?

) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Best regards. ___ Andrey

[Q] why I get this message

Hi! Last time I sometimes get this messages: ERROR 1049: Unknown database 'stat Database exist and I put many records to tables in this DB. But sometimes I get this message. This DB have many tables, now ~730. Why I get this messages. Can I fix this? PS OS - FreeBSD 4.3-STABLE max open file -

Why not use indexes?

| NULL | NULL | | +-++--+--+-+---+-+--++-+ ___ Andrey Kotrekhov [EMAIL PROTECTED

Re: MySQL and PHP4

unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ___ Andrey Kotrekhov [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: mysql uses 99% cpu under freebsd 4.3

. ___ Andrey Kotrekhov [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Re: mysql uses 99% cpu under freebsd 4.3

] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ___ Andrey Kotrekhov [EMAIL PROTECTED] - Before posting, please check: http

problem under FreeBSD4.2-STABLE

all that I found in mysqladmin help. But any results. If I restart mysqld, it work fine and will work fine some days or week. After that this story will repeat. mysql-3.23.32 FreeBSD-4.2-STABLE Any ideas. Best regards. ___ Andrey Kotrekhov [EMAIL

[Q]index and data on different disks

? ___ Andrey Kotrekhov [EMAIL PROTECTED] - 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