Re: [Q] event for client?
Hi! Baron Schwartz wrote: The situation is more complicated. I have 2 servers and ring replication between them. On 1 server there is a process which cashes some data from DB (this decrease number of queries very match and increase performance). But sometimes there are some modification of data 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 mysql client application about changing in the some table. One process puts periodically record into the table. Second process waits new records. It is very expensive way to do SELECT from this table each second. Is there any other right way to inform second process? I was waiting to see if anyone else had any ideas, because I don't think my ideas are very good. I should say that I think this is generally a hard problem to solve with generic SQL, but I think some systems do support their own extensions to provide signalling or notification. In MySQL, the two things I can think of are: 1) make the polling more efficient. Instead of polling the table you're watching, have the inserting process set a flag in another, smaller table, and poll that table. Another thing you can do to make polling more efficient, when it is necessary, is use a variable wait time. Exponential or Fibonacci has worked well for me. For more on this, see http://www.xaprb.com/blog/2006/05/04/how-to-make-a-program-choose-an-optimal-polling-interval/ 2) Take advantage of things that use semaphores under the covers. The most obvious one for me is a string lock with GET_LOCK(). The waiting process and the polling process could get and release the lock to signal each other. Be careful though, as if you use more than one lock, there is a potential for deadlock, and if you don't there is a potential for race conditions. I have not implemented this myself, and think I would probably write something buggy on my first attempt, so these are just crude ideas. Cheers Baron -- Andrey Kotrekhov [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[Q] event for client?
SQL Hello! Is there any way to inform mysql client application about changing in the some table. One process puts periodically record into the table. Second process waits new records. It is very expensive way to do SELECT from this table each second. Is there any other right way to inform 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/[EMAIL PROTECTED]
SQL restore deleted records
SQL Hello, All. There is a problem. Ones many records from MyISAM table are deleted. Nobody change this table after this. The records have variable length. How can I restore it? The table format isn't well described in manual, as for me. 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: SQL restore deleted records
Добрый день. SQL Hello, All. There is a problem. Ones many records from MyISAM table are deleted. Nobody change this table after this. The records have variable length. How can I restore it? The table format isn't well described in manual, as for me. is not it possible to recover data from mysql binary log? (if it exists) insert statements must be there There isn't any log and backup :( -- 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] 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! IMHO this the bug in 4.1.8 to create library shared libraries without .so suffix. After this any programs linked with static libraries not dynamic, because of convention lib*.so.[0-9] in shared libraries names. ldconfig doesn't see new libraries at all too. This bug in 4.1.8 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://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 archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysql-4.1.8 library name bug
SQL Hello, All! IMHO this the bug in 4.1.8 to create library shared libraries without .so suffix. After this any programs linked with static libraries not dynamic, because of convention lib*.so.[0-9] in shared libraries names. ldconfig doesn't see new libraries at all too. This bug in 4.1.8 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://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: FreeBSD and MySQL - mysqld eats CPU alive
Did you compile mysql from source or you use precompiled binary package? I use mysql with different versions of FreeBSD without big problems. adp [EMAIL PROTECTED] wrote: I have several MySQL and FreeBSD installs across a few different sites, and I consistently have problems with mysqld. It will begin to eat up all of the CPU and eventually become unresponsive (or the machine will just burn). I can't seem to manually reproduce this, but given enough time a FreeBSD box with mysqld will go down. Running MySQL on FreeBSD requires some magic. One of the famous magicians is Jeremy Zawodny. Check his sacred MySQL-on-FreeBSD scriptures at http://jeremy.zawodny.com/blog/archives/cat_mysql.html I hope you will find a revelation there. ;) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / 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] 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: FreeBSD and MySQL - mysqld eats CPU alive
. Usually I run configure like this: ./configure \ --prefix=/usr/local/mysql_4 \ --without-debug \ --with-charset=koi8_ru \ --with-extra-charset=koi8_ukr,win1251,win1251ukr \ --with-mysqld-user=X \ --without-berkeley-db \ --without-isam \ --without-innodb \ --enable-thread-safe-client 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 several MySQL and FreeBSD installs across a few different sites, and I consistently have problems with mysqld. It will begin to eat up all of the CPU and eventually become unresponsive (or the machine will just burn). I can't seem to manually reproduce this, but given enough time a FreeBSD box with mysqld will go down. Running MySQL on FreeBSD requires some magic. One of the famous magicians is Jeremy Zawodny. Check his sacred MySQL-on-FreeBSD scriptures at http://jeremy.zawodny.com/blog/archives/cat_mysql.html I hope you will find a revelation there. ;) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / 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] 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]
[q] 4.1.2 Collation how to...
SQL Hi, All! This is configure scrypt haw I have compiled mysql 4.1.2 ./configure \ --prefix=/usr/local/mysql_4 \ --without-debug \ --with-charset=koi8r \ --with-collation=koi8r_general_ci \ --with-extra-charset=koi8u,cp1251 \ --with-mysqld-user=mysql \ --without-berkeley-db \ --without-isam \ --without-innodb \ --enable-thread-safe-client After that any programs using libmysqlclient has the problem with collation if they try compare char fields. I try ask query show variables and see: Variable_name=character_set_client Value=latin1 Variable_name=character_set_connection Value=latin1 Variable_name=character_set_databaseValue=koi8r Variable_name=character_set_results Value=latin1 Variable_name=character_set_server Value=koi8r Variable_name=character_set_system Value=utf8 Variable_name=character_sets_dir Value=/usr/local/mysql_4/share/mysql/charsets/ Variable_name=collation_connection Value=latin1_swedish_ci Variable_name=collation_databaseValue=koi8r_general_ci Variable_name=collation_server Value=koi8r_general_ci What options for configure should I set that my programs/clients have character_set_client and etc is set to koi8r ? 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://lists.mysql.com/[EMAIL PROTECTED]
Re: collation problem
SQL thank you. I found how to set koi8r charset for the server: to set default collation for configure. But how to build mysql client and client library that default client sharset is koi8r? It isn't useful to set this in my.cnf IMHO if I use only one charset for my application. I want something like client default characterset during a building the mysql :) Try commands : select charset('_R'); select collation('_R'); select charset('price') from analit ; select collation('price') from analit ; If this command does not return koi8r then client gives to server string 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`. this is the result of show create table: CREATE TABLE `analit` ( `d` date NOT NULL default '-00-00', `service` binary(16) NOT NULL default '', `price` char(50) NOT NULL default '', `type` char(50) NOT NULL default '', `val` double NOT NULL default '0', `city` char(16) NOT NULL default '', `VIP` int(11) NOT NULL default '0', `currency` char(8) NOT NULL default 'unit', `label` int(11) NOT NULL default '0', `status` int(11) NOT NULL default '0', PRIMARY KEY (`d`,`service`,`price`,`type`,`city`,`VIP`), KEY `city` (`city`), KEY `d` (`d`), KEY `label` (`label`) ) ENGINE=MyISAM DEFAULT CHARSET=koi8r The request return me a error: mysql select * from analit where price rlike '_R'; ERROR 1267 (HY000): Illegal mix of collations (koi8r_general_ci,IMPLICIT) 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 PROTECTED] ISP Alkar Teleport . +380 562 34-00-44 IMHO problem is when you try to check two differrent charsets, if _R is in a koi8r then you must try select * from analit where price rlike _koi8r '_R'; Hmm... I have koi8 charset under FreeBSD, and I have the same effect if I try to do: select * from analit where price='something'; The problem take place if I try to compare char field without binary flag. Any ideas. Maybe something was changed in my.cnf from 4.1.1 to 4.1.2, was it? Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport . +380 562 34-00-44 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: FreeBSD 5.x
SQL MySQL under FreeBSD 5.x works way much better than under FreeBSD 4.x but still not at production level. In my experience it works fine on a single CPU box and with relatively small tables. If the tables grow really big (tens of Gigs) and/or in SMP mode (including HT), then FreeBSD's behaviour is unacceptable. It randomly crashes in random places. Tested on 5.0, 5.1, 5.2, etc. Only linuxthreads tested, no KSE. We use FreeBSD-5.2.1 with one HT P4 processor. And mysql-4.1.1 with KSE. There are many tables ~0.5G and some ~1.1G They unite into merge table. (near 1000 000 000 records in summary :) ) This work without crash for me. But mysqld with KSE doesn't shutdown under havy loading. But I wrote this before. Peter Zyumbilev -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / 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] 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: FreeBSD 5.x
Hi. SQL I use mysql-4.0.X under FreeBSD-5.2.1 There is no problem with libc_r. But under heavy loading with kse mysqld doesn't shutdown. This problem isn't only with kse. It was discussed some weeks ago. And if I remember it is exist with any other pthreads and under linux too. With kse mysql do concurrent selects more faster on MyISAM tables. For example: the same 2 selects with kse - 11 sec the same 2 selects with c_r - ~18 sec Peter wrote: | Hi, | Thanks for the reply :-)) | Any corruptions on MyIsam tables ? Cause in my case tables seems to | crash a lot on the freebsd machines, processor almost die on 4.x ... | Nothing like this. I have a lot of MyISAM tables and a view InnoDB Tables. There was no crash since April. So long... Gerrit -- beine computer support f?r open source software seumestrasse 82 08525 plauen fon: 0049 3741 404 837 fax: 0049 3741 404 839 gsm: 0049 178 279 48 32 mail: [EMAIL PROTECTED] url: http://www.beine-computer.de icq: 123851585 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Output from gpg gpg: /home/kota/.gnupg/options:112: ?? ? ? honor-http-proxy gpg: ??? keyserver-options honor-http-proxy ?? gpg: ???: ??! gpg: ??? ?? ?? ??. http://www.gnupg.org/faq.html gpg: ??? ??? ???, 6 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 For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
collation problem
SQL Hi, all! I have a problem after migration from 4.0.20 to 4.1.2 I have a table `analit`. this is the result of show create table: CREATE TABLE `analit` ( `d` date NOT NULL default '-00-00', `service` binary(16) NOT NULL default '', `price` char(50) NOT NULL default '', `type` char(50) NOT NULL default '', `val` double NOT NULL default '0', `city` char(16) NOT NULL default '', `VIP` int(11) NOT NULL default '0', `currency` char(8) NOT NULL default 'unit', `label` int(11) NOT NULL default '0', `status` int(11) NOT NULL default '0', PRIMARY KEY (`d`,`service`,`price`,`type`,`city`,`VIP`), KEY `city` (`city`), KEY `d` (`d`), KEY `label` (`label`) ) ENGINE=MyISAM DEFAULT CHARSET=koi8r The request return me a error: mysql select * from analit where price rlike '_R'; ERROR 1267 (HY000): Illegal mix of collations (koi8r_general_ci,IMPLICIT) 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 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 and NPTL
SQL I have the problem like this under FreeBSD 5.2 with libkse (kernel threads). Server with high loading doesn't want to shutdown. But server with low loading does. Steve, I have had this same problem exept the entire server does not hang, only one thread which experiences a signficiat slowdown. This happens a couple times a week for our 4 servers. I believe this is a thread scheduling issue. The mysql support team suggests against using NPTL. However, I use mysqld-max on redhat linux 9.0 and have found a 10-20% performance difference at HIGH (hundreds of connections) load levels. The support team claims the difference in performance between linux threads and NPTL is never significant. Incidentally I have experinced this same thread starvation issue on redhat as 3.0 amd64 while using Linux threads. Theory is that glic 2.3 is to blame ( redhat 9.0 - glibc-2.3.2-11.9 , redhat as 3.0 - glibc-2.3.2-95.6 ). So the version of glibc looks to be the culprit. As I understand it Mysql is working with Redhat to determine the issues with glibc 2.3. I haven't tried the export line. Trevor Steve Meyers wrote: Has anyone else experienced this bug? http://bugs.mysql.com/bug.php?id=868 We've been seeing this problem on several of our servers (see the last comment to the bug). MySQL just hangs occasionally, it happens about 3-4 times per month. We have 13 database servers, so that unfortunately increases our odds. I just wondered how many other people have seen it, and if the suggested export LD_ASSUME_KERNEL=2.2.5; mysqld_safe has worked for anyone. In order to turn that on, I will need to take our site down completely, which is (of course) not desirable. Thanks! Steve Meyers -- 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] 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: 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 on master, slave is not update own data :( What replication options do you use? Check if queries are present in the master binary logs and in the relay logs on the slave. I research the problem and have got some details. Now we have this theme of mysqld replication (with server ids) +-+ +--+-1| 4 | | ^-| | | 5-+ +--6 And when I update something server 1 query relicates to the servers 5,6,4 But when I update the same table in server 4 query replicates to the server 1 but doesn't replicate to the servers 5 and 6. Servers 1,4 has version 4.0.17. Servers 5,6 has version 4.1.1 Is it a bug? Can anybody repeat it? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / 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] 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: 4.0.X with 4.1.1
. What replication options do you use? Check if queries are present in the master binary logs and in the relay l= ogs on the slave. I research the problem and have got some details. Now we have this theme of mysqld replication (with server ids) +-+ +--+-1| 4 | | ^-| | | 5-+ +--6 And when I update something server 1 query relicates to the servers 5,6,4 But when I update the same table in server 4 query replicates to the server 1 but doesn't replicate to the servers 5 and 6. Servers 1,4 has version 4.0.17. Servers 5,6 has version 4.1.1 Is it a bug? Can anybody repeat it? Did you run server 1 with --log-slave-updates option? No. But I can restart mysqld with this option. Should I do this? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / 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] 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: 4.0.X with 4.1.1
What replication options do you use? Check if queries are present in the master binary logs and in the relay l= ogs on the slave. I research the problem and have got some details. Now we have this theme of mysqld replication (with server ids) +-+ +--+-1| 4 | | ^-| | | 5-+ +--6 And when I update something server 1 query relicates to the servers 5,6,4 But when I update the same table in server 4 query replicates to the server 1 but doesn't replicate to the servers 5 and 6. Servers 1,4 has version 4.0.17. Servers 5,6 has version 4.1.1 Is it a bug? Can anybody repeat it? Did you run server 1 with --log-slave-updates option? No. But I can restart mysqld with this option. Should I do this? Thank you very much. Problem has been resolved -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / 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] 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 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]
4.0.X with 4.1.1
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 on master, slave is not update own data :( 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]
Grant problem, existent grants ended to work (fwd)
SQL Description: User has ALL grants to the database. mysql show grants for [EMAIL PROTECTED]; +--- --+ | Grants for [EMAIL PROTECTED] | +--- --+ | GRANT USAGE ON *.* TO '_ANALIT_'@'XXX.XXX.XXX.XXX' IDENTIFIED BY PASSWORD 'yyy y' | | GRANT ALL PRIVILEGES ON `atas`.* TO '_ANALIT_'@'XXX.XXX.XXX.XXX' | +--- --+ 2 rows in set (0.00 sec) I create two connection to the server from host XXX.XXX.XXX.XXX. The first for read, the second for write(replace, update, insert) This works near 1 day. But after near 1 day grants lost. And I have: mysql insert into analit set label=10; ERROR 1142: insert command denied to user: '[EMAIL PROTECTED]' for table 'analit' Show grants on the server shows the same as above show grants. All grants tables are checked without error. After restarting mysqld, grants work again. How-To-Repeat: Fix: I don't know. But restarting server restore grants 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:mysql-4.0.17 (Source distribution) Server: /usr/local/mysql/bin/mysqladmin Ver 8.40 Distrib 4.0.17, for unknown-freebsd4.8 on i386 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 4.0.17-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 1 day 20 hours 47 min 54 sec Threads: 11 Questions: 5071868 Slow queries: 951 Opens: 589 Flush tables: 3 Open tables: 157 Queries per second avg: 31.449 C compiler:2.95.4 C++ compiler: 2.95.4 Environment: System: FreeBSD 4.8-STABLE FreeBSD 4.8-STABLE #0: Fri Aug 22 15:44:48 EEST 2003 i386 2 CPU Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.4 20020320 [FreeBSD] Compilation info: CC='gcc' CFLAGS='-O3 -mpentiumpro' CXX='gcc' CXXFLAGS='-O3 -felide-constructors -fno-exceptions -fno-rtti -mpentiumpro' LDFLAGS='' ASFLAGS='' LIBC: -r--r--r-- 1 root wheel 1224554 22 16:02 /usr/lib/libc.a lrwxr-xr-x 1 root wheel 9 22 16:02 /usr/lib/libc.so - libc.so.4 -r--r--r-- 1 root wheel 578880 22 16:02 /usr/lib/libc.so.4 Configure command: ./configure '--prefix=/usr/local/mysql' '--without-debug' '--enable-thread-safe-client' '--with-mysqld-ldflags=-all-static' '--enable-assembler' '--with-charset=koi8_ru' '--with-extra-charset=koi8_ukr' '--with-mysqld-user=mysql' '--without-berkeley-db' '--without-isam' '--without-innodb' 'CFLAGS=-O3 -mpentiumpro' 'CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti -mpentiumpro' 'CXX=gcc' Perl: This is perl, version 5.005_03 built for i386-freebsd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 100,000,000 row limit?
SQL :) We have ~1 200 000 000 rows in one MyISAM table. And it works :) I don't believe this. I'm going to write a script to disprove this theory right now.. We have a lot more than 100,000,000 more than that in a single MyISAM table at work: mysql select count(*) from probe_result; +---+ | count(*) | +---+ | 302045414 | +---+ 1 row in set (0.00 sec) -- thanks, Will -- 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] 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: Problem with replication
SQL Hi! Does anybody have any solution? I change time where query run. Each new day where query run first ones in day replication crash. Slave start on slave server restore replication. How can it be? I have no any ideas. Both servers have 4.0.16 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 statement. This records are inserted into analit before this UPDATE. UPDATE finds records on master, I have checked the records on master and I see the result of UPDATE. But there is the error on slave server. If I run any query on analit like select count(*) from analit where label=1070931600 and after this SLAVE STOP; SLAVE START problem is solved. Is it a bug in server? Can mysqld break the order of replication query on multy-CPU computers? Any ideas, please. ++-+-+---+ -+-+--+---+ ---+--+---+ -+-++ - - - - - +--+- +-+ _ Master_Host_ Master_User _ Master_Port _ Connect_retry _ Master_Log_File _ Read_Master_Log_Pos _ Relay_Log_File _ Relay_Log_Pos _ Relay_Master_Log_File _ Slave_IO_Running _ Slave_SQL_Running _ Replicate_do_db _ Replicate_ignore_db _ Last_errno _ Last_error _ Skip_counter _ Exec_master_log_pos _ Relay_log_space _ ++-+-+---+ -+-+--+---+ ---+--+---+ -+-++ - - - - - +--+-+ -+ _ XXX _ Z _ _ 60_ a0-bin.029 _ 2210728 _ a1-relay-bin.001 _ 5880071 _ a0-bin.029 _ Yes _ No_ atas_ _ 1032 _ Error 'Can't find record in 'analit'' on query 'UPDATE analit, price_grp SET analit.status=price_grp.status, analit.currency=price_grp.currency WHERE analit.price=price_grp.price AND analit.service=price_grp.service AND analit.city=price_grp.city AND label=1070931600'. Default database: '' _ 0_ 2210187 _ 5880612 _ -- 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] 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]
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 statement. This records are inserted into analit before this UPDATE. UPDATE finds records on master, I have checked the records on master and I see the result of UPDATE. But there is the error on slave server. If I run any query on analit like select count(*) from analit where label=1070931600 and after this SLAVE STOP; SLAVE START problem is solved. Is it a bug in server? Can mysqld break the order of replication query on multy-CPU computers? Any ideas, please. ++-+-+---+ -+-+--+---+ ---+--+---+ -+-++ - - - - - +--+- +-+ _ Master_Host_ Master_User _ Master_Port _ Connect_retry _ Master_Log_File _ Read_Master_Log_Pos _ Relay_Log_File _ Relay_Log_Pos _ Relay_Master_Log_File _ Slave_IO_Running _ Slave_SQL_Running _ Replicate_do_db _ Replicate_ignore_db _ Last_errno _ Last_error _ Skip_counter _ Exec_master_log_pos _ Relay_log_space _ ++-+-+---+ -+-+--+---+ ---+--+---+ -+-++ - - - - - +--+-+ -+ _ XXX _ Z _ _ 60_ a0-bin.029 _ 2210728 _ a1-relay-bin.001 _ 5880071 _ a0-bin.029 _ Yes _ No_ atas_ _ 1032 _ Error 'Can't find record in 'analit'' on query 'UPDATE analit, price_grp SET analit.status=price_grp.status, analit.currency=price_grp.currency WHERE analit.price=price_grp.price AND analit.service=price_grp.service AND analit.city=price_grp.city AND label=1070931600'. Default database: '' _ 0_ 2210187 _ 5880612 _ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Repeated 100% CPU problem in FreeBSD
SQL I have the same situation. I set skip-name-resolve in my.cnf. But sometimes mysqld get all CPU. I can't notice strong dependences between name resoving and mysqld stuped. Hello, Most of the time, MySQL 4.0.16 runs absolutely fine on my FreeBSD 4.9 system. However, today, unexplicably, it's run into the same problem 3 times now; a couple of the threads suddenly start eating 100% CPU for no good reason while doing a SELECT. They'll sit there until I kill them, which results in a lot of hair tearing as it comes back up checking all the tables. I haven't been able to produce a core despite sending it a SIGABRT, but I'll try recompiling with -g (do the supplied binaries have this?) soon. Pretty much all I can find around that might contribute relates to the poor threading implementation on FreeBSD and the name resolving issue. I should have worked around both of them; I've built with linuxthreads, and I have skip-name-resolve in my.cnf. Does *anyone* have any clues why this randomly happens? It had been fine for 30 or so days prior to this, and today it's crashed 3 times in this way. I've recently run a myisamchk -r *.MYI over all the tables 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 [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 [Q] how to migrate 4.0 - 4.1
. Thank you. But what is about binary fields? When I start mysqld-4.0.. field in table are char(x) binary. But when I start mysql-4.1.0 in the same table the same field is not binary. Is this bug? Nope. From the v4.1 BINARY means that no collation is applicable to the column. I understand this and I want this. But my binary fields under 4.1.0 loss binary flag. But under 4.0.12 they have it (the fields in same tables). I head the 4.1.1 version will fix this Or is there right way to restore binary flag on field. Use collation with _bin at the end of collation name. It is fine for new tables, but I say about tables created under 4.0.X and after migration to 4.1.0 they loss binary flags on their fields. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / 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] 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 [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: http://www.mysql.com/doc/en/Charset-MySQL.html Thank you. But what is about binary fields? When I start mysqld-4.0.. field in table are char(x) binary. But when I start mysql-4.1.0 in the same table the same field is not binary. Is this bug? Or is there right way to restore binary flag on field. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / 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] 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]
SQL [Q] how to migrate 4.0 - 4.1
SQL mysql HI, All! I have a question. I migrate from 4.0.14 to 4.1.0 but: the 4.0.14 show me: mysql desc statname; +--+-+--+-+-+---+ | Field| Type| Null | Key | Default | Extra | +--+-+--+-+-+---+ | statname | char(16) binary | | PRI | unknown | | | passwd | char(64) binary | | | * | | | env | char(10)| | | | | | area | int(11) | | | 0 | | | manager | char(16) binary | | | | | | d_create | datetime| | | -00-00 00:00:00 | | | d_change | datetime| | | -00-00 00:00:00 | | | wizard | int(11) | | | 0 | | +--+-+--+-+-+---+ And 4.1.0 show me on the sane table: mysql mysql desc statname; +--+--+--+--+-+-+---+ | Field| Type | Collation| Null | Key | Default | Extra | +--+--+--+--+-+-+---+ | statname | char(16) character set koi8r | koi8r_general_ci | | PRI | unknown | | | passwd | char(64) character set koi8r | koi8r_general_ci | | | * | | | env | char(10) character set koi8r | koi8r_general_ci | | | | | | area | int(11) | binary | | | 0 | | | manager | char(16) character set koi8r | koi8r_general_ci | | | | | | d_create | datetime | koi8r_general_ci | | | -00-00 00:00:00 | | | d_change | datetime | koi8r_general_ci | | | -00-00 00:00:00 | | | wizard | int(11) | binary | | | 0 | | +--+--+--+--+-+-+---+ But where is my binary flags? Select use fields as binary. But I don't want binary 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/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SQL [Q] how to migrate 4.0 - 4.1
SQL mysql Hi, All. Other question is: Can I create case sensitive field with right ordering of national characters. HI, All! I have a question. I migrate from 4.0.14 to 4.1.0 but: the 4.0.14 show me: mysql desc statname; +--+-+--+-+-+---+ | Field| Type| Null | Key | Default | Extra | +--+-+--+-+-+---+ | statname | char(16) binary | | PRI | unknown | | | passwd | char(64) binary | | | * | | | env | char(10)| | | | | | area | int(11) | | | 0 | | | manager | char(16) binary | | | | | | d_create | datetime| | | -00-00 00:00:00 | | | d_change | datetime| | | -00-00 00:00:00 | | | wizard | int(11) | | | 0 | | +--+-+--+-+-+---+ And 4.1.0 show me on the sane table: mysql mysql desc statname; +--+--+--+--+-+-+---+ | Field| Type | Collation| Null | Key | Default | Extra | +--+--+--+--+-+-+---+ | statname | char(16) character set koi8r | koi8r_general_ci | | PRI | unknown | | | passwd | char(64) character set koi8r | koi8r_general_ci | | | * | | | env | char(10) character set koi8r | koi8r_general_ci | | | | | | area | int(11) | binary | | | 0 | | | manager | char(16) character set koi8r | koi8r_general_ci | | | | | | d_create | datetime | koi8r_general_ci | | | -00-00 00:00:00 | | | d_change | datetime | koi8r_general_ci | | | -00-00 00:00:00 | | | wizard | int(11) | binary | | | 0 | | +--+--+--+--+-+-+---+ But where is my binary flags? Select use fields as binary. But I don't want binary 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/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 archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 is: | +-A| C | -| | +-B Configuration A: server-id = 4 master-host=XXX master-user=XXX master-password=XXX master-port=3306 replicate-do-db=ZZ master-connect-retry=60 log-slave-updates = Configuration B: server-id = 3 user= mysql master-host = 195.248.191.22 master-user = ghsdr_repl master-password = Dtp6TrH master-port = 3306 replicate-do-db = ZZ replicate-do-table = ZZ.counter replicate-do-table = ZZ.counter_price replicate-do-table = ZZ.reserv_unit replicate-do-table = ZZ.service replicate-do-table = ZZ.ppp_utmp replicate-do-table = ZZ.net replicate-do-table = ZZ.service_net But there are no tables A and B in replicate-do-table list. I have 2 servers. 1-st is master, 2-d - slave. But slave store only some tables of master. For example, master has 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; -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / 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] 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]
Replication question
Hi, All! SQL, mysql I have 2 servers. 1-st is master, 2-d - slave. But slave store only some tables of master. For example, master has 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 . +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
Hi, All! SQL, mysql 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 I have 2 servers. 1-st is master, 2-d - slave. But slave store only some tables of master. For example, master has 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 . +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 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]
mysql 2 servers on 1 DB
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 on different servers, but they use 1 DB. Is this possible? Sorry for my english. Best 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) 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
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 on different servers, but they use 1 DB. Is this possible? If you enable MySQL's extenal locking support, yes. But how safe is this? Is this work at all? In manual I see strong warning: WARNING: Normally you should never have two servers that update data in the same database! If your OS doesn't support fault-free system locking, this may lead to unpleasant surprises! What will be happened when I update some records throw 1-st server and select the same records throw 2-d server? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 100 days, processed 2,121,676,852 queries (244/sec. avg) Best 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) 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
re: re: [Q] Replication temporary tables (fwd)
äÏÂÒÙÊ ÄÅÎØ. Yes, temporary table are replicated properly since 3.23.29: http://www.mysql.com/doc/en/Replication_Features.html AK Hmm... What is the reason? AK If I create a temporary table in one process, I can't use it in another. AK And after close connection table will destroy. 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 ÔÅÌ. +380 562 34-00-44 - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: [Q] Replication temporary tables (fwd)
äÏÂÒÙÊ ÄÅÎØ. sql Andrey, Tuesday, October 01, 2002, 11:53:41 AM, you wrote: AK Why is temporary tables replecated? AK Is it true? Yes, temporary table are replicated properly since 3.23.29: http://www.mysql.com/doc/en/Replication_Features.html Hmm... What is the reason? If I create 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-00-44 - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[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 - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[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 [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/ (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
Re: problem with libmysqlclient_r.so
Hi! Under FreeBSD gethostbyname is not thread-safe And there is no thread-safe gethostbyname_r (function exist but not thread-safe) Are mysql know about this!!! Just a note about this problem: We will add a wrapper for gethostbyname() in 3.23.51 and the 4.0.2 that will fix things for OS where gethostbyname is not threadsafe. Thank you very mach. And now I use libmysqlclient.so and each mysql_real_connect include in pthread_mutex_lock(), pthread_mutex_unlock() construction. :) It helps me in thread programs. Regards, Monty Best 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) 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
Re: problem with libmysqlclient_r.so
äÏÂÒÙÊ ÄÅÎØ. Andrey Are mysql know about this!!! Sorry but if your OS doesn't support gethostbyname_r(), then mysql_real_connect() is not thread safe (I have just updated our documentation about this) Thank you. Another issue is that if your client dies in the dbug_ code, this means that you have probably not followed the instructions in the manual section: 'How to Make a Threaded Client' For example, have you called mysql_thread_init() before calling mysql_real_connect() in all your threads ? Hmm... I use mysql_init() in each thread but: 8.4.4.4 my_thread_init() . This is automatically called by my_init() and mysql_connect(). ~ And in manual: To get a threaded client where you can interrupt the client from other threads and set timeouts when talking with the MySQL server, you should use the -lmysys, -lstring, and -ldbug 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 - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 Is there right? Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport ÔÅÌ. +380 562 34-00-44 - Compiler is OK. But your program is multithreaded, so check with `ldd` whether you have linked in libstdc++ ... I think problem is in libmysqlclient_r.so becouse I compile program which work fine many month with libmysqlclient_r. And program died in the same place. #0 _db_enter_ (_func_=0x28252311 mysql_real_query, _file_=0x28251d48 libmysql.c, _line_=1784, _sfunc_=0xbfafa80c, _sfile_=0xbfafa810, _slevel_=0xbfafa814, _sframep_=0xbfafa818) at dbug.c:712 712 *_sfunc_ = state-func; (gdb) p _sfunc_ $1 = (char **) 0x0 (gdb) p state-func Cannot access memory at address 0x8. (gdb) this is configure parameters ./configure \ --prefix=/usr/local/mysql \ --with-debug \ --with-charset=koi8_ru \ --with-extra-charset=koi8_ukr,win1251,win1251ukr \ --with-mysqld-user=mysql \ --without-berkeley-db \ --with-innodb \ --enable-thread-safe-client -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com Best 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) 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
Re: problem with libmysqlclient_r.so
Hi! äÏÂÒÙÊ ÄÅÎØ. I think problem is in libmysqlclient_r.so becouse I compile program which work fine many month with libmysqlclient_r. And program died in the same place. #0 _db_enter_ (_func_=0x28252311 mysql_real_query, _file_=0x28251d48 libmysql.c, _line_=1784, _sfunc_=0xbfafa80c, _sfile_=0xbfafa810, _slevel_=0xbfafa814, _sframep_=0xbfafa818) at dbug.c:712 712 *_sfunc_ = state-func; (gdb) p _sfunc_ $1 = (char **) 0x0 (gdb) p state-func Cannot access memory at address 0x8. (gdb) Best regards. ___ 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 in mysql_real_query, instead in _db_enter. This is most likely a consequence of some error in your program. I am not agree. I take _another program_ which work fine during ~2 year with previouse mysql version (mysql-3.23.44 for example). And I send dump from this program. Why I interested libmysqlclient_r? I have a program, which try to connect to mysql twice. But the second connection freeze in mysql_real_connect. I use libmysqlclient.so (mysql-3.23.42 FreeBSD-4.4RC) I try to upgrade to mysql-3.23.49 and use mysqlclient_r on test computer and have many problems (I write about their before). But now I attach to working process which freese and see: (gdb) bt #0 0x18237970 in _thread_kern_sched () from /usr/lib/libc_r.so.4 #1 0x182382d2 in _thread_kern_sched_state () from /usr/lib/libc_r.so.4 #2 0x1823b791 in _thread_fd_lock_debug () from /usr/lib/libc_r.so.4 #3 0x1826df86 in _close () from /usr/lib/libc_r.so.4 #4 0x1823eb72 in _res_close () from /usr/lib/libc_r.so.4 #5 0x1823dc49 in res_send () from /usr/lib/libc_r.so.4 #6 0x182418ad in res_query () from /usr/lib/libc_r.so.4 #7 0x18241d88 in res_querydomain () from /usr/lib/libc_r.so.4 #8 0x18241aca in res_search () from /usr/lib/libc_r.so.4 #9 0x1824d692 in _gethostbydnsname () from /usr/lib/libc_r.so.4 #10 0x1824c14c in gethostbyname2 () from /usr/lib/libc_r.so.4 #11 0x1824c0c9 in gethostbyname () from /usr/lib/libc_r.so.4 ~~~ #12 0x180e7cdc in mysql_real_connect () from /usr/local/mysql/lib/libmysqlclient.so.10 #13 0x1812f93c in MysqlConnection::real_connect (this=0x80c9c18, db=0x80fe8b0 zzz, host=0x80fb040 xxx.xxx.xxx, user=0x80fe910 xxx, passwd=0x80c26aa , port=3306, compress=1, connect_timeout=60, socket_name=0x80c26be , client_flag=0) at connection.cc:52 #14 0x808384f in QueueModule::Run (this=0x80c9c00) at QModule.cc:166 #15 0x8068a8b in start_Module (ptr=0x80c9c00) at Module.cc:23 #16 0x181fce73 in _thread_start () from /usr/lib/libc_r.so.4 #17 0x0 in ?? () Under FreeBSD gethostbyname is not thread-safe And there is no thread-safe gethostbyname_r (function exist but not thread-safe) Are mysql know about this!!! -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Best 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) 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
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 0x280eceae in mysql_ping (mysql=0x80c9c1c) at libmysql.c:2248 #2 0x80832d2 in QueueModule::Run (this=0x80c9c00) at /usr/local/mysql++/include/connection1.hh:80 #3 0x8068b2f in start_Module (ptr=0x80c9c00) at Module.cc:23 #4 0x282063af in _thread_start () from /usr/lib/libc_r.so.4 #5 0x0 in ?? () (gdb) p state $1 = (CODE_STATE *) 0x0 (gdb) why code_state() return NULL? Is this right? Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport ÔÅÌ. +380 562 34-00-44 Does not seem like our bug ! Because last time it crashed in a completely different place. Plus, it I change version MySQL, maybe this is the reason? is unlikely that it would crash in ping. Check out your compiler version and whether libstdc++ got linked into the binary. % 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 Is there right? Best 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) 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
Re: problem with libmysqlclient_r.so
äÏÂÒÙÊ ÄÅÎØ. program crash in my_fopen this is stack of program : (gdb) bt #0 0x180ef7f2 in my_fopen () from /usr/local/mysql/lib/libmysqlclient_r.so.10 #1 0x180f0b20 in search_default_file () from /usr/local/mysql/lib/libmysqlclient_r.so.10 [skip] Hi! First of all, what version of limysql are you using ?? OK. I got mysql-3.23.49, configure it: ./configure \ --prefix=/usr/local/mysql \ --with-debug \ --with-charset=koi8_ru \ --with-extra-charset=koi8_ukr,win1251,win1251ukr \ --with-mysqld-user=mysql \ --without-berkeley-db \ --with-innodb \ --enable-thread-safe-client OS: FreeBSD 4.5-STABLE (cvsup today :) ) 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 0x280eceae in mysql_ping (mysql=0x80c9c1c) at libmysql.c:2248 #2 0x80832d2 in QueueModule::Run (this=0x80c9c00) at /usr/local/mysql++/include/connection1.hh:80 #3 0x8068b2f in start_Module (ptr=0x80c9c00) at Module.cc:23 #4 0x282063af in _thread_start () from /usr/lib/libc_r.so.4 #5 0x0 in ?? () (gdb) p state $1 = (CODE_STATE *) 0x0 (gdb) why code_state() return NULL? Is this right? Second, please do : frame 1 and let us know the values for the following parameters : const char *dir, const char *config_file, const char *ext, TYPELIB *group) Best 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) 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
Re: problem with libmysqlclient_r.so
Hi, I use mysql++ And each object Connection use own MYSQL mysql; mysql_init called in Connection constructor. Hi, You use and two different mysql_init ? Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL 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 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 program crash in my_fopen this is stack of program : (gdb) bt #0 0x180ef7f2 in my_fopen () from /usr/local/mysql/lib/libmysqlclient_r.so.10 #1 0x180f0b20 in search_default_file () from /usr/local/mysql/lib/libmysqlclient_r.so.10 #2 0x180f085f in load_defaults () from /usr/local/mysql/lib/libmysqlclient_r.so.10 #3 0x180e776b in mysql_read_default_options () from /usr/local/mysql/lib/libmysqlclient_r.so.10 #4 0x180e8054 in mysql_real_connect () from /usr/local/mysql/lib/libmysqlclient_r.so.10 #5 0x1812f940 in MysqlConnection::real_connect (this=0x80c8c18, db=0x80fd8b0 kuku, host=0x80fa040 xxx.xxx.net, user=0x80fd910 test, passwd=0x80c1bca , port=3306, compress=1, connect_timeout=60, socket_name=0x80c1bde , client_flag=0) at connection.cc:52 #6 0x8082dc3 in QueueModule::Run (this=0x80c8c00) at QModule.cc:138 #7 0x8068a8f in start_Module (ptr=0x80c8c00) at Module.cc:23 #8 0x181fce73 in _thread_start () from /usr/lib/libc_r.so.4 #9 0x0 in ?? () (gdb) frame 5 #5 0x1812f940 in MysqlConnection::real_connect (this=0x80c8c18, db=0x80fd8b0 stat, host=0x80fa040 skynet.alkar.net, user=0x80fd910 stat, passwd=0x80c1bca , port=3306, compress=1, connect_timeout=60, socket_name=0x80c1bde , client_flag=0) at connection.cc:52 52 if (mysql_real_connect(mysql,host,user,passwd,db, port,socket_name,client_flag)) (gdb) p host $1 = (cchar *) 0x80fa040 xxx.xxx.net (gdb) p user $2 = (cchar *) 0x80fd910 test (gdb) p passwd $3 = (cchar *) 0x80c1bca (gdb) p db $4 = (cchar *) 0x80fd8b0 kuku (gdb) 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] ISP Alkar Teleport ÔÅÌ. +380 562 34-00-44 - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Best 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) 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
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 program crash in my_fopen this is stack of program : (gdb) bt #0 0x180ef7f2 in my_fopen () from /usr/local/mysql/lib/libmysqlclient_r.so.10 #1 0x180f0b20 in search_default_file () from /usr/local/mysql/lib/libmysqlclient_r.so.10 [skip] Hi! First of all, what version of limysql are you using ?? ? this example is from mysql 3.23.42 libmysqlclient_r.so.10 Second, please do : frame 1 and let us know the values for the following parameters : const char *dir, const char *config_file, const char *ext, TYPELIB *group) #1 0x180f0b20 in search_default_file () from /usr/local/mysql/lib/libmysqlclient_r.so.10 Will I need to compile mysql with --with-debug option to see parameters? 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] ISP Alkar Teleport ÔÅÌ. +380 562 34-00-44 -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com Best 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) 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
problem with libmysqlclient_r.so
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 program crash in my_fopen this is stack of program : (gdb) bt #0 0x180ef7f2 in my_fopen () from /usr/local/mysql/lib/libmysqlclient_r.so.10 #1 0x180f0b20 in search_default_file () from /usr/local/mysql/lib/libmysqlclient_r.so.10 #2 0x180f085f in load_defaults () from /usr/local/mysql/lib/libmysqlclient_r.so.10 #3 0x180e776b in mysql_read_default_options () from /usr/local/mysql/lib/libmysqlclient_r.so.10 #4 0x180e8054 in mysql_real_connect () from /usr/local/mysql/lib/libmysqlclient_r.so.10 #5 0x1812f940 in MysqlConnection::real_connect (this=0x80c8c18, db=0x80fd8b0 kuku, host=0x80fa040 xxx.xxx.net, user=0x80fd910 test, passwd=0x80c1bca , port=3306, compress=1, connect_timeout=60, socket_name=0x80c1bde , client_flag=0) at connection.cc:52 #6 0x8082dc3 in QueueModule::Run (this=0x80c8c00) at QModule.cc:138 #7 0x8068a8f in start_Module (ptr=0x80c8c00) at Module.cc:23 #8 0x181fce73 in _thread_start () from /usr/lib/libc_r.so.4 #9 0x0 in ?? () (gdb) frame 5 #5 0x1812f940 in MysqlConnection::real_connect (this=0x80c8c18, db=0x80fd8b0 stat, host=0x80fa040 skynet.alkar.net, user=0x80fd910 stat, passwd=0x80c1bca , port=3306, compress=1, connect_timeout=60, socket_name=0x80c1bde , client_flag=0) at connection.cc:52 52 if (mysql_real_connect(mysql,host,user,passwd,db, port,socket_name,client_flag)) (gdb) p host $1 = (cchar *) 0x80fa040 xxx.xxx.net (gdb) p user $2 = (cchar *) 0x80fd910 test (gdb) p passwd $3 = (cchar *) 0x80c1bca (gdb) p db $4 = (cchar *) 0x80fd8b0 kuku (gdb) 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] ISP Alkar Teleport ÔÅÌ. +380 562 34-00-44 - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: FreeBSD+MySQL
äÏÂÒÙÊ ÄÅÎØ. | table_cache | 256 | +---+---+ m1# mysql -e show status like 'Open%' +---+---+ | Variable_name | Value | +---+---+ | Open_tables | 256 | | Open_files| 446 | | Open_streams | 0 | | Opened_tables | 6114 | +---+---+ Ok, this is bad :) I should have also asked what your mysqld uptime was at this point. 6144 table opens is pretty high even for a couple days of uptime, though. Try bumping table_cache up to 512 and see what happens. Keep bumping it up until 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] ISP Alkar Teleport ÔÅÌ. +380 562 34-00-44 - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: FreeBSD+MySQL
äÏÂÒÙÊ ÄÅÎØ. I have the same problem. We increase max number of users in the kernel config and recompile. The problem is solve at most. Try to increase max number of open files in kernel. Hi, I'm currently running FreeBSD 4.3-stable with MySQL 3.23.39. My problem is weird an unpreditable. I have a database driven website which has several hundred visitors per day. After viewing my logs on a daily basis, I see a Unknown database error appear from time to time. Now, I also have a script set in cron which accesses the database every so often an I see the same Unknown database error from time to time when this script is ran. The error is completely spuradic and unpredictable. Sometimes I go for days without seeing the problem. Not only that, if I notice the problem immediately and check things out, I can connect to the database. So within a matter of minutes it goes from an Unknown database to a database that is alive and accessible. I've tried upping the mbufs, checking the file descriptors, tweaking the mysqld server params, applying soft-updates, and turning off Apache::DBI, nothing seems to work. I've seen at least 2 other mailing list entries where people have the exact same problem. The only solution I received was to switch to a Linux OS. I've also read that there is a threading problem with FreeBSD+MySQL on an SMP machine. I'm running a machine with only 1 processor. Do you have any idea as to what may be causing this problem and if so, do you have a suggested solution? Any help you may be able to give will certainly be appreciated. Thanks, Ozette Brown - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Best 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) 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
RE: --How to dump only table structure with MySQLDump?
Hi! I run now mysql 3.23.42 If I run mysqld without --skip-innodb Then query delete from a; run so slow (but the table is MYISAM!!!) Why? Is it a bug or no? check the command line option -d (or --no-data) -Original Message- From: Barry McClure [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 1:45 AM To: [EMAIL PROTECTED] Subject: --How to dump only table structure with MySQLDump? I would like to extract the DDL for the database so I can re-run it elsewhere. MySQLDump can do that, but it also exports the data. Is there a way for it to just export the Create Table statements? TIA Barry - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Best 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) 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
[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 - 4136 mysql versions 3.23.25-beta Thanks. __ Andrey - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Why not use indexes?
Hi I have index on field dstn But query select sum(usd) from fin_journal where dstn like 'O%' AND date='2001-06-01 00:00:00' AND date'2001-07-01 00:00:00' AND descr IN ('abonplata POP3', 'registration POP3') group by dstn,dsuba,ident ; don't use in. In manual I found than indexes are using in LIKE How can I see that index is used? explain select sum(usd) from fin_journal where dstn like 'O%' AND date='2001-06-01 00:00:00' AND date'2001-07-01 00:00:00' AND descr IN ('abonplata POP3', 'registration POP3') group by dstn,dsuba,ident ; +-+--+---+--+-+--+---+-+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-+--+---+--+-+--+---+-+ | fin_journal | ALL | dstn | NULL |NULL | NULL | 39797 | where used; Using temporary | +-+--+---+--+-+--+---+-+ If I see possible_keys-dstn, is this indes in use? mysql show index from fin_journal; +-++--+--+-+---+-+--++-+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Comment | +-++--+--+-+---+-+--++-+ | fin_journal | 1 | KEY1 |1 | d | A |NULL | NULL | NULL | | | fin_journal | 1 | KEY1 |2 | dstn| A |NULL | NULL | NULL | | | fin_journal | 1 | KEY2 |1 | d | A |NULL | NULL | NULL | | | fin_journal | 1 | KEY2 |2 | dsuba | A |NULL | NULL | NULL | | | fin_journal | 1 | KEY3 |1 | c | A |NULL | NULL | NULL | | | fin_journal | 1 | KEY3 |2 | cstn| A |NULL | NULL | NULL | | | fin_journal | 1 | KEY4 |1 | c | A |NULL | NULL | NULL | | | fin_journal | 1 | KEY4 |2 | csuba | A |NULL | NULL | NULL | | | fin_journal | 1 | k_sesid |1 | sesid | A NULL | NULL | NULL | | | fin_journal | 1 | dsuba|1 | dsuba | A |NULL | NULL | NULL | | | fin_journal | 1 | ident|1 | ident | A |NULL | NULL | NULL | | | fin_journal | 1 | csuba|1 | csuba | A |NULL | NULL | NULL | | | fin_journal | 1 | dstn |1 | dstn| A |NULL | NULL | NULL | | +-++--+--+-+---+-+--++-+ ___ 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] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL and PHP4
On Thu, 24 May 2001, Scott Baker wrote: I don't agree. If mysql install in other directory then /usr/local you need use --with-mysql=mysqldir and sometimes --with-mysql-include and --with-mysql-lib options. Do you need to specify a directory? I just did --with-mysql At 01:14 PM 5/24/2001 -0400, Bill Tangren wrote: When I compile PHP4 (4.04pl1) with the option --with-mysql=mysqldir... I get the error 'cannot find mysqlclient library under mysqldir' I did a search through the mysqsl (3.23.38) source code after I compiled it, and I don't find that library anywhere? What am I doing wrong? - Scott Baker - Webster Internet - Network Technician 503.266.8253 - [EMAIL PROTECTED] You may be disappointed if you fail, but you are doomed if you don't try. - Beverly Sills - 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 [EMAIL PROTECTED] Trouble 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://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
Re: mysql uses 99% cpu under freebsd 4.3
On Wed, 11 Apr 2001, Sinisa Milivojevic wrote: Hi! Hi Ken, This seems to be a problem with threads on FreeBSD, although on which side, yet remains to be seen. It seems to appear that it is surfacing not just under heavy load, but when there are many threads running. Many means more then 300 or 400. My mysql server is not under heavy load. We have less then 20 connection at ones. But we have the same problem under FreeBSD-4.2 STABLE The mysqld can catch all CPU ones a day, sometimes ones a week. IMHO it is not depend from number of threads or number of queries at ones. ___ 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] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql uses 99% cpu under freebsd 4.3
On Mon, 9 Apr 2001 [EMAIL PROTECTED] wrote: I have the same problem under FreeBSD-4.2 STABLE sometimes it work fin 1week, but sometimes 1 day. Description: mysql uses 99% cpu and becomes extremely unresponsive under high load How-To-Repeat: send about 300 simultaneous visitors to www.chicagobusiness.com and tell them to click around. Fix: restart mysql. this usally helps, at least for a few minutes. sometimes it climbs back to 99% though. Submitter-Id:submitter ID Originator: Jon Nathan Organization: Chaffee Interactive MySQL support: extended email support Synopsis:mysql uses 99% cpu and becomes unresponsive Severity:serious Priority:high Category:mysql Class: support Release: mysql-3.23.36 (Source distribution) from freebsd ports Environment: System: FreeBSD d1.crain.com 4.3-RC FreeBSD 4.3-RC #1: Tue Apr 3 16:17:52 GMT 2001 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/CHAFFEE i386 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.2 19991024 (release) Compilation info: CC='cc' CFLAGS='-O2 -pipe -mpentiumpro ' CXX='c++' CXXFLAGS='-O2 -pipe -mpentiumpro -felide-constructors -fno-rtti -fno-exceptions' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 1170734 Apr 3 12:24 /usr/lib/libc.a lrwxr-xr-x 1 root wheel 9 Apr 3 12:24 /usr/lib/libc.so - libc.so.4 -r--r--r-- 1 root wheel 559764 Apr 3 12:24 /usr/lib/libc.so.4 Configure command: ./configure --localstatedir=/data/db --without-perl --without-debug --without-readline --without-bench --with-mit-threads=no --with-libwrap --with-low-memory --enable-assembler --with-berkeley-db --with-charset=latin1 --prefix=/usr/local i386--freebsd4.3 Perl: This is perl, version 5.005_03 built for i386-freebsd - 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 [EMAIL PROTECTED] Trouble 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://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
problem under FreeBSD4.2-STABLE
Hi! Sometimes I look a problem with mysqld which load CPU. It work fine one week, two ... But ones something was happend and mysqld catch all CPU time. I don't know why. Mysqld continue work, but CPU load increase :( It catch 99% CPU I look in process list, kill all id, flush all tables and try 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 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] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[Q]index and data on different disks
Hi! I have so many data more than my SCSI HDD. But I can add large IDE HDD. I have an idea put index files on one HDD and data files to another. What do you think about this idea? What is more effictive, leave data to SCSI HDD or leave indexes on SCSI? ___ 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] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php