MySQL source component?
HI ALL I study mysql, and I want to trace the source code. Are there any documents that describe the data structure and the relationships between function in MySQL? Many thanks! - 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
make test hassle with 3.23.24a
I've been trying to figure this out for ages. I've compiled mysql with the following options: ./configure --prefix=/usr/local/mysql --enable-assembler --with-mysqld-user=mysq l --with-comment --without-readline "$@" and the compile goes just fine. Then I do make test (as one is want to do) and it decides to skip all the tests 8( (ie it says 'skipping' next to each test). Mysql is running and there is a socket for it. Anyone know what may be wrong? :/ PS. I've tried subscribing to this sucker but have not received a msg that I have actually done so, so please cc me on all replies as I may not actually be on the list (yet). -- CaT ([EMAIL PROTECTED])*** Jenna has joined the channel. cat speaking of mental giants.. Jenna me, a giant, bullshit Jenna And i'm not mental - An IRC session, 20/12/2000 - 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 rows does a table can hold?
I think a good soluthion it is to do a table for every thing and use MERGE table for searching data in all the table (for MERGE see documentation at pag. 271 "MySql table Type" chapter). Il 16:24, mercoled 14 marzo 2001, abdelhamid bettache scrisse: I want to ask you : 1- How many rows does a mysql table can hold? 2- I have to design a database for all universities of my country , Is it better to consider one database for each university or one database for all universities . Note that a query on a table "student" would be more quick if I use for every university its own student table . thank you sorry for my english __ Get your free domain name and domain-based e-mail from Namezero.com New! Namezero Plus domains now available. Find out more at: http://www.namezero.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 - 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
How to have a table very very big?
I have to store data for Internet desining (10-20 Gb at Day) so I have to use a data base very fast: MySql is fast? I have to put 10-20 Gb of data every day: but I can have a table only of 2Gb (I know that reading manual of Mysql). How to do a table so big? Thank you in advance, Rino. - 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
ordering a table by myiasmchk?
If I order a table using myiasmchk then, when I put other row in the table, this thable is still ordered or I have to reorder again? Thank you in advance,Mario. - 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: error 127
Thanks for help ., I tried it but also got the same error any other advice "Gerald L. Clark" wrote: Run isamchk on your tables. mohamed Abd El-Samei Mohamed wrote: Dear all i need help i have mysql-3.22.26a over unix solairs 7 when i try to apply query from the console to retrieve some information i got that error ERROR 1030: Got error 127 from table handler please help .. Thanks Sorry for bad english! -- Name : Mohamed Abd El-Samei Mohamed Company : Soficom Communications S.A.E Titel : System Administrator Tel : 202 7371952 fax : 202 7547415 e-mail : [EMAIL PROTECTED] Address : 30 baget Ali Zamalik.- P.C 11211 - 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 -- Name : Mohamed Abd El-Samei Mohamed Company : Soficom Communications S.A.E Titel : System Administrator Tel : 202 7371952 fax : 202 7547415 e-mail : [EMAIL PROTECTED] Address : 30 baget Ali Zamalik.- P.C 11211 - 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
Antwort: Webmin
On 14.03.2001 22:33:13 Charles L Hagen wrote: Has anyone found a GUI for MySQL on a Linux box? I found Webmin, but it seems limited. Is there an HTML GUI for MySQL? phpMyAdmin - see freshmeat - 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: Antwort: Webmin
Hi, alexander.skwar, Mysql has the type as the MSSQL BIT??? Regards, Sunrise [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
Invalid field size?!
I got a problem.. im using mySQL the newest release on a redhat 7.x for the server.. And im doing some programming.. on a win2k pro with delphi 5.0 ent ed. and im using the myODBC driver in windows to connect to the db. Tho when the db is empty [mailboxes] mailbox char 50 fullnamechar 50 password char 50 domain char 50 i got the user with all priv on.. the user.. so he is a super user, so it all works that way.. tho the problem is.. * When the database is empty then i got in Delphi Invalid field size error and cant use the db. * When i set some data in the db lets say mailbox = 'box1' fullname = 'donald duck' password = 'pluto' domain = 'ducktales.com' then i can use the db in delphi but i cant set values in other posts in the db that are larger in width (chars) then the other.. like this.. in the mailbox coloum i got 'box1' thats 4 chars in the other mailbox fields i cant set anything that is larger than 4 chars. and so on.. but if i set all fields with one post of 50 chars then i can use all fields like it should work!! please help!.. b4 i have to switch to ms$SQL // Eric Holmbom PICAB
Innobase table check.
Hello Heikki, Finally I was able to check the innobase tables included into mysql 3.23.34. Well first several times I was quite happy about them, but later understud that this is because option --create-options is broken :) So now I must say On my system innobase seems to work as bad as it worked before :( - ATIS test fails. Retrieving data Warning: Query 'select city.city_name,state.state_name,city.city_code from state,city where city.state_code=state.state_code' return ed 1 rows when it should have returned 11 rows Got error: when executing select flight.flight_code,aircraft.aircraft_type from flight,aircraft where flight.aircraft_code=aircraft .aircraft_code got 0 instead of 579 *** - mysqld is restarted during alter table test and one more time during the tests: Innobase: Started /usr/local/mysql/libexec/mysqld: ready for connections Innobase: Warning: out of memory in additional memory pool. Innobase: Innobase will start allocating memory from the OS. Innobase: You should restart the database with a bigger value in Innobase: the MySQL .cnf file for innobase_additional_mem_pool_size. 010314 19:00:00 Warning: Checking table: './oldgoodcounter/stop_recs' 010314 19:00:01 Warning: Checking table: './oldgoodcounter/registrants_stats' mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died. Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Bogus stack limit or frame pointer, aborting backtrace. Thread 5126 stopped in file buf0lru.c line 371 Thread 5126 stopped in file buf0lru.c line 371 Number of processes running now: 0 010314 21:13:33 mysqld restarted Innobase: Database was not shut down normally. Innobase: Starting recovery from log files... Innobase: Starting log scan based on checkpoint at Innobase: log sequence number 0 3385030377 - It seems like error message for error 139 should be changed because it says about 16M there innobase and gemini has their own limits about it. 139 = Too big row (= 16 M) Now few words about reasons why this may happen (I'll try to check them out soon) 1) I'm using 2.4.2 kernel,SMP - so there may be some incompatibilities. 2) I'm usung patched for 2GB limit GLIBC 3) I'm using ReiserFS file system. 4) The parameters I'm using. (Like bdb does not work with big tablecache) Anyway MYSQL with MYISAM works with no problem on this system, and I use the same system for production on 20 machines so this looks for me more like incomportability problem. -- Best regards, Peter mailto:[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
how to index on soundex / define own soundex-function
Hello I'm run a family/pedigree database with about 250.000 records of dogs. The dogs are mostly (to 90%) searched by name. To find similar records I have my own 'soundex' colums wich is searched and ofcourse indexed. table dog id int4(indexed) name varchar soundex varchar (indexed) fatherid int4(indexed) motherid int4(indexed) My problem is: I want to search for my own definition of soundex. Thats why I have my own soundex column. Question: - Is there a way to define my very own soundex or string-translation funktion? - Can I build an index on an self defined function? - Can I even define my own function without compiling mysql? Because my Provider wouldn't let me do this. Thank for answering Gunnar von Boehn - 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: ordering a table by myiasmchk?
On Thu, Mar 15, 2001 at 09:54:18AM +0100, Mario Latens wrote: If I order a table using myiasmchk then, when I put other row in the table, this thable is still ordered or I have to reorder again? You'll need to reorder again. Ordering with myisamchk is meant to increase performance, not to order the results of your queries. If you want your query results to be ordered, you need to use ORDER BY in the query. To make ORDER BY faster, you would use indexes on the table. Regards, Fred. Thank you in advance,Mario. - 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 -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands - 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
how to syncronisy/mirror two or more databases?
Hi I run a database using mysql 2.23 by a webspace provider. I would like to keep a 1to1 mirror of it at home. Unluckiely I have no shell/ftp access to the tables directory. The database-dump (with php) is far too big to download it every day. - Any ideas how to backup it? - I'm dreaming of the changing records on the website and at the mirror at home and then magically syncronising the database. - Any good books/docs that explain how to resolve this problems? Thanks, Gunnar von Boehn - 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: real limit of BLOBs
On Tue, Mar 13, 2001 at 04:18:41PM +0100, Alessandro de Manzano wrote: I'm planning to deploy MySQL for a project of my company but I've some concern about real size limit of BLOBs. I read on Paul DuBois' excellent book that longblob are 2^32-1 wide, but actually the communication _protocol_ between clients and server limits to 24Mb the dimension of a single record. It is still true ? or, maybe, have been "fixed" ? I guess it still is in 3.23.33. You might want to look at the TODO for 4.x? What workarounds could I use ? Well, if you *really* need to store blobs of over 24M, I would try to use the string append (or +) and SUBSTR functions to access the blob in parts. Never tried it though. If the data can change you need to use some locking mechanism while you fetch or update the BLOB in parts. This and any other solution that stores the data in MySQL would be awkward to use until the protocol limit is changed. In any case, it requires multiple queries. You might want to hide the implementation in some separate module of your code, so you don't need to make changes everywhere when you decide to change the implementation (e.g. when the protocol limit is lifted). Besides bypassing this problem (not using MySQL to save such BLOBs) there are other solutions ? Storage on a shared file system would be preferable in most cases, like someone else mentioned in his reply. Regards, Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands - 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
Error msg saying what?
Thu, 15 Mar 2001 11:09:14 +0100 SQL SQLDriverConnect Thu, 15 Mar 2001 11:09:14 +0100 ERR [TCX][MyODBC]Access denied for user: 'root@ipaddress' (Using password: YES)
Antwort: Re: Antwort: Webmin
On 15.03.2001 10:23:19 Sunrise wrote: Hi, alexander.skwar, Mysql has the type as the MSSQL BIT??? Pardon me? What do you mean? - 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: Error msg saying what?
On Thu, 15 Mar 2001, Eric Holmbom wrote: Thu, 15 Mar 2001 11:09:14 +0100 SQL SQLDriverConnect Thu, 15 Mar 2001 11:09:14 +0100 ERR [TCX][MyODBC]Access denied for user: 'root@ipaddress' (Using password: YES) It is saying (quite straightforwardly) that you either a) are using a wrong username b) are using a wrong or no password c) are using the correct username/pw but are trying to connect from a wrong IP address Have a look at your login rights and the fine manual on http://www.mysql.com/documentation/mysql/bychapter/manual_Privilege_system.html#Privilege_system If you have further problems/questions, feel free to contact the list again, but not after you tried long and hard yourself figuring it out! :-) Good luck regards, Jan-Aage Bruvoll - 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
A little bug?
Hello, I have just had a little problem with a SELECT query like this: SELECT DATE_FORMAT(Day,"%e.%m.%Y") AS ftag,* from TheTable; this query returns an SQL error: ERROR 1064: You have an error in your SQL syntax near '* from TheTable' at line 1 BUT: SELECT *,DATE_FORMAT(Day,"%e.%m.%Y") AS ftag from TheTable; this query works. Is this a bug in the SQL implamentation of MySQL? Thanks Robert - 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
Antwort: Error msg saying what?
On 15.03.2001 11:10:24 Eric Holmbom wrote: Thu, 15 Mar 2001 11:09:14 +0100 SQL SQLDriverConnect Thu, 15 Mar 2001 11:09:14 +0100 ERR [TCX][MyODBC]Access denied for user: 'root@ipaddress' (Using password: YES) Wrong password, I'd say. - 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: Monitoring Database
dear simon hello try mysqlman its the best tool to manage database remotely naveed - Original Message - From: Simon Green [EMAIL PROTECTED] To: Mysql [EMAIL PROTECTED] Sent: Thursday, March 15, 2001 4:50 PM Subject: Monitoring Database Hi I am trying to right a program to monitor mysql remotely (on the same network). It's so if there is any problem I can go over to using the slave. What is the best way of doing this? Thanks Simon - 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
Record locking problems
I am experiencing problems with record locking on database updates. When I use an Access update query to modify a record subsequent updates to the same records result an Access 97 message stating that the record is in use by another user. This happens if I am the sole user of the database. It would appear that the MySQL server is not releasing it's table locks correctly after an Access update query. Unfortunately I am unable to pin down which component is the source of the problem; MyODBC, Access97 or a MySQL servere misconfiguration. Software: MySQL server v3.22.21 o/s: SGI IRIX v6.5.9 MyODBC v2.50.36 MS Windows 95 MS Access 97MS Windows 95 Grateful for any help you can offer. Thanks. -- Paul Will Daewoo Worthing Technical Centre Tel:01903 227132 Fax:01903 227212 - 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
Innobase compile problems
Hi, I tried to build from source the latest MySQL 3.23.34a and I found the following problems: 1) The Makefile in the 'pars' and 'mem' directory have missing ../include/ paths on some dependencies. 2) In the 'mem' directory, the file mem0mem.c tries to include mem0dbg.c, but I think this should be mem0dbg.ic (I changed it to this anyway???) 3) The mysqld doesn't link. The function body for mem_init doesn't resolve. I looked in the innobase directory and couldn't find it anywhere. I did configure with --with-innobase and the following other configure options: --with-mysqld-ldflags=-all-static --without-bench --with-extra-charsets=none --enable-static=yes --without-debug Thanks, Rick - / Rick Mehalick Senior Consultant / Shell Services International SSI-GPAX / Phone: 281-544-5092(WCK) / Fax:281-544-2646(WCK) / email: [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: Monitoring Database
naveed wrote: dear simon hello try mysqlman its the best tool to manage database remotely naveed - Original Message - From: Simon Green [EMAIL PROTECTED] To: Mysql [EMAIL PROTECTED] Sent: Thursday, March 15, 2001 4:50 PM Subject: Monitoring Database Hi I am trying to right a program to monitor mysql remotely (on the same network). It's so if there is any problem I can go over to using the slave. What is the best way of doing this? Thanks Simon - 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 Simon, I use Linux (SuSE v7.0) with the KDE 'kmysql' and 'kmysqladmin' tools installed. Hope this helps. -- Paul Will Daewoo Worthing Technical Centre Tel:01903 227132 Fax:01903 227212 - 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: Monitoring Database
BigBrother (www.bb4.com) has a plugin for MySQL. It monitors the IP port of the mysqlserver and sends you a message when it is down (or start a script and do wahtever you want e.g. start up the slave). Hugo Burm [EMAIL PROTECTED] -Original MessageH- From: Simon Green [mailto:[EMAIL PROTECTED]] Sent: donderdag 15 maart 2001 12:20 To: Mysql Subject: Monitoring Database Hi I am trying to right a program to monitor mysql remotely (on the same network). It's so if there is any problem I can go over to using the slave. What is the best way of doing this? Thanks Simon - 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
Stupid question but can't find it in manual
Hi, How do I put two or more hosts in a single user row? I have all them at 'localhost' but I'd like to set it to something like 'localhost,machine.domain.tld,machine2.domain.tld' without having to repeat the line since I've got to manage a *bunch* of users. Thanks... - 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: show tables bug - minor update
Hi Greg, If you are speaking about show tables returns blank lines, than thank you very much and I hope you will find it! Please, keep us on track! Best regards, Lumberer. On Mon, Mar 12, 2001 at 09:57:28PM +, Greg Cope wrote: The following C and CXX flags will work (/usr/local/bin/gcc is actually pgcc). Reading specs from /usr/local/lib/gcc-lib/i686-pc-linux-gnu/pgcc-2.95.2.1/specs gcc version pgcc-2.95.2.1 20001224 (release). CC='/usr/local/bin/gcc' CFLAGS='-O6 -mpentiumpro -mstack-align-double' CXX='/usr/local/bin/gcc' CXXFLAGS='-O6 -mpentiumpro -mstack-align-double -felide-constructors -fno-exceptions -fno-rtti' This results in a decent binary. C and CXX flags that are blank give an ok binary with gcc (default redhat:) Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release). Now all I need to do is find some Ok flags for egc ! P.S. Good luck! It's really important. - 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: Compile failing
Martyn Perring writes: Hi, Can anyone shed any light on this? I'm trying to build mySQL V3.23.34a on Tru64 V4.0G using gcc2.95.2 and GNU Make version 3.79.1. The makefiles were created using ./configure --prefix=/nipweb/mysql. No other configure paramaters were used. The compile keeps failing with the following error(s): gmake[2]: Leaving directory `/tmp_mnt/home/perrinm/mysql-3.23.34a/libmysql' Making all in client gmake[2]: Entering directory `/tmp_mnt/home/perrinm/mysql-3.23.34a/client' c++ -DUNDEF_THREADS_HACK -I./../include -I../include -I./.. -I..-I..-O3 -DDBUG_OFF -fno-implicit-templates -c mysql.cc In file included from ../include/global.h:186, from mysql.cc:28: /usr/include/alloca.h:68: warning: declaration of `void * alloca(int)' /usr/include/alloca.h:68: warning: conflicts with built-in declaration `void * alloca(long unsigned int)' c++ -DUNDEF_THREADS_HACK -I./../include -I../include -I./.. -I..-I..-O3 -DDBUG_OFF -fno-implicit-templates -c readline.cc In file included from ../include/global.h:186, from readline.cc:20: /usr/include/alloca.h:68: warning: declaration of `void * alloca(int)' /usr/include/alloca.h:68: warning: conflicts with built-in declaration `void * alloca(long unsigned int)' c++ -DUNDEF_THREADS_HACK -I./../include -I../include -I./.. -I..-I..-O3 -DDBUG_OFF -fno-implicit-templates -c sql_string.cc In file included from ../include/global.h:186, from sql_string.cc:24: /usr/include/alloca.h:68: warning: declaration of `void * alloca(int)' /usr/include/alloca.h:68: warning: conflicts with built-in declaration `void * alloca(long unsigned int)' sql_string.cc: In method `bool String::set(double, unsigned int = 2)': sql_string.cc:181: implicit declaration of function `int snprintf(...)' gmake[2]: *** [sql_string.o] Error 1 gmake[2]: Leaving directory `/tmp_mnt/home/perrinm/mysql-3.23.34a/client' gmake[1]: *** [all-recursive] Error 1 gmake[1]: Leaving directory `/tmp_mnt/home/perrinm/mysql-3.23.34a' gmake: *** [all-recursive-am] Error 2 I haven't got a clue what's happening, maybe someone else does. Thanks, Martyn Perring -- -- Martyn Perring System Administrator, NIP Environment Support Team MLB4/5, Desk 265 BT Advanced Communications Technology Centre, Adastral Park, Martlesham Heath, Ipswich, Tel: (01473-)608334 Suffolk, IP5 3RE BTNet: *00 160 8334 Hi! Edit both config.h and my_config.h and #under HAVE_SNPRINTF. Also, please follow all recommendations for your OS from our manual. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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 over ODBC
Hi there, i received the following message: [TCX][MyODBC] Host 'XYZ' is not allowed to connect to this MySQL Server (#1130) any ideas regards denis - 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
Stange behaviour max(length(a)) on table with index on column a varchar(255)
Hi, I have a table: CREATE TABLE http_refer( rid int unsigned auto_increment, refer varchar(255), unique index(rid), unique index(refer) ); It is filled with referrers from our webserver log and has 4138 rows. Today I've tried to execute: mysql select max(length(refer)) from http_refer; or mysql select min(length(refer)) from http_refer; but both queries just hanged and I had to kill them. Some of table rows is full filled with urls from search engines with long list of parameters. My server system : Linux 2.2.18 mysql-3.23.33-log Any comments? Saulius Gurklys mailto:[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
Conversion
I have been told you offer a service to convert ASP scripts that connect to an access database to a mySQL database. If this is the case could you send me the URL of this resource. Many Thanks Paris. -- Paris Val Baker E-mail:[EMAIL PROTECTED] Phone: 0207 439 4399 Web: http://www.4i.co.uk 4i is a convergent media firm helping great clients deliver business benefits by design. - 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: Innobase compile problems
I failed to mention that I used the RedHat Source RPM and I am using RedHat 6.2. Rick -Original Message- From: Mehalick, Richard RE SSI-GRAX Sent: Thursday, March 15, 2001 6:10 AM To: 'Heikki Tuuri' Cc: '[EMAIL PROTECTED]' Subject: Innobase compile problems Hi, I tried to build from source the latest MySQL 3.23.34a and I found the following problems: 1) The Makefile in the 'pars' and 'mem' directory have missing ../include/ paths on some dependencies. 2) In the 'mem' directory, the file mem0mem.c tries to include mem0dbg.c, but I think this should be mem0dbg.ic (I changed it to this anyway???) 3) The mysqld doesn't link. The function body for mem_init doesn't resolve. I looked in the innobase directory and couldn't find it anywhere. I did configure with --with-innobase and the following other configure options: --with-mysqld-ldflags=-all-static --without-bench --with-extra-charsets=none --enable-static=yes --without-debug Thanks, Rick - / Rick Mehalick Senior Consultant / Shell Services International SSI-GPAX / Phone: 281-544-5092(WCK) / Fax:281-544-2646(WCK) / email: [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
Help querying a simple but large table
Hi all, I'm having problems getting reasonable speed queries from a simple table. First, a little info about my server setup: From mysqladmin version: mysqladmin Ver 7.11 Distrib 3.22.27, for -freebsd3.4 on i386TCX Datakonsult AB, by Monty Server version 3.22.30Protocol version 10Connection Localhost via UNIX socketUNIX socket /tmp/mysql.sock I'm running on a P166 with 96MB of RAM, with FreeBSD 3.4 dedicated to MySQL with no other load impeding tasks. I've created a simple table that contains stock exchange data, as follows: CREATE TABLE shares ( date date DEFAULT '-00-00' NOT NULL, symbol char(10) DEFAULT '' NOT NULL, open float(10,2) DEFAULT '0.00' NOT NULL, close float(10,2) DEFAULT '0.00' NOT NULL, high float(10,2) DEFAULT '0.00' NOT NULL, low float(10,2) DEFAULT '0.00' NOT NULL, volume int(11) DEFAULT '0' NOT NULL, PRIMARY KEY (date,symbol), KEY symbol_index (symbol(4)), KEY symbol_date_index (symbol(4),date)); To verify the indexes: mysql show index from shares;+++---+--+-+---+-+--+| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part |+++---+--+-+---+-+--+| shares | 0 | PRIMARY | 1 | date | A | 5791651 | NULL || shares | 0 | PRIMARY | 2 | symbol | A | 5791651 | NULL || shares | 1 | symbol_index | 1 | symbol | A | NULL | 4 || shares | 1 | symbol_date_index | 1 | symbol | A | NULL | 4 || shares | 1 | symbol_date_index | 2 | date | A | NULL | NULL |+++---+--+-+---+-+--+ And I've filled this with a bit of data. Well, more than a bit - 5,791,651 rows actually. Still, while this is large, it doesn't seem rediculously huge. Let's say I want to perform a query to select the last 22 days worth of closing prices for stock ABC. I run the query: mysql select close from shares where symbol='abc' and date current_date() order by date desc limit 22; ... Data eventually received ... 22 rows in set (12.23 sec) Now, to me that seems very slow. And this is a fairly good result for an uncached symbol - some queries of the same structure but using a different symbol have taken up to 30 seconds, with the server under no load other than this single connection to MySQL. Am I being unrealistic with my expectations of speed, or is there a way to optimize this? I ran "optimize table shares", which took 4 hours, and it's no faster. Incidentally, "explain" gives me the following: mysql explain select close from shares where symbol='abc' and date current_date() order by date desc limit 22;++--++--+-+--+--+---+| table | type | possible_keys | key | key_len | ref | rows | Extra |++--++--+-+--+--+---+| shares | ref | PRIMARY,symbol_index,symbol_date_index | symbol_index | 4 | abc | 4475 | |++--++--+-+--+--+---+ And benchmarking gives me: mysql select benchmark(100,1+1);1 row in set (0.83 sec) I'm running the server with the arguments: safe_mysqld --user=$mysql_daemon_user -O key_buffer=16M -O sort_buffer=1M --pid-file=$pid_file --datadir=$datadir Does anybody have any idea how I can get better results (short of upgrading the server) ? Could you please respond directly to me, as I'm not subscribed to this list. Thanks in advance, D. --- Dan
table design and structure
I had two questions about table design and format. I'm designing an application that has two tables. The first table will have -Many selects that return about 20 results on average. -Few inserts -Very few UPDATEs For this table it is not important that the newest inserts show up in selects immediately. So i was thinking of doing selects with insert delays and maybe a table lock for the update Now i understand that MySql does not support row locking, so i was wondering whether to use versioning with a MyIsam table or just use table locks. I'm looking to maximize speed and concurrency. Question1: Please give me a suggestion on the best way to approach this. The second table will have for every request sent by the browser: -Two selects that return data from a unique key ( select...where =unique key#) -one update that also update a unique key# Note that this will happen an a request scope and there maybe the occassional delete but that very insignificant. The site quotes "Concurrent users is not a problem if one doesn't mix updates and selects that needs to examine many rows in the same table. " Now is this true for the default table in MySql (which i believe is MyIsam) or do i need a special table structure. Note timing is important in this table so i cannot do low priority updates because the update has to happen with the selects in the request scope. Also the requests that come in are not necessarily unique ( they would be in most cases but not all) so they could be accessing the same row of the table. Question2: Would table locking be my best bet or will it be optimized with the default table. Please give me a suggestion on the best way to approach this. Thanks Ray - 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
Innobase table check.
Hi! "Peter" == Peter Zaitsev [EMAIL PROTECTED] writes: Peter Hello Heikki, Peter Finally I was able to check the innobase tables included into mysql Peter 3.23.34. Well first several times I was quite happy about them, but Peter later understud that this is because option --create-options is Peter broken :) Peter So now I must say On my system innobase seems to work as bad as it Peter worked before :( Peter - ATIS test fails. cut This is strange. I have run all benchmark tests with Innobase without any problems. How did you compile MySQL and Innobase ? Can you send us the output from mysqlbug ? Peter - mysqld is restarted during alter table test and one more time Peter during the tests: Peter Innobase: Started Peter /usr/local/mysql/libexec/mysqld: ready for connections Peter Innobase: Warning: out of memory in additional memory pool. Peter Innobase: Innobase will start allocating memory from the OS. Peter Innobase: You should restart the database with a bigger value in Peter Innobase: the MySQL .cnf file for innobase_additional_mem_pool_size. Peter 010314 19:00:00 Warning: Checking table: './oldgoodcounter/stop_recs' Peter 010314 19:00:01 Warning: Checking table: './oldgoodcounter/registrants_stats' cut Peter - It seems like error message for error 139 should be changed because Peter it says about 16M there innobase and gemini has their own limits Peter about it. Peter 139 = Too big row (= 16 M) I shall fix that. Peter Now few words about reasons why this may happen (I'll try to check Peter them out soon) Peter 1) I'm using 2.4.2 kernel,SMP - so there may be some incompatibilities. Peter 2) I'm usung patched for 2GB limit GLIBC Peter 3) I'm using ReiserFS file system. Peter 4) The parameters I'm using. (Like bdb does not work with big Peter tablecache) It could be the parameters; I don't know about that. What startup parameters are you using? Peter Anyway MYSQL with MYISAM works with no problem on this system, and I Peter use the same system for production on 20 machines so this looks for me Peter more like incomportability problem. Regards, Monty - 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 in running My SQL
hi i am installing My Sql on Linux 7 i was trying it for the whole day..the only problem i am facing since morning is that.. the SQL server starts during the booting of system when i go in bin and give mysqladmin command it gives error - Can't connect to server.. either the server is not running or the mysql.sock is missing.. then i restarted the SQL server by giving mysqld command.. but again it gave me same prob.. then i found the mysql.sock file... it's empty 0 bytes.. Then i checked for mysqld.. but no process is running by the name mysqld what to do now Please reply Thanx Get free email and a permanent address at http://www.netaddress.com/?N=1 - 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: error 127
Yes, make sure you shutdown the server before running isamchk. mohamed Abd El-Samei Mohamed wrote: Thanks for help ., I tried it but also got the same error any other advice "Gerald L. Clark" wrote: Run isamchk on your tables. mohamed Abd El-Samei Mohamed wrote: Dear all i need help i have mysql-3.22.26a over unix solairs 7 when i try to apply query from the console to retrieve some information i got that error ERROR 1030: Got error 127 from table handler please help .. Thanks Sorry for bad english! -- Name : Mohamed Abd El-Samei Mohamed Company : Soficom Communications S.A.E Titel : System Administrator Tel : 202 7371952 fax : 202 7547415 e-mail : [EMAIL PROTECTED] Address : 30 baget Ali Zamalik.- P.C 11211 - - 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: Help querying a simple but large table
On Fri, Mar 16, 2001 at 12:32:37AM +1030, Dan Makovec wrote: Hi all, I'm having problems getting reasonable speed queries from a simple table. ... I've created a simple table that contains stock exchange data, as follows: CREATE TABLE shares ( date date DEFAULT '-00-00' NOT NULL, symbol char(10) DEFAULT '' NOT NULL, open float(10,2) DEFAULT '0.00' NOT NULL, close float(10,2) DEFAULT '0.00' NOT NULL, high float(10,2) DEFAULT '0.00' NOT NULL, low float(10,2) DEFAULT '0.00' NOT NULL, volume int(11) DEFAULT '0' NOT NULL, PRIMARY KEY (date,symbol), KEY symbol_index (symbol(4)), KEY symbol_date_index (symbol(4),date) ); From what I've read, symbol_index is of no use here, because it is contained in symbol_date_index. It would hardly influence your select time, but will influence your insert time. Just thought I should mention it. Search the list and the documentation for more info on this. And I've filled this with a bit of data. Well, more than a bit - 5,791,651 rows actually. Still, while this is large, it doesn't seem rediculously huge. Let's say I want to perform a query to select the last 22 days worth of closing prices for stock ABC. I run the query: mysql select close from shares where symbol='abc' and date current_date() order by date desc limit 22; ... Data eventually received ... 22 rows in set (12.23 sec) mysql explain select close from shares where symbol='abc' and date current_date() order by date desc limit 22; ++--++--+-+--+--+---+ | table | type | possible_keys | key | key_len | ref | rows | Extra | ++--++--+-+--+--+---+ | shares | ref | PRIMARY,symbol_index,symbol_date_index | symbol_index | 4 | abc | 4475 | | ++--++--+-+--+--+---+ It uses your symbol_index so it scans (almost?) all 4475 rows for the 'abc' symbol. After scanning all of them, it will sort the result (I think). What you want is MySQL to use a range of records in symbol_date_index: select close from shares where symbol='abc' and date between '2001-02-21' and '2001-03-15'; This should use the correct index and scan only the rows you actually need. I assume there is a maximum of one record per day per symbol. You might want to use MySQL date functions to calculate (constant!) values instead of doing this in your script. Regards, Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands - 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
synopsis of the problem (one line) configure fails on aix 3.4.0
Description: Compiling Mysql for aix. I receive an error saying char size is 0, I noticed that another file is looked up and it is not present. "conftestval" How-To-Repeat: I have set my c compiler and c++ compiler to gcc, then entered the following, you should set your directories to the aprpriate values: ./configure --prefix=/ss5/mysql/ --localstatedir=/ss5/mysql/data --with-unix-socket-path=/ss5/mysql/mysql.sock Fix: None known yet... Submitter-Id: submitter ID[EMAIL PROTECTED] Originator:Jack Summanen x Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: configure fails on aix 3.4.0 Severity: critical Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.29a-gamma (Source distribution) Environment: System: AIX cypress 3 4 00049115A000 Some paths: /usr/local/bin/perl /bin/make /usr/local/bin/gcc /bin/cc GCC: Reading specs from /usr/local/lib/gcc-lib/rs6000-ibm-aix4.1/2.7.0/specs gcc version 2.7.0 Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx 1 bin bin 19 Oct 3 1999 /lib/libc.a - /usr/ccs/lib/libc.a lrwxrwxrwx 1 bin bin 19 Oct 3 1999 /usr/lib/libc.a - /usr/ccs/lib/libc.a Configure command: ./configure --prefix=/ss5/java/jack/mysql_platforms/sol/mysql --localstatedir=/ss5/java/jack/mysql_platforms/sol/mysql/data --with-unix-socket-path=/ss5/java/jack/mysql_platforms/sol/mysql/mysql.sock Perl: This is perl, version 5.002 - 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 in running My SQL
You did not tell us what hardware and MySQL version you are using. There is no Linux 7. If you are refering to RedHat Linux Version 7.0, and you installed the mysql found on the CD, then you have 3 choices. 1. chown -R mysql /var/lib/mysql If the mysql data directories are not in /var/lib/mysql, substitute the proper directory. 2. Get the corrected RPMs from RedHat. 3. Get the RPMs from mysql.com. If this does't help post the contents mysql's error log. Maybe someone can help with this aditional information. Rajat Rajvanshi wrote: hi i am installing My Sql on Linux 7 i was trying it for the whole day..the only problem i am facing since morning is that.. the SQL server starts during the booting of system when i go in bin and give mysqladmin command it gives error - Can't connect to server.. either the server is not running or the mysql.sock is missing.. then i restarted the SQL server by giving mysqld command.. but again it gave me same prob.. then i found the mysql.sock file... it's empty 0 bytes.. Then i checked for mysqld.. but no process is running by the name mysqld what to do now Please reply Thanx Get free email and a permanent address at http://www.netaddress.com/?N=1 - 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
Re: MySQL over ODBC
Did you read chapter 6 in the manual? denis mettler wrote: Hi there, i received the following message: [TCX][MyODBC] Host 'XYZ' is not allowed to connect to this MySQL Server (#1130) any ideas regards denis - 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
Re: MySQL make install problem.
No, it should not be. Eric Morgan wrote: Yes, The prefix path I used below is the path to the source distribution. Should it not be? Eric Mohamad Ilhami wrote: On Wed, 14 Mar 2001, Eric Morgan wrote: I configured and compiled mysql-3.23.34a without even a warning: ./configure --prefix=/usr/local/mysql-3.23.34a Is Mysql binary installation directory (indicated by prefix) same with MySQL source code ? make but when I do a make install I get errors listed below. I included the mysqlbug output if needed below that. I dont know what the install is trying to do here (newbie :). I have made sure that mysql wasnt already installed (rpm -qa|grep mysql ). Anyone have any clues? TIA! Eric Making install in sql-bench make[1]: Entering directory `/usr/local/mysql-3.23.34a/sql-bench' make[2]: Entering directory `/usr/local/mysql-3.23.34a/sql-bench' make[2]: Nothing to be done for `install-exec-am'. /bin/sh ../mkinstalldirs /usr/local/mysql-3.23.34a/sql-bench /usr/bin/install -c test-ATIS /usr/local/mysql-3.23.34a/sql-bench/test-ATIS /usr/bin/install: `test-ATIS' and `/usr/local/mysql-3.23.34a/sql-bench/test-ATIS' are the same file /usr/bin/install -c test-connect /usr/local/mysql-3.23.34a/sql-bench/test-connect /usr/bin/install: `test-connect' and `/usr/local/mysql-3.23.34a/sql-bench/test-connect' are the same file /usr/bin/install -c test-create /usr/local/mysql-3.23.34a/sql-bench/test-create /usr/bin/install: `test-create' and `/usr/local/mysql-3.23.34a/sql-bench/test-create' are the same file /usr/bin/install -c test-insert /usr/local/mysql-3.23.34a/sql-bench/test-insert /usr/bin/install: `test-insert' and `/usr/local/mysql-3.23.34a/sql-bench/test-insert' are the same file /usr/bin/install -c test-big-tables /usr/local/mysql-3.23.34a/sql-bench/test-big-tables /usr/bin/install: `test-big-tables' and `/usr/local/mysql-3.23.34a/sql-bench/test-big-tables' are the same file /usr/bin/install -c test-select /usr/local/mysql-3.23.34a/sql-bench/test-select /usr/bin/install: `test-select' and `/usr/local/mysql-3.23.34a/sql-bench/test-select' are the same file /usr/bin/install -c test-wisconsin /usr/local/mysql-3.23.34a/sql-bench/test-wisconsin /usr/bin/install: `test-wisconsin' and `/usr/local/mysql-3.23.34a/sql-bench/test-wisconsin' are the same file /usr/bin/install -c test-alter-table /usr/local/mysql-3.23.34a/sql-bench/test-alter-table /usr/bin/install: `test-alter-table' and `/usr/local/mysql-3.23.34a/sql-bench/test-alter-table' are the same file /usr/bin/install -c bench-init.pl /usr/local/mysql-3.23.34a/sql-bench/bench-init.pl /usr/bin/install: `bench-init.pl' and `/usr/local/mysql-3.23.34a/sql-bench/bench-init.pl' are the same file /usr/bin/install -c compare-results /usr/local/mysql-3.23.34a/sql-bench/compare-results /usr/bin/install: `compare-results' and `/usr/local/mysql-3.23.34a/sql-bench/compare-results' are the same file /usr/bin/install -c run-all-tests /usr/local/mysql-3.23.34a/sql-bench/run-all-tests /usr/bin/install: `run-all-tests' and `/usr/local/mysql-3.23.34a/sql-bench/run-all-tests' are the same file /usr/bin/install -c server-cfg /usr/local/mysql-3.23.34a/sql-bench/server-cfg /usr/bin/install: `server-cfg' and `/usr/local/mysql-3.23.34a/sql-bench/server-cfg' are the same file /usr/bin/install -c crash-me /usr/local/mysql-3.23.34a/sql-bench/crash-me /usr/bin/install: `crash-me' and `/usr/local/mysql-3.23.34a/sql-bench/crash-me' are the same file /usr/bin/install -c copy-db /usr/local/mysql-3.23.34a/sql-bench/copy-db /usr/bin/install: `copy-db' and `/usr/local/mysql-3.23.34a/sql-bench/copy-db' are the same file make[2]: *** [install-benchSCRIPTS] Error 1 make[2]: Leaving directory `/usr/local/mysql-3.23.34a/sql-bench' make[1]: *** [install-am] Error 2 make[1]: Leaving directory `/usr/local/mysql-3.23.34a/sql-bench' make: *** [install-recursive] Error 1 SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `' and `'). SEND-PR: From: root To: [EMAIL PROTECTED] Subject: [50 character or so descriptive subject here (for reference)] Description: precise description of the problem (multiple lines) How-To-Repeat: code/input/activities to reproduce the problem (multiple lines) Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id:submitter ID Originator: root Organization: organization of PR author (multiple lines) MySQL support: [none | licence | email support | extended email support ] Synopsis:synopsis of the problem (one line) Severity:[ non-critical | serious | critical ] (one line)
connection from php (please help!!)
Hello, im trying to connect to mysql server from php but i cant do it. i created the databases successfully!! i put : ?php $link = mysql_connect(host, user, password); ? Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /var/www/html/juan/index.php what happend? all looks all right if you reply this message please insert my address. - 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: Help querying a simple but large table
And I've filled this with a bit of data. Well, more than a bit - 5,791,651 rows actually. Still, while this is large, it doesn't seem rediculously huge. Let's say I want to perform a query to select the last 22 days worth of closing prices for stock ABC. I run the query: mysql select close from shares where symbol='abc' and date current_date() order by date desc limit 22; try this, it should help: select close from shares where symbol like 'abc' and date current_date() order by date desc limit 22; --- Sistemes - DRAC telemtic - David Diaz i Torrico c/ Transversal 226 - 08225 Terrassa Tel: +34 93 736 48 30 mailto:[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: Innobase compile problems
Rick, I tried to build from source the latest MySQL 3.23.34a and I found the following problems: 1) The Makefile in the 'pars' and 'mem' directory have missing ../include/ paths on some dependencies. Do you mean that when you compile, on the compiler line there is not the flag -I../include? The compiler line should look like the following (except that -g is my own addition): . gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../../include -I../include-g -O2 -c pars0 grm.c . If the flag is missing, there obviously is something wrong with our Makefile.am's or configure.in's. You probably know how to edit the Makefile's automake has generated? A quick fix is to add the missing -I's to the compiler lines there. 2) In the 'mem' directory, the file mem0mem.c tries to include mem0dbg.c, but I think this should be mem0dbg.ic (I changed it to this anyway???) No, it really should include mem0dbg.c :). I divided debug code and non-debug code into two files. 3) The mysqld doesn't link. The function body for mem_init doesn't resolve. I looked in the innobase directory and couldn't find it anywhere. The function is in mem0dbg.c. If you do not include mem0dbg.c, the function is not compiled in. We have to fix our automake files. Could you mail me the generated Makefile's which you think are wrong, so that we could look at them. Regards, Heikki I did configure with --with-innobase and the following other configure options: --with-mysqld-ldflags=-all-static --without-bench --with-extra-charsets=none --enable-static=yes --without-debug Thanks, Rick - / Rick Mehalick Senior Consultant / Shell Services International SSI-GPAX / Phone: 281-544-5092(WCK) / Fax:281-544-2646(WCK) / email: [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: Innobase table check.
Peter, could you ftp your binary (compiled with -g option) to support.mysql.com directory /pub/mysql/Incoming I can then try to run the ATIS test on your binary on our SMP Linux. One possible reason for the errors you get is that your version of GCC is buggy in inlining of code, but that is only a wild guess. Regards, Heikki At 12:40 PM 3/15/01 +0300, you wrote: Hello Heikki, Finally I was able to check the innobase tables included into mysql 3.23.34. Well first several times I was quite happy about them, but later understud that this is because option --create-options is broken :) So now I must say On my system innobase seems to work as bad as it worked before :( - ATIS test fails. Retrieving data Warning: Query 'select city.city_name,state.state_name,city.city_code from state,city where city.state_code=state.state_code' return ed 1 rows when it should have returned 11 rows Got error: when executing select flight.flight_code,aircraft.aircraft_type from flight,aircraft where flight.aircraft_code=aircraft .aircraft_code got 0 instead of 579 *** - mysqld is restarted during alter table test and one more time during the tests: Innobase: Started /usr/local/mysql/libexec/mysqld: ready for connections Innobase: Warning: out of memory in additional memory pool. Innobase: Innobase will start allocating memory from the OS. Innobase: You should restart the database with a bigger value in Innobase: the MySQL .cnf file for innobase_additional_mem_pool_size. 010314 19:00:00 Warning: Checking table: './oldgoodcounter/stop_recs' 010314 19:00:01 Warning: Checking table: './oldgoodcounter/registrants_stats' mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died. Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Bogus stack limit or frame pointer, aborting backtrace. Thread 5126 stopped in file buf0lru.c line 371 Thread 5126 stopped in file buf0lru.c line 371 Number of processes running now: 0 010314 21:13:33 mysqld restarted Innobase: Database was not shut down normally. Innobase: Starting recovery from log files... Innobase: Starting log scan based on checkpoint at Innobase: log sequence number 0 3385030377 - It seems like error message for error 139 should be changed because it says about 16M there innobase and gemini has their own limits about it. 139 = Too big row (= 16 M) Now few words about reasons why this may happen (I'll try to check them out soon) 1) I'm using 2.4.2 kernel,SMP - so there may be some incompatibilities. 2) I'm usung patched for 2GB limit GLIBC 3) I'm using ReiserFS file system. 4) The parameters I'm using. (Like bdb does not work with big tablecache) Anyway MYSQL with MYISAM works with no problem on this system, and I use the same system for production on 20 machines so this looks for me more like incomportability problem. -- Best regards, Peter mailto:[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
What to optimize when disc activita is very high?
Hi I have a long-running select that's basicly just summing a couple of columns in a 1-2GB big table. It lasts for 5-10 hours and I notice that the disc activity is *very* high: vmstat 1 says: 5 0 0 30332 3068 5240 129260 0 0 10260 658 498 63 35 3 4 0 0 30332 3192 5244 129132 0 0 10240 617 441 54 44 2 6 0 0 30332 2140 5244 130156 0 0 1024 187 661 464 64 35 2 5 0 0 30332 2168 5240 130160 0 0 11520 787 595 65 35 0 6 0 0 30332 3292 5244 130160 0 0 11550 574 453 63 31 6 I have 256MB Ram and a Pentium II processor, which variables should I raise to get this select faster? My current config and the select are attached below. Thanks in advance for *any* help! bye, -christian- EXPLAIN SELECT sum( channel_traffic.in_bytes + channel_traffic.out_bytes ) as raw_traffic, channel_traffic.in_bytes + channel_traffic.out_bytes - 1.2* ( channel_traffic.in_uc_packets + channel_traffic.out_uc_packets + channel_traffic.in_mc_packets + channel_traffic.out_mc_packets ) as adj_traffic, min(channel_traffic.timestamp) as start, max(channel_traffic.timestamp) as end, count(*) FROM channel_traffic WHERE channel_traffic.timestamp between "2001-02-01" and "2001-02-28 23:59:59" GROUP BY channel_traffic.hostname, channel_traffic.interfacename +-+--+---+--+-+--++-+ | table | type | possible_keys | key | key_len | ref | rows | Extra | | +-+--+---+--+-+--++-+ | channel_traffic | ALL | NULL | NULL |NULL | NULL | 269474 | where |used; Using temporary | +-+--+---+--+-+--++-+ ++--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++--+--+-+-+---+ | timestamp | datetime | | PRI | -00-00 00:00:00 | | | hostname | varchar(15) | | PRI | | | | interfacename | varchar(30) | | PRI | | | | in_bytes | int(10) unsigned | | | 0 | | | out_bytes | int(10) unsigned | | | 0 | | | in_uc_packets | int(10) unsigned | | | 0 | | | out_uc_packets | int(10) unsigned | | | 0 | | | in_mc_packets | int(10) unsigned | | | 0 | | | out_mc_packets | int(10) unsigned | | | 0 | | ++--+--+-+-+---+ #log= /var/log/mysql.log skip-locking set-variable= key_buffer=64M set-variable= max_allowed_packet=1M set-variable= table_cache=128 set-variable= sort_buffer=2M set-variable= record_buffer=2M set-variable= thread_cache=2 set-variable= thread_concurrency=2 # Try number of CPU's*2 set-variable= myisam_sort_buffer_size=16M -- Christian HammersWESTEND GmbH - Aachen und Dueren Tel 0241/701333-0 [EMAIL PROTECTED] Internet Security for ProfessionalsFax 0241/911879 WESTEND ist CISCO Systems Partner - Premium Certified - 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: Data tool
Yes, there are a couple of methods such as mysqlimport. Please read the manual for the others. - Original Message - From: "WANG_KING£¨Íõ¸Ö£©" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 15, 2001 10:30 Subject: Data tool I want to load data to mysql. Does mysql has any tools like sqlload in oracle? - 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
Re: How to have a table very very big?
Hi Mario, I think I had the same problem as you, and got som help... You have three ways of doing this: 1. Switch to a FileSystem that supports bigger Files 2. Use MERGE, create a lot of small tables and use MERGE in you select Querys, The manual is quit god at explaining how to do this, but I'll think you will find the limitations about INSERT as irritating as I 3. Use the --with-raid option. This is what I do. You need to recompile the mysqld using --with-raid when configuering it. This way you can create tables Using: RAID_TYPE=1 RAID_CHUNKS=XX RAID_CHUNKSIZE=YY The RAID_CHUNKS tells the mysql how many separate files it will split the DB into. IE. RAID_CHUNKS=100 will create 100 datafiles, wich each can be 2GB = 2 000 GB. More about this in CREATE TABLE. The problem with this is the indexfile, wich now is the problem (max 2GB) But I'll will reach that in about 2 weeks so ill figure something out by then. /roger I have to store data for Internet desining (10-20 Gb at Day) so I have to use a data base very fast: MySql is fast? I have to put 10-20 Gb of data every day: but I can have a table only of 2Gb (I know that reading manual of Mysql). How to do a table so big? Thank you in advance, Rino. - 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 _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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
RE: How many rows does a table can hold?
I want to ask you : 1- How many rows does a mysql table can hold? 2- I have to design a database for all universities of my country , Is it better to consider one database for each university or one database for all universities . Note that a query on a table "student" would be more quick if I use for every university its own student table . The Internet Football Club is a footy game by Rage which uses mysql as the backend database. We run this on a Windows NT box and have found mysql good for 3 million plus rows. However we still split the tables into a day-by-day transaction basis so we won't exceed 3 million. This is a similar approach to the idea of splitting the table into separate Universities. We use php and apache with mysql. gavin http://www.internetfootballclub.com/ifc/game.htm. - 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
Fwd: Question: What sort of lock occurs during Optimization?
All, I've got a quick question - In section 7.11 of the manual on Optimize_Table it states that the table is "locked" during optimization. It does not state however, if this is a read-lock, a write-lock or both. Can you clarify? Thanks Since I'm not a member of this list, could any responses please be mailed to [EMAIL PROTECTED]? Mark Mark Dombeck, Ph.D. Director, Mental Health Net (617) 964-1280 - Voice and Fax http://mentalhelp.net/ [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
JDBC CONNECTION PROBLEM
Hi I am using Resin1.2.3 engine to run my servlet and mysql database with mysql-jdbc driver to connect my servlet with database but it gives me null pointer exception when I run my servlet 500 servlet exception java.lang.NullPointerException I hope many of you might have face this problemso please help me in fixing this problem I am copying my servlet public class Firstdb extends HttpServlet { public void doGet(HttpServletRequest req,HttpServletResponse res) throws ServletException,IOException { Connection con = null; Statement stmt = null; ResultSet rs = null; res.setContentType("text/html"); PrintWriter out= res.getWriter(); try { //load driver Class.forName("org.gjt.mm.mysql.Driver").newInstance(); //get connection con = DriverManager.getConnection("jdbc:mysql://localhost:8080/test"); //create statement stmt = con.createStatement(); //execute an sql query rs = stmt.executeQuery("SELECT * FROM employee"); out.println("HTMLHEADTITLEPHONE BOOK/TITLE/HEAD"); out.println("BODY"); out.println("UL"); while(rs.next()) { out.println("LI"+rs.getString(1)+" " + rs.getString(2) + " " +rs.getString(3)); } out.println("/UL"); out.println("/BODY/HTML"); } catch(ClassNotFoundException e) { out.println("couldn't load database driver:" +e.getMessage()); } catch(SQLException e) { out.println("SQLException caught:"+e.getMessage()); } catch(Exception e) { out.println("unable to load driver"); } try { // rs.close(); // stmt.close(); con.close(); } catch (SQLException ignored) { } } } Thanks Scott Decosta
SQL query
Hi , i have the following method: public Object getValueAt(int row, int column){ // in here i want to construct a SQL query which gives the object at a certain row and column } Do you know how to do it? Thanks Pawan - 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: Fwd: Question: What sort of lock occurs during Optimization?
In the last episode (Mar 15), Mark Dombeck, Ph.D. said: All, I've got a quick question - In section 7.11 of the manual on Optimize_Table it states that the table is "locked" during optimization. It does not state however, if this is a read-lock, a write-lock or both. Can you clarify? Thanks Easy enough to test. It's a write lock. -- Dan Nelson [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
Source Control
Anyone know of a Source control system implemented in MySQL? C. Duncan Hudson Dynax Solutions, Inc. Tel 216.292.8203 FAX 216.292.8273 EMail [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
mysqldump generates invalid SQL for db table
Description: Performing a "mysqldump --all-databases --opt" produces invalid SQL for the "db" table i.e.: KEY User(User) Attempting to rebuild tables with the mysql client using this SQL fails with a syntax error. If the SQL is modified to: KEY User (User) then the mysql client creates the "db" table happily. How-To-Repeat: mysqldump --all-databases --opt foo.sql mysql foo.sql Fix: Ensure a space character seperates the KEY name and parenthesis. Submitter-Id: submitter ID Originator:Neil Darlow Organization: MySQL support: none Synopsis: mysqdump generates invalid SQL for "db" table Severity: serious Priority: high Category: mysql Class: sw-bug Release: mysql-3.23.32 (Source distribution) Server: /usr/local/bin/mysqladmin Ver 8.14 Distrib 3.23.32, for unknown-openbsd2.7 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 3.23.32 Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/mysql/mysql.sock Uptime: 4 days 1 hour 40 min 12 sec Threads: 7 Questions: 878 Slow queries: 1 Opens: 180 Flush tables: 1 Open tables: 12 Queries per second avg: 0.002 Environment: System: OpenBSD kandb 2.7 KANDB#0 i386 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-unknown-openbsd2.7/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='cc' CFLAGS='-O2 ' CXX='c++' CXXFLAGS='-O2 ' LDFLAGS='-L/usr/local/lib' LIBC: -r--r--r-- 1 root bin 687102 Dec 11 19:34 /usr/lib/libc.a -r--r--r-- 1 root bin 563475 Dec 11 19:34 /usr/lib/libc.so.25.0 Configure command: ./configure --enable-shared --enable-static --localstatedir=/var/mysql --with-libwrap --with-mysqld-user=mysql --with-unix-socket-path=/var/mysql/mysql.sock --without-perl --without-debug --without-readline --without-bench --without-mit-threads --prefix=/usr/local --sysconfdir=/etc - 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
connecting Microsoft Access to MySQL (Formerly Re: [#Deleted]records in Access)
I see. I added the timestamp field (I never knew there was a field type of timestamp), relinked the table in Access 2000 and the darn thing actually worked! Did this just become a requirement in MySQL 3.23? As I mentioned in a previous post, the timestamp field was not required when I was working with Access 97 and MySQL 3.22, and everything worked fine with that combination. Well, whatever works. Christopher Lewis -- Previous Message -- The "trick" is that while an autoincrement field is a nice thing to have as a primary key, is to put a timestamp field in each MySQL table (in addition to the primary key). - 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: SQL query
Pawan Kanda wrote: Hi , i have the following method: public Object getValueAt(int row, int column){ // in here i want to construct a SQL query which gives the object at a certain row and column } Do you know how to do it? Thanks Pawan Maybe make your sql statement read sql = "your query here " + " LIMIT " + row + ",1"; .. run your query .. then you would just return myrecordset.getwhatever(column); if you need to make many calls to this get value it would be very slow, you should maybe run the query and set it to some object in the class so you can just pull from it (like an array), unless it is HUGE, but then there are trade-offs, the above will be required to run the query every time you access the method. - 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
Regexp matching
I'm having a problem with REGEXP : I have several rows that look like this : Health : health services : safety : physical abuse : women Health : health services : safety : rescue Health : health services : safety : sexual abuse Health : health services : safety : sexual abuse : children Health : health services : safety : sexual abuse : women Health : health services : safety : travel-general cautions Health : volunteer services : children I want to do a search that selects "Health : {words]" but ignores "Health : {words] : {words]". I've tried combinations of [\w] and[a-zA-Z] but they're all or nothing-- either I get all of the results with one or colons or none of the results. Any help would be appreciated. All the best, Mike DeWolfe - 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: Postgres to MySQL Migration
Does someone has an answer for this already done question ?? - Original Message - From: "Jason Bell" [EMAIL PROTECTED] To: "mysql list" [EMAIL PROTECTED] Sent: Friday, March 09, 2001 5:58 PM Subject: Postgres to MySQL Migration Anyone know an easy way to migrate a Database from Postgres to MySQL? -Jason Bell --jehpcifbdnkjhlkhkckb Content-Type: message/rfc822 Content-Disposition: inline; filename="mysql_67844.ezm" - 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++ binary RPM broken
I encountered a few problems with the genuine 1.7.8-1 binary RPM for mysql++. - If I compile: Connection con("temp","localhost","root","temp",3306,0,60,1,"",0); The linker complains: undefined reference to `MysqlConnection::MysqlConnection(char const *, char const *, char const *, char const *, unsigned int, char, unsigned int, bool, char const *, unsigned int)' - It seems the constructor is in the header, but not in the lib. - If I choose another constructor (like Connection con("temp")), I get a segfault: 406 result = *my_free_list; Current language: auto; currently c++ (gdb) where #0 mysql_ti_sql_type_info_lookup::mysql_ti_sql_type_info_lookup (this=0x40089e6 0, types=0x40089e80, size=62) at /usr/include/g++-2/stl_alloc.h:406 #1 0x40040356 in global constructors keyed to mysql_ti_sql_type_info_lookup::mysql_ti_sql_type_info_lookup () at type_info.cc:82 #2 0x4005ae44 in __do_global_ctors_aux () at null1.hh:16 #3 0x400342fe in ?? () at /usr/include/g++-2/std/bastring.cc:177 from /usr/lib/libsqlplus.so.1 However, if I compile it myself from the tarball, everything works fine... (My compiler is gcc-2.95.2) Jerome. - 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: Tuning Ram vs Hardrive ?
Hi, I would like to tune the performance of my database. The database is rather small about 80 MB altogether. (with 20 Mb indexes) The most complex selections open 32 tables at ones. The database is mostly readonly (99%). What settings show I use to maximize the speed of the queries? What would happen if I equip the computer with very much RAM? Will all the tables be cached and the speed of the harddrives not matter anymore? Is there a way to hold all tables in memory and only regularly (every x min) sync them to disk to improve the speed of reads? thanks for *any* answer Gunnar von Boehn - 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
join
join - 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
System requirements for MySQL?
I cant seem to find system requirements anywhere for MySQL, even inside the hundreds of pages of the manual... I wish to run the latest stable release on MySQL on a Windows NT Workstation PC, and will also use this PC to run ColdFusion Professional 4.5 server. Where could I find recommended or minimum requirements for this? Help! Thanks, Chris Peterson
Re: mysqldump generates invalid SQL for db table
Does anybody know if this amount of memory usage is normal? (taken from *top*) PID USER PRI NI SIZE SWAP RSS SHARE LC STAT %CPU %MEM TIME COMMAND 677 root 90 19228 0 18M 15801S 0.0 2.1 0:07 mysqld 679 root 90 19228 0 18M 15800S 0.0 2.1 0:14 mysqld 680 root 90 19228 0 18M 15800S 0.0 2.1 0:04 mysqld keeps going for 30 connections Why does the SIZE so high? It would seem to me that the SHARE should be much closer to the SIZE value... Why doesn't mySQL share more of its memory? Can I make mySQL share more? I would think that the database keys would be shared between the processes... Are they? I have attached the my.cnf file - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 15, 2001 9:37 AM Subject: mysqldump generates invalid SQL for "db" table Description: Performing a "mysqldump --all-databases --opt" produces invalid SQL for the "db" table i.e.: KEY User(User) Attempting to rebuild tables with the mysql client using this SQL fails with a syntax error. If the SQL is modified to: KEY User (User) then the mysql client creates the "db" table happily. How-To-Repeat: mysqldump --all-databases --opt foo.sql mysql foo.sql Fix: Ensure a space character seperates the KEY name and parenthesis. Submitter-Id: submitter ID Originator: Neil Darlow Organization: MySQL support: none Synopsis: mysqdump generates invalid SQL for "db" table Severity: serious Priority: high Category: mysql Class: sw-bug Release: mysql-3.23.32 (Source distribution) Server: /usr/local/bin/mysqladmin Ver 8.14 Distrib 3.23.32, for unknown-openbsd2.7 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 3.23.32 Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/mysql/mysql.sock Uptime: 4 days 1 hour 40 min 12 sec Threads: 7 Questions: 878 Slow queries: 1 Opens: 180 Flush tables: 1 Open tables: 12 Queries per second avg: 0.002 Environment: System: OpenBSD kandb 2.7 KANDB#0 i386 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-unknown-openbsd2.7/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='cc' CFLAGS='-O2 ' CXX='c++' CXXFLAGS='-O2 ' LDFLAGS='-L/usr/local/lib' LIBC: -r--r--r-- 1 root bin 687102 Dec 11 19:34 /usr/lib/libc.a -r--r--r-- 1 root bin 563475 Dec 11 19:34 /usr/lib/libc.so.25.0 Configure command: ./configure --enable-shared --enable-static --localstatedir=/var/mysql --with-libwrap --with-mysqld-user=mysql --with-unix-socket-p ath=/var/mysql/mysql.sock --without-perl --without-debug --without-readline --without-bench --without-mit-threads --prefix=/usr/loca l --sysconfdir=/etc - 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
Re: Postgres to MySQL Migration
I never found an answer. I plan to write a PHP page to help automate this, and expect to have it done soon, time permitting. --Jason Bell Yurais Fernndez Leal wrote: Does someone has an answer for this already done question ?? - Original Message - From: "Jason Bell" [EMAIL PROTECTED] To: "mysql list" [EMAIL PROTECTED] Sent: Friday, March 09, 2001 5:58 PM Subject: Postgres to MySQL Migration Anyone know an easy way to migrate a Database from Postgres to MySQL? -Jason Bell --jehpcifbdnkjhlkhkckb Content-Type: message/rfc822 Content-Disposition: inline; filename="mysql_67844.ezm" - 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
Re: System requirements for MySQL?
Cold Fusion 4.5 Server is a hog. If you can run that you probably have enough memory for MySQL. I would not run them simultaneously with less than 384 MB ram. Charles Hagen On Thu, 15 Mar 2001, Chris Peterson wrote: I cant seem to find system requirements anywhere for MySQL, even inside the hundreds of pages of the manual... I wish to run the latest stable release on MySQL on a Windows NT Workstation PC, and will also use this PC to run ColdFusion Professional 4.5 server. Where could I find recommended or minimum requirements for this? Help! Thanks, Chris Peterson -- Charles L. Hagen Engineer Hagen IT 920-261-8499 - 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 have a table very very big?
I saw that someone already gave you some suggestions, but the reply seemed to lack a bit of WHY you have that limitation, so I thought I would explain. The 2Gb limitation is not in MySQL. It's in your operating system. If you read some of your OS's docs, you can see how to get around this problem either by installing a filesystem patch or by switching to a different file system. You may not even HAVE this limitation, again the only way to really know is to check with your OS's docs. - Original Message - From: "Mario Latens" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 15, 2001 12:49 AM Subject: How to have a table very very big? I have to store data for Internet desining (10-20 Gb at Day) so I have to use a data base very fast: MySql is fast? I have to put 10-20 Gb of data every day: but I can have a table only of 2Gb (I know that reading manual of Mysql). How to do a table so big? Thank you in advance, Rino. - 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
table + index repartition
Hi, I have to mananage a very big table (about 20 Go) A database correspond to a directory. A table correspond to a file. Is it possible to distribute the table on several physical partition (like with Oracle that can use several table space to store one table) ? Thanks, -- Pascal Thivent - 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
composite primary key in Access..?
Friends. people out in here are very afraid , when they hear Mysql does not support foreign keys. It really become difficult , why foreign keys are not enforced by mysql. Anyways, can u please tell me does our favourite database support composite primary keys as in Acess databse key...? U see people out here are so used to see the relationship diagram, they really feel scared of hearing a DB not supporting Foreign keys Thanx. Vj Free Web Email Filter Enhancements. http://www.freewebemail.com/filtertools/
Re: INFO
MySQLGui is a good option in graphical mode, there are other command line clients too At 19.40 14/3/01 +0100, you wrote: can I manage mysql server 3.23 on red hat linux 6.1 using a win32 client on win nt ? thank you in advance. regards. Andrea GIGLIOTTI GB Net S.n.c. Via Bagni Caldi, 11 55021 Bagni di Lucca (LU) Tel. 0583-805533 Fax 0583-807912 http://www.g-bnet.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 - 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 about indexes
I seem to remember that Microsoft SQL Server has the concept of a "covered index" that worked something like this: Suppose you have a table with a product_category, and a price. You query alot on product_category, so you create an index on it. You're expression might look like this: select product_id, product_category, price from product where product_category=15245 In SQL Server, you could optimize this by creating your index using all three fields. The MySQL equivalent would be create index whatever (product_category, product_price, product_id) Now, using the same select statement as above, the server would return all data strictly from the index. It wouldn't even read from the table. Does MySQL do this now, or are there plans to do something similar in the future?
RE: Innobase compile problems
Please see my comments below. Do you mean that when you compile, on the compiler line there is not the flag -I../include? No, not really. I mean in the dependencies for a target. If the flag is missing, there obviously is something wrong with our Makefile.am's or configure.in's. You probably know how to edit the Makefile's automake has generated? A quick fix is to add the missing -I's to the compiler lines there. I was able to fix it, but a new configure will mess it up again. No, it really should include mem0dbg.c :). I divided debug code and non-debug code into two files. The mem0dbg.c file could not be found in the 'mem' directory. Thanks, Rick - 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: Antwort: Webmin
Sunrise wrote: Hi, alexander.skwar, Mysql has the type as the MSSQL BIT??? Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) Yes and this is documented in manual. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ - 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
SQLxxxx.ISM/ISD files in /tmp
For some reason I cannot figure, mysqld is now leaving loads of SQL.ISD/ISM files in /tmp/ .. perhaps 10 a minute.. there are no errors reported in the mysqld log file, other than one or two connection aborted every hour. the files are all owned by root, group root. /tmp is rwx word with t bit on. As far as I can guess this started with a linux kernel upgrade to 2.4.1 There seems to be no other ill effects from this -Justin - 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: Innobase compile problems
Rick, have you downloaded version 3.23.34 and not 3.23.34a? I downloaded 3.23.34a, untarred it, and mem0dbg.c was in innobase/mem directory. I have attached to this email a copy of mem0dbg.c. Are your Makefile's such that they did not build all the object files and libraries needed for linking MySQL? Maybe that has been fixed in 3.23.34a. I have been able to compile and link on Linux. Not all dependencies for included headers are listed in Makefile's, since that would make the dependency list very long. But I assume you have not modified any of the header files and that does not matter to you. Regards, Heikki At 12:52 PM 3/15/01 -0600, you wrote: Please see my comments below. Do you mean that when you compile, on the compiler line there is not the flag -I../include? No, not really. I mean in the dependencies for a target. If the flag is missing, there obviously is something wrong with our Makefile.am's or configure.in's. You probably know how to edit the Makefile's automake has generated? A quick fix is to add the missing -I's to the compiler lines there. I was able to fix it, but a new configure will mess it up again. No, it really should include mem0dbg.c :). I divided debug code and non-debug code into two files. The mem0dbg.c file could not be found in the 'mem' directory. Thanks, Rick / The memory management: the debug code. This is not a compilation module, but is included in mem0mem.* ! (c) 1994, 1995 Innobase Oy Created 6/9/1994 Heikki Tuuri */ mutex_t mem_hash_mutex; /* The mutex which protects in the debug version the hash table containing the list of live memory heaps, and also the global variables below. */ /* The following variables contain information about the extent of memory allocations. Only used in the debug version. Protected by mem_hash_mutex above. */ ulint mem_n_created_heaps = 0; ulint mem_n_allocations = 0; ulint mem_total_allocated_memory = 0; ulint mem_current_allocated_memory= 0; ulint mem_max_allocated_memory= 0; ulint mem_last_print_info = 0; /* Size of the hash table for memory management tracking */ #define MEM_HASH_SIZE 997 /* The node of the list containing currently allocated memory heaps */ typedef struct mem_hash_node_struct mem_hash_node_t; struct mem_hash_node_struct { UT_LIST_NODE_T(mem_hash_node_t) list; /* hash list node */ mem_heap_t* heap; /* memory heap */ char* file_name;/* file where heap was created*/ ulint line; /* file line of creation */ ulint nth_heap;/* this is the nth heap created */ UT_LIST_NODE_T(mem_hash_node_t) all_list;/* list of all created heaps */ }; typedef UT_LIST_BASE_NODE_T(mem_hash_node_t) mem_hash_cell_t; /* The hash table of allocated heaps */ mem_hash_cell_t mem_hash_table[MEM_HASH_SIZE]; /* The base node of the list of all allocated heaps */ mem_hash_cell_t mem_all_list_base; ibool mem_hash_initialized= FALSE; UNIV_INLINE mem_hash_cell_t* mem_hash_get_nth_cell(ulint i); /* Accessor function for the hash table. Returns a pointer to the table cell. */ UNIV_INLINE mem_hash_cell_t* mem_hash_get_nth_cell(ulint i) { ut_a(i MEM_HASH_SIZE); return((mem_hash_table[i])); } /* Accessor functions for a memory field in the debug version */ void mem_field_header_set_len(byte* field, ulint len) { ut_ad(len = 0); mach_write(field - 2 * sizeof(ulint), len); } ulint mem_field_header_get_len(byte* field) { return(mach_read(field - 2 * sizeof(ulint))); } void mem_field_header_set_check(byte* field, ulint check) { mach_write(field - sizeof(ulint), check); } ulint mem_field_header_get_check(byte* field) { return(mach_read(field - sizeof(ulint))); } void mem_field_trailer_set_check(byte* field, ulint check) { mach_write(field + mem_field_header_get_len(field), check); } ulint mem_field_trailer_get_check(byte* field) { return(mach_read(field + mem_field_header_get_len(field))); } /** Initializes the memory system. */ void mem_init( /*=*/ ulint size) /* in: common pool size in bytes */ { #ifdef UNIV_MEM_DEBUG ulint i; /* Initialize the hash table */ ut_a(FALSE == mem_hash_initialized); mutex_create(mem_hash_mutex); mutex_set_level(mem_hash_mutex, SYNC_MEM_HASH); for (i = 0; i MEM_HASH_SIZE; i++) { UT_LIST_INIT(*mem_hash_get_nth_cell(i)); }
En: En:Fw: [BQ75] Fwd: Re: LER COM URGÊNCIA (fwd)
- Original Message - From: walkiriocosta To: Sérgio floripa Cc: adrianovarig ; berg ; beto ; emilson ; fenix ; jacira ; junior ; marcelao ; vagno ; zeus Sent: Sunday, March 11, 2001 6:43 PM Subject: En:Fw: [BQ75] Fwd: Re: LER COM URGÊNCIA (fwd) E-mail grátis BOL com antivírus! Faça já o seu!http://www.bol.com.br__E-mail grátis BOL com antivírus! Faça já o seu!http://www.bol.com.br - Original Message -From: [EMAIL PROTECTED]To: [EMAIL PROTECTED]; [EMAIL PROTECTED];[EMAIL PROTECTED]; [EMAIL PROTECTED];[EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED];[EMAIL PROTECTED]; [EMAIL PROTECTED];[EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED];[EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED];[EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED];[EMAIL PROTECTED]; [EMAIL PROTECTED]Sent: Thursday, March 08, 2001 6:32 PMSubject: En: [BQ75] Fwd: Re: LER COM URGÊNCIA (fwd) -Mensagem Original- De: roberto salvucci Para: [EMAIL PROTECTED] ; [EMAIL PROTECTED] ;[EMAIL PROTECTED] ; [EMAIL PROTECTED] ;[EMAIL PROTECTED] ; [EMAIL PROTECTED] ;[EMAIL PROTECTED] ; [EMAIL PROTECTED] ;[EMAIL PROTECTED] ; [EMAIL PROTECTED] ;[EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] ;[EMAIL PROTECTED] ; [EMAIL PROTECTED] ;[EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] Enviada em: quarta-feira, 7 de março de 2001 09:19 Assunto: [BQ75] Fwd: Re: LER COM URGÊNCIA From: "Roberto Salvucci" Subject: Re: LER COM URGÊNCIA Date: Tue, 6 Mar 2001 20:49:24 -0300ACABEI DE RECEBER. NÃO TEMOS NADA A PEDER.Prezados e queridos amigos, Leiam esta carta e ajam rapidamente. Estou enviando esta carta paravocês porque recebi informação por parte de um profissional e amigo. A MICROSOFT e a AOL (America On Line), atualmente as duas maioresempresas da Internet, para garantir ao Internet Explorer a posição deprograma de navegação mais usado, estão testando uma versão beta doprograma. Ao enviar esta carta aos seus amigos, ela será conferida pelaMICROSOFT (é preciso que os seus amigos usem o Microsoft Windows) ao longode duas semanas. A MICROSOFT pagará U$ 245 para cada pessoa a qual vocêsenviarem esta carta. A MICROSOFT pagará à vocês U$ 243 para cada carta forwardada e pagaráU$ 241 para cada terceira pessoa a qual vocês enviarem esta comunicação. Daqui a duas semanas a MICROSOFT entrará em contato com vocês viae-mail e lhes despachará o cheque. No início eu duvidei... até que depois de duas semanas recebi viae-mail a comunicação e, poucos dias a seguir, o cheque de U$ 24.800. Vocês devem enviar esta comunicação imediatamente, antes que termine oprazo do teste da versão beta da Internet Explorer. Quem banca tudo isso é o senhor Bill Gates. Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. --- UOL: o melhor da Internet. -Mensagem Original- De: roberto salvucci Para: [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] ; [EMAIL PROTECTED] Enviada em: quarta-feira, 7 de março de 2001 09:19 Assunto: [BQ75] Fwd: Re: LER COM URGÊNCIA From: "Roberto Salvucci" <[EMAIL PROTECTED]> <[EMAIL PROTECTED]><[EMAIL PROTECTED]><[EMAIL PROTECTED]><[EMAIL PROTECTED]><[EMAIL PROTECTED]><[EMAIL PROTECTED]><[EMAIL PROTECTED]><[EMAIL PROTECTED]><[EMAIL PROTECTED]><[EMAIL PROTECTED]><[EMAIL PROTECTED]><[EMAIL PROTECTED]><[EMAIL PROTECTED]><[EMAIL PROTECTED]><[EMAIL PROTECTED]><[EMAIL PROTECTED]><[EMAIL PROTECTED]><[EMAIL PROTECTED]><[EMAIL PROTECTED]><[EMAIL PROTECTED]><[EMAIL PROTECTED]><[EMAIL PROTECTED]><[EMAIL PROTECTED]><[EMAIL PROTECTED]><[EMAIL PROTECTED]><[EMAIL PROTECTED]><[EMAIL PROTECTED]><[EMAIL PROTECTED]><[EMAIL PROTECTED]><[EMAIL PROTECTED]><[EMAIL PROTECTED]><[EMAIL PROTECTED]><[EMAIL PROTECTED]><[EMAIL PROTECTED]><[EMAIL PROTECTED]><[EMAIL PROTECTED]><[EMAIL PROTECTED]> Subject: Re: LER COM URGÊNCIA Date: Tue, 6 Mar 2001 20:49:24 -0300 ACABEI DE RECEBER. NÃO TEMOS NADA A PEDER. Prezados e queridos amigos, Leiam esta carta e ajam rapidamente. Estou enviando esta carta para vocês porque recebi informação por parte de um profissional e amigo. A MICROSOFT e a AOL (America On Line), atualmente as duas maiores empresas da Internet, para garantir ao Internet Explorer a posição de programa de navegação mais usado, estão testando uma versão beta do programa. Ao enviar esta carta aos seus amigos, ela será conferida pela MICROSOFT (é preciso que os seus amigos usem o Microsoft Windows) ao longo de duas semanas. A
Enforcing quotas with MySQL?
Does MySQL allow either user or group quotas to be enforced per database? Thanks, Jose - 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
Got an error reading communication packets
I have been getting this error quite a bit, and keep losing my access to the database from my persistent connection, it seems... any idea where I should be looking to solve the problem? Mysql 3.23.34 on Solaris 2.7 Error is: 010315 10:41:55 Aborted connection 27 to db: 'events' user: 'webdev' host: `localhost' (Got an error reading communication packets) 010315 10:41:55 Aborted connection 2 to db: 'events' user: 'webdev' host: `localhost' (Got an error reading communication packets) 010315 12:57:26 Aborted connection 41 to db: 'events' user: 'webdev' host: `localhost' (Got an error reading communication packets) 010315 12:57:26 Aborted connection 42 to db: 'events' user: 'webdev' host: `localhost' (Got an error reading communication packets) 010315 13:29:28 Aborted connection 56 to db: 'events' user: 'webdev' host: `localhost' (Got an error reading communication packets) 010315 13:29:28 Aborted connection 57 to db: 'events' user: 'webdev' host: `localhost' (Got an error reading communication packets) 010315 14:39:23 Aborted connection 5 to db: 'dashboard' user: 'webdev' host: `localhost' (Got an error reading communication packets) 010315 14:58:40 Aborted connection 58 to db: 'events' user: 'webdev' host: `localhost' (Got an error reading communication packets) 010315 14:58:40 Aborted connection 59 to db: 'events' user: 'webdev' host: `localhost' (Got an error reading communication packets) -- ___ __ ____ _ _ _ _ / __)( )( ) /__\( \/ )( ___) ( \( )( ___)(_ _) \__ \ )(__)( /(__)\\ / )__)) ( )__) )( (___/(__)(__)(__)\/ ()()(_)\_)() (__) Money talks: Mine says goodbye! - 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
Can't connect to local MySQL server through socket '' (111)
I get the subject error when running the static or semi-static linux builds on Mandrake 7.2. My database is working fine and I am able to use another client, KMySQLAdmin, without problems. Cal __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.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
Join question
I have 2 tables with a common field of Title. Table 1 defined as: Name;varchar(60) Title;varchar(60) Year;varchar(4) Other;varchar(30) Other2;varchar(30) act_no;int(8) unsigned zerofill Table 2 defined as: MM;varchar(4) Title;varchar(48) Archive;varchar(4) record_num;int(8) unsigned zerofill I need to search Table 1 for an persons name. ie. searching Table 1 for Tom Hanks may return: Green Mile Cast Away and then I need to find out how many individual items for each title are in Table 2. ie return Green Mile 10 35mm 6 16mm Cast Away 4 35mm 20 BETA I have it working by using 2 seperate select calls. I'd like to use join, if possible, to speed this process up. TIA! - 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: Join question
Your two Title fields are not the same size. This could prevent a match. It will slow down joins in 3.22. Carl Schrader wrote: I have 2 tables with a common field of Title. Table 1 defined as: Name;varchar(60) Title;varchar(60) Year;varchar(4) Other;varchar(30) Other2;varchar(30) act_no;int(8) unsigned zerofill Table 2 defined as: MM;varchar(4) Title;varchar(48) Archive;varchar(4) record_num;int(8) unsigned zerofill I need to search Table 1 for an persons name. ie. searching Table 1 for Tom Hanks may return: Green Mile Cast Away and then I need to find out how many individual items for each title are in Table 2. ie return Green Mile 10 35mm 6 16mm Cast Away 4 35mm 20 BETA I have it working by using 2 seperate select calls. I'd like to use join, if possible, to speed this process up. TIA! - 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
Special Character \
Can someone tell me how to insert an selct back a directory into mysql using sql? I'm trying to insert and reselect c:\My Documents into a varchar field and I keep having a problem with the special character \ Jeff
Mysql_install_db
To whom it may concern: When running, the /scripts/mysql_install_db, it starts off with preparing the tables, and then it says it is Installing the tables. That is all it does, it says the process is running and everything. Does it take a real long time for it to install the tables? If so how long? We are running this on a Alpha 1000a digital Unix 5.1. Thanks
Error writing file './mydb/mytable.frm' (Errcode: 28)
Somehow, our MySQL server just started giving the error: Error writing file './mydb/mytable.frm' (Errcode: 28) whenever I try to create a table using the following: CREATE TABLE boundary ( id INTEGER UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT); Precisely where can I find the documentation for this error code 28? Can anyone tell me what the possible causes are? Any help would be greatly appreciated. Ken Whitmore [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: Special Character \
use \\ combination - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 15, 2001 11:55 PM Subject: Special Character \ Can someone tell me how to insert an selct back a directory into mysql using sql? I'm trying to insert and reselect c:\My Documents into a varchar field and I keep having a problem with the special character \ Jeff - 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_install_db
"Olivier, Dave" wrote: To whom it may concern: When running, the /scripts/mysql_install_db, it starts off with preparing the tables, and then it says it is Installing the tables. That is all it does, it says the process is running and everything. Does it take a real long time for it to install the tables? If so how long? We are running this on a Alpha 1000a digital Unix 5.1. Thanks No , but unless you ran it as mysql_install_db --user=mysql it probably created the files with root as the owner. Mysqld will hang trying to open them. chown -R mysql /usr/local/mysql/var ( or whatever the data directory is. ) - 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: Error writing file './mydb/mytable.frm' (Errcode: 28)
Ken Whitmore wrote: Somehow, our MySQL server just started giving the error: Error writing file './mydb/mytable.frm' (Errcode: 28) whenever I try to create a table using the following: CREATE TABLE boundary ( id INTEGER UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT); Precisely where can I find the documentation for this error code 28? Can anyone tell me what the possible causes are? Any help would be greatly appreciated. Ken Whitmore [EMAIL PROTECTED] perror 28 No space left on device. I guess your disk is full! - 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
List your software with new feature-based search engine
Dear Software Manufacturer: We can help you make it much easier to promote your software on the Internet. Your company is invited to list its software products at no charge on BigSoftE, the first Internet Software Search Engine. Launching this month, Bigsofte provides detailed product information to those searching on the BigSoftE.com site as well as on the most popular Internet IT and Search portals. More than 6000 software companies have responded to BigSoftE including industry leaders such as Computer Associates, Hitachi, Informix, and Intuit. Please take just a few moments to learn more about BigSoftE and this time-sensitive offer. Read our FAQs, take a tour of the step-by-step listing process, and sign up to list your products today at http://www.bigsofte.com/vendors/index.cfm?id=42701203 Hurry! BigSoftE will launch in just a few weeks. Respond by MARCH 31st to ensure extra exposure for your company and products during our launch promotions. Sign up now, or take a tour of BigSoftE by visiting http://www.bigsofte.com/vendors/index.cfm?id=42701203 Thank You, BigSoftE Vendor Services [EMAIL PROTECTED] P. 877-947-6383 x 250 Note: The URL in this message was created specifically for the recipient. It is designed for their exclusive use. If you would like to request an invitation for a colleague, or you are having trouble with the URL, please go to http://www.bigsofte.com/listings. **SOFTWARE RESELLERS AND SERVICE PROVIDERS** In addition to information on software titles, BigSoftE provides links to resellers and service providers for each manufacturer's products. If your company is a reseller or service provider for software products manufactured by others, then please refer* your business partners who make software and request that they include your contact information as part of their listing. *To refer a manufacturer, reply to this message with REFERRAL in the subject line. **INTERNATIONAL software companies** Support for International companies is currently under development. If you are a software manufacturer located outside the United States, please use your U.S. office address if available, or use a placeholder address and supply us with your correct international address in the comments field at the end of the listing process. We will manually update your company information to reflect your correct address before launch of bigsofte.com. Thank you for your consideration. REMOVE INSTRUCTIONS We apologize if we have contacted you in error. To be removed from our mailing list, please REPLY to this message with the word REMOVE in the subject line. - 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: Special Character \
The problem with the \\ is that it inserts it into the database as \\ and when it's retrieved it's a \\ - Original Message - From: "Michail A.Baikov" [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, March 15, 2001 2:08 PM Subject: Re: Special Character \ use \\ combination - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 15, 2001 11:55 PM Subject: Special Character \ Can someone tell me how to insert an selct back a directory into mysql using sql? I'm trying to insert and reselect c:\My Documents into a varchar field and I keep having a problem with the special character \ Jeff - 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
problems with mysql table
Hi there I have a problem with one mysql table and i don't know how to solve it .. the table has some important stuff. when i make a select this is what happens mysql select * from imp_addr; ERROR 1030: Got error 127 from table handler mysql and isamchk isamchk imp_addr.ISM Checking ISAM file: imp_addr.ISM Data records:1223 Deleted blocks: 0 - check file-size - check delete-chain - check index reference - check record links Can anyone help me on this ??? Thanks :) -- Nuno Ferreira AKA |rider http://rider.lusoweb.pt mailto:[EMAIL PROTECTED] http://www.lusoweb.pt mailto:[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: Regexp matching
On Thu, Mar 15, 2001 at 08:50:01AM -0800, Mike DeWolfe wrote: I'm having a problem with REGEXP : I have several rows that look like this : Health : health services : safety : physical abuse : women Health : health services : safety : rescue Health : health services : safety : sexual abuse Health : health services : safety : sexual abuse : children Health : health services : safety : sexual abuse : women Health : health services : safety : travel-general cautions Health : volunteer services : children I want to do a search that selects "Health : {words]" but ignores "Health : {words] : {words]". I've tried combinations of [\w] and[a-zA-Z] but they're all or nothing-- either I get all of the results with one or colons or none of the results. Any help would be appreciated. What about "Health : [^:]*$" ? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - 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: Failover and Replication [HOWTO]
Hi , I posted a few considerations about fialover implementation , to the list , but i don't recived any feed back , well lets see what we have : But i write a bunch of perl scripts and now I use them in production and very happy with the result . Here what I have : Baiscly what I want is an sql cluster (composed of min 2 servers ) that can survive a crash and still working . (we all want this ) so i set up a very simple replication between a master and a slave and I use an dynamic dns to locate slave master . like this : master.sql.corp.com192.168.1.100 slave1.sql.corp.com 192.168.1.101 slaveN.sql.corp.com 192.168.1.10N I have a wrapper that send all selects to the slaves and updates to the master i have an advanced watchdog that check if all sqls are up , and if : SLAVE FAIL : I simply updater the DNS to slave-1 and all applications still working the dns update is very quick (1sec) . MASTER FAIL : I simply update the DNS to the NEXT slave for the master and next slave for the slave (to avoid all selects on the master) I run change master to on all slaves , and the party keep going this works from 2 to N servers , I can setup an opensource project , and put all watchdog/dns update /setup stuff in it if any body is intrestead in this . I run this for 2 month and all goes very very well i'm very happy with this . My cluster is : 5 pc , and I use it for a web cluster (10 pc) so I use 1 slave for 2 httpds . For the moment after an server fail , i sync it back using a simple script , the watch dog don't do it because i dont want a buggy server coming in and out the party . I would be very happy to release all implementation . Very best Constantin Bogomolnyi - Original Message - From: "Bryan Coon" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 14, 2001 6:10 PM Subject: Failover and Replication Hi, We are implementing a linux cluster, and rather than get gouged by oracle (in performance and licensing) would much rather use MySQL. I searched through the archives and found several references to failover and replication but still have some questions. If I understand correctly, replication creates a working copy of mysql on another server, but it looks like the algorithm to automatically change slave to master if the master dies will not be added until mysql 4.x (from 11.4 in the manual). Is this still the case? Im not sure when that was written, perhaps there is news on this front? I also did not find a expected release date Does anyone have any stories/suggestions/experiences in regards to rolling our own monitoring script? Thanks! Bryan - 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
RE: problems with mysql table
Hi, Try some of the more aggressive fixing options on isamchk - see the manual for details. Quentin -Original Message- From: Nuno Ferreira [mailto:[EMAIL PROTECTED]] Sent: Friday, 16 March 2001 10:39 a.m. To: [EMAIL PROTECTED] Subject: problems with mysql table Hi there I have a problem with one mysql table and i don't know how to solve it .. the table has some important stuff. when i make a select this is what happens mysql select * from imp_addr; ERROR 1030: Got error 127 from table handler mysql and isamchk isamchk imp_addr.ISM Checking ISAM file: imp_addr.ISM Data records:1223 Deleted blocks: 0 - check file-size - check delete-chain - check index reference - check record links Can anyone help me on this ??? Thanks :) -- Nuno Ferreira AKA |rider http://rider.lusoweb.pt mailto:[EMAIL PROTECTED] http://www.lusoweb.pt mailto:[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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: Failover and Replication [HOWTO]
Hi Bogomolnyi, I am really interested in your scripts. I don't have a use for them at this time, but I am planning to use a fallback system myself in the next few month. 5 pc , and I use it for a web cluster (10 pc) so I use 1 slave for 2 httpds Do you have a similar scheme for the web server? For the moment after an server fail , i sync it back using a simple script , the watch dog don't do it because i dont want a buggy server coming in and out the party . That's totally acceptable. The fallback when a server dies has do be automatically, because it must be fast. Bringing back a server can take some time. Jens - 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: problems with mysql table
# isamchk -a -d -e -f -i -l -o imp_addr.ISM ISAM file: imp_addr.ISM Data records: 1223 Deleted blocks: 0 Recordlength:25 Record format: Packed table description: Key Start Len Index Type User time 0.00, System time 0.00 Maximum resident set size 0, Integral resident set size 0 Non physical pagefaults 16, Physical pagefaults 51, Swaps 0 Blocks in 0 out 0, Messages in 0 out 0, Signals 0 Vouluntary context switches 0, Invouluntary context switches 0 - Anymore available STRONG options i can use ??? cause i think that ones are about all ... and still no good luck :( regards On Fri, 16 Mar 2001, Quentin Bennett wrote: Hi, Try some of the more aggressive fixing options on isamchk - see the manual for details. Quentin -Original Message- From: Nuno Ferreira [mailto:[EMAIL PROTECTED]] Sent: Friday, 16 March 2001 10:39 a.m. To: [EMAIL PROTECTED] Subject: problems with mysql table Hi there I have a problem with one mysql table and i don't know how to solve it .. the table has some important stuff. when i make a select this is what happens mysql select * from imp_addr; ERROR 1030: Got error 127 from table handler mysql and isamchk isamchk imp_addr.ISM Checking ISAM file: imp_addr.ISM Data records:1223 Deleted blocks: 0 - check file-size - check delete-chain - check index reference - check record links Can anyone help me on this ??? Thanks :) -- --- Nuno Ferreira mailto:[EMAIL PROTECTED] http://www.lusoweb.pt --- - 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
Install Questions/Problems
I'm trying to install mysql on my redhat 6.2 machine, i've done the groupadd, useradd, etc. when i ./configure --prefix=/usr/local/src/mysql it runs thru everything and then stops- just a blinking cursor, that leaves 3 processes running, when i try to run 'make' it says no targets and no makefile??? I d/l mysql-3.23.34-pc-linux-gnu-i686.tar.gz any ideas what i've done wrong??? Thanks very much, terry - 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
the ORDER BY bug fix in 3.23.35
According to the changelog, there's a bug in ORDER BY that was recently introduced but fixed in 3.23.35. 3.23.34 fixed a bug in bidirectional replication though, so I'm wondering what the specifics of the bugs were, since I want to do bidirectional replication, but don't want a serious ORDER BY bug since I do a lot of those in my code. Any info would be appreciated. -- "On a normal ascii line, the only safe condition to detect is a 'BREAK' - everything else having been assigned functions by Gnu EMACS." (By Tarl Neustaedter) - 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
speed of INSERT DELAYED vs INSERT
I implemented a mysql based user tracker. On every visit of a user I log some data to the DB. Experimenting with INSERTs I used DELAYED and benchmarked the page. An DELAYED insert takes aprox. 9 times more to execute than an insert. I am using PHP. When I call the query function it takes 9 times more to respond when using a delayed insert than a normal one. I know that the delayed insert will not get really inserted until some conditions are met, but howcome the call takes more time ? - 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
'make test' fails merge test (Sol8,x86)
Hi, I've compiled mysql 3.23.33 but while doing a 'make test' the merge test fails (it passes all others). Any common reason for this? Thanks in advance. Sander - 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
3.23.33-3.23.34a crashing with panic from BDB handler
I'm experiencing a problem where mysqld is crashing every time I run a particular query. The specific error from the client is: ERROR 1015: Can't lock file (errno: -30989) ERROR 2013: Lost connection to MySQL server during query The server error log is reporting: bdb: transaction has active cursors bdb: PANIC: Invalid argument mysqld got signal 11 At that point it either dumps core and dies (3.23.33) or restarts itself (3.23.34a), sometimes reporting errors on startup again in 3.23.34a. For the time being I have downgraded to 3.23.32, but before I fill out a bug report or send my whole database structure and query (basically the query that crashes things is working on bdb tables, but not as part of a transaction, it joins a total of 4 tables, all on a primary key column), I wanted to find out if anyone else has experienced a similar problem or could point me in the right direction. -Scott -- Scott McCool [EMAIL PROTECTED] (571)633-5749 --