MySQL IPv6 enabled ready !!!
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 ( I apologize for duplicate message. Just for make sure the anti-spam process) To MySQL staff and developer's team: At http://www.ngn.euro6ix.org/IPv6/mysql you will find a patch to make the last stable version on MySQL, (4.0.8) ready to run on the new protocol IPv6. Far from forking the main line of MySQL development, but with the only purpose to improve the excellence of MySQL as a GPL Open Source DBMS, I suggest you to initialize the process to incorporate this proposal into official CVS tree. A few questions: + I tried to patch the 5.X version on the web, but this seemed to be incomplete and I could not compile it on a clear way. So, the basis for the patch is 4.0.8 + Read the corresponding file readme-mysql-4.0.8-v6-20040701.txt on the same URL. You will find some open questions not so easy to solve for me, since I'm not an expert on hacking MySQL system. Future collaboration could include support on IPv6 issues from my side. You should understand that nGn, the company releasing this patch, as a partner of Euro6IX Project has not been assigned so much resources to be full time dedicated to MySQL development. Other interesting projects are in queue to be ported into IPv6. + Some tests have been achieved on a IPv6 network, fully compliant. However, a more exhaustive plan of testing should be scheduled before releasing the code. Anyway, take my gratitude and acknowledge for releasing the Open source code. It has been one oportunity to learn from such a great project like MySQL. I hope you to find it usefull ! Regards. -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQFA7BtN7cY00jhNuEcRAnpAAJ48F/eQXgJ9MxMxma25KM11D5yWGACeNovA RDz5jitHD9hNs4uTIJo2/Jo= =FkEJ -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL IPv6 enabled ready !!!
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 To MySQL staff and developer's team: At http://www.ngn.euro6ix.org/IPv6/mysql you will find a patch to make the last stable version on MySQL, (4.0.8) ready to run on the new protocol IPv6. Far from forking the main line of MySQL development, but with the only purpose to improve the excellence of MySQL as a GPL Open Source DBMS, I suggest you to initialize the process to incorporate this proposal into official CVS tree. A few questions: + I tried to patch the 5.X version on the web, but this seemed to be incomplete and I could not compile it on a clear way. So, the basis for the patch is 4.0.8 + Read the corresponding file readme-mysql-4.0.8-v6-20040701.txt on the same URL. You will find some open questions not so easy to solve for me, since I'm not an expert on hacking MySQL system. Future collaboration could include support on IPv6 issues from my side. You should understand that nGn, the company releasing this patch, as a partner of Euro6IX Project has not been assigned so much resources to be full time dedicated to MySQL development. Other interesting projects are in queue to be ported into IPv6. + Some tests have been achieved on a IPv6 network, fully compliant. However, a more exhaustive plan of testing should be scheduled before releasing the code. Anyway, take my gratitude and acknowledge for releasing the Open source code. It has been one oportunity to learn from such a great project like MySQL. I hope you to find it usefull ! Regards. - -- PGP public key: http://www.ngn.euro6ix.org/IPv6/rafael.martinez.gpg -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD4DBQFA6gj57cY00jhNuEcRAi2iAJ96BvSVr8c0A48zGQIlXrm3COsQHwCYk+36 Z3tT0P+gwdxaeSXV5kVnwQ== =SOnq -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Replication of temporary tables
On 26 Feb 2002, Arjen Lentz wrote: On Tue, 2002-02-26 at 12:21, Peter Jennings wrote: We have been trying to solve a replication issue related to TEMPORARY tables. Here's the issue Every three hours we run a processX (C++ compiled program) on the Master mysql that goes something like this: CREATE TEMPORARY TABLE tempTableA INSERT INTO tempTableA INSERT INTO normalTableB SELECT * FROM tempTableA processX terminates. Here's what we observe on the Slave side: ERROR: 1146 Table 'MainDatabase.tempTableA' does not exist Slave: error running query 'INSERT normalTableB SELECT * FROM tempTableA Hei We have seen a problem that I am sure has something to do with this too. (Latest test in a 3.23.47 rpm binary from www.mysql.com system) If a program creates and uses a temporary table and something happens with this program (stop, crash) before it sends a 'drop table' to the DB (or finish without sending to the DB a 'drop table' for this temporary table), the slave will stop replication even if the master DB drops all the temporary tables associated to the connection terminated. This error is what you get in the master when this happens : * Slave: query 'drop table prod.test01' partially completed on the master and was aborted. There is a chance that your master is inconsistent at this point. If you are sure that your master is ok, run this query manually on the slave and then restart the slave with SET SQL_SLAVE_SKIP_COUNTER=1; SLAVE START; * Sincerely Rafael Martinez - 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
Replication + Tmp tables + Flush master/slave = crash
Hei I think we have found a bug in mysql replication. We have some programs that are working against a master DB and that use temporary tables. The hole system works without problems until we run a flush master/slave. Then the replication in the slave DB stops working because of this. How to produce the crash: - We need a system with replication working master-slave. Run f.ex: MASTER: create temporary table testtmp(id text); MASTER: insert into testtmp values (testing); Until here everything works fine. You can continue working with this tmp table without problems. But if we run: MASTER: flush tables with read lock; MASTER: flush master; SLAVE: flush slave; MASTER: unlock tables; MASTER; insert into testtmp values(testing2); The replication in slave will stop working with a error message saying that table testtmp does not exist. This is a huge problem for us. We have many programs working against the master DB, they run for weeks and the process of stopping/starting all of them is not trivial, so we can not stop all of them to run a flush master/slave when the binary update log file gets to big. Is this a bug?, is it another way of doing what we want to do without crashing replication? Do you need more information? Thanks for your help Sincerely Rafael Martinez - 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
Mysql question and sql request. Are they the same?
Hei I asked this question sometime ago but I did not get any answer :-( and I can not find any explanation of this in the mysql manual. Could anybody explain me the different between a question and a sql-request in mysql?. F.example: If I send a sql-request to mysql: select * from Table where column_A=1 and column_B=2 order by column_C; num.sql_request = 1 and num.questions = 1 Is this true? Can I send 1 sql_request that generate many questions? I am asking this because I am getting around 17.000.000 QUESTIONS a day in my DB (show status), but I am sure we don't send 17 mill sql-request to mysql. Thanks for your help. Sincerely Rafael Martinez -- - 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
Question - Request. Are they the same? I dont think so. (fwd)
Hei Could anybody explain me the different between a question and a sql-request in mysql?. F.example: If I send a sql-request to mysql: select * from Table where column_A=1 and column_B=2 order by column_C; num.sql_request = 1 and num.questions = 1 Is this true? Can I send 1 sql_request that generate many questions? I am asking this because I am getting around 17.000.000 QUESTIONS a day in my DB, but I am sure we don't send 17 mill sql-request to mysql. Thanks for your help. Sincerely Rafael Martinez -- - 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
[Bug report] Databases disappear from the server - (vi.recover)
Description: - This morning we were unable to access our databases from our applications. After a closed check in the mysql-server, I found out that all the databases had disappear. A show databases returned only ONE DB named vi.recover , Is the first time I see this DB in our server. If I tryed to access this DB, use vi.recover I got an error ERROR 1102: Incorrect database name 'vi.recover'. All the files from the different DB where still in the HD. After a shutdown of the mysql-server, check of the DB and starting the mysql-server again, all my DB where back and vi.recover disappear. - We use iasam tables. - Some of them are some GB big with some millions entries. - This is the first time I see this happend with the server and I am very worried, because these DB are a central part of our system and must be running all the time. If you need more info, just ask me about it. In advance, thank you for your help. How-To-Repeat: --- No idea. No errors log anywhere. Fix: - The only way to get all the databases back is to shutdown the mysql-server, run myisamchk in all the databases and start the mysql-server again. Submitter-Id: -- Rafael Martinez Originator: Organization: MySQL support: [none] Synopsis: Databases disappear from the server but Mysql server does not crash. Severity: [ critical ] Priority: [ high ] Category: mysql Class: [ sw-bug ] Release: mysql-3.23.38 (Source distribution) Environment: - System: FreeBSD name.domain 4.3-RELEASE FreeBSD 4.3-RELEASE #0: Fri May 11 00:13:53 CEST 2001 /usr/src/sys/compile/MYKERNEL i386 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.3 [FreeBSD] 20010315 (release) Compilation info: CC='cc' CFLAGS='-O -pipe -D__USE_UNIX98 -D_REENTRANT -D_THREAD_SAFE -I/usr/local/include/pthread/linuxthreads' CXX='c++' CXXFLAGS='-O -pipe -D__USE_UNIX98 -D_REENTRANT -D_THREAD_SAFE -I/usr/local/include/pthread/linuxthreads -felide-constructors -fno-rtti -fno-exceptions' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 1174570 Apr 21 11:05 /usr/lib/libc.a lrwxrwxrwx 1 root wheel 9 May 10 03:58 /usr/lib/libc.so - libc.so.4 -r--r--r-- 1 root wheel 561580 Apr 21 11:05 /usr/lib/libc.so.4 Configure command: ./configure --localstatedir=/usr/local/mysql/var --without-perl --without-debug --without-readline --without-bench --with-mit-threads=no --with-libwrap --with-low-memory --enable-assembler --with-berkeley-db '--with-named-thread-libs=-DHAVE_GLIBC2_STYLE_GETHOSTBYNAME_R -D_THREAD_SAFE -I/usr/local/include/pthread/linuxthreads -L/usr/local/lib -llthread -llgcc_r' --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
Re: Multiple CPU's in Freebsd
---Reply to mail from Sinisa Milivojevic about Multiple CPU's in Freebsd Ken Menzel writes: Hi Sinisa, Since matt hasn't responded yet, I'll let you know, its not the version of FreeBSD, but the ports collection. The ports collections does not have a version number, people should just fetch latest (using cvsup) however you can fetch by date. A package in the ports collection may require a particulur version of soemthing else (ie OS or Library) but when the package is built it will check and update or error as necessary. I can give you more details if you want Sinisa. Ken Thanks for the info Ken. The info that you have provided is truly sufficient. We shall try to change building process of MySQL for FreeBSD as soon as it becomes feasible. Hello First of all, thank you to everybody who came with good suggestions and fixes. I have the 4xCpu machine with freebsd and mysql using all of then, and it looks pretty good :-) (we'll see when I finish testing it ;-) ). One idea will be to put this information in the Mysql-manual so anybody who ones to install/compile from source in freebsd can do it without the problems we have had. Sincerely rafael Martinez - 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: Multiple CPU's in Freebsd
---Reply to mail from Sinisa Milivojevic about Multiple CPU's [EMAIL PROTECTED] writes: Hi, Can anyone help me out! Does MySQL run efficently in a multi CPU environment. [..] MySQL supports as many CPU as you might have, but FreeBSD threads do not support SMP, so MySQL can not use them. I am trying to run mysql in freebsd 4.3 in a 4xCpu machine. And as you say mysql only use 1 of them. Is it possible in any way to use all the cpus in this machine with mysql? I thougt I was doing something wrong or that I had to patch some libraries but after your answer I am starting to panic. What about MIT-threads? I can not install Linux in this machine (scsi + raid card not stable), that is the reason because I am using freebsd and I need to get this machine in production as soon as possible. Any ideas, suggestions, tips, help are welcome. Sincerely Rafael Martinez - 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: Inserting 307,284 lines. Is this ok?
---Reply to mail from Mike Mike about Inserting 307,284 lines. Is this ok? Hello I was wondering if inserting 307,284 is to much to put into one table. Can MySQL handle this? Its a 70MEG File. I have a 550 with 256MEG ram but it only shows 64. [] I have a database with 20-30 tables. One of them has almost 2.000.000 entries and it use around 6GB (17 columns). Another has more than 2.500.000 and uses around 100MB (1 column) No problems at all. I suppose this answer your question. Sincerely Rafael Martinez ---End reply - 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 many queries per second do you get?
---Reply to mail from Nathanial Hendler about How many queries per second do you get? Hello, I was just looking at my MySQL databse using mytop and saw that I was getting over 60 queries per second. Can people give me an idea of how many queries per second they get? Hello I have a database with around 180.000.000 questions a week, that means around 297 questions per second. Sincerely Rafael Martinez - 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
Bug in Mysql C API?
Hei If I send a SELECT sql-request to my DB and this request returns an "Empty set" ... mysql_num_rows(MYSQL_RES *result) returns 0 - This is OK but mysql_num_fields(MYSQL_RES *result) returns 1 - This is not OK ;-) Why? Am I missing anything? Sincerely Rafael Martinez - 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 Memory Requirements...
---Reply to mail from Daniel Kirk about MySQL Memory Requirements... What it looks like i'm going for is the following setup 30gb eide hdd celeron 700Mhz processor 256MB RAM red hat linux mysql apache/tomcat I'm a bit worried because the database is on the same server as the website. Will the machine fall over because it doesn't have enough ram/CPU power (for about 20k users per week as below)? any ball park comments eg no worries, close call, not a chance? I will be more worried about that EIDE 30Gb disk than about the rest. I would invest a little more money in a SCSI system. The diference in performance will be enormous, specially with many processes using the disk at the same time. Sincerely Rafael Martinez - 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