i have a real problem ...
i use mysql 3.23.34a and using BLOB's and timestamps leads to errors ( when giving all timestamps the value now() only some of them return the correct date the BLOB's don't even return anything ... ) ... is this version that buggy ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqladmin
Hi guys I wanted to setup password for mysql access so I typed 'mysqladmin mypasswordhere' but now I have problems even doing mysqlshow because it requires a password. How do I disable the password ? thanks Tom - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
JSP-Mysql:-Bad handshake problem
Hi
I am using resin-1.2.3 and mysql at backend on windows 2000...I am trying to connect
to mysql thru my JSP's but gotta bad handshake...I am using mysql-jdbc driver...
My JSP code is like this..
%@ page language=java import= java.sql.*, java.util.* %
%@ page import=sqlBean %
%@ page import=empQBean %
jsp:useBean id=empQBean class=empQBean scope=page /
%
empQBean.setConnection();
if(empQBean.getEmp1()) {
while(empQBean.getNextEmployee()) {
String eid = empQBean.getColumn(empid);
String last = empQBean.getColumn(lastname);
String first = empQBean.getColumn(first);
String ext = empQBean.getColumn(extension);
%
and In my empQBean I am trying to make connection..
empQBean
public class empQBean extends sqlBean {
String empSql = select * from employee;
ResultSet rs = null;
Statement stmt = null;
public boolean getEmp1() throws Exception {
stmt = myCon.createStatement();
rs = stmt.executeQuery(empSql);
return( rs != null);
}
public boolean getNextEmployee() throws Exception {
return rs.next();
}
public String getColumn(String inCol) throws Exception {
return rs.getString(inCol);
}
}
sqlBean
public abstract class sqlBean {
private String myDriver = org.gjt.mm.mysql.Driver;
private String myUrl = jdbc:mysql://localhost:3306/test;
protected Connection myCon;
public sqlBean() {}
public void setConnection() throws Exception {
Class.forName(myDriver);
myCon = DriverManager.getConnection(myUrl);
}
}
So please tell me why I am getting bad handshake problem.
Thanks
Madhulika
Re: host.frm error
I did a search and i do not have that file on my system, and i have been running RedHat for about 6 years now. And this is a redhat-7.1 box HTH -- Dane Knudson wrote: I have installed mysql during the install of RH linux. When I try and start the service, there is an entry in the error log stating it can't find the host.frm file. Any ideas would be appreciated. I have copied the host.frm file to every location under a ./mysql/ directory. Thanks Dane Knudson Account Manager - Technical Freedom Technologies Level 20, Tower 2 500 Oxford Street Bondi Junction NSW 2022 Australia Tel: +61 (0) 2 9386-1777 Fax: +61 (0) 2 9386-1577 Mobile: 0417 252697 E-mail:[EMAIL PROTECTED] www.freedomtechnologies.com -- Michael B. Weiner Systems Administrator/Partner The UserFriendly Network (UFN) -- Linux Registered User #94900Have you been counted? http://counter.li.org PGP fprint: 30 1D CC BA 30 30 63 35 CD 58 E0 89 A9 17 CC C0 8C 55 F7 72 -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Source Make Error
Running FreeBSD 4.2 64MB Ram 2Gb HD on Pent MMX166. df says that I have 1.2GB free on /usr Trying to make Mysql 3.23.37 source after a while I get the following error bsdbox /kernel swap_page_getswapspace: failed Now I don't know if this a BSD problem or to do with Mysql Any ideas anyone? Howard Picken (Server, SQL, Query... etc) [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: Question regarding memory usage
On Mon, 7 May 2001 06:27:08 -0400 (EDT) Jon Valvatne [EMAIL PROTECTED] wrote: As you'd expect, the server gets bogged down rather quickly at this point, serving new requests very slowly if at all. Restarting MySQL helps right away, buying me another 24 hours of stable uptime. If this is a linux box it could be a problem with linuxthreads. Try upgrading to kernel 2.4.4 Details: From my.cnf: skip-locking skip-networking set-variable= max_connections=18 try raising max_connections set-variable= key_buffer=200M set-variable= max_allowed_packet=1M set-variable= table_cache=256 set-variable= sort_buffer=1M set-variable= record_buffer=1M set-variable= myisam_sort_buffer_size=20M set-variable= thread_cache=8 set-variable= thread_concurrency=4 # Try number of CPU's*2 try raising thread concurrency. set-variable= query_buffer_size=16k set-variable= tmp_table_size=6M set-variable= delayed_insert_limit=15 set-variable= max_write_lock_count=1 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
need help
Hi,all
How can I get rid of the lock on database?
for I want to operate one database but two tables at same time,
Thanks and best regards
~{B7B~B~FdP^T6Yb~}
~{Na=+IOOB6xGsKw~}
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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 setup
A brand new installation has no password set, therefore you do not need -p so your command should be exactly as I've already given you. Of course you add your-brand-new-password after the word password. If that still doesn't work, you can stop the server, delete the privileges database, rerun mysql_install_db and try setting the password again. or restart the server with the skip grants option, set the password (don't forget to flush privileges), then restart the server as normal. How to do all this is explained in the manual. - Original Message - From: Alud [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, May 07, 2001 18:32 Subject: RE: mySQL setup Hi Thanks, I tried, but it still didn't work. Can somebody point me to an idiot proof installation site, I've tried a few from the web, some seam to help slightly, others seam to hinder more Cheers, Alud -Original Message- From: Rolf Hopkins [mailto:[EMAIL PROTECTED]] Sent: 07 May 2001 10:47 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: mySQL setup Since this a first installation try ./bin/mysqladmin -u root password instead. - Original Message - From: Alud [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, May 07, 2001 17:27 Subject: mySQL setup Hey I'm kinda new to all this, so please forgive me if this seams like a dumb question: I've been trying to set up a mySQL server today, and I can get so far, but keep getting a problem, I've never done anything like this before so I'm quite happy to accept that I'm missing something easy, but any help would be gratefully received. I'm running Suse 7.1 Brgds, Alud -- -- - amy:~/mysql-3.23.37-pc-linux-gnu-i686 # ./bin/mysqladmin -u root -p password Enter password: /bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' - So then I try and check that the server is there: - amy:~/mysql-3.23.37-pc-linux-gnu-i686 # ./bin/mysqladmin version ./bin/mysqladmin Ver 8.19 Distrib 3.23.37, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.37 Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 59 min 37 sec Threads: 1 Questions: 5 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mysqladmin
I actually wanted to disable passwords completely. so when I type mysql the mysql comes up. Tom - Original Message - From: Zak Greant [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, May 06, 2001 11:57 PM Subject: Re: mysqladmin Use the -p option to allow you to enter the password. --zak - Original Message - From: Tom Gao [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, May 07, 2001 12:46 AM Subject: mysqladmin Hi guys I wanted to setup password for mysql access so I typed 'mysqladmin mypasswordhere' but now I have problems even doing mysqlshow because it requires a password. How do I disable the password ? thanks Tom - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Question regarding memory usage
Jon Valvatne wrote: Hello, I have a hopefully simple question here: My web site is dynamically serving 300k page views a day from a MySQL database, running on a dual P3/700 with 512 megs of ram. Considering the complexity of my queries and the data amount involved, I know I should expect the server to be overworked, but the weird thing is how the problem manifests itself: When I start up MySQL and Apache, things seem to run fine for a while, and they continue running fine for about 24 hours. Then, when MySQL memory usage has grown to around 70-80 megs, things start to slow down. Queries which previously were over in a few hundredths of a second start taking up to several seconds to complete, usually spending the extra time Sending data or Copying to temp table. As you'd expect, the server gets bogged down rather quickly at this point, serving new requests very slowly if at all. Restarting MySQL helps right away, buying me another 24 hours of stable uptime. What could cause this? I suspect it has something to do with the settings in my.cnf, but I've tried many different combinations without success. If someone could point me to the right variable(s) to tweak, that would be helpful in itself. Suggested values for my system would help even more. For now I can handle things by restarting MySQL every night, but that's not a good solution. Shouldn't MySQL, in theory, be able to reuse memory and other resources well enough for a system which stays stable for 24 hours to be expected to stay stable for a year? Could this be some sort of memory leak in either MySQL or Apache? Any help or advice would be much appreciated. Server details below. Thanks, Jon Valvatne Webmaster, AvidGamers.Com Details: Dual PIII/700 512MB RAM 9GB SCSI Drive MySQL 3.23.37 Apache 1.3.12 PHP 4.0.4pl1 From my.cnf: skip-locking skip-networking set-variable= max_connections=18 set-variable= key_buffer=200M set-variable= max_allowed_packet=1M set-variable= table_cache=256 set-variable= sort_buffer=1M set-variable= record_buffer=1M set-variable= myisam_sort_buffer_size=20M set-variable= thread_cache=8 set-variable= thread_concurrency=4 # Try number of CPU's*2 set-variable= query_buffer_size=16k set-variable= tmp_table_size=6M set-variable= delayed_insert_limit=15 set-variable= max_write_lock_count=1 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Hi, Are you sure that you need 200Mb of key_buffer cache ? Since your machine is obviously swapping a lot when it slows down (you can verify that with vmstat), I think you should try first to lower RAM usage. Use 'mysqladmin extended-status' and find out how much RAM you need for key_buffer (check 'Key_blocks_used' variable) and reduce key_buffer value. Hope this helps -- Joseph Bueno NetClub/Trader.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
Create Database error
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 With a bad syntax, i create a database named : Ysa2E3iUbr mysql create it, but i can't drop it...? there's a bug? How can i do to drop it? Thank's.. Davy Azevedo La Vie est l'art d'apprendre à mourir dignement La Naissance est son Apothéose. -BEGIN PGP SIGNATURE- Version: PGPfreeware 7.0.3 for non-commercial use http://www.pgp.com iQA/AwUBOvaOIbRtBMpEaPXcEQJ3PQCgpt7gsjc7ncCkiIhO027cB/+nz4cAoMXZ YKP9M1yRZX0XSj8fkY/lr35m =BL8/ -END PGP SIGNATURE-
Re: Question regarding memory usage
That's the weird part; it doesn't seem to be swapping at all. When trying different combinations in my.cnf, I had key_buffer as low as 64M without any effect. Jon On Mon, 7 May 2001, Joseph Bueno wrote: Hi, Are you sure that you need 200Mb of key_buffer cache ? Since your machine is obviously swapping a lot when it slows down (you can verify that with vmstat), I think you should try first to lower RAM usage. Use 'mysqladmin extended-status' and find out how much RAM you need for key_buffer (check 'Key_blocks_used' variable) and reduce key_buffer value. Hope this helps -- Joseph Bueno NetClub/Trader.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: myODBC
I am going to assume that you are on a windows platform and tell you about what I did. I developed a large ERP system using MSAccess for the front end and MySQL for the backend. Because MSAccess doesn't notice changes to the table structure of a MySQL (ODBC) table, I wrote a routine that deleted all of the MySQL connections during startup, and then relinked them. Because ODBC stores the user names and passwords in the registry (anyone with access to the registry can read a users password for MySQL unencrypted) I added a function that rewrote the necessary registry keys before and after the tables were linked. These keys control the user name, password, and MySQL options. After the tables are linked, I rewrite the keys with a bogus password to prevent a registry editor from compromising the password. I leave the password as a global variable and use it for Pass through queries and the like. I know this isn't full proof but its better then the defaults, at least IMHO. Hope that helps, [EMAIL PROTECTED] I apologize for the HTML but this mailer won't let me turn it off. -Original Message- From: mysql-digest-help [mailto:[EMAIL PROTECTED]] Sent: Saturday, May 05, 2001 1:16 PM To: mysql Cc: warren Subject: myODBC Hi there I have an ODBC connection to my database, but I want the ability to specify the username and password with my code when the connection is made. At the moment I just use the values entered when I setup the ODBC connection but this is most definatelly not what I want. Thanks Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Question regarding memory usage
On Mon, 7 May 2001 07:40:26 -0400 (EDT) [EMAIL PROTECTED] wrote: Thanks for the quick reply. I set max_connections so low because even at peaks I never need more, and when the slowdowns happen, it seems to have an easier time recovering if there are 15 slow connections hanging than if there are hundreds. Are you saying you have 15 slow queries and thus only 3 connections available for your site to run at time server crashes? that's wrong and probably one of the reasons your site slows down. I guess you have some script(s) with 'corrupt' queries that take loads of time (on non-indexed fields or something) to complete. So mysql gets more and more slow queries which may take hours to complete, whilst slowing down your site. You should check which script(s) are responsible for this, and fix the bugs. I'll try the thread concurrency thing, thanks. I was under the impression this variable was only effective on a Solaris box, but I may be wrong? you might be quite right. i just noticed it was not the default.. I suspect you may be right about linuxthreads being the problem. Unfortunately, I'm on a managed hosting solution, and I'm not sure if I want to risk a kernel panic and countless hours of expensive support :) you always could try if same database/scripts generate same errors on another box.. Thanks again, Jon On Mon, 7 May 2001, Rene Tegel wrote: On Mon, 7 May 2001 06:27:08 -0400 (EDT) Jon Valvatne [EMAIL PROTECTED] wrote: As you'd expect, the server gets bogged down rather quickly at this point, serving new requests very slowly if at all. Restarting MySQL helps right away, buying me another 24 hours of stable uptime. If this is a linux box it could be a problem with linuxthreads. Try upgrading to kernel 2.4.4 Details: From my.cnf: skip-locking skip-networking set-variable= max_connections=18 try raising max_connections set-variable= key_buffer=200M set-variable= max_allowed_packet=1M set-variable= table_cache=256 set-variable= sort_buffer=1M set-variable= record_buffer=1M set-variable= myisam_sort_buffer_size=20M set-variable= thread_cache=8 set-variable= thread_concurrency=4 # Try number of CPU's*2 try raising thread concurrency. set-variable= query_buffer_size=16k set-variable= tmp_table_size=6M set-variable= delayed_insert_limit=15 set-variable= max_write_lock_count=1 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
socket
I Installed redhat 7.1 and Mysql. And use mysql_install_db and know when i use mysqladmin -u root -h myhostname -p password 'mypassword' take a error message. It's began Can't connect to MySQL server on ... (111) and i didn't see mysql.sock file anywhere in my HD. I try telnet myhost 3306 but i didn't any connections. Connection refused. (But normal Telnet port is running) Please help me what can i do? Thx Halil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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-Server getting signal 11 ... !!
Check what cron does every day at 0:00. It is probably deleting your socket. Stephan Skusa wrote: Hello, I've got a problem: My MySQL-Server gets signal 11 almost every day arround 0:00 am ... I have a nice mrtg - graph showing this ... ;o) In fact every time the server crashes the statement shown in the server.log (or a similar one with other memID) is executed. topsitesTEMP is a temporary table. Every time I execute this statement manualy using tool mysql everything works fine. TIA Stephan Skusa mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died Attemping backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong stack range sanity check, ok, backtrace follows 0x4009365d 0x80d7664 0x80b7d2d 0x80dab94 0x80dab19 0x80c3629 0x80c67e2 0x80c27f3 0x80c1b57 stack trace successful, now will try to get some variables. Some pointers may be invalid and cause dump abort thd-query at 0x84af148 = SELECT myROWNUM, histRANKING FROM topsitesTEMP WHERE memID=12800 thd-thread_id = 17276 successfully dumped variables, if you ran with --log take a look at the details of what thread 17276 did to cause the crash. In some cases of really bad corruption, this value can be invalid Please use the information above to create a repeatable test case for the crash, and send it to [EMAIL PROTECTED] Number of processes running now: 0 010504 23:56:38 mysqld restarted /usr/local/mysql-3.23.33/libexec/mysqld: Warten auf Verbindungen. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [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: Probs with AUTO_INCREMENT column
On Mon, May 07, 2001 at 07:21:59AM -0700, [EMAIL PROTECTED] wrote: Hi all, I've started using MySQL for the first time and I'm hvaing a bit of a problem with defining an AUTO_INCREMENT column. I'm using ver 3.23.32 which I downloaded for Linux and Win2k. I am having this problem on both systems. Ok if I try to run the create table statement: create table test (id_pk numeric(10) AUTO_INCREMENT) I get the error: Error while executing statement: Invalid argument value: Incorrect column specifier for column 'id_pk' Correct the statement and do another try! Does anyone know why this happens? Am I missing something that needs to included during compilation? Nope, it's just that AUTO_INCREMENT can only be used with INTEGER columns. Also, an AUTO_INCREMENT column must be defined as a key. So, try: CREATE TABLE test (id_pk INTEGER AUTO_INCREMENT NOT NULL PRIMARY KEY); G'luck, Peter -- I am not the subject of this sentence. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Question regarding memory usage
On Mon, 7 May 2001, Rene Tegel wrote: On Mon, 7 May 2001 07:40:26 -0400 (EDT) [EMAIL PROTECTED] wrote: Thanks for the quick reply. I set max_connections so low because even at peaks I never need more, and when the slowdowns happen, it seems to have an easier time recovering if there are 15 slow connections hanging than if there are hundreds. Are you saying you have 15 slow queries and thus only 3 connections available for your site to run at time server crashes? that's wrong and probably one of the reasons your site slows down. I guess you have some script(s) with 'corrupt' queries that take loads of time (on non-indexed fields or something) to complete. So mysql gets more and more slow queries which may take hours to complete, whilst slowing down your site. You should check which script(s) are responsible for this, and fix the bugs. I'm not really talking about the web site slowing down here (of course it does), I'm talking about the queries themselves slowing down. I do have some queries which could use optimization, but they're in no way corrupt. All queries are run regularily during the 24 hour period during which the server runs fine. Then suddenly the same queries start taking several seconds, sometimes even minutes. This leads to the processes building up and waiting for locks, but at that point the server is already screwed; the 18 processes are busy and if I had max_connections at 200, then 200 processes would be busy after not too long. This system is getting an average of 4 page requests every second, it's fairly obvious that the battle is lost once queries start taking more than a few seconds. I'll try the thread concurrency thing, thanks. I was under the impression this variable was only effective on a Solaris box, but I may be wrong? you might be quite right. i just noticed it was not the default.. I suspect you may be right about linuxthreads being the problem. Unfortunately, I'm on a managed hosting solution, and I'm not sure if I want to risk a kernel panic and countless hours of expensive support :) you always could try if same database/scripts generate same errors on another box.. Too late, I already took the risk and upgraded to 2.4.4. Went smoothly :) So now I'll just sit tight and see how it goes. Hopefully, the problems are gone. Thanks for the help, Jon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Question regarding memory usage
Hi, From a system point of view, there are 3 main reasons for a slowdown: - CPU : Your machine is slow because the CPUs are at 100% and can't do anything more. - I/O : Your processes are waiting for data from the disk. - RAM : You don't have enough RAM so your machine is swapping and all your processes run much slower. According to your first message, third reason seemed the most obvious. If your machine is not swapping, then first two reasons are good candidates. You really should run 'vmstat' while your server is slow and try to figure out where the time is spent. Also, you should check Apache status. Have you looked at server-status output ? How many BusyServers ? Are there any IdleServers left ? If all your servers are busy, it may be due to some performance problem on your server (as discussed above) but it may also come from slow clients that are just eating all your connections; in this case, raising your MaxClients parameter in Apache should help (don't forget to raise max_connections in mysql.cnf too). Hope this helps -- Joseph Bueno NetClub/Trader.com Jon Valvatne wrote: That's the weird part; it doesn't seem to be swapping at all. When trying different combinations in my.cnf, I had key_buffer as low as 64M without any effect. Jon On Mon, 7 May 2001, Joseph Bueno wrote: Hi, Are you sure that you need 200Mb of key_buffer cache ? Since your machine is obviously swapping a lot when it slows down (you can verify that with vmstat), I think you should try first to lower RAM usage. Use 'mysqladmin extended-status' and find out how much RAM you need for key_buffer (check 'Key_blocks_used' variable) and reduce key_buffer value. Hope this helps -- Joseph Bueno NetClub/Trader.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Do I need to locak a file when foind a SELECT?
Hi,
As the subject states, I am getting an error in my Perl script telling
me that a table is not locked yet all I am doing is a SELECT. Why do I
need lock a table in order to issue a SELECT?
The code in question is:
$sqlCmd = $dbh-prepare(q{
SELECT Booking FROM Bookings where Booking = ?})
or die Can't prepare select statement in Bookings:
$DBI::errstr;
$retCount = $sqlCmd-execute($booking)
or die Can't execute select statement in Bookings:
$DBI::errstr;
The error message is:
DBD::mysql::st execute failed: Table 'Bookings' was not locked with LOCK
TABLES
at ./lclmail.pl line 435.
Can't execute select statement in Bookings: Table 'Bookings' was not
locked with
LOCK TABLES at ./lclmail.pl line 435.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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: SELECT DISTINCT or GROUP BY problem
On Monday 07 May 2001 03:37, Andrew Leshkin wrote:
Hello,
I have the following perfomance problem with simple query on one of my
servers:
Here is my table ~6 records.
+-+-+--+-++-
---+
| Field | Type| Null | Key | Default| Extra
|
+-+-+--+-++-
---+
| record_id | int(11) unsigned| | PRI | NULL |
auto_increment |
| dd | date| | MUL | -00-00 |
|
| category_id | tinyint(4) unsigned | | | 0 |
|
| type_id | tinyint(4) unsigned | | | 0 |
|
| design | varchar(10) | | ||
|
| body| text| | ||
|
| indexed | enum('Y','N') | | MUL | N |
|
+-+-+--+-++-
---+
Here is the query :
mysql SELECT DISTINCT dd from privatinfo_record;
++
| dd |
++
| 2001-04-02 |
| 2001-04-09 |
| 2001-04-16 |
| 2001-04-23 |
| 2001-04-30 |
++
5 rows in set (0.15 sec)
And everything looks okay untill I'll do several this queries at the
same time. I tested this query with the same tables on other servers
with same MySQL configuration and version - it works ok.
First Server cddb.infonet.ee - Linux 2.2.17 - Pentium Pro 200mhz, 198M
RAM (NORMAL SERVER)
Concurrency Level: 1 - Requests per second: 1.31
Concurrency Level: 10 - Requests per second: 1.20
Second Server si.infonet.ee - Linux 2.4.2 - 2 x Pentium III 800Mhz, 1G
RAM (BAD SERVER)
Concurrency Level: 1 - Requests per second: 6.46
Concurrency Level: 10 - Requests per second: 0.52
^^^ ???
This is a known problem with unpatched LinuxThreads, and this is one reason
we strongly encourage all Linux users to use our binary instead of building
their own, unless they patch LinuxThreads the way we did. LinuxThreads is
terrible when you have high concurrently and lots of short critical regions,
which is the case with MySQL. You can read more about this at
http://www.mysql.com/doc/L/i/Linux.html
P.S. Just something to laugh about - if you take the second CPU out of your
fast machine, you will actually get about 6 requests per second instead of
0.52 with 10 clients with your current binary. Almost like it says in the
Bible, if thine right eye (CPU) offend thee, pluck it out
--
MySQL Development Team
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA
___/
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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: looking for information
Your Name wrote: dear sir/madam i'm currentlly doing a research on MYSQL and i would like to know more information about it :where does MYSQL come from who created it ... 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: Database Connection
http://mmmysql.sourceforge.net/mm.doc.tar.gz -Original Message- From: Greg Cardoza [mailto:[EMAIL PROTECTED]] Sent: Monday, May 07, 2001 3:10 PM To: [EMAIL PROTECTED] Subject: Database Connection Hello: Is there anyone who can supply me with the syntax for connecting to a database using JAVA and mm.mysql... I've been to sourceforge.net and couldn't find exactly what I was looking for. All I'm asking for is the detailed lines of code in the try block statement to connect to a database. Thanks a bunch... Greg __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
php - MySQL 3.23.37 problem
I just installed mySQL and want to install the rpm that allows it to communicate with php. When I do that I get the following error: error: failed dependencies: mysql is needed by php-mysql-4.0.4pl1-9 I don't understand. Here is a list of installed components: mysql-DBI-perl-bin-1.825 MySQL Perl Interface MySQL-shared-3.23.37 MySQL - Shared libraries MySQL-devel-3.23.37 MySQL - Development header files and libraries MySQL-client-3.23.37 MySQL - Client Mysql-DBI-perl-bin-1.1825 Mysql Perl Interface MySQL-3.23.37 MySQL: a very fast and reliable SQL database engine I cannot find any other packages to install for 3.23.37. I am running red hat 7. Any help would be greatly appreciated, in your response it would help me if you put Will: in the subject line. Thank you Will - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to return the value of deleted rows
Hello Folks, I wonder how can I return the number of deleted rows after a DELETE SQL statement. Is there any way to return the quantity of updated rows as well? Thanks, C.F.
Re: How to return the value of deleted rows
Not having a copy of the MYSQL manual in front of me, I asked my resident M$ SQL expert. He said if there is no built in function, then do a count before, a count after and subtract the two. :) Cal - Original Message - From: Carlos Fernando Scheidecker Antunes [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Monday, May 07, 2001 3:01 PM Subject: How to return the value of deleted rows Hello Folks, I wonder how can I return the number of deleted rows after a DELETE SQL statement. Is there any way to return the quantity of updated rows as well? Thanks, C.F. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
char - varchar ?
Hi, In various create table statements char columns are converted to varchar.. I was wondering why this was happening. Here's an example: CREATE TABLE realtors(name VARCHAR(255) not null, address VARCHAR(255) not null, city VARCHAR(255) not null, state CHAR(2) not null, country CHAR(2) not null, zip CHAR(5) not null, phone VARCHAR(50) not null, cell VARCHAR(50) not null, fax VARCHAR(50) not null, nvio VARCHAR(25) not null, estlead CHAR(5) not null, servicearea VARCHAR(255) not null); Query OK, 0 rows affected (0.11 sec) Here, zip and estlead have been converted to varchar(5). Thanks. Alec - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 while SETting A PASSWORD during installation
After installation of MySQL version 3.23.37 on Linux/i386 with the command: rpm -i MySQL-3.23.37-1.i386.rpm two lines of instruction come up, asking to /usr/bin/mysqladmin -u root -p password 'new-password' /usr/bin/mysqladmin -u root -h hostxxx -p password 'new-password' the first line works only after the -p is omitted, the second line doesn't work, the result is: /usr/bin/mysqladmin: connect to server at 'hostxxx' failed error: 'Host 'hostxxx.domainyyy.com' is not allowed to connect to this MySQL server' (here hostxxx and domainyyy represent some other actual names) Could anyone know the answer this problem? Thanks __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: char - varchar ?
http://www.mysql.com/doc/S/i/Silent_column_changes.html second item, quoted here: If any column in a table has a variable length, the entire row is variable-length as a result. Therefore, if a table contains any variable-length columns (VARCHAR, TEXT, or BLOB), all CHAR columns longer than three characters are changed to VARCHAR columns. This doesn't affect how you use the columns in any way; in MySQL, VARCHAR is just a different way to store characters. MySQL performs this conversion because it saves space and makes table operations faster. See section 8 MySQL Table Types. - Original Message - From: Alec Solway [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, May 07, 2001 2:38 PM Subject: char - varchar ? Hi, In various create table statements char columns are converted to varchar.. I was wondering why this was happening. Here's an example: CREATE TABLE realtors(name VARCHAR(255) not null, address VARCHAR(255) not null, city VARCHAR(255) not null, state CHAR(2) not null, country CHAR(2) not null, zip CHAR(5) not null, phone VARCHAR(50) not null, cell VARCHAR(50) not null, fax VARCHAR(50) not null, nvio VARCHAR(25) not null, estlead CHAR(5) not null, servicearea VARCHAR(255) not null); Query OK, 0 rows affected (0.11 sec) Here, zip and estlead have been converted to varchar(5). Thanks. Alec - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: char - varchar ?
Alec Solway wrote: Hi, In various create table statements char columns are converted to varchar.. I was wondering why this was happening. Here's an example: CREATE TABLE realtors(name VARCHAR(255) not null, address VARCHAR(255) not null, city VARCHAR(255) not null, state CHAR(2) not null, country CHAR(2) not null, zip CHAR(5) not null, phone VARCHAR(50) not null, cell VARCHAR(50) not null, fax VARCHAR(50) not null, nvio VARCHAR(25) not null, estlead CHAR(5) not null, servicearea VARCHAR(255) not null); Query OK, 0 rows affected (0.11 sec) Here, zip and estlead have been converted to varchar(5). Thanks. Alec see the manual www.mysql.com/doc There is no problem here, that is standard be behaviour, by having any variable size columns on a row you defeat the advantage of fixed length rows so the db might as well use varchar to save space, so it does. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: char - varchar ?
Hi, Char columns are used with fixed-length type table, whereas varchar are used with dynamic table. If you have varchar columns in your table, all char columns will be convert to varchar column (you can't have a fixed-length table if your table contain varchar, blob or text field). Here are the property of static table : All CHAR, NUMERIC, and DECIMAL columns are space-padded to the column width. Very quick. Easy to cache. Easy to reconstruct after a crash, because records are located in fixed positions. Doesn't have to be reorganized (with myisamchk) unless a huge number of records are deleted and you want to return free disk space to the operating system. Usually requires more disk space than dynamic tables. Jocelyn Fournier Presence-PC www.presence-pc.com Dans un e-mail daté du 07/05/2001 23:42:12 Paris, Madrid (heure d'été), [EMAIL PROTECTED] a écrit : Sujet :char - varchar ? Date :07/05/2001 23:42:12 Paris, Madrid (heure d'été) From:[EMAIL PROTECTED] (Alec Solway) To:[EMAIL PROTECTED] Hi, In various create table statements char columns are converted to varchar.. I was wondering why this was happening. Here's an example: CREATE TABLE realtors(name VARCHAR(255) not null, address VARCHAR(255) not null, city VARCHAR(255) not null, state CHAR(2) not null, country CHAR(2) not null, zip CHAR(5) not null, phone VARCHAR(50) not null, cell VARCHAR(50) not null, fax VARCHAR(50) not null, nvio VARCHAR(25) not null, estlead CHAR(5) not null, servicearea VARCHAR(255) not null); Query OK, 0 rows affected (0.11 sec) Here, zip and estlead have been converted to varchar(5). Thanks. Alec - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- Headers Return-Path: [EMAIL PROTECTED] Received: from rly-yh05.mx.aol.com (rly-yh05.mail.aol.com [172.18.147.37]) by air-yh03.mail.aol.com (v77_r1.36) with ESMTP; Mon, 07 May 2001 17:42:12 2000 Received: from web.mysql.com (web.mysql.com [192.58.197.162]) by rly-yh05.mx.aol.com (v77_r1.36) with ESMTP; Mon, 07 May 2001 17:41:38 -0400 Received: (qmail 17223 invoked by uid 7797); 7 May 2001 21:36:06 - Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm (http://www.ezmlm.org) List-ID: mysql.mysql.com Precedence: bulk List-Help: mailto:[EMAIL PROTECTED] List-Unsubscribe: mailto:[EMAIL PROTECTED] List-Post: mailto:[EMAIL PROTECTED] List-Subscribe: mailto:[EMAIL PROTECTED] Delivered-To: mailing list [EMAIL PROTECTED] Received: (qmail 17209 invoked from network); 7 May 2001 21:36:04 - Message-Id: [EMAIL PROTECTED] X-Sender: [EMAIL PROTECTED] X-Mailer: QUALCOMM Windows Eudora Version 5.0.2 Date: Mon, 07 May 2001 16:38:40 -0500 To: [EMAIL PROTECTED] From: Alec Solway [EMAIL PROTECTED] Subject: char - varchar ? Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed
running mysql as different users
Hi all: I need help here. I am trying to install mysql here. First, I was able to install it, but only be able to run it as either root or mysql. I tried installation several times. Somehow, it worked now. I was able to login as a different user and run /usr/local/mysql/bin/mysql (just run mysql did not work). I then tried to run it using /usr/local/mysql/bin/mysql -u slash -p. And, it did not work this time. It says: ERROR 1045: Access denied for user 'slash@localhost' (Using Password: YES). I am really confused, desperately need help. Thanks in advance. Xiaowu Xiaowu Gai 2104 Molecular Biology Building Department of Zoology Genetics Iowa State University Ames, IA 50010 Tel: (515)-2940022 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Hardware
We are trying to purchase a server for mysql and were wondering about what is the best hardware to go with. Any suggestions or web sites that have information would be appreciated. Thank you, Dan Mouw
OLAP
Is anyone using mysql for OLAP? Any particular tools to check? thanks in advance, thalis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
My SQL C_API(urgent)
Hi, I am having a peculiar problem with C_API.How to execute a query string with its length more than 255 characters using mysql_query() function.My sql query is more than 255 characters long and is getting truncated. Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 SQL C_API(urgent)
On Tue, May 08, 2001 at 12:51:02AM +0100, VVM Ravikumar Sarma Chengalvala wrote: Hi, I am having a peculiar problem with C_API.How to execute a query string with its length more than 255 characters using mysql_query() function.My sql query is more than 255 characters long and is getting truncated. Regards, Ravi mysql_query() doesn't have any length limitation like that. How big is the buffer in which you're storing your query? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 SQL C_API(urgent)
Try mysql_real_query(). This function takes three parameters, the first two are the same as mysql_query(). The third is the length of the query string. Regards. Alec At 06:51 PM 5/7/01, VVM Ravikumar Sarma Chengalvala wrote: Hi, I am having a peculiar problem with C_API.How to execute a query string with its length more than 255 characters using mysql_query() function.My sql query is more than 255 characters long and is getting truncated. Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 while SETting A PASSWORD during installation
- Original Message - From: tang jie [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 08, 2001 5:41 Subject: problem while SETting A PASSWORD during installation After installation of MySQL version 3.23.37 on Linux/i386 with the command: rpm -i MySQL-3.23.37-1.i386.rpm two lines of instruction come up, asking to /usr/bin/mysqladmin -u root -p password 'new-password' -p is not needed because it is a brand new installation and brand new installations do have a password set. /usr/bin/mysqladmin -u root -h hostxxx -p password 'new-password' Again -p is not needed until a password has been set. Depends on what you are using as hostxxx. If you're on the local machine where the mysql server resides, you don't really need -h or you could use localhost or 127.0.0.1 the first line works only after the -p is omitted, the second line doesn't work, the result is: /usr/bin/mysqladmin: connect to server at 'hostxxx' failed error: 'Host 'hostxxx.domainyyy.com' is not allowed to connect to this MySQL server' (here hostxxx and domainyyy represent some other actual names) Could anyone know the answer this problem? Thanks __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 mysql as different users
It could be either you haven't set up a user by that name or you didn't set that users password correctly. Have another read of Ch 6 of the manual and then the GRANT and REVOKE commands in chapter 7. - Original Message - From: Xiaowu Gai [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 08, 2001 6:07 Subject: running mysql as different users Hi all: I need help here. I am trying to install mysql here. First, I was able to install it, but only be able to run it as either root or mysql. I tried installation several times. Somehow, it worked now. I was able to login as a different user and run /usr/local/mysql/bin/mysql (just run mysql did not work). I then tried to run it using /usr/local/mysql/bin/mysql -u slash -p. And, it did not work this time. It says: ERROR 1045: Access denied for user 'slash@localhost' (Using Password: YES). I am really confused, desperately need help. Thanks in advance. Xiaowu Xiaowu Gai 2104 Molecular Biology Building Department of Zoology Genetics Iowa State University Ames, IA 50010 Tel: (515)-2940022 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to get rid of the lock on database?
MySQL support two locks:table lock,db lock,
is it true?
if true,how could I get rid of db lock for I want to access two different tables in
one db,
help!
Thanks and best regards
~{B7B~B~FdP^T6Yb~}
~{Na=+IOOB6xGsKw~}
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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 involving negative values and AUTO_INCREMENT
Why would you want to manually set an AUTO_INCREMENT column?? You might as well use an integer column if you want to be able to change its values... - TIM Description: On some releases of mysql, after you manually set an AUTO_INCREMENT column to a negative value, the AUTO_INCREMENT fails. On mysql 3.23.32 mysql DROP TABLE IF EXISTS temp; Query OK, 0 rows affected (0.00 sec) mysql CREATE TABLE temp( -id INT NOT NULL AUTO_INCREMENT, -foo VARCHAR(255), -PRIMARY KEY(id)); Query OK, 0 rows affected (0.02 sec) mysql INSERT INTO temp (id,foo) VALUES (-1, works); Query OK, 1 row affected (0.00 sec) mysql INSERT INTO temp (foo) VALUES (works); Query OK, 1 row affected (0.00 sec) mysql INSERT INTO temp (foo) VALUES (doesn't); Query OK, 1 row affected (0.00 sec) mysql select * from temp; ++-+ | id | foo | ++-+ | -1 | works | | 0 | works | | 1 | doesn't | ++-+ 3 rows in set (0.00 sec) mysql On mysql 3.23.37: mysql DROP TABLE IF EXISTS temp; Query OK, 0 rows affected (0.00 sec) mysql CREATE TABLE temp( - id INT NOT NULL AUTO_INCREMENT, - foo VARCHAR(255), - PRIMARY KEY(id)); Query OK, 0 rows affected (0.00 sec) mysql INSERT INTO temp (id,foo) VALUES (-1, works); Query OK, 1 row affected (0.00 sec) mysql INSERT INTO temp (foo) VALUES (works); Query OK, 1 row affected (0.00 sec) mysql INSERT INTO temp (foo) VALUES (doesn't); ERROR 1062: Duplicate entry '2147483647' for key 1 mysql SELECT * FROM temp; ++---+ | id | foo | ++---+ | -1 | works | | 2147483647 | works | ++---+ 2 rows in set (0.03 sec) How-To-Repeat: DROP TABLE IF EXISTS temp; CREATE TABLE temp( id INT NOT NULL AUTO_INCREMENT, foo VARCHAR(255), PRIMARY KEY(id)); INSERT INTO temp (id,foo) VALUES (-1, works); INSERT INTO temp (foo) VALUES (works); INSERT INTO temp (foo) VALUES (doesn't); Fix: None knwn. Submitter-Id:submitter ID Originator: Andrew Barros Organization: Andrew Barros [EMAIL PROTECTED] GPG Key Fingerprint: EC9C DFC5 C565 E90C 0FFA C4E7 539F DE81 2A92 E07D http://andy.netherweb.com/ _ _ _ _ _ ___| |_| |_ ___ _ _ _ _ ___| |_ | ' \/ -_) _| ' \/ -_) '_| ' \/ -_) _| |_||_\___|\__|_||_\___|_| |_||_\___|\__| MySQL support: [none | licence | email support | extended email support ] none Synopsis:Problem involving negative values and AUTO_INCREMENT Severity:non-critical Priority:medium Category:mysql Class: sw-bug Release: mysql-3.23.37 (Source distribution) Environment: System: Linux discovery 2.4.1 #1 Tue Jan 30 23:44:03 EST 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20010506 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='-O2 -g' CXX='g++' CXXFLAGS='-O2 -g -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 May 7 19:43 /lib/libc.so.6 - libc-2.2.3.so -rwxr-xr-x1 root root 1105224 May 6 16:19 /lib/libc-2.2.3.so -rw-r--r--1 root root 2529096 May 6 16:21 /usr/lib/libc.a -rw-r--r--1 root root 178 May 6 16:21 /usr/lib/libc.so -rw-r--r--1 root root 712844 Mar 31 00:23 /usr/lib/libc-client.so.2000 Configure command: ./configure --prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin --datadir=/usr/share --sysconfdir=/etc/mysql --localstatedir=/var/lib/mysql --includedir=/usr/include --infodir=/usr/share/info --mandir=/usr/share/man --enable-shared --with-libwrap --enable-assembler --with-berkeley-db --with-innodb --with-gemini --enable-static --enable-shared --with-raid --enable-thread-safe-client --without-readline --with-unix-socket-path=/var/run/mysqld/mysqld.sock --with-mysqld-user=mysql --without-bench --with-extra-charsets=all - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
mysqld - immediate segfault
Description: I've been using the Slackware mysql package, but I want to use ODBC, and MyODBC won't compile because my_dir.h is missing. In order to get all the headers, shared libraries, and thread support I need, I apparently have to compile MySQL from source, but I'm can't get that to work. I've tried compiling each of the past four releases of MySQL from source, and I've had no configuration or compilation problems, but each one of them immediately crashed when I ran the resulting executables. Here's the error message from the server.err file: 010507 22:21:44 mysqld started mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died. Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Bogus stack limit or frame pointer, aborting backtrace. 010507 22:21:44 mysqld ended How-To-Repeat: This happens every time I compile MySQL from source. I've tried leaving out any and all of the configuration options, with no effect. Fix: Please help. Submitter-Id: submitter ID Originator:David Andrew Michael Noelle Organization: MySQL support: none Synopsis: mysqld - immediate segfault Severity: critical Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.37 (Source distribution) Environment: System: Linux gauss 2.4.2 #2 Thu Mar 29 22:21:41 EST 2001 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-slackware-linux/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 11 Jan 31 04:06 /lib/libc.so.6 - libc-2.2.so -rwxr-xr-x 1 root root 4808643 Nov 20 17:11 /lib/libc-2.2.so -rw-r--r-- 1 root root 24076056 Nov 20 17:07 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Nov 20 17:07 /usr/lib/libc.so lrwxrwxrwx 1 root root 29 Jan 31 04:13 /usr/lib/libc.so.1 - /usr/i486-sysv4/lib/libc.so.1 Configure command: ./configure --prefix=/usr/local/mysql --with-berkeley-db --with-mysqld-user=data --enable-thread-safe-client --enable-assembler - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to install MYSQLGUI?
Hi, I'm a new user for MYSQL, I have a problem that I want to install the GUI application for MYSQL. Which I should download and install, also would you mind send or tell me where I can find the install instruction? Thank you for you attention, and I'm look forward to heard from you soon. RoujinZ
AUTO_INCREMENT Confusion
I'm a bit confused about AUTO-INCREMENT behaviour. I have a table with an AUTO-INCREMENT column defined as int unsigned primary key. Records are regularly added and then later deleted from this table. If the last record is deleted, the sequence begins at 1 again. Reading from MySQL (Paul Dubois) pages 94-95, it says that the values in an automatically generated series are strictly increasing and not reused, even if the maximum value is deleted. This applies to 3.23 and up. The sequence is restarted only if you delete all records from the table using the DELETE FROM tbl_name syntax. I am deleting row by row (DELETE FROM tbl_name WHERE...). Shouldn't the sequence be preserved, i.e. if the last record in the table has value 43 and I delete it, shouldn't the next record get 44 ? I am running 3.23.37 on Suse 7.0 Thanks. Kevin McBrearty ATG Automation Technologies Group Ltd. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 - immediate segfault
On Monday 07 May 2001 20:35, [EMAIL PROTECTED] wrote: Description: I've been using the Slackware mysql package, but I want to use ODBC, and MyODBC won't compile because my_dir.h is missing. In order to get all the headers, shared libraries, and thread support I need, I apparently have to compile MySQL from source, but I'm can't get that to work. I've tried compiling each of the past four releases of MySQL from source, and I've had no configuration or compilation problems, but each one of them immediately crashed when I ran the resulting executables. Here's the error message from the server.err file: 010507 22:21:44 mysqld started mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died. Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Bogus stack limit or frame pointer, aborting backtrace. 010507 22:21:44 mysqld ended Have you tried --with-mysqld-ldflags=-all-static ? If that works, the problem is most likely that your shared libraries do not match your includes. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Help
Hi, I am having a terrible problem with MySQL and I am desperated as nobody seems to find the source. I have a Web site ( www.genteirc.com ) whith MySQL database access. The problem is that those Mysql processes are growing continuously until they consume all of the memory ( 2 Gigas ). I include at the end of the message two files that we have captured just before the reboot of the machine. Somebody is saying that MySQL doesn´t work with Intel multiprocessors and his solutions is to remove one of the proccesors ¿¿??. Can you please help me ?. Thanks very much in advanced. Best regards, Salvador 6:47pm up 1 day, 23:05, 2 users, load average: 2.57, 3.04, 3.06 407 processes: 402 sleeping, 5 running, 0 zombie, 0 stopped CPU states: 33.9% user, 51.4% system, 0.0% nice, 14.6% idle Mem: 2074332K av, 2062048K used, 12284K free, 259320K shrd, 42224K buff Swap: 1052248K av, 752252K used, 26K free 47108K cached PID USER PRI NI SIZE RSS SHARE STAT LIB %CPU %MEM TIME COMMAND 9035 cvsanon 12 0 832 796 324 R 0 15.2 0.0 7:15 top 11435 root 2 0 45536 42M 1044 S 0 5.5 2.0 0:03 mysqld 11448 root 1 0 45536 42M 1044 S 0 4.1 2.0 0:01 mysqld 11488 root 1 0 45536 42M 1044 S 0 4.0 2.0 0:00 mysqld 11437 root 1 0 45536 42M 1044 S 0 3.7 2.0 0:04 mysqld 11502 root 1 0 45536 42M 1044 S 0 3.7 2.0 0:00 mysqld 11459 root 1 0 45536 42M 1044 S 0 3.5 2.0 0:02 mysqld 11442 root 1 0 45536 42M 1044 S 0 3.4 2.0 0:00 mysqld 11450 root 1 0 45536 42M 1044 R 0 3.4 2.0 0:02 mysqld 11509 root 1 0 45556 42M 1044 S 0 3.4 2.0 0:00 mysqld 11470 root 1 0 45536 42M 1044 S 0 3.2 2.0 0:01 mysqld 11244 root 1 0 45536 42M 1044 S 0 3.1 2.0 0:05 mysqld 11407 root 1 0 45536 42M 1044 S 0 3.1 2.0 0:02 mysqld 11425 root 1 0 45536 42M 1044 S 0 3.1 2.0 0:02 mysqld 11455 root 1 0 45536 42M 1044 S 0 3.1 2.0 0:01 mysqld | 221860 | genteirc | localhost | genteirc | Query | 10| Locked | SELECT COUNT(*) as nregs FROM genteirc WHERE OK='1' | | 221861 | genteirc | localhost | genteirc | Query | 9 | Locked | SELECT COUNT(*) as nregs FROM genteirc WHERE OK='1' | | 221864 | genteirc | localhost | genteirc | Query | 9 | Locked | SELECT COUNT(*) as nregs FROM genteirc WHERE OK='1' | | 221893 | genteirc | localhost | genteirc | Query | 4 | Locked | update genteirc set novedad=0 where novedad=1 AND to_days(now())-to_days(Alta) 10 | | 221911 | genteirc | localhost | genteirc | Query | 2 | Locked | SELECT COUNT(*) as nregs FROM genteirc WHERE OK='1' | | 221917 | genteirc | localhost | genteirc | Query | 0 | Locked | update genteirc set novedad=0 where novedad=1 AND to_days(now())-to_days(Alta) 10 | | 221918 | root | localhost | | Query | 0 | | show processlist | ++--+---+--+-+---+--+--- ---+ Uptime: 69622 Threads: 231 Questions: 4679585 Slow queries: 2395 Opens: 320 Flush tables: 1 Open tables: 314 Queries per second avg: 67.214 ++--+---+--+-+---+-- --+- -+ | Id | User | Host | db | Command | Time | State | Info | ++--+---+--+-+---+-- --+- -+ | 15406 | genteirc | localhost | genteirc | Sleep | 14| | | | 111020 | genteirc | localhost | genteirc | Sleep | 3 | | | | 128653 | genteirc | localhost | genteirc | Sleep | 3 | | | | 129780 | genteirc | localhost | genteirc | Sleep | 2 | | | | 130243 | genteirc | localhost | genteirc | Sleep | 862 | | | | 131061 | genteirc | localhost | genteirc | Sleep | 44| | | | 131752 | nobody | localhost | | Sleep | 22713 | | | | 131842 | genteirc | localhost | genteirc | Sleep | 86| | | | 131935 | genteirc | localhost | genteirc | Sleep | 63| | | | 132576 | genteirc | localhost | genteirc | Sleep | 204 | - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: AUTO_INCREMENT Confusion
At 12:14 AM -0400 5/8/01, Kevin McBrearty wrote: I'm a bit confused about AUTO-INCREMENT behaviour. I have a table with an AUTO-INCREMENT column defined as int unsigned primary key. Records are regularly added and then later deleted from this table. If the last record is deleted, the sequence begins at 1 again. Reading from MySQL (Paul Dubois) pages 94-95, it says that the values in an automatically generated series are strictly increasing and not reused, even if the maximum value is deleted. This applies to 3.23 and up. The sequence is restarted only if you delete all records from the table using the DELETE FROM tbl_name syntax. I am deleting row by row (DELETE FROM tbl_name WHERE...). Shouldn't the sequence be preserved, i.e. if the last record in the table has value 43 and I delete it, shouldn't the next record get 44 ? Yes, it should. I just tried it and it works. But then I changed the table to type BDB and got the behavior you're describing, so it appears the behavior differs betweeen table types. Are you using a BDB table? I am running 3.23.37 on Suse 7.0 Thanks. Kevin McBrearty ATG Automation Technologies Group Ltd. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Paul DuBois, [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
'Can't find file: './mysql/user.fr
I get the following message: $ mysqladmin -u root password 'newpassword' mysqladmin: unable to change password; error: 'Can't find file: './mysql/user.fr m' (errno: 13)' I think I may have run scripts/mysql_install_db twice! (never work on a computer when you're half asleep!) Could that be the cause of it? thanks __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL
Fatal error: out of dynamic memory in yy_create_buffer() in Unknown on line 0 I am getting this error on my machine. MySQL proccesses are growing up to consume all the machine memory. I have seen them running with 48 M . How can I find out the source of the problem ? ; how can I check that there is no programming problems ? Thanks very much in adavanced, Salvador
Problem involving negative values and AUTO_INCREMENT
Description: On some releases of mysql, after you manually set an AUTO_INCREMENT column to a negative value, the AUTO_INCREMENT fails. On mysql 3.23.32 mysql DROP TABLE IF EXISTS temp; Query OK, 0 rows affected (0.00 sec) mysql CREATE TABLE temp( -id INT NOT NULL AUTO_INCREMENT, -foo VARCHAR(255), -PRIMARY KEY(id)); Query OK, 0 rows affected (0.02 sec) mysql INSERT INTO temp (id,foo) VALUES (-1, works); Query OK, 1 row affected (0.00 sec) mysql INSERT INTO temp (foo) VALUES (works); Query OK, 1 row affected (0.00 sec) mysql INSERT INTO temp (foo) VALUES (doesn't); Query OK, 1 row affected (0.00 sec) mysql select * from temp; ++-+ | id | foo | ++-+ | -1 | works | | 0 | works | | 1 | doesn't | ++-+ 3 rows in set (0.00 sec) mysql On mysql 3.23.37: mysql DROP TABLE IF EXISTS temp; Query OK, 0 rows affected (0.00 sec) mysql CREATE TABLE temp( - id INT NOT NULL AUTO_INCREMENT, - foo VARCHAR(255), - PRIMARY KEY(id)); Query OK, 0 rows affected (0.00 sec) mysql INSERT INTO temp (id,foo) VALUES (-1, works); Query OK, 1 row affected (0.00 sec) mysql INSERT INTO temp (foo) VALUES (works); Query OK, 1 row affected (0.00 sec) mysql INSERT INTO temp (foo) VALUES (doesn't); ERROR 1062: Duplicate entry '2147483647' for key 1 mysql SELECT * FROM temp; ++---+ | id | foo | ++---+ | -1 | works | | 2147483647 | works | ++---+ 2 rows in set (0.03 sec) How-To-Repeat: DROP TABLE IF EXISTS temp; CREATE TABLE temp( id INT NOT NULL AUTO_INCREMENT, foo VARCHAR(255), PRIMARY KEY(id)); INSERT INTO temp (id,foo) VALUES (-1, works); INSERT INTO temp (foo) VALUES (works); INSERT INTO temp (foo) VALUES (doesn't); Fix: None knwn. Submitter-Id: submitter ID Originator:Andrew Barros Organization: Andrew Barros [EMAIL PROTECTED] GPG Key Fingerprint: EC9C DFC5 C565 E90C 0FFA C4E7 539F DE81 2A92 E07D http://andy.netherweb.com/ _ _ _ _ _ ___| |_| |_ ___ _ _ _ _ ___| |_ | ' \/ -_) _| ' \/ -_) '_| ' \/ -_) _| |_||_\___|\__|_||_\___|_| |_||_\___|\__| MySQL support: [none | licence | email support | extended email support ] none Synopsis: Problem involving negative values and AUTO_INCREMENT Severity: non-critical Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.37 (Source distribution) Environment: System: Linux discovery 2.4.1 #1 Tue Jan 30 23:44:03 EST 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20010506 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='-O2 -g' CXX='g++' CXXFLAGS='-O2 -g -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 May 7 19:43 /lib/libc.so.6 - libc-2.2.3.so -rwxr-xr-x1 root root 1105224 May 6 16:19 /lib/libc-2.2.3.so -rw-r--r--1 root root 2529096 May 6 16:21 /usr/lib/libc.a -rw-r--r--1 root root 178 May 6 16:21 /usr/lib/libc.so -rw-r--r--1 root root 712844 Mar 31 00:23 /usr/lib/libc-client.so.2000 Configure command: ./configure --prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin --datadir=/usr/share --sysconfdir=/etc/mysql --localstatedir=/var/lib/mysql --includedir=/usr/include --infodir=/usr/share/info --mandir=/usr/share/man --enable-shared --with-libwrap --enable-assembler --with-berkeley-db --with-innodb --with-gemini --enable-static --enable-shared --with-raid --enable-thread-safe-client --without-readline --with-unix-socket-path=/var/run/mysqld/mysqld.sock --with-mysqld-user=mysql --without-bench --with-extra-charsets=all - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
