Re: Database Size Limit
On Mon, Jan 14, 2002 at 11:52:35AM -0800, Aaron Brick wrote:
in specific reference to linux, you are speaking of the 2.4 kernel,
glibc 2.2, and ext{2,3} filesystem? is it the case that large files
are correctly addressed (ie, seamlessly) on such systems?
Yes.
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.41-max: up 14 days, processed 335,914,046 queries (270/sec. avg)
-
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 with TOMCAT and JSP giving problems..
On Thu, Jan 17, 2002 at 12:48:58PM +0530, aravind gorthy wrote: Hai, I am using MySQL with TOMCAT and JSP for development purpose. 1. Every morning without restarting the tomcat server, i am unable to connect the MySql Database. What might be the problem.. I did't get this type of problem in Oracle SQL server. What error message do you get? Can you connect with something other than Tomcat when that happens? 2. While Running Tomcat Server , I Loose Database Connection To get Connection from database server, i am restarting tomcat server each time, Is MySQL Behaves same with all Servers ?] It is likely not a MySQL problem. But it could be. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 14 days, processed 336,160,796 queries (270/sec. avg) - 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 with TOMCAT and JSP giving problems..
I have been using mysql with Tomcat without any problems. Can you please give a more detailed version of your problem so that it can be helped out. take it easy Neeraj On Thu, 17 Jan 2002 00:53:12 -0800 Jeremy Zawodny [EMAIL PROTECTED] wrote: On Thu, Jan 17, 2002 at 12:48:58PM +0530, aravind gorthy wrote: Hai, I am using MySQL with TOMCAT and JSP for development purpose. 1. Every morning without restarting the tomcat server, i am unable to connect the MySql Database. What might be the problem.. I did't get this type of problem in Oracle SQL server. What error message do you get? Can you connect with something other than Tomcat when that happens? 2. While Running Tomcat Server , I Loose Database Connection To get Connection from database server, i am restarting tomcat server each time, Is MySQL Behaves same with all Servers ?] It is likely not a MySQL problem. But it could be. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 14 days, processed 336,160,796 queries (270/sec. avg) - 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 _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.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
ANNOUNCE: MySQL monitoring with moodss-15.6
Moodss (a modular monitoring application, graphical and daemon) fully supports the MySQL database and great efforts are made in collaboration with the MySQL AB developer Sinisa Milivojevic, in order to achieve a practical and thorough monitoring of MySQL servers. No less than 6 modules, such as the new myhealth and upcoming myerrorlog modules, are available. This version adds the new *myhealth* module, which allows monitoring the health of a database server. Carefully chosen relevant indicators are displayed, allowing the administrator to set meaningful thresholds. For example, it is possible to alert several persons with an email message when a server becomes unreachable, or the number of remaining connections becomes low, or intrusions may be attempted... The module online help suggests values for thresholds, along with a description of the causes and eventual remedies, all only a mouse move away... This module was designed with the extremely valuable help of Sinisa Milivojevic [EMAIL PROTECTED], whom I wish to sincerely thank for his input. More examples and documentation can be found in the module help file, at http://jfontain.free.fr/myhealth/myhealth.htm, various screenshots and other modules for MySQL (mystatus, myvars, myprocs, myquery, ...) are visible at the moodss and MySQL specific page: http://jfontain.free.fr/mysql/, whereas complete information on moodss itself can be found at http://jfontain.free.fr/moodss/. Main features of moodss and its MySQL modules: * monitor as many servers (such as replicated) as you wish, on the same dashboard * threshold alerts forwarded by email to the administrators * native connection to the database servers or via ODBC * performance, statistics (graphs, pies, ...) and errors monitoring * background monitoring with the moomps daemon * monitor servers residing on any MySQL supported platforms (UNIX, Windows, ...) * can be combined with server system monitoring (cpustats, memstats, mounts, ...), network monitoring (snmp, snmptrap, ...) and web server monitoring (apache, apachex, ...) to construct a site wide monitoring station * critical errors and warnings reporting directly from the MySQL error log, even on remote machines, thanks to the upcoming myerrorlog module * Windows support is planned, albeit with reduced functionality Development on moodss MySQL modules is very active, and your comments, bug reports, feature requests, ... will be greatly appreciated. Downloads: http://jfontain.free.fr/moodss-15.6.tar.bz2 http://jfontain.free.fr/moodss-15.6-1.i386.rpm http://jfontain.free.fr/moomps-1.2.1-1.i386.rpm http://jfontain.free.fr/moodss-15.6-1.spec Enjoy! -- Jean-Luc Fontaine - 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: Roadmap
On Tue, Jan 15, 2002 at 08:42:44PM +0200, Emmanuel van der Meulen wrote: Hello all, Is there a roadmap for MySQL releases Sort of. The way it generally works is that the MySQL developers work off the TODO list that you'll find in the MySQL Manual. and in particular when it the eta for 4.1? The ETAs always seem to be guesses at best... They tend not to relesae software and call it stable until it really is stable. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 14 days, processed 336,472,706 queries (270/sec. avg) - 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: [PHP-DB] any good web hosting with php and mysql support?
Check out : http://www.weberdev.com/index.php3?GoTo=phenominet/prices.htm This is your one stop shop for hosting. WeberDev.com is hosted there and I can tell you that their service is amazing. They are fast, reliable and more than anything, very professional (specially in PHP / MySQL). Sincerely berber Visit http://www.weberdev.com Today!!! To see where PHP might take you tomorrow. -Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Monday, January 14, 2002 8:18 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: [PHP-DB] any good web hosting with php and mysql support? Hi All, I am currently looking for a reliable web host to host my personal website. I know there are millions of web hosting companies that have PHP and MYSQL support but I just can't trust any of the fully-assured and confident webhosting ads anymore. I would like to get a service from a company for which someone can vouch. I did started hosting my web site at a webhoster that promised 99.99% uptime and my site is hardly ever up and running. They don't answer my emails either. IS there anyone who have web sites hosted at webhosting service for a reasonably long time without any problems? IF yes, can you please contact me and tell me about it? This might be kind of off-topic for both lists, and i apologize to both lists, so you might want to reply to my email rather than sending it to list(s). Thank you very much. Gurhan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [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: Memory
On Wed, Jan 16, 2002 at 09:46:48PM -0500, John Kemp wrote: From the innodb.com site (bugs fixes): This has me worried, but I haven't seen this behaviour on our site. We have innodb_buffer_pool = 1100Mb key_buffer = 400 Mb record_buffer = 10Mb sort_buffer = 20Mb max_connections = 220 which according to this formula gives me 1100 + 400 + (220 * (20 + 10)) + ( 220 * 1) = 8320Mb at max capacity. At roughly half capacity (96 connections) we're using only 1390Mb, so I'm finding it hard to believe it's going to scale that badly right now. We only have 4Gb memory on our linux-based database machine right now - should I be upgrading? ;-) Does anyone have any information that either supports or refutes the statement above? I'd be interested if you did Well, the sort_buffer and record_buffer will only be allocated on an as-needed basis. And they'll exist for very short periods of time, ideally. So your 1390 comes mainly from innodb_buffer_pool + key_buffer which are the two global buffers (non-thread-specific) that are involved. You'll likely see a single MySQL thread peek above that on occasion, but you'd need things to get pretty bad before you eat up all your memory. See http://jeremy.zawodny.com/mysql/mysql2.pdf for a bit of info on the difference between global and per-thread memory in MySQL. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 14 days, processed 336,064,611 queries (270/sec. avg) - 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: my.ini vs. my.cnf on Winodws?
On Thu, Jan 17, 2002 at 03:17:10AM +0200, Michael Widenius wrote: Hi! Sinisa my.cnf will be read first and if it is found my.ini will not be read Sinisa at all. Sinisa Take a look at mysys/default.c for futher details ... To refresh my memory, I did. MySQL will first read systemdir\my.ini and then C:\my.cnf Thanks for the clarification, Monty. Will it read *both* files if they exist, then? Just like /etc/my.cnf and datdir/my.cnf on Unix platforms? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 14 days, processed 335,941,996 queries (270/sec. avg) - 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: Tergat MySQL Studio
Now there seems to be some kind of evaluation version available: http://www.mysqlstudio.com/shareware.php3 Just downloaded and at least it looks pretty creamy with the latest XP style widgets... I guess this is the more commercial direction MySQL might take. Like what Covalent is doing with apache. Guess its ok. Somebody always pays... cheers, dutch From: Chris Lott Date: Tue, 15 Jan 2002 08:41:00 -0900 Has anyone had a chance to try out the new MySQL Studio product (http://www.mysqlstudio.com/feature.php3)? There doesn't appear to be any kind of demo, ad while it is only $70, I figured I'd check with all of you before trying it. What I would really like is something akin to ER Studio and other Embarcadero products I use for SQL Server that would work with (or also with) MySQL! Sure makes dealing with massively complex relationships and structures more convenient, either with InnoDB or with forthcoming MySQL 4.1 ... c -- Chris Lott -- http://www.chrislott.org/ _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - 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
Tergat MySQL Studio
Now there seems to be some kind of evaluation version available: http://www.mysqlstudio.com/shareware.php3 Just downloaded and at least it looks pretty creamy with the latest XP style widgets... I guess this is the more commercial direction MySQL might take. Like what Covalent is doing with apache. Guess its ok. Somebody always pays... cheers, dutch From: Chris Lott Date: Tue, 15 Jan 2002 08:41:00 -0900 Has anyone had a chance to try out the new MySQL Studio product (http://www.mysqlstudio.com/feature.php3)? There doesn't appear to be any kind of demo, ad while it is only $70, I figured I'd check with all of you before trying it. What I would really like is something akin to ER Studio and other Embarcadero products I use for SQL Server that would work with (or also with) MySQL! Sure makes dealing with massively complex relationships and structures more convenient, either with InnoDB or with forthcoming MySQL 4.1 ... c -- Chris Lott -- http://www.chrislott.org/ _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - 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 This message was posted using eunum --- http://www.cn.eunum.com/ To interact with a real-time, threaded interface to this e-mail list, go visit the link MySQL below: http://www.cn.eunum.com/homestead/92.html . - 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
InnoDB memory allocation on FreeBSD
Hello everyone, I`m running mysql version 4.0.0-alpha under FreeBSD 4.3-STABLE on a dual pentium 4 x 1Ghz with a total memory of 1.5Gb and a scsi hard drive with a volume about 50Gb. The problem is in the InnoDB startup option innodb_buffer_pool_size. I`m trying to set it to about 500MB. When giving this option mysql won`t start and the error log reports that InnoDB cannot allocate requested memory size: InnoDB: Fatal error: cannot allocate 524304384 bytes of InnoDB: memory with malloc! Total allocated memory InnoDB: by InnoDB 157458980 bytes. Operating system errno: 12 InnoDB: Cannot continue operation! InnoDB: Check if you should increase the swap file or InnoDB: ulimits of your operating system. Here is the output of top: 160 processes: 1 running, 159 sleeping CPU states: 10.3% user, 0.0% nice, 2.1% system, 0.3% interrupt, 87.3% idle Mem: 329M Active, 577M Inact, 137M Wired, 25M Cache, 163M Buf, 638M Free Swap: 3257M Total, 3257M Free Where can i be wrong? --- Best regards, Alexei V. Alexandrov - 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: InnoDB memory allocation on FreeBSD
Hi! On Jan 17, Alexei V. Alexandrov wrote: Hello everyone, I`m running mysql version 4.0.0-alpha under FreeBSD 4.3-STABLE on a dual pentium 4 x 1Ghz with a total memory of 1.5Gb and a scsi hard drive with a volume about 50Gb. The problem is in the InnoDB startup option innodb_buffer_pool_size. I`m trying to set it to about 500MB. When giving this option mysql won`t start and the error log reports that InnoDB cannot allocate requested memory size: InnoDB: Fatal error: cannot allocate 524304384 bytes of InnoDB: memory with malloc! Total allocated memory InnoDB: by InnoDB 157458980 bytes. Operating system errno: 12 InnoDB: Cannot continue operation! InnoDB: Check if you should increase the swap file or InnoDB: ulimits of your operating system. Here is the output of top: 160 processes: 1 running, 159 sleeping CPU states: 10.3% user, 0.0% nice, 2.1% system, 0.3% interrupt, 87.3% idle Mem: 329M Active, 577M Inact, 137M Wired, 25M Cache, 163M Buf, 638M Free Swap: 3257M Total, 3257M Free Where can i be wrong? --- Best regards, Alexei V. Alexandrov It's well-known kernel config issue. See LINT % limit ... datasize524288 kbytes ... % grep MAXDSIZ /usr/src/sys/compile/SERG/machine/* vmparam.h:#ifndef MAXDSIZ vmparam.h:#define MAXDSIZ (512UL*1024*1024) /* max data size */ Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - 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
Feature comparison and alternate approaches (MySql - PostgreSql/Oracle)
Hi, Is there some material available which comapres mySql with Oracle and PostgreSql. What I am looking for is a comparison of features, for example what all is supported by Oracle/PostgreSql which is not there in mySql. It will be great if there is some information on alternative approaches that could be taken in case some particular feature is not supported. For example MySql does not support stored procedures; so what could be done on client or server side to achieve the same effect (almost), etc. Regards, Arvind - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
why too long entries get _cut_ without error
Hy, I have an interesting question, I just realized that Mysql simply cuts Data i want to insert into a field when it is too long, without giving any warning or error message. Ok, i know now that this happens and that i have to take care myself that this doesn't happen. But i am very curious why this is so? This seems to me like a busdriver that starts drinving without taking care if there is a child which is still half hanging out of the bus. My data gets lost without me getting noticed that this is so. any guesses? henning - 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: my.ini vs. my.cnf on Winodws?
Hi! Jeremy == Jeremy Zawodny [EMAIL PROTECTED] writes: Jeremy On Thu, Jan 17, 2002 at 03:17:10AM +0200, Michael Widenius wrote: Hi! Sinisa my.cnf will be read first and if it is found my.ini will not be read Sinisa at all. Sinisa Take a look at mysys/default.c for futher details ... To refresh my memory, I did. MySQL will first read systemdir\my.ini and then C:\my.cnf Jeremy Thanks for the clarification, Monty. Jeremy Will it read *both* files if they exist, then? Just like /etc/my.cnf Jeremy and datdir/my.cnf on Unix platforms? Yes; (That was what I tried to write) 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
Re: why too long entries get _cut_ without error
On Thu, 17 Jan 2002, Henning Sprang wrote: ... I just realized that Mysql simply cuts Data i want to insert into a field when it is too long, without giving any warning or error message. . . If the field has fixed length that is standard behaviour (together with right-padding too short values with spaces). -- , M A R I O data miner, LIACC, room 221 tel 351+226078830, ext 121 A M A D O Rua Campo Alegre, 823 fax 351+226003654 A L V E S P-4150-180 PORTO, Portugalmob 351+939354002 - 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: why too long entries get _cut_ without error
M. A. Alves wrote: On Thu, 17 Jan 2002, Henning Sprang wrote: ... I just realized that Mysql simply cuts Data i want to insert into a field when it is too long, without giving any warning or error message. . . If the field has fixed length that is standard behaviour (together with right-padding too short values with spaces). Yes, I know, this is standart, dosumented behaviour, but i just cannot imagine _why_ and asked therfore... henning - 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: Official State of Mysql-Max
Hi! Heikki == Heikki Tuuri [EMAIL PROTECTED] writes: Heikki Ross, Heikki Ross Davis wrote in message ... On the front screen of the mysql site the mysql-Max 3.23.47 is listed as stable. However on the download page it is said to be considered a beta yet? Heikki the download page is lagging behind. The MySQL manual describes it as gamma, Heikki which is also the official classification by Innobase Oy. The reason that I am asking this question, is that the Borland Delphi Developers will not release a new version that supports the record locking until this program is OFFICIALLY listed as stable. Stable according to whose definition ? If you with 'stable' means 'well tested and suitable for production use', that is true for all MySQL releases, including most alpha releases :) If you compare MySQL release scheme to many other products, you will see that a stable version recommended to be used by other products, this is close to what we call beta here at MySQL. You can find more about this at: http://www.mysql.com/doc/W/h/Which_version.html 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
Error 1062: Duplicate entry '127' for Key 1
database,sql,query,table If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: insert into equipment (id,description) values (null,'test data'); returns the error message in the subject line. I've tried the obvious stuff like deleting the record with id=127 in. The id field is auto_increment, btw. I'm sure it's something obvious... -- Gary Smith - [EMAIL PROTECTED] Web: http://www.l33t-d00d.co.uk Pics: http://photos.l33t-d00d.co.uk Webcam: http://webcam.l33t-d00d.co.uk -- Gary Smith - [EMAIL PROTECTED] Web: http://www.l33t-d00d.co.uk Pics: http://photos.l33t-d00d.co.uk Webcam: http://webcam.l33t-d00d.co.uk - 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: my.ini vs. my.cnf on Winodws?
Michael Widenius writes: Hi! MySQL will first read systemdir\my.ini and then C:\my.cnf Sorry, Sinisa, you can't get things right every time ;) (No one can...) I have updated the manual regarding this. Regards, Monty Yes, you are right. I looked a bit better. Only if some other default config file is provided at startup (--defaults-file=...) then that one is read instead of systemdir\my.ini. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error 1062: Duplicate entry '127' for Key 1
an index cannot be null
you should do this :
insert into equipment (id,description) values ('','test data');
regards
At 14:27 17/01/2002, you wrote:
database,sql,query,table
If you just reply to this message, and include the entire text of it in the
reply, your reply will go through. However, you should
first review the text of the message to make sure it has something to do
with MySQL. Just typing the word MySQL once will be sufficient, for example.
You have written the following:
insert into equipment (id,description) values (null,'test data');
returns the error message in the subject line. I've tried the obvious stuff
like deleting the record with id=127 in. The id field is auto_increment,
btw. I'm sure it's something obvious...
--
Gary Smith - [EMAIL PROTECTED]
Web: http://www.l33t-d00d.co.uk
Pics: http://photos.l33t-d00d.co.uk
Webcam: http://webcam.l33t-d00d.co.uk
--
Gary Smith - [EMAIL PROTECTED]
Web: http://www.l33t-d00d.co.uk
Pics: http://photos.l33t-d00d.co.uk
Webcam: http://webcam.l33t-d00d.co.uk
-
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: JDBC and MySQL problem, please help.
Hi, Michael Tam wrote: Hi All, I just installed resin-cmp-1.0.5 with Apache1.3.22 and mysql3.23.47. I used m.mmysql.2.0.8 JDBC driver with the following config segment in my resin.conf: resource-ref res-ref-namejdbc/test/res-ref-name res-typejavax.sql.XADataSource/res-type init-param driver-name="org.gjt.mm.mysql.Driver"/ [snip] Do you use MySQL or MySQL-max? MySQL-max supports Transaction but MySQL does not support it. MySQL-max does not support Distributed Transaction(Two-Phase Commit). And "org.gjt.mm.mysql.Driver" is not for XADataSource. So "javax.sql.XADataSource" does not work fine. -- TAKAHASHI, Tomohiro - 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 1062: Duplicate entry '127' for Key 1
It's probably a tinyint field which won't go higher than 127.
Fred.
On Thu, Jan 17, 2002 at 02:40:54PM +0100, Thibaut Allender wrote:
an index cannot be null
you should do this :
insert into equipment (id,description) values ('','test data');
regards
At 14:27 17/01/2002, you wrote:
database,sql,query,table
If you just reply to this message, and include the entire text of it in the
reply, your reply will go through. However, you should
first review the text of the message to make sure it has something to do
with MySQL. Just typing the word MySQL once will be sufficient, for
example.
You have written the following:
insert into equipment (id,description) values (null,'test data');
returns the error message in the subject line. I've tried the obvious stuff
like deleting the record with id=127 in. The id field is auto_increment,
btw. I'm sure it's something obvious...
--
Gary Smith - [EMAIL PROTECTED]
Web: http://www.l33t-d00d.co.uk
Pics: http://photos.l33t-d00d.co.uk
Webcam: http://webcam.l33t-d00d.co.uk
--
Gary Smith - [EMAIL PROTECTED]
Web: http://www.l33t-d00d.co.uk
Pics: http://photos.l33t-d00d.co.uk
Webcam: http://webcam.l33t-d00d.co.uk
-
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
--
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
Re: why too long entries get _cut_ without error
On Thu, 17 Jan 2002, Henning Sprang wrote: ... I just realized that Mysql simply cuts Data i want to insert into a field when it is too long, without giving any warning or error message. . . If the field has fixed length that is standard behaviour (together with right-padding too short values with spaces). Yes, I know, this is standart, dosumented behaviour, but i just cannot imagine _why_ and asked therfore... So your field is of fixed length type (you hadn't told us that yet). As to the rationale, I don't think SQL has one. I would guess it was simplicity (of the definition of SQL), not withstanding the fact that SQL is spuriously complicated in other things. Cheers, -- , M A R I O data miner, LIACC, room 221 tel 351+226078830, ext 121 A M A D O Rua Campo Alegre, 823 fax 351+226003654 A L V E S P-4150-180 PORTO, Portugalmob 351+939354002 - 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: Memory
John, I suggest setting record_buffer to 1 MB. Disk reads in blocks of 1 MB are probably as fast as in blocks of 10 MB. Also set sort_buffer to 1 MB, and only increase it if there are performance problems. The maximum process space of Linux x86 is 2 GB, and better play safe. Jeremy, I think some Intel x86 processors support segmented memory above 4 GB. Is that supported in Linux? Jeremy, also thanks for your article in the latest Linux Magazine. I too learned something about tuning MySQL :). Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB Jeremy Zawodny wrote in message ... On Wed, Jan 16, 2002 at 09:46:48PM -0500, John Kemp wrote: From the innodb.com site (bugs fixes): This has me worried, but I haven't seen this behaviour on our site. We have innodb_buffer_pool = 1100Mb key_buffer = 400 Mb record_buffer = 10Mb sort_buffer = 20Mb max_connections = 220 which according to this formula gives me 1100 + 400 + (220 * (20 + 10)) + ( 220 * 1) = 8320Mb at max capacity. At roughly half capacity (96 connections) we're using only 1390Mb, so I'm finding it hard to believe it's going to scale that badly right now. We only have 4Gb memory on our linux-based database machine right now - should I be upgrading? ;-) Does anyone have any information that either supports or refutes the statement above? I'd be interested if you did Well, the sort_buffer and record_buffer will only be allocated on an as-needed basis. And they'll exist for very short periods of time, ideally. So your 1390 comes mainly from innodb_buffer_pool + key_buffer which are the two global buffers (non-thread-specific) that are involved. You'll likely see a single MySQL thread peek above that on occasion, but you'd need things to get pretty bad before you eat up all your memory. See http://jeremy.zawodny.com/mysql/mysql2.pdf for a bit of info on the difference between global and per-thread memory in MySQL. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 14 days, processed 336,064,611 queries (270/sec. avg) - 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
Fw: are my table good optimized (using of indexs)
Hi I have this query on ma table: explain select count(przetargi_zaw.id_kat),przetargi_typy.nazwa as typy from przetargi_typy left join przetargi_zaw on przetargi_zaw.id_kat = przetargi_typy.id group by typy; i see: +---+---+---++---+-- -++---+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +---+---+---++---+-- -++---+ | przetargi_typy | ALL | NULL | NULL |NULL | NULL |7 | Using temporary | | przetargi_zaw | ref | id_kat | id_kat | 4 | przetargi_typy.id | 14 | Using index | +---+---+---+-+--+-- -++---+ 2 rows in set (0.00 sec) Are my table good optimized ?? (i use index right way ?) Oops, my table: +-++--+-+-++ | Field | Type | Null | Key | Default | Extra | +-++--++-+-- --+ | id | int(7) unsigned | | PRI| NULL| auto_increment | | id_kat | int(5) unsigned | | MUL | 0 | | | krotko | varchar(255) | YES | | NULL| | | nazwa_pliku | varchar(60) | | | | | +-++--++-+-- --+ +---+-+--+-+-++ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-++ | id | int(5) unsigned | | PRI | NULL| auto_increment | | nazwa | char(50) | | | - || +---+-+--+-+-++ regards Ireneusz Piasecki KomNet s.c. -- Okresl Swoje potrzeby - my znajdziemy oferte za Ciebie! [ http://oferty.onet.pl ] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem with access settings on one database on mySQL
Hi I have MySQL running on a RAQ4i. It has been running perfectly well for almost a year and has four separate databases on it. Last week, whilst checking over the sites that make calls on these databases I noticed that only one had problems. Through searching the FAQs and online documentation I have narrowed down the problem to being something to do with the access permissions on the .frm files of the database tables. I am using PHP MyAdmin 2.2.1 to view and edit the tables and data. When I click the database to view the tables they are all displayed, but instead of showing the Records | Type | Size information all the tables show the phrase 'in use'. If I try to browse any of the tables I receive the error message: Error SQL-query : SELECT * FROM `about` LIMIT 0, 30 MySQL said: Can't find file: './gilmours/about.frm' (errno: 13) The file ./gilmours/about.frm does exist, by the way. I have backup copies of all the files (.frm, .MYI, .MYD) and by following the instructions in the online documentation have tried FLUSH TABLE, which runs without error, but doesn't give any change, I have tried all the repair options (REPAIR TABLE, myisamchk) and I have tried CHMODing the files, all without success, the same errors occur. I have also tried the 'very difficult repair' on this page : http://www.mysql.com/doc/R/e/Repair.html still leaving the same error. I cannot drop any tables or even the whole database itself, which would be a viable option as I have full backups of data and structure. I have changed the access restrictions to 666, 550, 777, and finally 660, which is what the tables in the other databases are, with no avail, I have restarted MySQL, numerous times, as well as rebooting the server. I have tried taking a working version of the same table from another database (they all are based on a similar structure) also with no success. The files as the moment stand as '-rw-rw mysql root about.frm' for example, is this correct? H E L P!! please... pretty please, with a cherry on top... Just an extra note, I am a newbie MySQL user, so please do not take anything for granted in your reply. This is my first post to this user group, but I have spent two days looking round the mailing list and FAQs to find the answer, but not really knowing what to search for has hampered my search. Any help will be gratefully and openly accepted. Thanking you in advance... Keiran Wynyard - 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: Memory
I suggest setting record_buffer to 1 MB. Disk reads in blocks of 1 MB are probably as fast as in blocks of 10 MB. I agree A typical modern disk has an average access time of 5.5 msec and a transfer rate of 40 Mbyte/sec. This means that the two are the same for a disk transfer of about 200kbyte. Therefore, tranfers significantly smaller than 200kb will be wasteful because of too many seeks, whereas transfers more than a few times this will be wasteful (unless all the data is used) because of time spent getting data which is never used. For a disk of this type (good scsi 10,000 rpm), I would have thoght a transfer size of 0.5-1.0 megabyte would be a good target. If the disk has lower acces tume (e.g. 15,000 rpm) reduce the transfer size. If the disk is externally raid-ed, probably increase the transfer size. Alec Cawley (who uses disks for video servers) SQL database - 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: why too long entries get _cut_ without error
M. A. Alves wrote: On Thu, 17 Jan 2002, Henning Sprang wrote: So your field is of fixed length type (you hadn't told us that yet). Aehm, no, it isn't! It's VARCHAR. Sorry I overread that part, a colleague sitting next to me told me that this behaviour is _normal_ and documented, and so I didn't read the manual then myself, was just curious what the reasons are. Is it an undocumented feature then when this happens with VARCHAR fields? TIA, henning BTW: this message just came back top me with the order to put database,sql,query,table into it because it would be considered spam else. how about letting messages through with field, too, and how about checking if it's a reply to a thread? - 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
Server configuration denies access to data source
I got the same problem, and i have the impression that this is a MySQL bug... Sorry i can't help you at this moment... i have to help myself first ! :)) Good luck - 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: Memory
Heikki Jeremy, Thanks again for your help. I'll try it out and see how things go. I will just note that in most of the MySQL documentation talks about how one can set key_buffer or innodb_buffer_pool up to 75% of your maximum memory, which in the case of our db machines is 4GB. I have been monitoring our memory usage under load, and even with the numbers I listed below, I have not yet seen a server crash from 200 simultaneous connections, which has been our peak so far. We did see this a while back on an earlier version (we're now running 3.23.45-max) but our server has been running like this for 45 days and counting. So I guess this is more of a case (as Jeremy seemed to be suggesting) that this *might* happen if we have a lot of simultaneous, tricky queries (when we'd see lots of sort_buffer and record_buffer get allocated for each connection/thread) This also implies that if you're mostly using Innodb tables for querying that you probably wouldn't see this happening, because: 1) Innodb doesn't lock the whole table - so simultaneous queries on the same table will get done faster, and thus memory will be freed up quicker. 2) Does querying or updating the Innodb tablespace effect record_buffer and sort_buffer anyway? The more I think about it, the more I realize that since we started doing work with Innodb tables, our database memory problems have basically gone away. Any thoughts on that? John Director, Software Development Streetmail Inc. Heikki Tuuri wrote: John, I suggest setting record_buffer to 1 MB. Disk reads in blocks of 1 MB are probably as fast as in blocks of 10 MB. Also set sort_buffer to 1 MB, and only increase it if there are performance problems. The maximum process space of Linux x86 is 2 GB, and better play safe. Jeremy, I think some Intel x86 processors support segmented memory above 4 GB. Is that supported in Linux? Jeremy, also thanks for your article in the latest Linux Magazine. I too learned something about tuning MySQL :). Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB Jeremy Zawodny wrote in message ... On Wed, Jan 16, 2002 at 09:46:48PM -0500, John Kemp wrote: From the innodb.com site (bugs fixes): This has me worried, but I haven't seen this behaviour on our site. We have innodb_buffer_pool = 1100Mb key_buffer = 400 Mb record_buffer = 10Mb sort_buffer = 20Mb max_connections = 220 which according to this formula gives me 1100 + 400 + (220 * (20 + 10)) + ( 220 * 1) = 8320Mb at max capacity. At roughly half capacity (96 connections) we're using only 1390Mb, so I'm finding it hard to believe it's going to scale that badly right now. We only have 4Gb memory on our linux-based database machine right now - should I be upgrading? ;-) Does anyone have any information that either supports or refutes the statement above? I'd be interested if you did Well, the sort_buffer and record_buffer will only be allocated on an as-needed basis. And they'll exist for very short periods of time, ideally. So your 1390 comes mainly from innodb_buffer_pool + key_buffer which are the two global buffers (non-thread-specific) that are involved. You'll likely see a single MySQL thread peek above that on occasion, but you'd need things to get pretty bad before you eat up all your memory. See http://jeremy.zawodny.com/mysql/mysql2.pdf for a bit of info on the difference between global and per-thread memory in MySQL. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 14 days, processed 336,064,611 queries (270/sec. avg) - 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: Problem with access settings on one database on mySQL
The user under which mysql is running ( 'mysql' ? Better check. ) does not have read permissions on the .frm files OR does not have execute (x) permissions on their parent ( or any ancestor ) directory. chown -R mysql:mysql /var/lib/mysql should do the trick. Replace /var/lib/mysql with the actual directory that contains all of the mysql databases. Keiran Wynyard wrote: Hi I have MySQL running on a RAQ4i. It has been running perfectly well for almost a year and has four separate databases on it. Last week, whilst checking over the sites that make calls on these databases I noticed that only one had problems. Through searching the FAQs and online documentation I have narrowed down the problem to being something to do with the access permissions on the .frm files of the database tables. I am using PHP MyAdmin 2.2.1 to view and edit the tables and data. When I click the database to view the tables they are all displayed, but instead of showing the Records | Type | Size information all the tables show the phrase 'in use'. If I try to browse any of the tables I receive the error message: Error SQL-query : SELECT * FROM `about` LIMIT 0, 30 MySQL said: Can't find file: './gilmours/about.frm' (errno: 13) The file ./gilmours/about.frm does exist, by the way. I have backup copies of all the files (.frm, .MYI, .MYD) and by following the instructions in the online documentation have tried FLUSH TABLE, which runs without error, but doesn't give any change, I have tried all the repair options (REPAIR TABLE, myisamchk) and I have tried CHMODing the files, all without success, the same errors occur. I have also tried the 'very difficult repair' on this page : http://www.mysql.com/doc/R/e/Repair.html still leaving the same error. I cannot drop any tables or even the whole database itself, which would be a viable option as I have full backups of data and structure. I have changed the access restrictions to 666, 550, 777, and finally 660, which is what the tables in the other databases are, with no avail, I have restarted MySQL, numerous times, as well as rebooting the server. I have tried taking a working version of the same table from another database (they all are based on a similar structure) also with no success. The files as the moment stand as '-rw-rw mysql root about.frm' for example, is this correct? H E L P!! please... pretty please, with a cherry on top... Just an extra note, I am a newbie MySQL user, so please do not take anything for granted in your reply. This is my first post to this user group, but I have spent two days looking round the mailing list and FAQs to find the answer, but not really knowing what to search for has hampered my search. Any help will be gratefully and openly accepted. Thanking you in advance... Keiran Wynyard - 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
Server configuration denies access to data source
Ok, i think i've found the cause of my problem and maybe your too ! In fact my MySQL doesn't close opens conections and he doesn't let me open an another one...and so throw me an exception. If i'm waiting few minutes before opening new connections, it's working, so just check your 'connection timeout' value or find another way to close all those unclosed connections. Good luck again ! - 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: why too long entries get _cut_ without error
On Thu, 17 Jan 2002, Henning Sprang wrote: So your field is of fixed length type (you hadn't told us that yet). Aehm, no, it isn't! It's VARCHAR. Doesn't matter: If you assign a value to a CHAR or VARCHAR column that exceeds the column's maximum length, the value is truncated to fit. (MySQL Manual) -- , M A R I O data miner, LIACC, room 221 tel 351+226078830, ext 121 A M A D O Rua Campo Alegre, 823 fax 351+226003654 A L V E S P-4150-180 PORTO, Portugalmob 351+939354002 - 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
configure and compile problems
Hy, has anyone ever experienced the problem that when specifying a program-prefix with configure, the specified prefix will be prefixed two times, say i do ./configure --prefix=/usr/local/mysql/ --program-prefix=ga then I get binaries like gagamysql gagamysqladmin gagamysqlshow and so on.. Another thing what just happens to me is that then, after I compiled with the aboce configure command, when I run /usr/local/mysql/bin/gagamysql_install_db it tells me to do a make install before running it, but I actually did, otherwise i could run it in /usr/local/mysql/bin. But that might have something to do with the wrong names?! I will try now if all goes without the --program-prefix... ps: using source for mysql-3.23.47, SuSE Linux 7.3, updated from 7.0 henning - 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: Server configuration denies access to data source
It is the code that closes the connections (pconnect) So it would be good to have a look at client first... MySQL should have no problme with upto 1000 connetions...more if you are not on Linx.. I hope this helps you or some one else... Simon -Original Message- From: Core Dumped [mailto:[EMAIL PROTECTED]] Sent: 17 January 2002 15:42 To: [EMAIL PROTECTED] Subject: Server configuration denies access to data source Ok, i think i've found the cause of my problem and maybe your too ! In fact my MySQL doesn't close opens conections and he doesn't let me open an another one...and so throw me an exception. If i'm waiting few minutes before opening new connections, it's working, so just check your 'connection timeout' value or find another way to close all those unclosed connections. Good luck again ! - 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
updated moodss and MySQL web page
added to http://jfontain.free.fr/mysql/ : - Howto: - Monitoring replicated servers - Sending SNMP traps - Sending SMS messages Please let me know what you think and/or you have other ideas for howtos. Cheers, -- Jean-Luc Fontaine - 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 with TOMCAT and JSP giving problems..
I am using mySQL with tomcat and JSP without any problem. Hearing about your symptoms, I would guess that your connections need to be refreshed from time to time (after a certain time an unactive connection will be dropped which explain why you have to restart tomcat) You should use a connectionPoolManager. I personally use the one from bitmechanic and I am so far happy with it http://www.bitmechanic.com/projects/jdbcpool/ Regards, Benoit -Original Message- From: aravind gorthy [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 17, 2002 8:19 AM To: [EMAIL PROTECTED] Subject: MySQL with TOMCAT and JSP giving problems.. Hai, I am using MySQL with TOMCAT and JSP for development purpose. 1. Every morning without restarting the tomcat server, i am unable to connect the MySql Database. What might be the problem.. I did't get this type of problem in Oracle SQL server. 2. While Running Tomcat Server , I Loose Database Connection To get Connection from database server, i am restarting tomcat server each time, Is MySQL Behaves same with all Servers ?] Does any one in the list face this type of Problem. Thanks in advance Aravind Gorthy, VisualSoft Technolgies, Hyderabad-India. _ Chat with friends online, try MSN Messenger: http://messenger.msn.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: Problem with access settings on one database on mySQL
Gerald Thanks a lot for that... The first option is what worked, I didn't think to CHMOD the directory to give execute permissions! Just for the record and for any other newbies out there, the database table worked when I CHMOD'd the directory all the .frm, .MYI, .MYD files are held in to 700. Thanks again Keiran -Original Message- From: Gerald Clark [mailto:[EMAIL PROTECTED]] Sent: 17 January 2002 15:30 To: Keiran Wynyard Cc: [EMAIL PROTECTED] Subject: Re: Problem with access settings on one database on mySQL The user under which mysql is running ( 'mysql' ? Better check. ) does not have read permissions on the .frm files OR does not have execute (x) permissions on their parent ( or any ancestor ) directory. chown -R mysql:mysql /var/lib/mysql should do the trick. Replace /var/lib/mysql with the actual directory that contains all of the mysql databases. Keiran Wynyard wrote: Hi I have MySQL running on a RAQ4i. It has been running perfectly well for almost a year and has four separate databases on it. Last week, whilst checking over the sites that make calls on these databases I noticed that only one had problems. Through searching the FAQs and online documentation I have narrowed down the problem to being something to do with the access permissions on the .frm files of the database tables. I am using PHP MyAdmin 2.2.1 to view and edit the tables and data. When I click the database to view the tables they are all displayed, but instead of showing the Records | Type | Size information all the tables show the phrase 'in use'. If I try to browse any of the tables I receive the error message: Error SQL-query : SELECT * FROM `about` LIMIT 0, 30 MySQL said: Can't find file: './gilmours/about.frm' (errno: 13) The file ./gilmours/about.frm does exist, by the way. I have backup copies of all the files (.frm, .MYI, .MYD) and by following the instructions in the online documentation have tried FLUSH TABLE, which runs without error, but doesn't give any change, I have tried all the repair options (REPAIR TABLE, myisamchk) and I have tried CHMODing the files, all without success, the same errors occur. I have also tried the 'very difficult repair' on this page : http://www.mysql.com/doc/R/e/Repair.html still leaving the same error. I cannot drop any tables or even the whole database itself, which would be a viable option as I have full backups of data and structure. I have changed the access restrictions to 666, 550, 777, and finally 660, which is what the tables in the other databases are, with no avail, I have restarted MySQL, numerous times, as well as rebooting the server. I have tried taking a working version of the same table from another database (they all are based on a similar structure) also with no success. The files as the moment stand as '-rw-rw mysql root about.frm' for example, is this correct? H E L P!! please... pretty please, with a cherry on top... Just an extra note, I am a newbie MySQL user, so please do not take anything for granted in your reply. This is my first post to this user group, but I have spent two days looking round the mailing list and FAQs to find the answer, but not really knowing what to search for has hampered my search. Any help will be gratefully and openly accepted. Thanking you in advance... Keiran Wynyard - 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
Access Denied problem in MS Access
Hi I have been experiencing the following error when using MyODBC in Windows 2000 within Microsoft Access 2000 with MDAC Component 2.7: ODBC--call failed [TCX][MyODBC]Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) (#1045) The thing I can't understand is the problem does not always occur, only sometimes - and I known that I am entering the correct password, because like I said sometimes it will work and sometimes it won't, and I have been using the same password on other machines when logging in as root. The permissions table should be set to allow any hostname to connect as i entered root@% as the hostname. I cannot distinguish between times when the error will occur, and times when it will not - it usually only happens on one or two tables in the database, and pretty much always when I try to add a new link table in MS Access. I have tried it with and without the Safety check box checked. The IP is 217.199.170.217, database: orders, logging in as user root on port 3306. Any help that could be provided would be greatly appreciated, this is causing me major problems, and I've got a deadline approaching!! Cheers Joe - 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: Tergat MySQL Studio
And can you turn those off and get normal widgets that respect user system settings? XP style for me is a reason to not even look! At 11:07 2002-01-17, you wrote: Just downloaded and at least it looks pretty creamy with the latest XP style widgets... G: database,sql,query,table -- Marjolein Katsma HomeSite Help - http://hshelp.com/ - Extensions, Tips and Tools The Bookstore - http://books.hshelp.com/ - Books for webmasters and webrookies - 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
Not updating tables with data but no errors either
Hello, I have a freebsd machine running mysql and php. Yes I am one of those newbies. I have read the FU*K manual. I have a sams learn in 21 day book. also a php essentials and build your own database drive book. I have a brazilian rain forest of manuals,printouts etc. We have a php page that we put in people that belong to a football pool. However it is not adding the data to the table. We do not get any error messages either even tho the php page is setup to display the errors. I find no errors in the http-errrors.log. the httpd-access.log shows the post with no errors. I have checked permissions and the seem right. I can go to the machine and add a person by command line. Using the same info as in the mysql_connect on the php page i can add from the command line. Any help, direction or clues is greatly appreciated. mark - 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
instillation problems
I've been trying to install mysql-3.23.43 on a SunOS 5.7 machine. I grabbed mysql-3.23.43-sun-solaris2.7-sparc.tar.gz from the ftp site. I've unzipped and untarred the file, but I don't see a configure file or a Makefile for that matter. What gives? When I issue the tar xvf I get the following error: i686-cmp-adabas,mysql, 691 bytes, 2 tape blocks tar: directory checksum error Any help you could give would be great! Thanks, Chris Stefanick - 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: Memory
John, I had already updated the online manual at http://www.innodb.com. It warns now about the 2 GB limit on memory usage in Linux x86. InnoDB does not use the record_buffer of MySQL at all. But sort_buffer is used. I think the danger lies in server overload: many ORDER BY queries may get stuck in the 'sorting data' phase which will raise memory usage to 2 GB. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com John Kemp wrote in message ... Heikki Jeremy, Thanks again for your help. I'll try it out and see how things go. I will just note that in most of the MySQL documentation talks about how one can set key_buffer or innodb_buffer_pool up to 75% of your maximum memory, which in the case of our db machines is 4GB. I have been monitoring our memory usage under load, and even with the numbers I listed below, I have not yet seen a server crash from 200 simultaneous connections, which has been our peak so far. We did see this a while back on an earlier version (we're now running 3.23.45-max) but our server has been running like this for 45 days and counting. So I guess this is more of a case (as Jeremy seemed to be suggesting) that this *might* happen if we have a lot of simultaneous, tricky queries (when we'd see lots of sort_buffer and record_buffer get allocated for each connection/thread) This also implies that if you're mostly using Innodb tables for querying that you probably wouldn't see this happening, because: 1) Innodb doesn't lock the whole table - so simultaneous queries on the same table will get done faster, and thus memory will be freed up quicker. 2) Does querying or updating the Innodb tablespace effect record_buffer and sort_buffer anyway? The more I think about it, the more I realize that since we started doing work with Innodb tables, our database memory problems have basically gone away. Any thoughts on that? John Director, Software Development Streetmail Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
REPLICATION BUG
From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: REPLICATION BUG Description: The bug manifests itself in the following situation. A temporary table has been created on the master server. A query is executed using an alias for that temporary table. The connection is dropped without explicitly dropping that temporary table. In the binary log, mysql records a drop of the temporary table using the table alias. When the replication server reads this command, it is unaware of a table of this name and replication is dropped. How-To-Repeat: # Perl code sample #!/usr/local/bin/perl5 -w use DBI; my $dbh = DBI-connect(DBI:mysql:DBNAME:DBHOST:DBPORT, User, Password); $dbh-do(CREATE TEMPORARY TABLE tmpTableBug(tempField int not null)); $dbh-do(SELECT TableAlias.tempField FROM tmpTableBug AS TableAlias); $dbh-do(CREATE TEMPORARY TABLE tmpTableOk(tempField int not null)); $dbh-do(SELECT tempField FROM tmpTableOk); $dbh-disconnect; # Server will log drop table APES.tmpTableOk,APES.TableAlias; Fix: Explicitly drop temporary table Submitter-Id: Originator: Organization: MySQL support: none Synopsis: TEMPORARY TABLE DROP causes disconnect of replication slave. Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.41 (Source distribution) Environment: System: SunOS flotsam 5.8 Generic_108528-08 sun4u sparc SUNW,Ultra-4 Architecture: sun4 Some paths: /bin/perl /usr/local/bin/make /usr/local/bin/gcc /opt/SUNWspro.5.0/SC5.0/bin/cc GCC: Reading specs from /usr/local/gcc-2.95.2-sl/lib/gcc-lib/sparc-sun-solaris2.6/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='/usr/local/gcc-2.95.2-sl/bin/gcc -R/usr/local/gcc-2.95.2-sl/lib' CFLAGS='' CXX='/usr/local/gcc-2.95.2-sl/bin/g++ -R/usr/local/gcc-2.95.2-sl/lib' CXXFLAGS='' LDFLAGS='' LIBC: -rw-r--r-- 1 root bin 1759264 Jun 29 2001 /lib/libc.a lrwxrwxrwx 1 root root 11 Aug 22 20:13 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1136692 Jun 29 2001 /lib/libc.so.1 -rw-r--r-- 1 root bin 1759264 Jun 29 2001 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Aug 22 20:13 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1136692 Jun 29 2001 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/unique/apps/mysql-3.23.41 --with-innodb --without-docs Perl: This is perl, version 5.005_03 built for sun4-solaris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FW: Optimization
Hello all, I'm having real trouble trying to optimize MySQL cause I can't believe that MSSQL is faster. My configurations are as follows: MSSQL 2000 on W2K server. PIII 733 - 512 MB memory. MySQL-3.23.47-1 on Redhat 7.2. Dual PIII 1000 - 1.128 GB memory I have a PHP script that runs on a Redhat 7.1 - PIII 500 640 MB memory. The php script takes a username from a mysql table and runs a query for each of the usernames on another table. The test is that I have 2 different versions of the script that do the exactly same thing but one queries the MSSQL server and the other the MySQL. The MSSQL version takes 28 secs while the MySQL takes 34 secs. As you can see the MSSQL is much more slower with less RAM. I said what the heck I will use the my-huge.cnf to see if it makes any difference. Unfortunately nothing changed and then I started panicking.. It can't be true! I noticed that MSSQL caches the queries while MySQL doesn't. In my script I might have this: select emails from dbo_Company where username=''; come up 5 or even 10 times. If I run it on mysql It takes always 0.26 secs while it appears the MSSQL caches the result and doesn't take any time at all. If I get the same query in the script 10 times I'm losing immediately 2.34 secs with MySQL. Is there a way to get the same behavior in MySQL.. Regards, Spyros - 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: Not updating tables with data but no errors either
We have a php page that we put in people that belong to a football pool. However it is not adding the data to the table. We do not get any error messages either even tho the php page is setup to display the errors. I find no errors in the http-errrors.log. the httpd-access.log shows the post with no errors. You're looking in the wrong logs. Find the hostname.err file in the mysql data directory, and look through that. You may also want to try using the update log (mysqld --update_log=...). This will help you find out if the requests do indeed make it to the server. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - 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: running sql commands from a shell
On Thursday 17 Jan 2002 1:13 am, Mr Aaron Brandis wrote: Hi everyone This is the first time I have posted to this list and I was wondering if someone could answer my question. I know you can run commands from a shell prompt (such as unix...) like: shell mysql -e 'SELECT * FROM table' database for a simple select query and shell mysqlimport --local database table.txt to import information from a text file. I was just wondering how (and even if you can) set up a pager and write to a file from the shell. I can do it from the mysql command prompt like this: mysql pager cat /home/aaron/tube.txt; mysql select Run from tubes; This will put the result of the query into tubes.txt So does anyone know if i can do this from the shell prompt?? type tee FILENAME and notee to stop - 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: Optimization
Hi, It's already done since MySQL 4.0.1. Take a look here : http://www.mysql.com/doc/Q/u/Query_Cache.html Regards, Jocelyn - Original Message - From: Ioakim Spyros [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 17, 2002 6:52 PM Subject: FW: Optimization Hello all, I'm having real trouble trying to optimize MySQL cause I can't believe that MSSQL is faster. My configurations are as follows: MSSQL 2000 on W2K server. PIII 733 - 512 MB memory. MySQL-3.23.47-1 on Redhat 7.2. Dual PIII 1000 - 1.128 GB memory I have a PHP script that runs on a Redhat 7.1 - PIII 500 640 MB memory. The php script takes a username from a mysql table and runs a query for each of the usernames on another table. The test is that I have 2 different versions of the script that do the exactly same thing but one queries the MSSQL server and the other the MySQL. The MSSQL version takes 28 secs while the MySQL takes 34 secs. As you can see the MSSQL is much more slower with less RAM. I said what the heck I will use the my-huge.cnf to see if it makes any difference. Unfortunately nothing changed and then I started panicking.. It can't be true! I noticed that MSSQL caches the queries while MySQL doesn't. In my script I might have this: select emails from dbo_Company where username=''; come up 5 or even 10 times. If I run it on mysql It takes always 0.26 secs while it appears the MSSQL caches the result and doesn't take any time at all. If I get the same query in the script 10 times I'm losing immediately 2.34 secs with MySQL. Is there a way to get the same behavior in MySQL.. Regards, Spyros - 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: REPLICATION BUG
The bug manifests itself in the following situation. A temporary table has been created on the master server. A query is executed using an alias for that temporary table. The connection is dropped without explicitly dropping that temporary table. In the binary log, mysql records a drop of the temporary table using the table alias. When the replication server reads this command, it is unaware of a table of this name and replication is dropped. ... Release: mysql-3.23.41 (Source distribution) This bug seems to have been fixed in 3.23.46. From the change log: --- D.2.2 Changes in release 3.23.46 Fixed problem with aliased temporary tables replication --- / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Replication Problems
Hy all, I just try to set up Replication with two mysql databases, i did everything like described in the Replication-Howto. Now i get the following errors when starting the slave: 020117 18:37:55 mysqld started Can't initialize InnoDB as 'innodb_data_file_path' is not set /usr/sbin/mysqld-max: ready for connections 020117 18:37:55 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'samba-bin.001' at position 536 ERROR: 1017 Can't find file: './tropon_001/Tagesberichte.frm' (errno: 13) 020117 18:37:55 Slave: error running query 'CREATE TEMPORARY TABLE TB_Tage TYPE=HEAP SELECT DISTINCT Datum FROM Tagesberichte AS TB WHERE Besucher_ID=10021 ' 020117 18:37:55 Error running query, slave aborted. Fix the problem, and re-start the slave thread with mysqladmin start-slave. We stopped at log 'samba-bin.001' position 536 020117 18:37:55 Slave thread exiting, replication stopped in log 'samba-bin.001' at position 536 the file is actually there (in the data directory at least, i don't know what is meant with the ./tropon... directory exactly as it is a relative path, and i checked if mysql recognizes the data directory by setting some unimpoortant settings in a my.cnf file in there - the changes where accepted correctly, i did make sure to remove that testing file again. When I connect to the database on the slave with mysql-client i get the following: ... Didn't find any fields in table 'Statistiken' Didn't find any fields in table 'Tagesberichte' Database changed I see there are some tables which don't produce errors, but for all, with or without errors, there are .frm files in the data directory, i see there are different file permissions for differenbt table files, but again the failing tables don't have something of those in common. has anyone an idea what i can look for? henning - 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: Optimization
The first thing that comes to mind is that you're running the databases on different hardware and operating systems. I know the Linux kernel had some SMP performance issues not too long ago, prompting IBM to rewrite portions of the kernel and improving performance by (I think) 16-20%. Also, you're only using one processor at a time if your test isn't multithreaded. The general overhead of SMP combined with Linux kernel issues may be where the difference is. I would format a new hard drive with Linux (non-SMP), temporarily install it in the W2K box and see what numbers you get. Bret -Original Message- From: Ioakim Spyros [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 17, 2002 12:53 PM To: [EMAIL PROTECTED] Subject: FW: Optimization Hello all, I'm having real trouble trying to optimize MySQL cause I can't believe that MSSQL is faster. My configurations are as follows: MSSQL 2000 on W2K server. PIII 733 - 512 MB memory. MySQL-3.23.47-1 on Redhat 7.2. Dual PIII 1000 - 1.128 GB memory I have a PHP script that runs on a Redhat 7.1 - PIII 500 640 MB memory. The php script takes a username from a mysql table and runs a query for each of the usernames on another table. The test is that I have 2 different versions of the script that do the exactly same thing but one queries the MSSQL server and the other the MySQL. The MSSQL version takes 28 secs while the MySQL takes 34 secs. As you can see the MSSQL is much more slower with less RAM. I said what the heck I will use the my-huge.cnf to see if it makes any difference. Unfortunately nothing changed and then I started panicking.. It can't be true! I noticed that MSSQL caches the queries while MySQL doesn't. In my script I might have this: select emails from dbo_Company where username=''; come up 5 or even 10 times. If I run it on mysql It takes always 0.26 secs while it appears the MSSQL caches the result and doesn't take any time at all. If I get the same query in the script 10 times I'm losing immediately 2.34 secs with MySQL. Is there a way to get the same behavior in MySQL.. Regards, Spyros - 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: Not updating tables with data but no errors either
On Thursday 17 Jan 2002 4:52 pm, fla wire wrote: Hello, I have a freebsd machine running mysql and php. Yes I am one of those newbies. I have read the FU*K manual. I have a sams learn in 21 day book. also a php essentials and build your own database drive book. I have a brazilian rain forest of manuals,printouts etc. We have a php page that we put in people that belong to a football pool. However it is not adding the data to the table. We do not get any error messages either even tho the php page is setup to display the errors. I find no errors in the http-errrors.log. the httpd-access.log shows the post with no errors. I have checked permissions and the seem right. I can go to the machine and add a person by command line. Using the same info as in the mysql_connect on the php page i can add from the command line. tried the mysql_error() function in php ? printed the connection variable to check you have a resource id ? - 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: check for server start
thanks, sinisa. in case anyone else wants it, here is the shell fragment i wrote to test for this condition. there is no timeout. #!/bin/sh echo -n waiting for MySQL: until [ -n `mysqladmin ping 2/dev/null` ] do echo -n . sleep 1 done echo MySQL started. aaron. /\ | Aaron Brick (415) 206 - 4685 | | [EMAIL PROTECTED] Room 3501C, SFGH | Programmer Analyst, Functional Genomics Core Sandler Center for Basic Research in Asthma Lung Biology Center, Department of Medicine San Francisco General Hospital University of California, San Francisco - 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: Replication Problems - solved!
Hy, sorry for the trouble! i tried to do a chown mysql:daemon -R * in the data dir, and after that it worked. I didn't try that before because somehow i couldn't see a connection between differing ownerships and disfunctional tables when looking at this. sorry, henning Henning Sprang wrote: Hy all, I just try to set up Replication with two mysql databases, i did everything like described in the Replication-Howto. Now i get the following errors when starting the slave: 020117 18:37:55 mysqld started Can't initialize InnoDB as 'innodb_data_file_path' is not set /usr/sbin/mysqld-max: ready for connections 020117 18:37:55 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'samba-bin.001' at position 536 ERROR: 1017 Can't find file: './tropon_001/Tagesberichte.frm' (errno: 13) 020117 18:37:55 Slave: error running query 'CREATE TEMPORARY TABLE TB_Tage TYPE=HEAP SELECT DISTINCT Datum FROM Tagesberichte AS TB WHERE Besucher_ID=10021 ' 020117 18:37:55 Error running query, slave aborted. Fix the problem, and re-start the slave thread with mysqladmin start-slave. We stopped at log 'samba-bin.001' position 536 020117 18:37:55 Slave thread exiting, replication stopped in log 'samba-bin.001' at position 536 the file is actually there (in the data directory at least, i don't know what is meant with the ./tropon... directory exactly as it is a relative path, and i checked if mysql recognizes the data directory by setting some unimpoortant settings in a my.cnf file in there - the changes where accepted correctly, i did make sure to remove that testing file again. When I connect to the database on the slave with mysql-client i get the following: ... Didn't find any fields in table 'Statistiken' Didn't find any fields in table 'Tagesberichte' Database changed I see there are some tables which don't produce errors, but for all, with or without errors, there are .frm files in the data directory, i see there are different file permissions for differenbt table files, but again the failing tables don't have something of those in common. has anyone an idea what i can look for? henning - 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: Replication Problems
chown -R mysql:mysql /var/lib/mysql ( or whatever the data directory is ). Henning Sprang wrote: Hy all, I just try to set up Replication with two mysql databases, i did everything like described in the Replication-Howto. Now i get the following errors when starting the slave: 020117 18:37:55 mysqld started Can't initialize InnoDB as 'innodb_data_file_path' is not set /usr/sbin/mysqld-max: ready for connections 020117 18:37:55 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'samba-bin.001' at position 536 ERROR: 1017 Can't find file: './tropon_001/Tagesberichte.frm' (errno: 13) 020117 18:37:55 Slave: error running query 'CREATE TEMPORARY TABLE TB_Tage TYPE=HEAP SELECT DISTINCT Datum FROM Tagesberichte AS TB WHERE Besucher_ID=10021 ' 020117 18:37:55 Error running query, slave aborted. Fix the problem, and re-start the slave thread with mysqladmin start-slave. We stopped at log 'samba-bin.001' position 536 020117 18:37:55 Slave thread exiting, replication stopped in log 'samba-bin.001' at position 536 the file is actually there (in the data directory at least, i don't know what is meant with the ./tropon... directory exactly as it is a relative path, and i checked if mysql recognizes the data directory by setting some unimpoortant settings in a my.cnf file in there - the changes where accepted correctly, i did make sure to remove that testing file again. When I connect to the database on the slave with mysql-client i get the following: ... Didn't find any fields in table 'Statistiken' Didn't find any fields in table 'Tagesberichte' Database changed I see there are some tables which don't produce errors, but for all, with or without errors, there are .frm files in the data directory, i see there are different file permissions for differenbt table files, but again the failing tables don't have something of those in common. has anyone an idea what i can look for? henning - 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: Optimization
Problem Solved. Indeed version 4 does work :-) Here are some times I got for all of you mysql fans (I knew that mysql couldn't let me down :-)) MSSQL: 28,6 secs MySQL 3: 40,1 secs MySQL 4: 36,3 secs MySQL 4 (caching enabled): 21,9 secs MySQL 4 (caching enabled - second pass): 0 secs So indeed caching DOES work.. Thanks a lot guys -Original Message- From: Fournier Jocelyn [Presence-PC] [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 17, 2002 7:58 PM To: Ioakim Spyros; [EMAIL PROTECTED] Subject: Re: Optimization Hi, It's already done since MySQL 4.0.1. Take a look here : http://www.mysql.com/doc/Q/u/Query_Cache.html Regards, Jocelyn - Original Message - From: Ioakim Spyros [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 17, 2002 6:52 PM Subject: FW: Optimization Hello all, I'm having real trouble trying to optimize MySQL cause I can't believe that MSSQL is faster. My configurations are as follows: MSSQL 2000 on W2K server. PIII 733 - 512 MB memory. MySQL-3.23.47-1 on Redhat 7.2. Dual PIII 1000 - 1.128 GB memory I have a PHP script that runs on a Redhat 7.1 - PIII 500 640 MB memory. The php script takes a username from a mysql table and runs a query for each of the usernames on another table. The test is that I have 2 different versions of the script that do the exactly same thing but one queries the MSSQL server and the other the MySQL. The MSSQL version takes 28 secs while the MySQL takes 34 secs. As you can see the MSSQL is much more slower with less RAM. I said what the heck I will use the my-huge.cnf to see if it makes any difference. Unfortunately nothing changed and then I started panicking.. It can't be true! I noticed that MSSQL caches the queries while MySQL doesn't. In my script I might have this: select emails from dbo_Company where username=''; come up 5 or even 10 times. If I run it on mysql It takes always 0.26 secs while it appears the MSSQL caches the result and doesn't take any time at all. If I get the same query in the script 10 times I'm losing immediately 2.34 secs with MySQL. Is there a way to get the same behavior in MySQL.. Regards, Spyros - 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 - 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: why too long entries get _cut_ without error
Doesn't matter: If you assign a value to a CHAR or VARCHAR column that exceeds the column's maximum length, the value is truncated to fit. ok, so it isn't depending on fixed length as you first said, and the reason for it is just the simple design of sql, right? As I see it, the question is what should an SQL server do in this case of a value being assigned to a CHAR (or VARCHAR) column that exceeds the column's maximum length. The current action is that this value is truncated to fit the column. The other option would be to automagically expand the column's length so the value would fit. Despite what the original poster may think, they _really_ don't want that to happen. Apart from applications that depend on only receiving a certain length string from a query (think buffer overflow), having an insert unexpected alter an indexed char column on a 200,000 row table would be A Bad Thing. I wouldn't be terribly opposed to having an option to be set to allow this, but it shouldn't be on by default, and most MySQL users who can read the manual and find the option to do this should already know why this is a bad thing and not want to use it. Ryan - 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: Tergat MySQL Studio
Nope. Looks like you're stuck with their creamy look. In fact, it doesn't really use XP widgets - it uses it's own widget set/skin which looks more like an MP3 player than a db admin tool. Incidentally, their database admin tool, called Navicat, looks awfully familiar... It's basically just a rebranded/reskinned version of SciBit's Mascon. The rest of the MySQL Studio consists of stock, installable versions of MySQL Max, Apache, PHP and MyODBC. So basically, if you already own Mascon (or buy it from http://www.scibit.com/ for $49.00), and download the latest installable binary releases of MySQL, Apache, etc, you've got the MySQL Studio, and as a bonus, it features a clean, standard UI, with the standard Windows style widgets. Al P.S. For those who haven't used Mascon, I highly recommend it. It's a terrific tool for managing MySQL databases -Original Message- From: Marjolein Katsma [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 17, 2002 11:16 AM To: MySQL Subject: Re: Tergat MySQL Studio And can you turn those off and get normal widgets that respect user system settings? XP style for me is a reason to not even look! At 11:07 2002-01-17, you wrote: Just downloaded and at least it looks pretty creamy with the latest XP style widgets... G: database,sql,query,table -- Marjolein Katsma HomeSite Help - http://hshelp.com/ - Extensions, Tips and Tools The Bookstore - http://books.hshelp.com/ - Books for webmasters and webrookies - 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: why too long entries get _cut_ without error
Doesn't matter: If you assign a value to a CHAR or VARCHAR column that exceeds the column's maximum length, the value is truncated to fit. ok, so it isn't depending on fixed length as you first said, and the reason for it is just the simple design of sql, right? As I see it, the question is what should an SQL server do in this case of a value being assigned to a CHAR (or VARCHAR) column that exceeds the column's maximum length. It should, of course, follow the SQL standard, which explicitly states that the value should be truncated and a warning issued. MySQL does both. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - 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
unmatched records
I am trying to compare two tables and get a list of all the data that does not match. How can I compare all the fields from two tables with one SQL statement? I've been using the Find Unmatched Query Wizard, but it will only let me compare one field at a time. I want to list all the ID numbers that have differing info in any field from two tables. Jac - 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
need developer to help transfer our site
Hello, We have a site that uses PHP and MySQL on Linux, and we need to get it moved from our own server to a professionally hosted server. Unfortunately no one in our organization has enough Linux and MySQL knowledge to make this happen, so we're looking to hire an experienced developer for this project. The site is not very big, and our new host is already in place, so it should be mostly a matter of transferring files. If anyone on this list is interested in our meager project please reply to me directly at [EMAIL PROTECTED] Thanks, JP - 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: why too long entries get _cut_ without error
On Thu, 17 Jan 2002, Henning Sprang wrote: ok, so it isn't depending on fixed length as you first said, and the reason for it is just the simple design of sql, right? Right. (Sorry for the previous inacuracy, I was using 'fixed' in a wide sense viz. including 'bounded'.) Cheers, -- , M A R I O data miner, LIACC, room 221 tel 351+226078830, ext 121 A M A D O Rua Campo Alegre, 823 fax 351+226003654 A L V E S P-4150-180 PORTO, Portugalmob 351+939354002 - 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: Tergat MySQL Studio
On Thursday 17 Jan 2002 7:16 pm, Alok K. Dhir wrote: P.S. For those who haven't used Mascon, I highly recommend it. It's a terrific tool for managing MySQL databases the only thing I would say against it, is that it's a client not a server, and a larger organisation that needs to change passwords has a small problem with informing every user. (I've had similar problems myself when disgruntled employees have left). - 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
Compiling on Solaris
A couple of questions about compiling on Solaris. 1) Are the Sun Workshop 6 compilers supported for MySQL and MySQL++? 1a) Can you use the -native flag without problems? 2) Is the binary distribution compiled with Sun or GNU compilers? Background Info: We are currently trying to ingest 1.5M/sec of weather data into a database, and we have had luck using MySQL 3.23.4x on a Linux 800Mhz machine with 256M of RAM. However, this machine is basically useless for anything else, and it is my desktop. We have several Sun servers with 4+ procs and 4+Gb of RAM, and I thought one would make a good ingest machine. So I would like to compile MySQL and MySQL++ with the Sun compilers to take full advantage of everything the platform has to offer. Any help would be great. Thanks, Brad Teale Universal Weather and Aviation, Inc. 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: why too long entries get _cut_ without error
On Thu, 17 Jan 2002, Ryan Fox wrote: The current action is that this value is truncated to fit the column. The other option would be to automagically expand the column's length so the value would fit. Despite what the original poster may think, they _really_ don't want that to happen. Right. That is what the 'text' type is there for. I wouldn't be terribly opposed to having an option to be set to allow this, No need. Just let the 'text' type get into the SQL standard, if it is not already there. Cheers, -- , M A R I O data miner, LIACC, room 221 tel 351+226078830, ext 121 A M A D O Rua Campo Alegre, 823 fax 351+226003654 A L V E S P-4150-180 PORTO, Portugalmob 351+939354002 - 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
SQL Forum
Hi. I have been attached to this mailing list for some months now. And i just love it when i open my post box to find 110 new emails! ;) ANyway, i have installed a bullitin board (vbullitin) with a table for SQL. I know the mailing list is a convenient way to keep track of things, but a board is a handy way of getting help. the link is www.forums.iainpb.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: MySQLd-MAX Crash - Possible Bug v3.23.47?
Rich, it was a bug. If inserts to several tables containing an auto-inc column are wrapped inside one LOCK TABLES, InnoDB will assert in lock0lock.c, line 2843. Workaround: remove the LOCK TABLES if you can, or LOCK just one table at a time. I have fixed the bug to 3.23.48. You will get a patch to ha_innobase.cpp if you need. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB Rich wrote in message ... v3.23.47 I have managed to Carsh the DB Server. I have a routine in my application which imports exports a database. My Import does the following process, (all commands sent through MyODBC). 1- Lock Table table1 write repeated for all tables in db. 2- Delete from table1 3- insert data into table1 (using INSERT, SQL constructed from data in an XML file) Repeat steps 2+3 for all tables. But when it gets to the very first insert of the sceond table, the server crashes with an assertion error, leaving my application to complain theres no MySQL server. Console Monitor shows: 020117 14:27:57 InnoDB: Started c:\mysql\bin\mysqld-max-nt: ready for connections InnoDB: Assertion failure in thread 1136 in file C:\get\innobase\lock\lock0lock.c line 2843 InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] InnoDB: Thread 1016 stopped in file C:\get\innobase\os\os0sync.c line 140 This procedure worked fine in MySQL v3.23.38 but since upgrading it does not work. I have tried ammending the SQL commands to a file and sending the SQL file through the server on the command line and there are no errors. I have tried upgrading MyODBC still nothing. Has anyone had any similar errors? - 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: Tergat MySQL Studio
looks more like an MP3 player than a db admin tool. Which is not necessary a bad thing :) I guess the main reason why linux is not growing its user base on desktops is the awful design of the UI of all basic apps. In addition to the lack of compatibility to M$ tools.. Incidentally, their database admin tool, called Navicat, looks awfully familiar... It's basically just a rebranded/reskinned version of SciBit's Mascon. The rest of the MySQL Studio consists of stock, installable versions of MySQL Max, Apache, PHP and MyODBC. You're right. There seems to be actually an additional launcher for MySQL server, some extra manuals and a hate-me nag-screen in the admin. There is also Mac release, which looks quite different: http://www.mysqlstudio.com/mac_detail.php3. Has anyone tried that yet? cheers, dutch _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - 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 Tcl/tk and Win me
Hello I am working in a project on Tcl/tk and Mysql, I use Win98, Just change my computer to a Sony Vaio PIII It comes whit Win me. We can not make it work, has any body do it? it so could you send me the .dll files or I just go back to win98. Alberto Romero [EMAIL PROTECTED] Mazatlan Mexico _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - 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
ID in table
Is there any way to start Ids in table from some number for exampl 1 with function auto_increment and not from 1? tnx jure - 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
Optimal value for 'max_connections'
Hi, i've been googlizing for a while now and can't find a straight answer to this question: - what is the optimal setting for max_connections in mysql? - how do i start the server w a higher number? stats on my db setup: - database machine has 384MB of ram - clients are web browsers hitting jsp pages which access the mysql db - one person can generate tens of threads moving around the site - current max connections is 100 - production server is red hat linux, dev server where i do all my development is win2k - Connections/Threads_Connected is currently 1:1 (cache problem?) i obviously need to do some optimization in my java code and jsp pages (who doesn't ;), but i also suspect the default 100 connections is too low. can i set this to 500 or 1000? also, i've been looking for a good site with mysql optimization tips, any suggestions? thanks a ton. -mitch - 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 can't find table forms.
Remember a while back when I posted about restoring a mysqlhotcopy copied database that I got an error that it can't find the .frm file? Well, the error reports have been coming in that apparently most if not all my tables (restored or new) have the same error. Here is a sample from one of the pages. Can't find file: './qwerty/table1.frm' (errno: 13) --- Anybody know of a possible reason for this? I have tried restarting mysqld as well as the entire server without any better results. I seem to be able to query some of the tables from the mysql client on the server machine but not always. Quick help would be very much appreciated, as this seems to have gone from bad to worse. Thanks in advance, ~Travis PS - I have just finished backing up all the databases using mysqldump as well as mysqlhotcopy (a little redundant but I don't want to lose any data). - 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: need developer to help transfer our site
Hi Has your host installed and configured MySQL, Apache, and PHP? If that's the case you're looking at a few of hours of work (depending on site size) Let me know if that's been done and give me some basic idea of your site size and I can get back with a price. Fred Steinkopf On Thu, 17 Jan 2002, JP Audette wrote: Hello, We have a site that uses PHP and MySQL on Linux, and we need to get it moved from our own server to a professionally hosted server. Unfortunately no one in our organization has enough Linux and MySQL knowledge to make this happen, so we're looking to hire an experienced developer for this project. The site is not very big, and our new host is already in place, so it should be mostly a matter of transferring files. If anyone on this list is interested in our meager project please reply to me directly at [EMAIL PROTECTED] Thanks, JP - 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 can't find table forms.
Error 13 is permission denied. chown -R mysql:mysql /var/lib/mysql ( or whatever ) Travis Farmer wrote: Remember a while back when I posted about restoring a mysqlhotcopy copied database that I got an error that it can't find the .frm file? Well, the error reports have been coming in that apparently most if not all my tables (restored or new) have the same error. Here is a sample from one of the pages. Can't find file: './qwerty/table1.frm' (errno: 13) --- Anybody know of a possible reason for this? I have tried restarting mysqld as well as the entire server without any better results. I seem to be able to query some of the tables from the mysql client on the server machine but not always. Quick help would be very much appreciated, as this seems to have gone from bad to worse. Thanks in advance, ~Travis PS - I have just finished backing up all the databases using mysqldump as well as mysqlhotcopy (a little redundant but I don't want to lose any data). - 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 can't find table forms.
Remember a while back when I posted about restoring a mysqlhotcopy copied database that I got an error that it can't find the .frm file? Well, the error reports have been coming in that apparently most if not all my tables (restored or new) have the same error. Here is a sample from one of the pages. Can't find file: './qwerty/table1.frm' (errno: 13) --- $ perror 13 Error code 13: Permission denied What are the file/directory permissions on the mysql directory? And the qwery directory? and the .frm file? Does the user running mysqld have permission to read/write/execute on those dirs/files? Might you at some point have been running mysqld as root, and now you are running it as the user mysql? / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - 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
FW: ID in table
Is there any way to start Ids in table from some number for exampl 1 with function auto_increment and not from 1? http://www.bitbybit.dk/mysqlfaq/faq.html#ch6_4_0 / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - 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: ID in table
I believe auto_increment uses the last highest value inserted into the record. So if your first insert is 1000, it will count up from 1000 there on after. Correct me if wrong. Mike -Original Message- From: Jure Grom [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 17, 2002 3:56 PM To: MySQL - List Subject: ID in table Is there any way to start Ids in table from some number for exampl 1 with function auto_increment and not from 1? tnx jure - 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: Optimal value for 'max_connections'
You can set your max_connections variable thusly: mysqld -O max_connections=1000 (That's an upper-case letter O and the above needs to be appended to the other options that start mysqld -Original Message- From: Mitch Fournier [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 17, 2002 3:00 PM To: [EMAIL PROTECTED] Subject: Optimal value for 'max_connections' Hi, i've been googlizing for a while now and can't find a straight answer to this question: - what is the optimal setting for max_connections in mysql? - how do i start the server w a higher number? stats on my db setup: - database machine has 384MB of ram - clients are web browsers hitting jsp pages which access the mysql db - one person can generate tens of threads moving around the site - current max connections is 100 - production server is red hat linux, dev server where i do all my development is win2k - Connections/Threads_Connected is currently 1:1 (cache problem?) i obviously need to do some optimization in my java code and jsp pages (who doesn't ;), but i also suspect the default 100 connections is too low. can i set this to 500 or 1000? also, i've been looking for a good site with mysql optimization tips, any suggestions? thanks a ton. -mitch - 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
Innodb funny error
Hi Heikki, Thought you might want to hear this one, I was trying to mysqldump our support database (all tables innodb) WHen I got the following error: bash-2.04$ mysqldump --opt -uken -p supportdb terms supportdb.dump Enter password: mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table 'terms' at row: 0 The server did not restart, all other tables would dump fine, but terms would not. I then altered the table type to myisam: alter table terms type=myisam --- then back to innodb alter table terms type=innodb And then the dump proceeded with no error! Are you aware of any problems like this? If it happens again would you like any other info? Ken P.S. Here is version info (running FreeBSD 4.4-stable) this is our internal test server bash-2.04$ mysqladmin -uken -p ver Enter password: mysqladmin Ver 8.23 Distrib 4.0.1-alpha, for unknown-freebsdelf4.4 on i386 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 4.0.1-alpha-debug-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 19 hours 48 min 33 sec Threads: 34 Questions: 161144 Slow queries: 5 Opens: 719 Flush tables: 1 Open tables: 522 Queries per second avg: 2.260 bash-2.04$ - Ken Menzel ICQ# 9325188 www.icarz.com [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: Compiling on Solaris
I found the answers to my previous question about MySQL in the manual. Doh!
However, when I tried to compile MySQL, I ran into the following error:
/bin/sh ../libtool --mode=compile cc
-DDEFAULT_CHARSET_HOME=\/export/home/bteale/mysql-3.23.47\
-DDATADIR=\/export/home/bteale/mysql-3.23.47/var\
-DSHAREDIR=\/export/home/bteale/mysql-3.23.47/share/mysql\
-DUNDEF_THREADS_HACK -DDONT_USE_RAID -I./../include -I../include
-I./.. -I.. -I..-O -DDBUG_OFF -Xa -fast -native -xstrconst -mt
-DHAVE_CURSES_H -I/export/home/bteale/pkgs/mysql-3.23.47/include
-DHAVE_RWLOCK_T -c hash.c
rm -f .libs/hash.lo
cc -DDEFAULT_CHARSET_HOME=\/export/home/bteale/mysql-3.23.47\
-DDATADIR=\/export/home/bteale/mysql-3.23.47/var\
-DSHAREDIR=\/export/home/bteale/mysql-3.23.47/share/mysql\
-DUNDEF_THREADS_HACK -DDONT_USE_RAID -I./../include -I../include -I./.. -I..
-I.. -O -DDBUG_OFF -Xa -fast -native -xstrconst -mt -DHAVE_CURSES_H
-I/export/home/bteale/pkgs/mysql-3.23.47/include -DHAVE_RWLOCK_T -c hash.c
-KPIC -DPIC
cc: Warning: -xarch=native has been explicitly specified, or implicitly
specified by a macro option, -xarch=native on this architecture implies
-xarch=v8plusa which generates code that does not run on pre UltraSPARC
processors
hash.c, line 189: reference to static variable hash_key in inline extern
function
hash.c, line 229: cannot recover from previous errors
cc: acomp failed for hash.c
make[2]: *** [hash.lo] Error 1
make[2]: Leaving directory `/export/home/bteale/pkgs/mysql-3.23.47/libmysql'
make[1]: *** [all-recursive] Error 1
I looked into hash.c, and the relevant code is as follows:
183: #ifndef _FORTREC_
184: inline
185: #endif
186: uint rec_hashnr(HASH *hash,const byte *record)
187: {
188: uint length;
189: byte *key=hash_key(hash,record,length,0);
190: return (*hash-calc_hashnr)(key,length);
191: }
To fix the problem I poked around, and ended up commenting out lines
183-185. After this it compiles fine. Will this lead to any problems?
Computer Config:
SunOS 5.8 sun4u sparc SUNW, Ultra-80
Sun Workshop 6 update 2 5.3 2001/05/15
Thanks,
Brad Teale
Universal Weather and Aviation, Inc.
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
Choosing Indexes
Would choosing a varchar field with 80 duplicate values, be a good candidate for indexing. Please take a look at my table structure. I am thinking of using the column odorant for indexing even though there will always be 80 duplicate values, per odorant, and there will be 350 unique odorants. Each odorant has 80 rows of data(A-AT). I am seriously wondering if this denormalization would actually give me a performance gain over normalizing the database. Any suggestions or comments are welcome. Also, I have gotten into the habit of creating a primary key with an automatically created number, is this unnecessary? I am seriously wondering just because of the amount of data that will be on disk and let alone the statistical calculations which I will need to do in memory. Thanks, SpartaCruz CREATE TABLE Odorants( id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT, odorantVARCHAR(30) NOT NULL, row TINYINT UNSIGNED NOT NULL, A DOUBLE(4,20), B DOUBLE(4,20), C DOUBLE(4,20), D DOUBLE(4,20), E DOUBLE(4,20), F DOUBLE(4,20), G DOUBLE(4,20), H DOUBLE(4,20), I DOUBLE(4,20), J DOUBLE(4,20), K DOUBLE(4,20), L DOUBLE(4,20), M DOUBLE(4,20), N DOUBLE(4,20), O DOUBLE(4,20), P DOUBLE(4,20), Q DOUBLE(4,20), R DOUBLE(4,20), S DOUBLE(4,20), T DOUBLE(4,20), U DOUBLE(4,20), V DOUBLE(4,20), W DOUBLE(4,20), X DOUBLE(4,20), Y DOUBLE(4,20), Z DOUBLE(4,20), AA DOUBLE(4,20), AB DOUBLE(4,20), AC DOUBLE(4,20), AD DOUBLE(4,20), AE DOUBLE(4,20), AF DOUBLE(4,20), AG DOUBLE(4,20), AH DOUBLE(4,20), AI DOUBLE(4,20), AJ DOUBLE(4,20), AK DOUBLE(4,20), AL DOUBLE(4,20), AM DOUBLE(4,20), AN DOUBLE(4,20), AO DOUBLE(4,20), AP DOUBLE(4,20), AQ DOUBLE(4,20), AR DOUBLE(4,20), AS DOUBLE(4,20), AT DOUBLE(4,20), PRIMARY KEY (id), UNIQUE UC_id (id)); - 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: Innodb funny error
Ken, the 'connection lost' error suggests some bug in the client or communication. Since you are running 4.0.1-alpha, it could be something with the query cache. I think Sanja has already fixed some bugs there since 4.0.1 was released. The query cache is suspect since the error did not crash the server, and it was restricted to one table. Well, the next time you get the problem you could try just inserting a single additional row to the table. That should invalidate the query cache, I think. ALTER TABLE certainly does that. I am forwarding this report to Monty and Sanja. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB Ken Menzel wrote in message ... Hi Heikki, Thought you might want to hear this one, I was trying to mysqldump our support database (all tables innodb) WHen I got the following error: bash-2.04$ mysqldump --opt -uken -p supportdb terms supportdb.dump Enter password: mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table 'terms' at row: 0 The server did not restart, all other tables would dump fine, but terms would not. I then altered the table type to myisam: alter table terms type=myisam --- then back to innodb alter table terms type=innodb And then the dump proceeded with no error! Are you aware of any problems like this? If it happens again would you like any other info? Ken P.S. Here is version info (running FreeBSD 4.4-stable) this is our internal test server bash-2.04$ mysqladmin -uken -p ver Enter password: mysqladmin Ver 8.23 Distrib 4.0.1-alpha, for unknown-freebsdelf4.4 on i386 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 4.0.1-alpha-debug-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 19 hours 48 min 33 sec Threads: 34 Questions: 161144 Slow queries: 5 Opens: 719 Flush tables: 1 Open tables: 522 Queries per second avg: 2.260 bash-2.04$ - Ken Menzel ICQ# 9325188 www.icarz.com [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: ID in table
It's messy but you can also insert x rows, then delete x rows and the next row inserted will have id x+1 assuming that you started with 0 rows. -- Peter Dunham Ellipse Media t. +44 (0)20 8656 0950 --- -Original Message- From: Mike Grabski [mailto:[EMAIL PROTECTED]] Sent: 17 January 2002 21:24 To: 'Jure Grom' Cc: MySQL - List Subject: RE: ID in table I believe auto_increment uses the last highest value inserted into the record. So if your first insert is 1000, it will count up from 1000 there on after. Correct me if wrong. Mike -Original Message- From: Jure Grom [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 17, 2002 3:56 PM To: MySQL - List Subject: ID in table Is there any way to start Ids in table from some number for exampl 1 with function auto_increment and not from 1? tnx jure - 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 - 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: [PHP] Mac OSX !?!?!?
There is a utility called daemonic which is designed to deal with this as well, but works for more than just MySQL -- it's intended to be used for all server daemons. http://daemonic.sourceforge.net/ It is Mac OS X-specific at this time, but according to the web site is designed for future compatibility with any operating system. It can be installed via Fink (http://fink.sourceforge.net) very easily, and is in fact required by many Fink packages. I must confess that I do not know much about it. Erik On Wednesday, January 16, 2002, at 08:01 PM, Richard Baskett wrote: Although the MySQL warnings, I got those because MySQL does not automatically start in OSX, if you know it's started then Im not sure, but if not.. go here to get the autostart utility: http://www.entropy.ch/software/macosx/mysql/ - 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
SHOW STATUS LIKE 'Uptime'
Hi. I recently installed MyCC 0.0.8 on Windows XP, and when attempting to connect to a MySQL 3.22.30-MIPS server, MyCC crashes after automatically issuing the following command: SHOW STATUS LIKE 'Uptime'. I've tested this using the generic mysql client, and indeed the server reports that this is an invalid command. I've checked the MySQL manual, and this looks like correct syntax, but obviously my server does not like it. I've already tried upgrading to 3.23.47 but am having little luck attempting to compile it on my Cobalt RaQ2 (I'd probably need to update gcc and glibc, which I'm not willing to do at this stage). Can this be fixed? 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: Memory
In the last episode (Jan 17), Jeremy Zawodny said: On Thu, Jan 17, 2002 at 04:37:40PM +0200, Heikki Tuuri wrote: The maximum process space of Linux x86 is 2 GB, and better play safe. Jeremy, I think some Intel x86 processors support segmented memory above 4 GB. Is that supported in Linux? Not sure. Most of what I've heard has always come back to the 2GB limit for a single process. There's probably some discussion of it in the linux-kernel archives. You can shift the kernel/userland split point; make it 3gb userland, 1gb kernel, but you probably don't want to go any more than that. Oracle has used multiple shared memory segments to allow a single process to access more than 4GB of memory on a 32-bit machines for years. You allocate (say) 10 600MB segments, but only map two in at a time. This approach wouldn't work well for Mysql since it's a single process. Threads all share the same address space, so all the threads would have to agree on which 2 segments to use at any point in time. -- 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
RE: SHOW STATUS LIKE 'Uptime'
Hi! Thanks a lot for you bug report. This has already been fixed and it will be available as soon as 0.8.1 (note the versioning scheme change) is released. Regards, Jorge -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico ___/ www.mysql.com -Original Message- From: Charles Burnett [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 17, 2002 5:05 PM To: [EMAIL PROTECTED] Subject: SHOW STATUS LIKE 'Uptime' Hi. I recently installed MyCC 0.0.8 on Windows XP, and when attempting to connect to a MySQL 3.22.30-MIPS server, MyCC crashes after automatically issuing the following command: SHOW STATUS LIKE 'Uptime'. I've tested this using the generic mysql client, and indeed the server reports that this is an invalid command. I've checked the MySQL manual, and this looks like correct syntax, but obviously my server does not like it. I've already tried upgrading to 3.23.47 but am having little luck attempting to compile it on my Cobalt RaQ2 (I'd probably need to update gcc and glibc, which I'm not willing to do at this stage). Can this be fixed? 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: Memory
On Thu, Jan 17, 2002 at 05:06:07PM -0600, Dan Nelson wrote: In the last episode (Jan 17), Jeremy Zawodny said: On Thu, Jan 17, 2002 at 04:37:40PM +0200, Heikki Tuuri wrote: The maximum process space of Linux x86 is 2 GB, and better play safe. Jeremy, I think some Intel x86 processors support segmented memory above 4 GB. Is that supported in Linux? Not sure. Most of what I've heard has always come back to the 2GB limit for a single process. There's probably some discussion of it in the linux-kernel archives. You can shift the kernel/userland split point; make it 3gb userland, 1gb kernel, but you probably don't want to go any more than that. Oracle has used multiple shared memory segments to allow a single process to access more than 4GB of memory on a 32-bit machines for years. You allocate (say) 10 600MB segments, but only map two in at a time. This approach wouldn't work well for Mysql since it's a single process. Threads all share the same address space, so all the threads would have to agree on which 2 segments to use at any point in time. Well, it's a good thing that affordable 64 bit hardware is on the way... :-) -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 14 days, processed 347,170,435 queries (267/sec. avg) - 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: Feature comparison and alternate approaches (MySql - PostgreSql/Oracle)
Steve Rapaport still at large are the (MySQL) police chasing you, or is this the consequence of an enjoyable festive season? =dn - 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: ID in table
People, KISS principle! Please research Table Options in 6.5.3 CREATE TABLE Syntax because this can be done when you set up/re-create or ALTER the table, without fuss... Regards, =dn - Original Message - From: Peter Dunham [EMAIL PROTECTED] To: Mike Grabski [EMAIL PROTECTED]; 'Jure Grom' [EMAIL PROTECTED] Cc: MySQL - List [EMAIL PROTECTED] Sent: 17 January 2002 22:43 Subject: RE: ID in table It's messy but you can also insert x rows, then delete x rows and the next row inserted will have id x+1 assuming that you started with 0 rows. -- Peter Dunham Ellipse Media t. +44 (0)20 8656 0950 --- -Original Message- From: Mike Grabski [mailto:[EMAIL PROTECTED]] Sent: 17 January 2002 21:24 To: 'Jure Grom' Cc: MySQL - List Subject: RE: ID in table I believe auto_increment uses the last highest value inserted into the record. So if your first insert is 1000, it will count up from 1000 there on after. Correct me if wrong. Mike -Original Message- From: Jure Grom [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 17, 2002 3:56 PM To: MySQL - List Subject: ID in table Is there any way to start Ids in table from some number for exampl 1 with function auto_increment and not from 1? tnx jure - 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 - 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: [PHP] Mac OSX !?!?!?
There is a link at http://www.entropy.ch/software/macosx/mysql/ for a startup items package. This will cause MySQL to start when you restart the Mac OS X system. On 1/17/2002 8:30 AM, Erik Price [EMAIL PROTECTED] wrote: There is a utility called daemonic which is designed to deal with this as well, but works for more than just MySQL -- it's intended to be used for all server daemons. http://daemonic.sourceforge.net/ It is Mac OS X-specific at this time, but according to the web site is designed for future compatibility with any operating system. It can be installed via Fink (http://fink.sourceforge.net) very easily, and is in fact required by many Fink packages. I must confess that I do not know much about it. Erik On Wednesday, January 16, 2002, at 08:01 PM, Richard Baskett wrote: Although the MySQL warnings, I got those because MySQL does not automatically start in OSX, if you know it's started then Im not sure, but if not.. go here to get the autostart utility: http://www.entropy.ch/software/macosx/mysql/ - 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 -- Jim Dickenson mailto:[EMAIL PROTECTED] Computers for Marketing Corporation http://www.cfmc.com/ eFax: 1-419-791-8924 - 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
. Priority - mysql_connect() ??
Well, Another app was launched on my mySQL server. Only this one is poorly coded and heavily used. Is there a way to change the priority of my connection? My entire app consists of select statements. Once I changed everything to SELECT HIGH_PRIORITY ..., that helped a ton. Can I bump my db connection higher? 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
Why does DISTINCT take so long time ??
Hi, I've notice sometimes DISTINCT clause take a really high amount of time to remove duplicates whereas it should be really quick (I assume it should be ;)) My first query is : mysql SELECT COUNT(*) as count, numreponse FROM searchhardwarefr3 GROUP BY mot,date,numreponse HAVING count1 LIMIT 100; it returns : +---++ | count | numreponse | +---++ | 2 | 111239 | | 2 | 108183 | | 2 | 73 | | 2 | 111383 | cut | 2 | 111239 | | 2 | 111760 | | 3 | 109166 | | 2 | 09 | | 3 | 109166 | +---++ 58 rows in set (14 min 51.15 sec) My second query is : mysql SELECT DISTINCT COUNT(*) as count, numreponse FROM searchhardwarefr3 GROUP BY mot,date,numreponse HAVING count1 LIMIT 100; Well I'm not enough patient to wait, but when I stop the querie, it has been running for more than 3500 seconds... (and more than 45mn in 'Removing duplicates' state...) mysql EXPLAIN SELECT DISTINCT COUNT(*) as count, numreponse FROM searchhardwarefr3 GROUP BY mot,date,numreponse HAVING count1 LIMIT 100; +---+---+---+-+-+--+ -+--+ | table | type | possible_keys | key | key_len | ref | rows| Extra| +---+---+---+-+-+--+ -+--+ | searchhardwarefr3 | index | NULL | PRIMARY | 75 | NULL | 2026032 | Using index; Using temporary | +---+---+---+-+-+--+ -+--+ 1 row in set (0.00 sec) mysql EXPLAIN SELECT COUNT(*) as count, numreponse FROM searchhardwarefr3 GROUP BY mot,date,numreponse HAVING count1 LIMIT 100; +---+---+---+-+-+--+ -+--+ | table | type | possible_keys | key | key_len | ref | rows| Extra| +---+---+---+-+-+--+ -+--+ | searchhardwarefr3 | index | NULL | PRIMARY | 75 | NULL | 2026032 | Using index; Using temporary | +---+---+---+-+-+--+ -+--+ 1 row in set (0.00 sec) Why does it take so much time to remove duplicates in only 58 rows ?? Thank you :) Regards, Jocelyn Fournier Presence-PC - 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 and PHP on a RaQ Server
Hi, This is my first post to this list so please be patient on this one. I was told that this might be the place to get an answer to this question, although not entirely a MySQL Question. So, any suggestions or help would appreciated. We have a RaQ4i 400MHz server with 512MB of RAM running PHP4.03p1 and MySQL 3.23.43 if memory serves correctly. We are looking at bringing on a client who uses 1 MySQL database and PHP to host a news site similar to Slashdot, the OpenSource app he uses is called GeekLog, if anyone has heard of it. He gets about 5000 unique visitors a day and about 10 page views per day. He uses about 30GB of bandwidth a month. I cannot say how many actual queries the databases gets unfortunately. Most (30-40%) of the traffic appears to be around mid-day My question is - what is the opinion that our server can handle this site. In mind and experience there should be no problem with a site as this. Again, I realize that this is partially off topic, but it would also be nice to know of various server configurations that work with MySQL for people who are making custom installations with varying demands and configurations. Does such a place exist. Many thanks in advance for any help that anyone on the list can offer. James Riordon System Administrator Amigo-3 Interactive Inc. http://www.amigo-3.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: . Priority - mysql_connect() ??
On Thu, Jan 17, 2002 at 08:27:40PM -0500, Jon Shoberg wrote: Well, Another app was launched on my mySQL server. Only this one is poorly coded and heavily used. That sucks. :-( Is there a way to change the priority of my connection? My entire app consists of select statements. Once I changed everything to SELECT HIGH_PRIORITY ..., that helped a ton. Can I bump my db connection higher? Other than what you've done, nothing else comes to mind. Any chance you can add indexes on the tables which may help the poorly coded app? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 15 days, processed 354,021,062 queries (267/sec. avg) - 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 1114 table full with 14000 error??
I am running Mysql 4.0 with InnoDB on a linux 2.4.0
machine
I am doing a mass import of a file with some 40
inserts
and I get a strange unknown error 1114
Interestingly enough , this is not exactly
reproducible, i.e.
the error occurs in slightly different import
positions.
I have been able thus far to successfully import at
least 10 such files
with the same size with no problems.
Any ideas of what is wrong??
Thanks, S.Alexiou
sp@qu5:~/NEW4 perror 1114
Error code 1114: Unknown error 1114
sp@qu5:~/NEW4 su
Password:
root@qu5:/home/sp/NEW4 ulimit -n 8192
root@quy5:/home/sp/NEW4 ulimit -a limit
core file size (blocks) 0
data seg size (kbytes) unlimited
file size (blocks) unlimited
max locked memory (kbytes) unlimited
max memory size (kbytes)unlimited
open files 8192
pipe size (512 bytes) 8
stack size (kbytes) unlimited
cpu time (seconds) unlimited
max user processes 32767
virtual memory (kbytes) unlimited
root@qu5:/home/sp/NEW4 cat /proc/sys/fs/file-nr
140273 8192
root@qu5:/home/sp/NEW4
root@qu5:/home/sp/NEW4 mysql -u sp -p DB1
newbackfrom20011009_ermsc1.sql
Enter password:
ERROR 1114 at line 111235: The table 'DR_OUTGOING_49_1'
is full
root@qu5:/home/sp/NEW4 vi
newbackfrom20011009_ermsc1.sql
root@qu5:/home/sp/NEW4 mysql -u sp -p DB1
newbackfrom20011009_ermsc1.sql
Enter password:
ERROR 1114 at line 119737: The table 'DR_TRANSIT_78_0'
is full
root@quality5:/home/sp/NEW4
How big is that table?
from kmysqladmin I get:
SELECT * FROM CDR_TRANSIT_78_0 ORDER BY anum LIMIT 9
46942 row(s) found
The table newbackfrom20011009_ermsc1.sql looks
like this:
--
set autocommit=0;
INSERT INTO DATES (donedate) VALUES('2001-10-09') ;
INSERT INTO DR_TR_389_0 VALUES(
'','389222963',4129,5857,2,'2001-10-
08','22:59:35',0,0,0,0.205625057220459,0,28,4,'AAA1',1,0
,3,'','','',10,0,'1','1',2,'','','20011009_ermsc1',1
,0,'','','','','-128-144-163-49-2-0-90-58-6-68-3-87-0-
0-',3,'','' );
commit;
---
Similarly, I get the same type of error when doing a
report vi a gui-driven
perl script on a differnt table:
Tk::Error: DBD::mysql::st execute failed: The table
'TMP2' is full at report79.pl line 404.
[\\main::__ANON__]
SELECT * FROM TMP2 ORDER BY date LIMIT 9
16019 row(s) found
---
sp@qu5:~/QUER df -h
FilesystemSize Used Avail Use% Mounted on
/dev/sda6 9.7G 4.8G 4.9G 49% /
/dev/sda7 4.6G 3.0G 1.6G 66% /var
/dev/sda1 23M 4.8M 16M 22% /boot
/dev/sda8 20G 14G 5.6G 72% /home
/dev/fd0 1.4M 821k 603k 58% /floppy
Here i s/etc/my.cnf
# Example mysql config file for very large systems.
#
# This is for large system with memory of 1G-2G where
the system runs mainly
# MySQL.
#
# You can copy this file to
# /etc/mf.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options
(in this
# installation this directory is /var/lib/mysql) or
# ~/.my.cnf to set user-specific options.
#
# One can in this file use all long options that the
program supports.
# If you want to know which options a program support,
run the program
# with --help option.
# The following options will be passed to all MySQL
clients
[client]
#password = your_password
port= 3306
socket = /var/lib/mysql/mysql.sock
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
port= 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
set-variable= key_buffer=384M
set-variable= max_allowed_packet=1M
set-variable= table_cache=512
set-variable= sort_buffer=2M
set-variable= record_buffer=2M
set-variable= thread_cache=8
set-variable= thread_concurrency=2 # Try number of
CPU's*2
set-variable= myisam_sort_buffer_size=64M
innodb_data_file_path=ibdata1:2000M;
log-bin
server-id = 1
#set-variable= open-files-limit=8192 #ulimit is
1024,hard 8192
# Uncomment the following if you are using BDB tables
#set-variable = bdb_cache_size=384M
#set-variable = bdb_max_lock=10
# Point the following paths to different dedicated disks
#tmpdir = /tmp/
#log-update = /path-to-dedicated-directory/hostname
[mysqldump]
quick
set-variable= max_allowed_packet=256M
[mysql]
no-auto-rehash
#safe-updates # Remove the comment character if you
are not familiar with SQL
[isamchk]
set-variable= key_buffer=256M
set-variable= sort_buffer=256M
set-variable= read_buffer=2M
set-variable= write_buffer=2M
[myisamchk]
set-variable= key_buffer=256M
set-variable= sort_buffer=256M
set-variable= read_buffer=2M
set-variable= write_buffer=2M
[mysqlhotcopy]
interactive-timeout
-
