Mysql with innodb support
I am setting up a web site with Linux (redhat 7.1), apache, php and mysql. I need the version of mysql with innodb support. Can anyone indicate to me what file or files I need to obtain to install thecorrect version of mysql and where I can down load them? Thanks in advance Regards Peter Goggin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 while make of 3.23.52
Hi All! mysql, sql, query I am trying to install mysql-3.23.52 . I configured with following command and then had run make. Make gives the following errors. Please help ./configure --with-low-memory --with-innodb --with-mysqld-ldflags=-rdynamic errors during make sql_lex.cc: In function `void lex_init()': sql_lex.cc:85: `symbols' undeclared (first use this function) sql_lex.cc:85: (Each undeclared identifier is reported only once for each function it appears in.) sql_lex.cc:87: `sql_functions' undeclared (first use this function) sql_lex.cc: In function `int find_keyword(LEX*, unsigned int, bool)': sql_lex.cc:168: `get_hash_symbol' undeclared (first use this function) *** Error code 1 make: Fatal error: Command failed for target `sql_lex.o' Current working directory /usr/local/mysql-3.23.52/sql *** Error code 1 make: Fatal error: Command failed for target `all-recursive' Regards - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Processing the join
I am interested in the internal join algorithms, not the join types that can be found in the manual. My question is how the join types in the manual are processed internally? Or, what are the different join algorithms supported by MySQL? It depends on your database query structure and especially what indexes are available. If you just put explain in front of your query you will be able to see how mysql will execute your query. On Tuesday, September 10, 2002, at 09:45 AM, Toni Strandell wrote: How does MySQL process a join between tables? Does it always use nested-loop join, or does it use sort-merge join if the table is sorted before joining it? Is the join algorithm merge if the tables are already sorted on the join attributes (through an index)? -- Toni Strandell [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
Demande d'inscription à mysql-france
Bonjour, Vous avez récemment demandé à vous inscrire au groupe mysql-france. Comme vous êtes déjà membre de ce groupe, votre demande ne sera pas prise en compte. Pour toute question sur l'envoi de messages à ce groupe, veuillez envoyer un e-mail à [EMAIL PROTECTED] Cordialement, L'équipe support Yahoo! Groupes L'utilisation du service Yahoo! Groupes est soumise à l'acceptation des Conditions d'utilisation et de la Charte sur la vie privée, disponibles respectivement sur http://fr.docs.yahoo.com/info/utos.html et http://fr.docs.yahoo.com/info/privacy.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
Problem with ALTER TABLE (err 1068)
Hello, I have a problem with the command ALTER TABLE. For example, this simple table test : +-+---+--+-+-++ | Field | Type | Null | Key | Default | Extra | +-+---+--+-+-++ | id | int(10) | | PRI | NULL| auto_increment | | texte | varchar(255) | YES | | NULL|| +-+---+--+-+-++ I want to modify the id column and convert it to tinyint type. The command line is : ALTER TABLE test MODIFY COLUMN id tinyint(3) unsigned NOT NULL PRIMARY KEY default NULL auto_increment; I launch it and I have this error : ERROR 1068: Multiple primary key defined Obviously if I remove the PRIMARY KEY, it does not begin squalling... The problem is that it's an automatic program which launches the ALTER TABLE so I'll be happy if I can keep the PRIMARY KEY. This was tested on a MySQL 4.0.2 as well as on 3.23.51. Is it a limit of ALTER ? A syntax error ?... Thank for your answers and sorry for my english :) Florent. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 eating up diskspace.
Hello everyone. I have had this very strange problem with Mysql, it seems to start eating diskspace untill the disk is full, restarting the mysql process seems to free all the used space again. Any idea what could be wrong? Kind regards Michael Wulff Nielsen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Default Win install -- mySQL autostarts when booting?
I did the normal default install. It seems to start up the mySQL server automatically when I start up Windows. Hence my question: Is there a standard way to change that so the server only runs when explicitly invoked? I think the WinMySQLAdmin program automatically installs MySQL as a service the first time it is started up. Since this is a natural thing to do after running the install script, one tends to get the service without realising it. The same tool will allow you to uninstall the service and (I think) start it manually once installed. There are many other ways of achieving the same effect, some of which Paul has already explained. Alec Cawley - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 innodb support
Hi Peter. You should download the max version of mysql binaries from www.mysql.com. It has innodb support. Also you could download the source files and compile mysql with innnodb support. Iago -Mensaje original- De: Peter Goggin [mailto:[EMAIL PROTECTED]] Enviado el: miércoles 11 de septiembre de 2002 8:41 Para: [EMAIL PROTECTED] Asunto: Mysql with innodb support I am setting up a web site with Linux (redhat 7.1), apache, php and mysql. I need the version of mysql with innodb support. Can anyone indicate to me what file or files I need to obtain to install thecorrect version of mysql and where I can down load them? Thanks in advance Regards Peter Goggin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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's Ip number
Hi all. Anybody knows how to obtain the server's ip number in MySQL? Is there any variable or function? Thanks in advance. Iago - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ResultSet.getDouble() not working with JDK 1.1.8
How-To-Repeat:
1. Use: JDK 1.1.8
2. Use: mysql-connector-java-2.0.14-bin.jar
3. Run testsuite file Transaction.java/class
Problem in ResultSet.getDouble() when testing testsuite Transaction.java
file:
java Transaction
java.lang.NoSuchMethodError: java.lang.Double: method
parseDouble(Ljava/lang/String;)D not found
at com.mysql.jdbc.ResultSet.getDouble(Unknown Source)
at com.mysql.jdbc.ResultSet.getDouble(Unknown Source)
at com.mysql.jdbc.ResultSet.getObject(Unknown Source)
at Transaction.init(Compiled Code)
at Transaction.main(Transaction.java:133)
Error occurs at:
System.out.println(RS.getDouble(2));
4. Change JDBC java code to use JDK 1.1.8 compatible calls.
Seems like parseDouble not supported in JDK 1.1.8 so change the code in
\mysql-connector-java-2.0.14\com\mysql\jdbc\ResultSet.java to
approx line 1783:
/**
* Converts a string representation of a number
* to a double. Need a faster way to do this.
*/
public static double getDouble(byte[] buf) throws SQLException
{
if (buf.length == 0)
{
return 0;
}
try
{
// Change to be JDK 1.1.8 compatible.
// return Double.parseDouble(new String(buf));
return Double.valueOf(new String(buf)).doubleValue();
}
catch (NumberFormatException e)
{
throw new SQLException(Bad format for number ' + new
String(buf) +
');
}
}
5. Run Transaction.java/class again:
java dbTransaction
Rollback Ok
23.485115
Commit Ok
Pete...
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 11 September 2002 8:05 PM
To: Peter Tan
Subject: Re: getDouble() not working with JDK 1.1.8
Your message cannot be posted to [EMAIL PROTECTED] because it did not
follow the format expected by our spam/off-topic filter. To this list we
accept only repeatable bugs reports, meaning that you can describe a
set of steps we can follow to repeat the bug on our systems.
If you are having problems with MySQL but are unable to provide the required
description, and have not purchased a support contract from MySQL AB,
you should send your message to [EMAIL PROTECTED] and possibly one of
our
knowledgable users or developers will help you. However, we do not guarantee
that every message on [EMAIL PROTECTED] will be answered. We can afford
to provide free code, but unfortunately, we cannot afford to provide
guaranteed free support on top of that. We do, nevertheless, fix our bugs
regardless of who reports them and whose systems they affect, and will
investigate your problem if you can prove to us with a test case that the
error is in our code and not yours.
If you have purchased a support contract from MySQL AB, you should follow
the standard support request procedure to report this problem. Support
contracts are available at https://order.mysql.com/.
If you are able to describe how we can repeat the problem, include the
string
How-To-Repeat: in the body of your message, followed by the detailed
description of what we need to do to make it happen, and our filter will
accept your message. If you use mysqlbug script, which comes with the MySQL
distribution, to post the message, it will be automatically accepted.
You have written the following:
---start of your message
Use: JDK 1.1.8
mysql-connector-java-2.0.14-bin.jar
Problem in ResultSet.getDouble() when testing testsuite Transaction.java
file:
java Transaction
Insert Rtn: 1
1
java.lang.NoSuchMethodError: java.lang.Double: method
parseDouble(Ljava/lang/String;)D not found
at com.mysql.jdbc.ResultSet.getDouble(Unknown Source)
at com.mysql.jdbc.ResultSet.getDouble(Unknown Source)
at com.mysql.jdbc.ResultSet.getObject(Unknown Source)
at dbTransaction.init(Compiled Code)
at dbTransaction.main(dbTransaction.java:133)
Error from:
System.out.println(RS.getDouble(2));
Seems like parseDouble not supported in JDK 1.1.8 so change the code in
\mysql-connector-java-2.0.14\com\mysql\jdbc\ResultSet.java to
line 1783:
/**
* Converts a string representation of a number
* to a double. Need a faster way to do this.
*/
public static double getDouble(byte[] buf) throws SQLException
{
if (buf.length == 0)
{
return 0;
}
try
{
// Change to be JDK 1.1.8 compatible.
// return Double.parseDouble(new String(buf));
return Double.valueOf(new String(buf)).doubleValue();
}
catch (NumberFormatException e)
{
Re: Processing the join
That is why you need to use the EXPLAIN command. As I understand it, MySQL has a number of different ways of doing a JOIN, and it attempts to optimise those dynamically by inspecting not only which indexes it has available but the sizes of the tables involved (e.g. to try to use the brute-force scan on the smallest table). The way in which any given JOIN will be processed will therefore change as the table grows/shrinks, and EXPLAIN is the best way to find out what it is doing. At least, that is my understanding. If incorrect. I would appreciate correction by those more knowledgeable. I am interested in the internal join algorithms, not the join types that can be found in the manual. My question is how the join types in the manual are processed internally? Or, what are the different join algorithms supported by MySQL? It depends on your database query structure and especially what indexes are available. If you just put explain in front of your query you will be able to see how mysql will execute your query. On Tuesday, September 10, 2002, at 09:45 AM, Toni Strandell wrote: How does MySQL process a join between tables? Does it always use nested-loop join, or does it use sort-merge join if the table is sorted before joining it? Is the join algorithm merge if the tables are already sorted on the join attributes (through an index)? Alec Cawley - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Processing the join
Yes, this is correct. But the thing is that I don't want to find out how a certain query is processed but instead how the processing is done when the query type is determined by the join optimizer. When the optimizer has decided to do a full table scan, does it do it as a nested loop join, a block nested loop join or with what algorithm? And if the query includes an ORDER BY, is the query processed as sort merge join, or as nested loop join which is then sorted. Or a hash join? So my question is not what join type (const, range, eq-ref, index scan, table scan) the optimizer chooses for a particular query, but how these join types are implemented and in which order they execute the operations (joining, sorting). On Wed, 11 Sep 2002 [EMAIL PROTECTED] wrote: That is why you need to use the EXPLAIN command. As I understand it, MySQL has a number of different ways of doing a JOIN, and it attempts to optimise those dynamically by inspecting not only which indexes it has available but the sizes of the tables involved (e.g. to try to use the brute-force scan on the smallest table). The way in which any given JOIN will be processed will therefore change as the table grows/shrinks, and EXPLAIN is the best way to find out what it is doing. At least, that is my understanding. If incorrect. I would appreciate correction by those more knowledgeable. I am interested in the internal join algorithms, not the join types that can be found in the manual. My question is how the join types in the manual are processed internally? Or, what are the different join algorithms supported by MySQL? It depends on your database query structure and especially what indexes are available. If you just put explain in front of your query you will be able to see how mysql will execute your query. On Tuesday, September 10, 2002, at 09:45 AM, Toni Strandell wrote: How does MySQL process a join between tables? Does it always use nested-loop join, or does it use sort-merge join if the table is sorted before joining it? Is the join algorithm merge if the tables are already sorted on the join attributes (through an index)? Alec Cawley - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 datafile usage map
Hi people, Is there any way I can see how much space each database is using from the innodb data file? Something showing how the space is divided among the databases. Thanks. sql,query Alexander Varshavchick, Metrocom Joint Stock Company Phone: (812)118-3322, 118-3115(fax) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 I use BerkerleyDB-4.0.14 for MySQL ??
Hello everybody !! I am a Chinese!! So my English is not very good. I hope someone can understand my question!! my question is : The MySQL-3.x.x and MySQL-4.x.x can use BerkeleyDB. But the version OF BerkeleyDB is V3.2.9, How can I use BerkeleyDB-4.0.14 in MySQL Thanks !! == PC home ¹q¤l«H½c¡A¥Ó½Ð½Ð¦Ü: http://www.pchome.com.tw PC home Online ºô¸ô®a®x¡G·|û²Ä¤@¡A¥xÆW³Ì¤jªº¤J¤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
installing
I have unzipped mysql-3.23.51-win-src.zip but cannot find the setup.exe file anywhere. What do I do next? Robert - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
R: installing
You have downoladed the source zip file, and so you have to compile it or download the binary version. Danilo -Messaggio originale- Da: Robert Barbaro [mailto:[EMAIL PROTECTED]] Inviato: venerdì 12 luglio 2002 11.52 A: [EMAIL PROTECTED] Oggetto: installing I have unzipped mysql-3.23.51-win-src.zip but cannot find the setup.exe file anywhere. What do I do next? Robert - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 1053 stalling replication
Mysql, sql, etc. Hi, I am using a slave to perform backups using mysqlhotcopy. This locks all tables in my database for 10 minutes. Sometimes the replication is aborted during the period that the tables are locked. The error message in the slave's log is: ERROR: 1053 Server shutdown in progress 020910 21:00:02 Slave: error running query 'insert into ...' 020910 21:00:02 Error running query, slave aborted. Fix the problem, and re-start the slave thread with mysqladmin start-slave. We stopped at log 'log-bin.114' position 75216512 The slave is then easily restarted using slave start. Does anyone know why this is happening ? I imagine it is something to do with the tables being locked - but I don't understand why it thinks there is a server shutdown, or why this isn't easily repeatable. My slave is 3.23.51 (linux 2.4), and the master is 3.23.33 (linux 2.2). regards, Martin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 ALTER TABLE (err 1068)
Maybe it is because some of your id are bigger than 127 wich is the limit for the Tinyint and when it is converted to this type, 127 is replacing all your id bigger than 127. Then you have multiple id with 127. Regards, Stephan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 10:01 AM To: [EMAIL PROTECTED] Subject: Problem with ALTER TABLE (err 1068) Hello, I have a problem with the command ALTER TABLE. For example, this simple table test : +-+---+--+-+-++ | Field | Type | Null | Key | Default | Extra | +-+---+--+-+-++ | id | int(10) | | PRI | NULL| auto_increment | | texte | varchar(255) | YES | | NULL|| +-+---+--+-+-++ I want to modify the id column and convert it to tinyint type. The command line is : ALTER TABLE test MODIFY COLUMN id tinyint(3) unsigned NOT NULL PRIMARY KEY default NULL auto_increment; I launch it and I have this error : ERROR 1068: Multiple primary key defined Obviously if I remove the PRIMARY KEY, it does not begin squalling... The problem is that it's an automatic program which launches the ALTER TABLE so I'll be happy if I can keep the PRIMARY KEY. This was tested on a MySQL 4.0.2 as well as on 3.23.51. Is it a limit of ALTER ? A syntax error ?... Thank for your answers and sorry for my english :) Florent. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
is table or row write locked during an update ?
Hello, I need to do an update on a table : * Something like this : * UPDATE my_table mt SET mt.field1 = mt.field1 + 1 WHERE mt.id = 100 * And there can have concurrent updates on this record. is there a risk of 2 (or more) updates done at the same time and my field and the result of the query to damage the field or does all the updates done in a queue ... ? Do I have to do a lock table before the update ? Thank you for your help Stef Webmaster of Atoova http://homecinema.atoova.com (running under php/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
Re: is table or row write locked during an update ?
BRACHET,STEPHAN (Non-HP-France,ex1) wrote: Hello, I need to do an update on a table : * Something like this : * UPDATE my_table mt SET mt.field1 = mt.field1 + 1 WHERE mt.id = 100 * And there can have concurrent updates on this record. is there a risk of 2 (or more) updates done at the same time and my field and the result of the query to damage the field or does all the updates done in a queue ... ? Do I have to do a lock table before the update ? Thank you for your help Stef Webmaster of Atoova http://homecinema.atoova.com (running under php/mysql) Hi, There is no risk and you don't need to lock the table yourself. Depending of the type of table you use, MySQL will automatically lock the entire table (myisam table type) or just the row (InnoDB). Regards -- Joseph Bueno - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: mysql install Q... error connecting /tmp/mysql.sock
anand, Wednesday, September 11, 2002, 8:05:48 AM, you wrote: av I have redhat linux 7.1 and I have downloaded mysql-3.23.52 av and followed all the instructions as to how to install and how av to bring up the database the scripts/mysql_install_db worked av fine and then I did ./bin/safe_mysqld and that worked fine too av but when I tried to execute the mysql program I got the following error av [root@abacusweb mysql]# bin/safe_mysqld av [1] 25307 av [root@abacusweb mysql]# Starting mysqld daemon with databases from av /var/lib/mysq av l av [root@abacusweb mysql]# av [root@abacusweb mysql]# mysql av ERROR 2002: Can't connect to local MySQL server through socket av '/tmp/mysql.sock' av (111) av = av I don't know how to run and capture the output from mysqlbug program av and if some one tells me how to redirect the output from mysqlbug program av I appreciate that If MySQL server is running, check where mysql.sock is located and specify path to the socket file with --socket option or edit my.cnf file. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 ALTER TABLE (err 1068)
Thanks Stephan for your answer but the error message would be : ERROR 1062: Duplicate entry '255' for key 1. I tried to drop the key : ALTER TABLE test DROP PRIMARY KEY but I had this message : ERROR 1075: Incorrect table definition; There can only be one auto column and it must be one auto column and it must be defined as a key. So I can't drop primary key and i can alter my primary key wih the keyword PRIMARY KEY !!... I think it's not a personnal problem but a limitation (or bug) of MySQL... Florent. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: installing
Robert, Friday, July 12, 2002, 12:51:41 PM, you wrote: RB I have unzipped mysql-3.23.51-win-src.zip but cannot find the setup.exe file RB anywhere. You downloaded the source distribution :-) RB What do I do next? Compile MySQL from source or download Win binary distribution. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 eating up diskspace.
m, Wednesday, September 11, 2002, 11:11:13 AM, you wrote: mdwdnatodd I have had this very strange problem with Mysql, it seems to start eating mdwdnatodd diskspace untill the disk is full, restarting the mysql process seems to free mdwdnatodd all the used space again. mdwdnatodd Any idea what could be wrong? What did you do with MySQL? Did you just started MySQL server? or what? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 ALTER TABLE (err 1068)
fpaul, Wednesday, September 11, 2002, 11:00:56 AM, you wrote: faadn I have a problem with the command ALTER TABLE. faadn For example, this simple table test : faadn +-+---+--+-+-++ faadn | Field | Type | Null | Key | Default | Extra | faadn +-+---+--+-+-++ faadn | id | int(10) | | PRI | NULL| auto_increment | faadn | texte | varchar(255) | YES | | NULL|| faadn +-+---+--+-+-++ faadn I want to modify the id column and convert it to tinyint type. The command line faadn is : faadn ALTER TABLE test MODIFY COLUMN id tinyint(3) unsigned NOT NULL PRIMARY KEY faadn default NULL auto_increment; faadn I launch it and I have this error : faadn ERROR 1068: Multiple primary key defined ALTER TABLE test MODIFY COLUMN id tinyint(3) unsigned auto_increment; faadn Obviously if I remove the PRIMARY KEY, it does not begin squalling... faadn The problem is that it's an automatic program which launches the ALTER TABLE so faadn I'll be happy if I can keep the PRIMARY KEY. faadn This was tested on a MySQL 4.0.2 as well as on 3.23.51. faadn Is it a limit of ALTER ? A syntax error ?... Thank for your answers and sorry -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 are OR-Clauses handled so badly?
I am using mysql select version() as version; +-+ | version | +-+ | 3.23.48-log | +-+ 1 row in set (0.00 sec) on Suse Linux 8.0 and Solaris 8. The problem exists on both platforms. I have mysql select count(*) from auth_kn; +--+ | count(*) | +--+ |95000 | +--+ 1 row in set (0.00 sec) with kk@kris:~ mysqldump --no-data test auth_kn -- MySQL dump 8.21 -- -- Host: localhostDatabase: test - -- Server version 3.23.48-log -- -- Table structure for table 'auth_kn' -- CREATE TABLE auth_kn ( login varchar(16) NOT NULL default '', alias varchar(16) NOT NULL default '', pw varchar(16) NOT NULL default '', PRIMARY KEY (login), UNIQUE KEY alias (alias) ) TYPE=MyISAM; The table data is synthetically generated for performance testing and looks like this: mysql select * from auth_kn limit 3; +---+---++ | login | alias | pw | +---+---++ | 0 | a0| 0 | | 1 | a1| 1 | | 2 | a2| 2 | +---+---++ 3 rows in set (0.05 sec) I want to build a login that accepts either the user name (which is a 16 digit number that is hard to remember) or the user aliass (which is a unique name the user created for himself) and a password. If I fire a simple query such as mysql select * from auth_kn where ( login = 1000 and pw = 1000 ); +---+---+--+ | login | alias | pw | +---+---+--+ | 1000 | a1000 | 1000 | +---+---+--+ 1 row in set (0.00 sec) mysql explain select * from auth_kn where ( login = 1000 and pw = 1000 ); +-+---+---+-+-+---+--+---+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-+---+---+-+-+---+--+---+ | auth_kn | const | PRIMARY | PRIMARY | 16 | const |1 | | +-+---+---+-+-+---+--+---+ 1 row in set (0.00 sec) all is well. The result for alias is exactly the same: mysql explain select * from auth_kn where ( alias = 1000 and pw = 1000 ); +-+ | Comment | +-+ | Impossible WHERE noticed after reading const tables | +-+ 1 row in set (0.00 sec) mysql explain select * from auth_kn where ( alias = a1000 and pw = 1000 ); +-+---+---+---+-+---+--+---+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-+---+---+---+-+---+--+---+ | auth_kn | const | alias | alias | 16 | const |1 | | +-+---+---+---+-+---+--+---+ 1 row in set (0.00 sec) My problems start as soon as I combine both statements with an or clause. It does not matter if I multiply the operands out or not: mysql select * from auth_kn where ( login = 1000 or alias = 1000 ) and pw = 1000; +---+---+--+ | login | alias | pw | +---+---+--+ | 1000 | a1000 | 1000 | +---+---+--+ 1 row in set (0.23 sec) mysql explain select * from auth_kn where ( login = 1000 or alias = 1000 ) and pw = 1000; +-+--+---+--+-+--+---++ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-+--+---+--+-+--+---++ | auth_kn | ALL | PRIMARY,alias | NULL |NULL | NULL | 95000 | where used | +-+--+---+--+-+--+---++ 1 row in set (0.00 sec) And multiplying the operands out giving mysql explain select * from auth_kn where ( login= 1000 and pw = 1000 ) or ( alias = 1000 and pw = 1000 ); +-+--+---+--+-+--+---++ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-+--+---+--+-+--+---++ | auth_kn | ALL | PRIMARY,alias | NULL |NULL | NULL | 95000 | where used | +-+--+---+--+-+--+---++ 1 row in set (0.00 sec) yields the same result. What is the reason for this loss on performance on such a simple query? How would I handle this situation? The current workaround is to have two simple queries, which performs much better than the combined query, but incurs the double RTT and twice the context switches and page faults. Recommendations? Kristian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list
Re: can not connect or log into MySQL anymore.
Do not run myisamchk with the server running. Stephen Sokalski wrote: version: 3.23.37 running on an RAQ Problem: I can not log into MySql as root - it hangs after I give it a password. Background: MySql was running fine for a year and then just stopped running. Symptoms: 1) Mysqld is running when I reboot the server but can't be shut down (/usr/share/mysql/mysql.server stop) and keeps timing out. 2) When it's running there is a .sock file 3) If I try to log in as any valid user, it simply waits indefinitely. 4) Suspecting that something is wrong with the mysql database, I ran a check on it: myisamchk -f *.MYI and myisamchk -r *.MYI Every time I run the -r it states it's repairing indexes. In any event: I know I should probably upgrade the version but it was a package that was suggested by sun at the time and I know I could download the binary but ... I want to make sure I understand what the problem is and know that I will be able to fix it by upgrading. Can someone explain what is going on? Will upgrading fix this problem, etc.? Thanks, Steve - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 are OR-Clauses handled so badly?
If you have proper indexes on alias, the optimizer should not make a table scan. You can try to add an index on pw too. Or you could combine the two queries with an UNION. But beside this point you have a possible problem with the basic design. It is possible that someone adds an alias that is the same as an existing login chosen by the system. This is a potential (but not very probable as they would have to have the same passwords too) security problem that could give access to wrong people. You have to check that the alias does not exist in alias (done with UNIQUE) nor in login while adding a new alias. Toni On Wed, 11 Sep 2002, Kristian Koehntopp wrote: I am using mysql select version() as version; +-+ | version | +-+ | 3.23.48-log | +-+ 1 row in set (0.00 sec) on Suse Linux 8.0 and Solaris 8. The problem exists on both platforms. I have mysql select count(*) from auth_kn; +--+ | count(*) | +--+ |95000 | +--+ 1 row in set (0.00 sec) with kk@kris:~ mysqldump --no-data test auth_kn -- MySQL dump 8.21 -- -- Host: localhostDatabase: test - -- Server version 3.23.48-log -- -- Table structure for table 'auth_kn' -- CREATE TABLE auth_kn ( login varchar(16) NOT NULL default '', alias varchar(16) NOT NULL default '', pw varchar(16) NOT NULL default '', PRIMARY KEY (login), UNIQUE KEY alias (alias) ) TYPE=MyISAM; The table data is synthetically generated for performance testing and looks like this: mysql select * from auth_kn limit 3; +---+---++ | login | alias | pw | +---+---++ | 0 | a0| 0 | | 1 | a1| 1 | | 2 | a2| 2 | +---+---++ 3 rows in set (0.05 sec) I want to build a login that accepts either the user name (which is a 16 digit number that is hard to remember) or the user aliass (which is a unique name the user created for himself) and a password. If I fire a simple query such as mysql select * from auth_kn where ( login = 1000 and pw = 1000 ); +---+---+--+ | login | alias | pw | +---+---+--+ | 1000 | a1000 | 1000 | +---+---+--+ 1 row in set (0.00 sec) mysql explain select * from auth_kn where ( login = 1000 and pw = 1000 ); +-+---+---+-+-+---+--+---+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-+---+---+-+-+---+--+---+ | auth_kn | const | PRIMARY | PRIMARY | 16 | const |1 | | +-+---+---+-+-+---+--+---+ 1 row in set (0.00 sec) all is well. The result for alias is exactly the same: mysql explain select * from auth_kn where ( alias = 1000 and pw = 1000 ); +-+ | Comment | +-+ | Impossible WHERE noticed after reading const tables | +-+ 1 row in set (0.00 sec) mysql explain select * from auth_kn where ( alias = a1000 and pw = 1000 ); +-+---+---+---+-+---+--+---+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-+---+---+---+-+---+--+---+ | auth_kn | const | alias | alias | 16 | const |1 | | +-+---+---+---+-+---+--+---+ 1 row in set (0.00 sec) My problems start as soon as I combine both statements with an or clause. It does not matter if I multiply the operands out or not: mysql select * from auth_kn where ( login = 1000 or alias = 1000 ) and pw = 1000; +---+---+--+ | login | alias | pw | +---+---+--+ | 1000 | a1000 | 1000 | +---+---+--+ 1 row in set (0.23 sec) mysql explain select * from auth_kn where ( login = 1000 or alias = 1000 ) and pw = 1000; +-+--+---+--+-+--+---++ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-+--+---+--+-+--+---++ | auth_kn | ALL | PRIMARY,alias | NULL |NULL | NULL | 95000 | where used | +-+--+---+--+-+--+---++ 1 row in set (0.00 sec) And multiplying the operands out giving mysql explain select * from auth_kn where ( login= 1000 and pw = 1000 ) or ( alias = 1000 and pw = 1000 ); +-+--+---+--+-+--+---++ | table | type | possible_keys | key | key_len | ref | rows | Extra |
Problems with client to sever access
I am using a win2000 server where mysql is installed under phptriad. I am trying to access the mysql databases from my machine by using the winmysqladmintool. This winmysqladmintool works on the server but on my machine the light is constantly red and it says the service is not installed or running. This has been wrecking my head for the last three days. Any help would be greatly appreciated Thank you TIm Timothy O'Connor Schlumberger Global Servicedesk Analyst Schlumberger Block 1C Marina Business Park Centre Park Road Cork City Ireland ( +353 214705405 * [EMAIL PROTECTED] I understand that U.S. trade regulations prohibit certain transfers of U.S. technology technical data or software to U.S. embargoed states. I am aware of Schlumberger's Trade Control Policy and the OFS Export Administration procedures with respect to U.S. embargoed states and confirm that this transmission does not cause a prohibited transfer of technology technical data or software
Re: can not connect or log into MySQL anymore.
Stephen, mysqlcheck works while the server is running. P. Gerald Clark wrote: Do not run myisamchk with the server running. Stephen Sokalski wrote: version: 3.23.37 running on an RAQ Problem: I can not log into MySql as root - it hangs after I give it a password. Background: MySql was running fine for a year and then just stopped running. Symptoms: 1) Mysqld is running when I reboot the server but can't be shut down (/usr/share/mysql/mysql.server stop) and keeps timing out. 2) When it's running there is a .sock file 3) If I try to log in as any valid user, it simply waits indefinitely. 4) Suspecting that something is wrong with the mysql database, I ran a check on it: myisamchk -f *.MYI and myisamchk -r *.MYI Every time I run the -r it states it's repairing indexes. In any event: I know I should probably upgrade the version but it was a package that was suggested by sun at the time and I know I could download the binary but ... I want to make sure I understand what the problem is and know that I will be able to fix it by upgrading. Can someone explain what is going on? Will upgrading fix this problem, etc.? Thanks, Steve - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Error 1053 stalling replication
I do: slave stop mysqlhotcopy slave start Martin Waite wrote: Mysql, sql, etc. Hi, I am using a slave to perform backups using mysqlhotcopy. This locks all tables in my database for 10 minutes. Sometimes the replication is aborted during the period that the tables are locked. The error message in the slave's log is: ERROR: 1053 Server shutdown in progress 020910 21:00:02 Slave: error running query 'insert into ...' 020910 21:00:02 Error running query, slave aborted. Fix the problem, and re-start the slave thread with mysqladmin start-slave. We stopped at log 'log-bin.114' position 75216512 The slave is then easily restarted using slave start. Does anyone know why this is happening ? I imagine it is something to do with the tables being locked - but I don't understand why it thinks there is a server shutdown, or why this isn't easily repeatable. My slave is 3.23.51 (linux 2.4), and the master is 3.23.33 (linux 2.2). regards, Martin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 are OR-Clauses handled so badly?
Am Mittwoch, 11. September 2002 15:19 schrieb Toni Strandell: If you have proper indexes on alias, the optimizer should not make a table scan. You can try to add an index on pw too. Or you could combine the two queries with an UNION. Sorry, UNION is not available, as it is implemented only in MySQL 4.x and we cannot upgrade the system to this MySQL version (it is a production system). But based on your hint I have searched the documentation again, and found http://www.mysql.com/doc/en/Searching_on_two_keys.html which is exactly my problem (but unfortunately offers no solution). You also reminded me of But beside this point you have a possible problem with the basic design. It is possible that someone adds an alias that is the same as an existing login chosen by the system. Thus I have chosen to normalize the design to login (either 1000, the login name in the previous example, or a1000, the alias name in the previous example) and make this a primary key. password (just like before) subscriber (the login name in the previous example) and make this a key, and mark it as a foreign key into an external customer table. This customer table does not actually exist in the MySQL web frontend, but only in the subscriber database in the backend, but I need this link for metering purposes. I now have at most 190.000 records instead of 95.000 previously, but the performance has improved greatly. Thank you for your quick assistance and for providing the proper search keyword for the documentation (searching for union leads directly to the URL Two Keys URL cited above). Kristian -- NP: Slaying the dreamer, Century Child (Nightwish) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 are OR-Clauses handled so badly?
Put an index on password. That should speed it up for you. Kristian Koehntopp wrote: Am Mittwoch, 11. September 2002 15:19 schrieb Toni Strandell: If you have proper indexes on alias, the optimizer should not make a table scan. You can try to add an index on pw too. Or you could combine the two queries with an UNION. Sorry, UNION is not available, as it is implemented only in MySQL 4.x and we cannot upgrade the system to this MySQL version (it is a production system). But based on your hint I have searched the documentation again, and found http://www.mysql.com/doc/en/Searching_on_two_keys.html which is exactly my problem (but unfortunately offers no solution). You also reminded me of But beside this point you have a possible problem with the basic design. It is possible that someone adds an alias that is the same as an existing login chosen by the system. Thus I have chosen to normalize the design to login (either 1000, the login name in the previous example, or a1000, the alias name in the previous example) and make this a primary key. password (just like before) subscriber (the login name in the previous example) and make this a key, and mark it as a foreign key into an external customer table. This customer table does not actually exist in the MySQL web frontend, but only in the subscriber database in the backend, but I need this link for metering purposes. I now have at most 190.000 records instead of 95.000 previously, but the performance has improved greatly. Thank you for your quick assistance and for providing the proper search keyword for the documentation (searching for union leads directly to the URL Two Keys URL cited above). Kristian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Which one, InnoDB or BerkeleyDB?
Which one would be the best with MySQL thinking in reliability and performance? Thanks a lot for your thoughts! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
group by clause
: i have one table with 4 fields (nik,name,child_name,child_number) i wan to query that the result will be like this +--+---++++ + | nik | name | child1 | child2 | child3 | child4 | +--+---++++ + | 1 | pai | mai | NULL | NULL | NULL | | 2 | mai | NULL | NULL | NULL | NULL | +--+---++++ + in oracle i can do this query like below select nik,name, max(decode(child_number,1,child_name)) child1, max(decode(child_number,2,child_name)) child2, max(decode(child_number,3,child_name)) child3, max(decode(child_number,4,child_name)) child4, from test group by nik,name and its work fine now i want to try in MYSQL but not work i use query like this SELECT nik, name, max(case when child_number='1' THEN child_name end) child1, max(case when child_number='2' THEN child_name end) child2, max(case when child_number='3' THEN child_name end) child3, max(case when child_number='4' THEN child_name end) child4 FROM test group by nik,name but the result is +--+---++++ + | nik | name | child1 | child2 | child3 | child4 | +--+---++++ + | 1 | pai | mai | NULL | NULL | NULL | | 2 | mai | NULL | NULL | NULL | NULL | +--+---++++ + why ? any body know ? thank's - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: AW: SQL help, search with related record in 2nd table
Carsten Thank you very much for pointing me in that direction, that nearly solved the issue but I still get a duplicate for each record that is in the second table (if WishListItems has 5 records for a Visitor, I get 5 duplicates in the result). I tried using GROUP BY to eliminate the duplicates and this seems to work, but it seems to too much overhead, or is it? Is writing the query this way correct? SELECT * FROM Visitors LEFT JOIN WishListItems ON Visitors.VisitorID=WishListItems.VisitorID WHERE WishListItems.VisitorID IS NOT NULL AND Visitors.NameLast='Collins' GROUP BY Visitors.NameLast; Michael At 9:33 AM +0200 9/11/02, Carsten Zilch wrote: Hello, the answer for: RE: Selecting data from one table if it's NOT in another should also answer your question Carsten -Ursprüngliche Nachricht- Von: Michael Collins [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 10. September 2002 22:40 An: [EMAIL PROTECTED] Betreff: SQL help, search with related record in 2nd table I am looking for some help on a SQL query to perform a search, but constrain the search to those records which have a related record in a second table. What I think I need is a subselect, but since this is not possible in 3.23.47, I am looking for work around. I have one table for Visitors (key is VisitorID) and another for items that a user has selected named WishListItems (foreign key is VisitorID). SELECT Visitors.* FROM Visitors, WishListItems WHERE Visitors.VisitorID=WishListItems.VisitorID AND Visitors.NameLast REGEXP 'Collins'; I get a result for each record there is in WishListItems. I tried using a Join but that does not help: SELECT Visitors.* FROM Visitors INNER JOIN WishListItems On Visitors.VisitorID=WishListItems.VisitorID WHERE Visitors.NameLast REGEXP 'Collins'; I seem to get the same result. What I need is to search Visitors, but only find records from Visitors if there are any records in WishListItems (I am not checking anythign in WishListItems, there just has to be at least one record). -- Michael __ -- Michael __ ||| Michael Collins ||| Kuwago Inc mailto:[EMAIL PROTECTED] ||| Seattle, WA, USAhttp://michaelcollins.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
A new Idea for FULLTEXT searchs
mysql, query speed up _ Sorry I may be bothering you but I was thinking (gosh! this is so bizarre on me) that may be we can make MySQL SGML compatible. I agree that MYSQL cannot be manipulated to handle jerarquical information because this is not the object and isnt mine either. May be we can add a NEW FEATURE ON INDEXING AND FULLTEXT that consists on avoiding the indexing of tags (as groups of words embrassed by and ), and support to add new rules to this one. In this case, we may use direct HTML code (for example) without worries of indexing the tags, and allow the developer to add new functionality as RTF support and TEX. Am I int the good way or I'll need to sleep more? Leonardo Javier Belén. AFIP-AR. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Is compiler advisory at source download valid?
Hi all. Is the compiler advisory at mysql source donwload web page still valid? The web page is http://www.mysql.com/downloads/mysql-3.23.html I've seen it some monts ago and I want to know if I could compiler the source with an gcc 3.0 compiler. These are the notes: Compiler Advisory: Several of our users have reported random crashes and table corruption with MySQL binaries compiled with gcc 2.96 on the x86 Linux platform. Although we were unable to duplicate the problems ourselves or understand their exact cause, we suspect with a great degree of confidence that the problem was compiler related. Replacing the faulty binary with our binary always eliminated the problem. We recommend that MySQL be compiled with gcc 2.95 if you have to compile your own binary at all. It is also acceptable to compile it with gcc 2.91 - builds with these compilers have been tested extensively. We would suggest, however, that you stay away from gcc 3.0 series until we have had some time to do some more extensive testing. The best solution in terms of stability and performance for most users is to use our binary instead of compiling their own. Please visit http://www.mysql.com/ to obtain an Official MySQL binary. To determine if you should be concerned about this compiler issue, execute gcc -v from the command prompt on your system. If the compiler reports version 2.96, then there is a problem (this is the case, for example on RH 7.x series or Mandrake 8.x). In this case, you should not try to compile your own binary before downgrading to one of the compilers mentioned above. You should also NOT use the MySQL server provided with your distribution -- as this copy of MySQL was compiled with the same ill-advised compiler version. Iago. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: do i must use mysql_free_result()?
At 8:46 -0500 9/11/02, Dizzy Myope wrote:
hi all:)
int main(void)
{
.
rs=mysql_store_result(connection);//get result to rs
..
mysql_free_result(rs);// it is necessary ???
rs=mysql_store_result(connection);// get result to rs again.
}
i write some codes with c++mysql like above, and i want to know
between the same mysql_res used twice ,
it is necessary to use mysql_free_result() or not.
Yes. Do you have some objection to doing so? :-)
3KS.
asap.
Dizzy Myope
[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
Error when executing mysql_install_db
Description: I have downloaded the binary mysql-3.23.52-hp-hpux10.20-hppa1.1.tar.gz grom mysql.com. After unzipping it and create the symbolic link in /usr/local/, I executed the script mysql_install_db. I receive the following message : Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables /usr/lib/dld.sl: Can't open shared library: /my/gnu/lib/gcc-lib/hppa1.1-hp-hpux10.20/3.1/../../../libgcc_s.sl /usr/lib/dld.sl: No such file or directory scripts/mysql_install_db[292]: 18448 Abort(coredump) Installation of grant tables failed! I search your site and the Internet and found nothing about this problem. I used gcc 2.95.3. The file libgcc_s.sl is not presente on my server. Thanks for yous help. How-To-Repeat: Fix: Submitter-Id: Andre Villeneuve Originator: Organization: MySQL support: none Synopsis: Error when executing mysql_install_db Severity: Priority: Category: mysql Class: Release: mysql-3.23.52 (Official MySQL binary) Environment: System: HP-UX beetle B.10.20 E 9000/785 2010232503 8-user license Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin//gmake /opt/gcc/bin//gcc /usr/bin/cc GCC: Reading specs from /opt/gcc/lib/gcc-lib/hppa1.1-hp-hpux10.20/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='-DHPUX -I/opt/dce/include -O3' CXX='g++' CXXFLAGS='-DHPUX -I/opt/dce/include -felide-constructors -fno-exceptions -fno-rtti -O3 ' LDFLAGS='' LIBC: -r-xr-xr-x 1 binbin1863680 Nov 10 1999 /lib/libc.1 -r--r--r-- 1 binbin2456532 Nov 10 1999 /lib/libc.a lrwxr-xr-x 1 root sys 15 Dec 2 1999 /lib/libc.sl - /usr/lib/libc.1 -r-xr-xr-x 1 binbin1863680 Nov 10 1999 /usr/lib/libc.1 -r--r--r-- 1 binbin2456532 Nov 10 1999 /usr/lib/libc.a lrwxr-xr-x 1 root sys 15 Dec 2 1999 /usr/lib/libc.sl - /usr/lib/libc.1 Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --enable-thread-safe-client --enable-local-infile --with-pthread --with-named-thread-libs=-ldce --with-lib-ccflags=-fpic --disable-shared 'CFLAGS=-DHPUX -I/opt/dce/include -O3' 'CXXFLAGS=-DHPUX -I/opt/dce/include -felide-constructors -fno-exceptions -fno-rtti -O3 ' CXX=g++ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Found a bug with... CREATE SELECT IF?
ant,
Tuesday, September 10, 2002, 10:28:13 PM, you wrote:
aasdn Apparently in 4.0.3 does not like if statements in it's
aasdn SELECT query... A query that once worked now returns 0 when I use
aasdn an IF, rather than the proper value
How-To-Repeat:
aasdn This is a simple example of how I am able to recreate...
aasdn CREATE TEMPORARY TABLE temp SELECT IF(LENGTH('test'),'test','test') AS test;
aasdn SELECT * FROM temp;
aasdn This will yield 0, where it should be test...
Hi!
Yes, it's a known bug and was already fixed in 4.0.4
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
___/ www.mysql.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
testfretf
Toni, Wednesday, September 11, 2002, 10:06:14 AM, you wrote: TS REALFROM: Toni Strandell [EMAIL PROTECTED] TS I am interested in the internal join algorithms, not the join types that TS can be found in the manual. My question is how the join types in the TS manual are processed internally? Or, what are the different join TS algorithms supported by MySQL? It depends on your database query structure and especially what indexes are available. If you just put explain in front of your query you will be able to see how mysql will execute your query. On Tuesday, September 10, 2002, at 09:45 AM, Toni Strandell wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
First question: a howto.
I can't add a new user or I don't know the proper way to log into the server. I added a user; call him webley. Ran my sql statement to insert into the user and db tables. Granted all rights because I was unsure how many rights my cgi script would need. It does need to create new tables and populate data. when I try to log in as that user, mysql -u webley -p icesql I get the prompt for a password but after entering I get access denied. The icesql is in the db table and webley does have rights in the db table for that database. Can someone tell me if I am missing the big flick? Brian Duke CTIP/TNT CFP IPSA Level(3) Communication (720) 888-7797 ==-=-=-=-=--==--==¬ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ANN: EMS MySQL Manager 1.9 released
EMS HiTech company is announcing the next version (1.9) of MySQL Manager -- A Powerful MySQL Administration and Development Tool for Windows95/98/ME/NT/2000/XP. You can download the latest version from http://www.mysqlmanager.com/download.phtml EMS HiTech is announcing the special offer as we have a quarter-million visitor on our website. Up to September 15, 2002 you can purchase all our software with 15% discount. Buy now and save your money! What's new in version 1.9? 1. Visual Query Builder was significantly improved. Most of the known bugs in Visual Query Builder are fixed, some MySQL-specific words and constructs such as LIMIT #, SQL_SMALL_RESULT, SQL_BIG_RESULT, HIGH_PRIORITY are supported now. Also a possibility to alter the visual settings of Query Builder was added to Environment Options dialog (see the Query Builder page within that dialog). (*) 2. Import Data Wizard: the import data engine was updated to the latest version (1.4) of EMS QuickImport suite (http://www.ems-hitech.com/quickimport/). The major improvement of this update is an ability to import data from Microsoft Access database. (*) 3. Export Data as INSERT dialog exports only currently selected records now. (*) 4. Fixed bug with importing data from .csv files with empty values within records. (*) 5. Changing a field size is now possible after changing a field type in the Edit Field dialog. 6. Fixed bug with wrong text representing just after record editing in the Data View if the database font charset is different from default. 7. Some minor bugfixes and small improvements. (*) - Professional Edition only What is the EMS MySQL Manager? EMS MySQL Manager provides you powerful and effective tools for MySQL Server administration and objects management. Its Graphical User Interface (GUI) allows you to create/edit all MySQL database objects in a most easy and simple way, run SQL scripts, manage users and administrate user privileges, visually build SQL queries, extract or print metadata, export/import data, view/edit BLOBs and many more services that will make your work with the MySQL server as easy as it can be... We hope you'll enjoy working with our software. Thank you for your attention. Best regards, EMS HiTech development team. http://www.ems-hitech.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: Windows XP Installation Problems
Well, I finally figured out the problem, it was a corrupt installation package. Funny thing is I downloaded three different times from different sites. Working now, thanks. -=Bryan=- -Original Message- From: Miguel Angel Solórzano [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 10, 2002 7:22 PM To: Lukoni, Bryan AG:EX; 'Michael Bunzel' Cc: '[EMAIL PROTECTED]' Subject: RE: Windows XP Installation Problems At 16:40 10/9/2002 -0700, Lukoni, Bryan AG:EX wrote: Hi, Thanks Michel: Enabled the error reporting, but no luck. I'm stumped why I am not seeing any error messages when it fails to install. Do you know if the MYSQL installation makes any modifications to the registry or adds files to the system directory. Nothing is copied to registry. If not I could probably just copy the complete directory from the other computer onto a CD and recopy to the problem computer. The above will works. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel Angel Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ São Paulo - Brazil ___/ 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: First question: a howto.
At 10:12 -0600 9/11/02, [EMAIL PROTECTED] wrote: I can't add a new user or I don't know the proper way to log into the server. I added a user; call him webley. Ran my sql statement to insert into the user and db tables. Granted all rights because I was unsure how many rights my cgi script would need. It does need to create new tables and populate data. when I try to log in as that user, mysql -u webley -p icesql I get the prompt for a password but after entering I get access denied. The icesql is in the db table and webley does have rights in the db table for that database. Can someone tell me if I am missing the big flick? If you used INSERT, did you also FLUSH PRIVILEGES after creating the grant table entries? Generally, it's better to use GRANT, which is easier, and also causes the server to reread the grant tables automatically. Brian Duke CTIP/TNT CFP IPSA Level(3) Communication (720) 888-7797 ==-=-=-=-=--==--==¬ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Q: How to determine size(s) of db files?
Is there a MySQL command that will return the amount of disk space used by a particular database? I find lots of references to size limits on tables / databases etc. but nothing on the actual 'disk usage'. This would be nice to have I think, since without access to the data directory on the server, I have to ask my ISP to do a 'du' for me. I maintain several databases for clients with my ISP, and since I'm paying for disk space, I'd like to be able to pass that cost on to my clients. -- /* All outgoing email scanned by Norton Antivirus 2002 */ Amer Neely, Softouch Information Services W: www.softouch.on.ca E: [EMAIL PROTECTED] V: 519.438.5887 Perl | PHP | MySQL | CGI programming for all data entry forms. We make web sites work! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 bug?
Folks, I'm experiencing some strange behavior with our mysql server and I'm curious to see if anybody else has had this problem. Over about a 3 month period, I noticed that the /var partition of our linux server claims to fill up. The server is well into it's 3 month cycle now and I have a short window to play with before the machine will just die. The output from df shows: machine:/var# df -k . Filesystem 1k-blocks Used Available Use% Mounted on /dev/hda3 497861345390126767 74% /var whereas the output from du returns: machine:/var# du -sk /var 145841 /var obviously there is a discrepency here. I ran lsof on the /var directory and noticed: machine:/var# lsof +D /var COMMAND PID USER FD TYPE DEVICESIZENODE NAME mysqld10917 root3u unix 0xc2367cc0 144707 /var/run/mysqld/mysqld.sock mysqld10917 root7u unix 0xc600f660 4464830 /var/run/mysqld/mysqld.sock mysqld10917 root 24u unix 0xc56f2c80 4465358 /var/run/mysqld/mysqld.sock mysqld10917 root 62u unix 0xc1bd7c80 4468136 /var/run/mysqld/mysqld.sock mysqld10917 root 82u unix 0xc2484980 4465577 /var/run/mysqld/mysqld.sock mysqld10931 root3u unix 0xc2367cc0 144707 /var/run/mysqld/mysqld.sock mysqld10931 root7u unix 0xc600f660 4464830 /var/run/mysqld/mysqld.sock mysqld10931 root 24u unix 0xc56f2c80 4465358 /var/run/mysqld/mysqld.sock mysqld10931 root 62u unix 0xc1bd7c80 4468136 /var/run/mysqld/mysqld.sock mysqld10931 root 82u unix 0xc2484980 4465577 /var/run/mysqld/mysqld.sock mysqld10932 root3u unix 0xc2367cc0 144707 /var/run/mysqld/mysqld.sock mysqld10932 root7u unix 0xc600f660 4464830 /var/run/mysqld/mysqld.sock mysqld10932 root 24u unix 0xc56f2c80 4465358 /var/run/mysqld/mysqld.sock mysqld10932 root 62u unix 0xc1bd7c80 4468136 /var/run/mysqld/mysqld.sock mysqld10932 root 82u unix 0xc2484980 4465577 /var/run/mysqld/mysqld.sock mysqld10933 root3u unix 0xc2367cc0 144707 /var/run/mysqld/mysqld.sock mysqld10933 root7u unix 0xc600f660 4464830 /var/run/mysqld/mysqld.sock mysqld10933 root 24u unix 0xc56f2c80 4465358 /var/run/mysqld/mysqld.sock mysqld10933 root 62u unix 0xc1bd7c80 4468136 /var/run/mysqld/mysqld.sock mysqld10933 root 82u unix 0xc2484980 4465577 /var/run/mysqld/mysqld.sock mysqld30032 root3u unix 0xc2367cc0 144707 /var/run/mysqld/mysqld.sock mysqld30032 root7u unix 0xc600f660 4464830 /var/run/mysqld/mysqld.sock mysqld30032 root 24u unix 0xc56f2c80 4465358 /var/run/mysqld/mysqld.sock mysqld30032 root 62u unix 0xc1bd7c80 4468136 /var/run/mysqld/mysqld.sock mysqld30032 root 82u unix 0xc2484980 4465577 /var/run/mysqld/mysqld.sock mysqld30146 root3u unix 0xc2367cc0 144707 /var/run/mysqld/mysqld.sock mysqld30146 root7u unix 0xc600f660 4464830 /var/run/mysqld/mysqld.sock mysqld30146 root 24u unix 0xc56f2c80 4465358 /var/run/mysqld/mysqld.sock mysqld30146 root 62u unix 0xc1bd7c80 4468136 /var/run/mysqld/mysqld.sock mysqld30146 root 82u unix 0xc2484980 4465577 /var/run/mysqld/mysqld.sock mysqld30193 root3u unix 0xc2367cc0 144707 /var/run/mysqld/mysqld.sock mysqld30193 root7u unix 0xc600f660 4464830 /var/run/mysqld/mysqld.sock mysqld30193 root 24u unix 0xc56f2c80 4465358 /var/run/mysqld/mysqld.sock mysqld30193 root 62u unix 0xc1bd7c80 4468136 /var/run/mysqld/mysqld.sock mysqld30193 root 82u unix 0xc2484980 4465577 /var/run/mysqld/mysqld.sock mysqld30767 root3u unix 0xc2367cc0 144707 /var/run/mysqld/mysqld.sock mysqld30767 root7u unix 0xc600f660 4464830 /var/run/mysqld/mysqld.sock mysqld30767 root 24u unix 0xc56f2c80 4465358 /var/run/mysqld/mysqld.sock mysqld30767 root 62u unix 0xc1bd7c80 4468136 /var/run/mysqld/mysqld.sock mysqld30767 root 82u unix 0xc2484980 4465577 /var/run/mysqld/mysqld.sock Is this some sort of unlinking bug? Naturally, a reboot fixes our problems for a couple of months. As I said in the beginning of the email, I've got a few days/a week before I REALLY need to reboot this machine. So I'd love to get some help on chasing this down, in case it is a bug and we need to get some data from it. Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the
Re: MySQL bug?
Jeremy, What would I do without the internet??? I restarted mysql by hand and the discrepency immediately went away. I should have thought about that. Thanks! Mark On Wed, Sep 11, 2002 at 12:01:29PM -0500, Jeremy Tinley wrote: Are you deleting any logs and not restarting the server after deleting? We had this problem with httpd logs. We'd move them off, but they were still open at the old file system location until a httpd restart. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 on OS X PROBLEM!
hi all, i am running OS X 10.2 and this version of mysql: mysql status -- ./bin/mysql Ver 11.18 Distrib 3.23.51, for apple-darwin6.0 (powerpc) Connection id: 117 Current database: mysql Current user: root@localhost Current pager: stdout Using outfile: '' Server version: 3.23.51-entropy.ch Protocol version: 10 Connection: Localhost via UNIX socket Client characterset:latin1 Server characterset:latin1 UNIX socket:/tmp/mysql.sock Uptime: 4 hours 15 min 17 sec php 4.2.1 also by entropy.ch my problem is the following: let's say i want to add the following user (just as a test): mysql grant all - on * - to test - with grant option; i do that and then i do a mysql use mysql; mysql SELECT * FROM user; the thing is, that all the permissions are still set to 'N'!! it won't accept the grant arguments. i also have phpMyAdmin 2.3.0 installed and if i change the user's permissions in there it accepts them. also the terminal will list them properly. why is this happening? please advise, phil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 bug?
Maybe a simple mysqladmin flush-logs would have done it. Mark Dieterich wrote: Jeremy, What would I do without the internet??? I restarted mysql by hand and the discrepency immediately went away. I should have thought about that. Thanks! Mark On Wed, Sep 11, 2002 at 12:01:29PM -0500, Jeremy Tinley wrote: Are you deleting any logs and not restarting the server after deleting? We had this problem with httpd logs. We'd move them off, but they were still open at the old file system location until a httpd restart. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
MySQL-DBI-perl-bin ... problems
hi list, have got an error in trying to install MySQL-bench-3.23.52-1 rpm says, that the file MySQL-DBI-perl-bin is reqired, but MySQL-DBI-perl-bin-1.1825-1 is installed. and so I could see in rpmfind.org, this file is the last one. would it be possible, that there should be another version of this file installed ? here is an output of a new try to install MySQL-DBI-perl-bin and have discovered the following hint in the messages, rpm produce with the -options : D: the B dependency needs an epoch (assuming same as A) A DBI-perl-bin = 1:0.93-1 B DBI-perl-bin = 0.90 ~~ ~~~ ~~ D: YESA DBI-perl-bin = 1:0.93-1 B DBI-perl-bin = 0.90 D: Requires: DBI-perl-bin = 0.90 YES (db provides) hmm, maybe, this is eventually a possible solution ? the kernel-version, I have is : kernel-2.4.9-31mppe the gcc-version : [root@mozart /root]# gcc -v Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-81) [root@mozart /root]# the full output of just installed Mysql-DBI ... is as follows : Mysql-DBI-perl-bin-1.1825-1 hope that helps for a solution thanks again bye hans - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Which one, InnoDB or BerkeleyDB?
On Wed, 11 Sep 2002, Guilherme Orcutt wrote: Which one would be the best with MySQL thinking in reliability and performance? Thanks a lot for your thoughts! InnoDB scales *MUCH* better than BerkeleyDB. While it did fine in our benchmarks consisting of a small number of records, in some benchmarks we ran here consisting of about a quarter million records, we let BerkeleyDB run 10 times longer than the InnoDB test before killing it and giving up. The live system is dealing with 2M records, and will soon be dealing with 2 to 3 times that many, so BerkeleyDB wasn't an option. This system does quite a bit of inserting/updating, so for a read-mostly table, the difference probably won't be as great, though from what I've seen in some of our systems that use BerkeleyDB directly from C, there is still some degradation from larger tables. The only advantage of BerkeleyDB over InnoDB that I know of is that InnoDB keeps everything in a set of files, whereas BerkeleyDB has a seperate file per table. Some people prefer it this way, as they can back up individual files. Personally, I prefer using mysqldump, which makes this a non-issue for the most part. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
4.0.3 datadir mangle bug
From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: 4.0.3 datadir mangle bug Description: mysqld is mangling the datadir. Fed in /mysql and it produces . ysql How-To-Repeat: Upgrade from 3.23.52 to 4.0.3 Fix: Unknown at this time. Tried to feed parameters to mysqld by hand with same results. Submitter-Id: submitter ID Originator:[EMAIL PROTECTED] Organization: RCS MySQL support: [none] Synopsis: See above Severity: [ critical ] Priority: [ high ] Category: mysql Class: [ sw-bug ] Release: mysql-4.0.3-beta (Source distribution) Environment: Debian 3.0 with all current updates. Kernel 2.4.19 System: Linux ns1 2.4.19 #5 SMP Sat Aug 17 22:38:56 CDT 2002 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 20011002 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Jun 8 03:18 /lib/libc.so.6 - libc-2.2.5.so -rwxr-xr-x1 root root 1153784 Apr 28 19:57 /lib/libc-2.2.5.so -rw-r--r--1 root root 2390922 Apr 28 19:58 /usr/lib/libc.a -rw-r--r--1 root root 178 Apr 28 19:58 /usr/lib/libc.so Configure command: ./configure --prefix=/usr --sysconfdir=/etc --with-mysqld-user=mysql --with-libwrap --with-raid --enable-assembler --with-mysqlfs --with-vio --with-openssl 14129 pts/1S 0:00 /bin/sh /usr/bin/safe_mysqld --datadir=/mysql 14158 pts/1S 0:01 /usr/libexec/mysqld --basedir=/usr --datadir=. ysql --user=mysql --pid-file=/mysql/ns1.pid --skip-locking 14160 pts/1S 0:00 /usr/libexec/mysqld --basedir=/usr --datadir=. ysql --user=mysql --pid-file=/mysql/ns1.pid --skip-locking 14161 pts/1S 0:00 /usr/libexec/mysqld --basedir=/usr --datadir=. ysql --user=mysql --pid-file=/mysql/ns1.pid --skip-locking 14162 pts/1S 0:00 /usr/libexec/mysqld --basedir=/usr --datadir=. ysql --user=mysql --pid-file=/mysql/ns1.pid --skip-locking 14163 pts/1S 0:00 /usr/libexec/mysqld --basedir=/usr --datadir=. ysql --user=mysql --pid-file=/mysql/ns1.pid --skip-locking 14164 pts/1S 0:00 /usr/libexec/mysqld --basedir=/usr --datadir=. ysql --user=mysql --pid-file=/mysql/ns1.pid --skip-locking 14165 pts/1S 0:00 /usr/libexec/mysqld --basedir=/usr --datadir=. ysql --user=mysql --pid-file=/mysql/ns1.pid --skip-locking 14166 pts/1S 0:00 /usr/libexec/mysqld --basedir=/usr --datadir=. ysql --user=mysql --pid-file=/mysql/ns1.pid --skip-locking 14167 pts/1S 0:00 /usr/libexec/mysqld --basedir=/usr --datadir=. ysql --user=mysql --pid-file=/mysql/ns1.pid --skip-locking 14168 pts/1S 0:00 /usr/libexec/mysqld --basedir=/usr --datadir=. ysql --user=mysql --pid-file=/mysql/ns1.pid --skip-locking 14169 pts/1R 0:00 ps ax - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 on OS X PROBLEM!
Have you done a 'mysqladmin reload' to reload the new grant tables into the server process? Any modifications you make to the permissions table won't take until until after a 'reload'. Rene philipp ringli wrote: hi all, i am running OS X 10.2 and this version of mysql: mysql status -- ./bin/mysql Ver 11.18 Distrib 3.23.51, for apple-darwin6.0 (powerpc) Connection id: 117 Current database: mysql Current user: root@localhost Current pager: stdout Using outfile: '' Server version: 3.23.51-entropy.ch Protocol version: 10 Connection: Localhost via UNIX socket Client characterset:latin1 Server characterset:latin1 UNIX socket:/tmp/mysql.sock Uptime: 4 hours 15 min 17 sec php 4.2.1 also by entropy.ch my problem is the following: let's say i want to add the following user (just as a test): mysql grant all - on * - to test - with grant option; i do that and then i do a mysql use mysql; mysql SELECT * FROM user; the thing is, that all the permissions are still set to 'N'!! it won't accept the grant arguments. i also have phpMyAdmin 2.3.0 installed and if i change the user's permissions in there it accepts them. also the terminal will list them properly. why is this happening? please advise, phil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Rene Churchill Specializing in Internet Databases, Vermont Web Wizard LLC Web Programming, Webmaster support, Phone: 802-244-5151 and custom programming. Fax: 802-244-5512 http://www.vtwebwizard.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: 4.0.3 datadir mangle bug
At 13:02 -0500 9/11/02, Mike Gohlke wrote: From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: 4.0.3 datadir mangle bug Description: mysqld is mangling the datadir. Fed in /mysql and it produces . ysql It's only changing the command line parameters viewable with ps. If you issue a SHOW VARIABLES LIKE 'datadir' query, what is the result? How-To-Repeat: Upgrade from 3.23.52 to 4.0.3 Fix: Unknown at this time. Tried to feed parameters to mysqld by hand with same results. Submitter-Id: submitter ID Originator:[EMAIL PROTECTED] Organization: RCS MySQL support: [none] Synopsis: See above Severity: [ critical ] Priority: [ high ] Category: mysql Class: [ sw-bug ] Release: mysql-4.0.3-beta (Source distribution) Environment: Debian 3.0 with all current updates. Kernel 2.4.19 System: Linux ns1 2.4.19 #5 SMP Sat Aug 17 22:38:56 CDT 2002 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 20011002 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Jun 8 03:18 /lib/libc.so.6 - libc-2.2.5.so -rwxr-xr-x1 root root 1153784 Apr 28 19:57 /lib/libc-2.2.5.so -rw-r--r--1 root root 2390922 Apr 28 19:58 /usr/lib/libc.a -rw-r--r--1 root root 178 Apr 28 19:58 /usr/lib/libc.so Configure command: ./configure --prefix=/usr --sysconfdir=/etc --with-mysqld-user=mysql --with-libwrap --with-raid --enable-assembler --with-mysqlfs --with-vio --with-openssl 14129 pts/1S 0:00 /bin/sh /usr/bin/safe_mysqld --datadir=/mysql 14158 pts/1S 0:01 /usr/libexec/mysqld --basedir=/usr --datadir=. ysql --user=mysql --pid-file=/mysql/ns1.pid --skip-locking 14160 pts/1S 0:00 /usr/libexec/mysqld --basedir=/usr --datadir=. ysql --user=mysql --pid-file=/mysql/ns1.pid --skip-locking 14161 pts/1S 0:00 /usr/libexec/mysqld --basedir=/usr --datadir=. ysql --user=mysql --pid-file=/mysql/ns1.pid --skip-locking 14162 pts/1S 0:00 /usr/libexec/mysqld --basedir=/usr --datadir=. ysql --user=mysql --pid-file=/mysql/ns1.pid --skip-locking 14163 pts/1S 0:00 /usr/libexec/mysqld --basedir=/usr --datadir=. ysql --user=mysql --pid-file=/mysql/ns1.pid --skip-locking 14164 pts/1S 0:00 /usr/libexec/mysqld --basedir=/usr --datadir=. ysql --user=mysql --pid-file=/mysql/ns1.pid --skip-locking 14165 pts/1S 0:00 /usr/libexec/mysqld --basedir=/usr --datadir=. ysql --user=mysql --pid-file=/mysql/ns1.pid --skip-locking 14166 pts/1S 0:00 /usr/libexec/mysqld --basedir=/usr --datadir=. ysql --user=mysql --pid-file=/mysql/ns1.pid --skip-locking 14167 pts/1S 0:00 /usr/libexec/mysqld --basedir=/usr --datadir=. ysql --user=mysql --pid-file=/mysql/ns1.pid --skip-locking 14168 pts/1S 0:00 /usr/libexec/mysqld --basedir=/usr --datadir=. ysql --user=mysql --pid-file=/mysql/ns1.pid --skip-locking 14169 pts/1R 0:00 ps ax - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
ld flag cause make error
SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with END-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in ' and '). SEND-PR: From: root To: [EMAIL PROTECTED] Subject: ld flag cause make error Description: After running CC=gcc CFLAGS=-O3 \ CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti \ ./configure --prefix=/usr/local/mysql --with-low-memory --enable-assembler, make chugs along for a while and then gives this: gcc -O3 -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti -fno-implicit-templates -fno-exceptions -fno-rtti -DUSE_MYSYS_NEW -DHAVE_CURSES_H -I/opt/PDmysql/src/mysql-3.23.52/include -DHAVE_RWLOCK_T -o .libs/mysql mysql.o readline.o sql_string.o completion_hash.o ../readline/libreadline.a -lcurses ../libmysql/.libs/libmysqlclient.so -lz -lcrypt -lgen -lsocket -lnsl -lm -Wl,--defsym -Wl,__cxa_pure_virtual=0 -lz -lcrypt -lgen -lsocket -lnsl -lm -R/opt/PDmysql/lib/mysql /usr/ccs/bin/ld: illegal option -- - ld: fatal: option -d has illegal argument efsym' collect2: ld returned 1 exit status make[2]: *** [mysql] Error 1 make[2]: Leaving directory /opt/PDmysql/src/mysql-3.23.52/client' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory /opt/PDmysql/src/mysql-3.23.52' make: *** [all-recursive-am] Error 2 How-To-Repeat: tar -zxvf mysql-3.23.52.tar.gz cd mysql-3.23.52 CC=gcc CFLAGS=-O3 CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti ./configure --prefix=/usr/local/mysql --with-low-memory --enable-assembler Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id: [EMAIL PROTECTED] Originator:Super-User Organization: organization of PR author (multiple lines) MySQL support: [none | licence | email support | extended email support ] Synopsis: ld flag causes make error Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: mysql-3.23.52 (Source distribution) Environment: machine, os, target, libraries (multiple lines) System: SunOS darqshado 5.8 Generic_108528-14 sun4u sparc SUNW,Ultra-5_10 Architecture: sun4 Some paths: /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gcc /usr/ucb/cc GCC: Reading specs from /opt/PDgcc3/lib/gcc-lib/sparc-sun-solaris2.8/3.0.3/specsConfigured with: ./configure --prefix=/opt/PDgcc3 Thread model: posix gcc version 3.0.3 Compilation info: CC='gcc' CFLAGS='-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' LDFLAGS='' LIBC: -rw-r--r-- 1 root bin 1768540 Feb 28 2002 /lib/libc.a lrwxrwxrwx 1 root root11 Sep 242001 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1146284 Feb 28 2002 /lib/libc.so.1 -rw-r--r-- 1 root bin 1768540 Feb 28 2002 /usr/lib/libc.a lrwxrwxrwx 1 root root11 Sep 242001 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 1146284 Feb 28 2002 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/usr/local/mysql --enable-assembler --with-extra-charsets=complex --enable-thread-safe-client --with-innodb --with-berkeley-db --enable-thread-safe-client 'CFLAGS=-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' 'CXXFLAGS=-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' CXX=gcc -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Philip A. Delyani System Administrator hottub.org [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: 4.0.3 datadir mangle bug
Paul DuBois wrote: At 13:02 -0500 9/11/02, Mike Gohlke wrote: From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: 4.0.3 datadir mangle bug Description: mysqld is mangling the datadir. Fed in /mysql and it produces . ysql It's only changing the command line parameters viewable with ps. If you issue a SHOW VARIABLES LIKE 'datadir' query, what is the result? This is getting even more perverse. Trying to connect with the mysql client everything just hangs. However, connecting via php it works fine. Via php it shows the datadir as '/mysql/'. Maybe the mysql client is hosed too? (both are going via localhost (which should be via the socket)). I just tested the php code via localhost/socket and forced IP connect. Both work fine but the cmdline client is hosed for any/all connections to all servers. It's looking like the client is hosed now. How-To-Repeat: Upgrade from 3.23.52 to 4.0.3 Fix: Unknown at this time. Tried to feed parameters to mysqld by hand with same results. Submitter-Id: submitter ID Originator:[EMAIL PROTECTED] Organization: RCS MySQL support: [none] Synopsis: See above Severity: [ critical ] Priority: [ high ] Category: mysql Class: [ sw-bug ] Release: mysql-4.0.3-beta (Source distribution) Environment: Debian 3.0 with all current updates. Kernel 2.4.19 System: Linux ns1 2.4.19 #5 SMP Sat Aug 17 22:38:56 CDT 2002 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 20011002 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Jun 8 03:18 /lib/libc.so.6 - libc-2.2.5.so -rwxr-xr-x1 root root 1153784 Apr 28 19:57 /lib/libc-2.2.5.so -rw-r--r--1 root root 2390922 Apr 28 19:58 /usr/lib/libc.a -rw-r--r--1 root root 178 Apr 28 19:58 /usr/lib/libc.so Configure command: ./configure --prefix=/usr --sysconfdir=/etc --with-mysqld-user=mysql --with-libwrap --with-raid --enable-assembler --with-mysqlfs --with-vio --with-openssl 14129 pts/1S 0:00 /bin/sh /usr/bin/safe_mysqld --datadir=/mysql 14158 pts/1S 0:01 /usr/libexec/mysqld --basedir=/usr --datadir=. ysql --user=mysql --pid-file=/mysql/ns1.pid --skip-locking 14160 pts/1S 0:00 /usr/libexec/mysqld --basedir=/usr --datadir=. ysql --user=mysql --pid-file=/mysql/ns1.pid --skip-locking 14161 pts/1S 0:00 /usr/libexec/mysqld --basedir=/usr --datadir=. ysql --user=mysql --pid-file=/mysql/ns1.pid --skip-locking 14162 pts/1S 0:00 /usr/libexec/mysqld --basedir=/usr --datadir=. ysql --user=mysql --pid-file=/mysql/ns1.pid --skip-locking 14163 pts/1S 0:00 /usr/libexec/mysqld --basedir=/usr --datadir=. ysql --user=mysql --pid-file=/mysql/ns1.pid --skip-locking 14164 pts/1S 0:00 /usr/libexec/mysqld --basedir=/usr --datadir=. ysql --user=mysql --pid-file=/mysql/ns1.pid --skip-locking 14165 pts/1S 0:00 /usr/libexec/mysqld --basedir=/usr --datadir=. ysql --user=mysql --pid-file=/mysql/ns1.pid --skip-locking 14166 pts/1S 0:00 /usr/libexec/mysqld --basedir=/usr --datadir=. ysql --user=mysql --pid-file=/mysql/ns1.pid --skip-locking 14167 pts/1S 0:00 /usr/libexec/mysqld --basedir=/usr --datadir=. ysql --user=mysql --pid-file=/mysql/ns1.pid --skip-locking 14168 pts/1S 0:00 /usr/libexec/mysqld --basedir=/usr --datadir=. ysql --user=mysql --pid-file=/mysql/ns1.pid --skip-locking 14169 pts/1R 0:00 ps ax - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
error updating table
Hi, we have an application that connect to MySQL via MyODBC. Sometimes, we have this error: [TCX][MyODBC] Got error 5 from table handler and MySQL drops. When it comes back up, it first gives an error with BDB tables (the type we use): 020911 15:10:17 bdb: page 0: illegal page type or format 020911 15:10:17 bdb: PANIC: Invalid argument then I have to start over. Versions are: MySQL-Max-NT-2.23.52 MyODBC-2.50.39 TIA, Ricardo. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
installation woes (4.0.3)
A problem on installation of 4.0.3. First, I tried with rpm -U and when I try to uninstall it says not installed when I try to install or upgrade it says already installed I looked at the rpm package files and try to erase them manually and they are not there So I tried the tarball ... linux:/usr/local/mysql # scripts/mysql_install_db Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables 020911 19:21:57 ./bin/mysqld: Shutdown Complete To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: ./bin/mysqladmin -u root password 'new-password' ./bin/mysqladmin -u root -h linux password 'new-password' See the manual for more instructions. You can start the MySQL daemon with: cd . ; ./bin/mysqld_safe You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; perl run-all-tests Please report any problems with the ./bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com linux:/usr/local/mysql # Looking at .data does not show any messages === linux:/usr/local/mysql # ls .INSTALL-BINARY include manual_toc.html support-files .. README lib mysql-test tests COPYING bin man scripts COPYING.LIB configure manual.html share ChangeLogdatamanual.txt sql-bench linux:/usr/local/mysql # cd data linux:/usr/local/mysql/data # ls . .. mysql test linux:/usr/local/mysql/data # = Besides, the thread concurrency variable is correct as I have 2 processors: (here is /etc/my.cnf) [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_size=500M set-variable = key_buffer=100M set-variable = max_allowed_packet=1M set-variable = table_cache=512 set-variable= max_connections=10 set-variable= tmp_table_size=400M set-variable = sort_buffer=2M set-variable = record_buffer=2M set-variable = thread_cache=8 set-variable = thread_concurrency=4 # Try number of CPU's*2 #set-variable = myisam_sort_buffer_size=64M set-variable = myisam_sort_buffer_size=4M innodb_data_home_dir= innodb_data_file_path=ibdata1:2000M;ibdata2:2000M;ibdata3:2000M;ibdata4:2000M;ibdata5:2000M;ibdata6:2000M;ibdata7:2000M;ibdata8:2000M ;/usr/ibdata/ibdata9:2000M;/usr/ibdata/ibdata10:2000M;/usr/ibdata/ibdata11:2000M;/usr/ibdata/ibdata12:2000M;/ibdata/ibdata13:2000M;/ibdata/ibdata14:2000M;/ibdata/ibdata15:2000M;/var/lib/mysql/ibdata16:2000M;/var/lib/mysql/ibdata17:2000M;/var/lib/mysql/ibdata18:2000M;/var/lib/mysql/ibdata19:2000M;/var/lib/mysql/ibdata20:2000M;/var/lib/mysql/ibdata21:2000M #;/usr/ibdata/ibdata9:2000M;/usr/ibdata/ibdata10:2000M ## Comment next line if you do not need recovery(the hostname-bin.xxx files) #log-bin ## server-id = 1 #set-variable= open-files-limit=8192 #ulimit is 1024,hard 8192 set-variable = innodb_buffer_pool_size=1100M # so that innodb_buffer_pool size+key_buffer+max_connections* (sort_buffer+record_buffer+2M)=1100+100+10*(2+2+2) =12602000M=RAM set-variable = innodb_additional_mem_pool_size=700M set-variable = innodb_log_file_size=1000M set-variable = innodb_log_buffer_size=20M # helps for large transactions # 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 --- THis might have been a permission issue, so I went to /usr/local/mysql/bin and changed all my* file ownerships to root root Then I ran the mysql_install_db script again and got no complaints, but still I cannot start the server. I must be doing something wrong, but can I get any hints? linux:/usr/local/mysql # scripts/mysql_install_db Installing all prepared tables 020911 19:46:49 ./bin/mysqld: Shutdown Complete To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: ./bin/mysqladmin -u root password 'new-password' ./bin/mysqladmin -u root -h linux password 'new-password' See the manual for more instructions. NOTE: If you are upgrading from a MySQL = 3.22.10 you should run the ./bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! You can start the MySQL daemon with: cd . ;
Re: Which one, InnoDB or BerkeleyDB?
I have done some small tests here and indeed InnoDB seems to be faster than BerkeleyDB. Thanks guys for your help! ;) ==MySQL List - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Rapid-fire connections causing MySQL grief
On Wed, Sep 11, 2002 at 02:55:01PM -0400, Kent Hoover wrote: Version: MySQL.3.22.32-log Does this problem ring a bell with anyone? I'm seeing two undesired behaviors, both, *I think* seem to be because I'm pounding a lot of connections against the same server/table, all from the same remote host. The workload that reaches MySQL is a succession of CONNECT-QUERY (very simple)- QUIT, say 200 times per second. After about the first 4000 connections, MySQL restarts, complaining that mysqld is hanging. Which OS are you running? Also, that's a pretty old MySQL. Have you considered upgrading? Many bugs have been fixed since then. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 36 days, processed 736,307,896 queries (233/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: Re: Rapid-fire connections causing MySQL grief
On Wed, 11 Sep 2002, Jeremy Zawodny ([EMAIL PROTECTED]) wrote:
On Wed, Sep 11, 2002 at 02:55:01PM -0400, Kent Hoover wrote:
Version: MySQL.3.22.32-log
Does this problem ring a bell with anyone?
I'm seeing two undesired behaviors, both, *I think*
seem to be because I'm pounding a lot of connections
against the same server/table, all from the same
remote host. The workload that reaches MySQL is
a succession of CONNECT-QUERY (very simple)- QUIT,
say 200 times per second. After about the first 4000
connections, MySQL restarts, complaining that
mysqld is hanging.
Which OS are you running?
Also, that's a pretty old MySQL. Have you considered upgrading? Many
bugs have been fixed since then.
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
Jeremy:
We're running Red Hat Linux 6.2.
Oh, yes, we've considered upgrading. Kind of hesitant to take
that step so far.
I've read through the Fixed in version { } sections of the
manual, didn't recognize what I have here, and was hoping that
someone out here would say Yes, I remember that, and it was
fixed!
Thanks,
Kent Hoover
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Rapid-fire connections causing MySQL grief
Version: MySQL.3.22.32-log Does this problem ring a bell with anyone? I'm seeing two undesired behaviors, both, *I think* seem to be because I'm pounding a lot of connections against the same server/table, all from the same remote host. The workload that reaches MySQL is a succession of CONNECT-QUERY (very simple)- QUIT, say 200 times per second. After about the first 4000 connections, MySQL restarts, complaining that mysqld is hanging. Secondly, prior to the restart, an occasional connection is denied because of an invalid password! All connections are requested by the same user with the same password. Please, someone, tell me that these 2 problems are both load related, were found and corrected by a later release than the one I have. Thanks, Kent Hoover - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
PD: The win admin for Mysql
Hi I'm looking for some software (under windows) that will connect to a sql - mysql base and make some drop of structure and data of a database Do you know any small free program like this ? TeQ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: PD: The win admin for Mysql
I've used dbtools http://www.dbtools.com.br/ However I'm using 1.0.12 rather than 1.0.15 since the newer version appears to have a few bugs. there is of cours mysqlgui from mysql (see their site). On Wed, 11 Sep 2002, =?iso-8859-2?Q?J=EAdrzej_Kolesi=F1ski?= wrote: Date: Wed, 11 Sep 2002 21:44:23 +0200 From: =?iso-8859-2?Q?J=EAdrzej_Kolesi=F1ski?= [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: PD: The win admin for Mysql Hi I'm looking for some software (under windows) that will connect to a sql - mysql base and make some drop of structure and data of a database Do you know any small free program like this ? TeQ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Lost connection upon connect from w2k client to rh7.3 server
hi all, I have a strange behaviour of a mysql 3.23.51 installation on a rh7.3 box in connection with connects from windows 2000 clients (no idea, if the windows version matters). Everytime I try to connect to the server (odbc, mysqlc-commandline-tool) I receive ERROR 2013: Lost connection After the connect the mysqld immediately dies WITHOUT giving any useful information in the log but gets restarted on the fly. The connect works perfectly though, if I try to connect either locally or from any other Linux box around (mandrake, suse, ...). ... any ideas appreciated ... Thanks Udo Rader - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Q: How to determine size(s) of db files? - Resolved
Eric Lamendola wrote: If you are using PHP, Then download phpMyAdmin from the website of the same name. It is the best PHP/Web based utility for connecting to a MySQL database. At 12:48 PM 9/11/02 -0400, Amer Neely wrote: Is there a MySQL command that will return the amount of disk space used by a particular database? I find lots of references to size limits on tables / databases etc. but nothing on the actual 'disk usage'. This would be nice to have I think, since without access to the data directory on the server, I have to ask my ISP to do a 'du' for me. I maintain several databases for clients with my ISP, and since I'm paying for disk space, I'd like to be able to pass that cost on to my clients. -- /* All outgoing email scanned by Norton Antivirus 2002 */ Amer Neely, Softouch Information Services W: www.softouch.on.ca E: [EMAIL PROTECTED] V: 519.438.5887 Perl | PHP | MySQL | CGI programming for all data entry forms. We make web sites work! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Eric, thanks for the tip. I grabbed it and configured it in about 2 minutes and can now access all my little friends. Oh, yes, and the file sizes are listed too :) -- /* All outgoing email scanned by Norton Antivirus 2002 */ Amer Neely, Softouch Information Services W: www.softouch.on.ca E: [EMAIL PROTECTED] V: 519.438.5887 Perl | PHP | MySQL | CGI programming for all data entry forms. We make web sites work! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Rapid-fire connections causing MySQL grief
At 01:55 PM 9/11/2002, you wrote: Version: MySQL.3.22.32-log Does this problem ring a bell with anyone? I'm seeing two undesired behaviors, both, *I think* seem to be because I'm pounding a lot of connections against the same server/table, all from the same remote host. The workload that reaches MySQL is a succession of CONNECT-QUERY (very simple)- QUIT, say 200 times per second. After about the first 4000 connections, MySQL restarts, complaining that mysqld is hanging. Secondly, prior to the restart, an occasional connection is denied because of an invalid password! All connections are requested by the same user with the same password. Please, someone, tell me that these 2 problems are both load related, were found and corrected by a later release than the one I have. Thanks, Kent Hoover Kent, Just a thought, but if your table is read-only and not extremely large, have you thought of changing it to a heap table? When the server starts up, create the heap table and import the MYISAM table into it. Use something like Create table h_mytable select * from mytable type=heap. Then build the indexes for it. Heap tables may solve the problem even for tables with a few thousand rows. Latency because of disk access is also reduced. If you do need to write to it, add a TimeStamp column and every 30 seconds write the modified rows back to the original table. Mike (sql 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mediumint(6) problem
Hi all, I have a small problem - I have the following table with numetic type. In my table is mediumint(6), but I can to insert value 11223344. I thougth the maximum value for mediumint(6) is 99. Do you have some idea what I should to do to be able insert value 99 as a maximum for my field? My table: CREATE TABLE `table` ( `id_a` mediumint(6) unsigned NOT NULL default '0', `id_b` mediumint(6) unsigned NOT NULL default '0', `id_c` mediumint(6) unsigned NOT NULL default '0', `area` char(2) NOT NULL default '', `group` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`id_a`,`id_a`,`id_b`) ) TYPE=MyISAM Background: MySQL version 3.23.49 on Red Hat Linux 7.3. Thank tou very much for your help. Regards, Jan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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/InnoDB crashes after a Select...order by DESC... LIMIT...
Rafa, - Original Message - From: [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, September 10, 2002 1:46 PM Subject: MySql/InnoDB crashes after a Select...order by DESC... LIMIT... Hello, I am working with mysqld-max-nt under windows 2000 and unsing InnoDb tables. After running the following select: Select cod,nom from grupos where cod '005' order by cod desc limit 1 mysqld crashes. Also it crashes whith limit 10, limit 50, or whatever limit you indicate. However, the following selects run ok: Select cod,nom from grupos where cod '005' order by cod desc (without limit) Select * from grupos where cod ’D01’ order by cod desc limit 1 Select * from grupos where strcmp(cod,’005')0 order by cod desc limit 1 Select * from grupos where cod 005 order by cod desc limit 1 Select * from grupos where cod 5 order by cod desc limit 1 This error only occurs with InnoDb tables and MySql 4.0.3 (with Mysql 3.23.52 it runs ok). With MyIsam tables it runs ok even under mysql 4.0.3 I enclose the file grupos.sql with the table definition and data. thank you for a very detailed bug report. The bug, assertion failure in btr0pcur.ic, happened because InnoDB did not store the cursor position in this case. The cursor needs to move downward in the alphabetical order. I have now pushed the fix to the 4.0 source tree. Thanks in advance, Rafa. P.D: Sorry for my english. Best regards, Heikki Innobase Oy sql 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: mediumint(6) problem
At 23:05 +0200 9/11/02, Jan Kudrman wrote: Hi all, I have a small problem - I have the following table with numetic type. In my table is mediumint(6), but I can to insert value 11223344. I thougth the maximum value for mediumint(6) is 99. Why? Do you have some idea what I should to do to be able insert value 99 as a maximum for my field? My table: CREATE TABLE `table` ( `id_a` mediumint(6) unsigned NOT NULL default '0', `id_b` mediumint(6) unsigned NOT NULL default '0', `id_c` mediumint(6) unsigned NOT NULL default '0', `area` char(2) NOT NULL default '', `group` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`id_a`,`id_a`,`id_b`) ) TYPE=MyISAM Background: MySQL version 3.23.49 on Red Hat Linux 7.3. Thank tou very much for your help. Regards, Jan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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-Front Discontinued
I went to http://www.anse.de/mysqlfront/ today ... the notice posted on the site says MySQL-Front - This project has been discontinued. Too bad ... Ansgar Becker developed a truly useful, powerful MySQL database management tool for us Windoze users. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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-Front Discontinued
I second that opinion. -Original Message- From: Gerald Jensen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 3:02 PM To: [EMAIL PROTECTED] Subject: MySQL-Front Discontinued I went to http://www.anse.de/mysqlfront/ today ... the notice posted on the site says MySQL-Front - This project has been discontinued. Too bad ... Ansgar Becker developed a truly useful, powerful MySQL database management tool for us Windoze users. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mediumint(6) problem
Mediumint refers to the fact that it is three bytes long rather than a regular 4 byte, 32 bit integer. It's range is like +/- 8,000,000 or so (look it up for sure) The 6 just has to do with how many digits will be displayed when you invoke the MySQL client for the row - spacing will be a minimum of 6 characters wide. From the website: http://www.mysql.com/doc/en/Numeric_types.html As an extension to the ANSI/ISO SQL92 standard, MySQL also supports the integer types TINYINT, MEDIUMINT, and BIGINT as listed in the tables above. Another extension is supported by MySQL for optionally specifying the display width of an integer value in parentheses following the base keyword for the type (for example, INT(4)). This optional width specification is used to left-pad the display of values whose width is less than the width specified for the column, but does not constrain the range of values that can be stored in the column, nor the number of digits that will be displayed for values whose width exceeds that specified for the column. When used in conjunction with the optional extension attribute ZEROFILL, the default padding of spaces is replaced with zeroes. For example, for a column declared as INT(5) ZEROFILL, a value of 4 is retrieved as 4. Note that if you store larger values than the display width in an integer column, you may experience problems when MySQL generates temporary tables for some complicated joins, as in these cases MySQL trusts that the data did fit into the original column width. So, MEDIUMINT(6) can contain +/-8,000,000 (more or less) and will display as 6 characters wide. Don't feel bad, I had the same confusion on char and varchar fields and what they can store/display. Have Fun, Ken Hylton Programmer Analyst IV LEC Systems Programming Billing Concepts, Inc. 7411 John Smith Drive San Antonio, Texas 78229-4898 (210) 949-7261 -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 4:53 PM To: Jan Kudrman; [EMAIL PROTECTED] Subject: Re: mediumint(6) problem At 23:05 +0200 9/11/02, Jan Kudrman wrote: Hi all, I have a small problem - I have the following table with numetic type. In my table is mediumint(6), but I can to insert value 11223344. I thougth the maximum value for mediumint(6) is 99. Why? Do you have some idea what I should to do to be able insert value 99 as a maximum for my field? My table: CREATE TABLE `table` ( `id_a` mediumint(6) unsigned NOT NULL default '0', `id_b` mediumint(6) unsigned NOT NULL default '0', `id_c` mediumint(6) unsigned NOT NULL default '0', `area` char(2) NOT NULL default '', `group` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`id_a`,`id_a`,`id_b`) ) TYPE=MyISAM Background: MySQL version 3.23.49 on Red Hat Linux 7.3. Thank tou very much for your help. Regards, Jan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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-Front Discontinued
Hi. Too bad ... Ansgar Becker developed a truly useful, powerful MySQL database management tool for us Windoze users. The support forum is still active: http://mysqlfront.venturemedia.de/ According to the moderator, Ansgar is neither going to make it commercial nor willing to make it open source. I wonder why. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Should I downgrade my client libraries?
Hi all! I want to try out the demo version of Rekall ( http://www.thekompany.com/products/rekall/ ) but it is linked against libmysqlclient.so.10. I have libmysqlclient.so.11 from MySQL-4.0.2, and for some reason I don't even have any libmysqlclient.so.x from MySQL-4.0.3, but anyway I need the client libraries from MySQL-4.0.1 (I assume). What effect would compiling these (from 4.0.1) with '--without-server' and installing them over my current ones (4.0.3) have? Is there another option for getting Rekall working with the old client libraries while still using my current ones for everything else? Thanks in advance! Dan -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.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: Schema changes affect regular select?
Yuri, ADD COLUMN should not affect a SELECT concurrently running on the table. I tested this with a 3 million row InnoDB table. Can you repeat that unexpected behavior? Regards, Heikki Innobase Oy Copied message: ... Subject: Schema changes affect regular select? From: Yuri Date: Tue, 10 Sep 2002 15:54:45 -0400 (EDT) Do schema operations affect regular statements? I've run alter table add column ... on the large table and it coinsided with select fld from same_table limit 0,1. And this select returned as if no records were available though there were plenty. Is this normal? Should schema changes run independantly if they _really_ don't affect regular statements (if fields not involved in select modified) ? I think schema changes should follow transactional paradigm. But that's tough to do, I understand. At least they have to wait on each other. Yuri. sql,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: MySQL-Front Discontinued
I share in that, Ansgar developed a very commercially sound product that he shared with the community. Thank-you Ansgar, [EMAIL PROTECTED] Patrick Sherrill And avid MySQLFront fan and user. CocoNet Corporation - Original Message - From: Manuel Villasante [EMAIL PROTECTED] To: 'Gerald Jensen' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, September 11, 2002 6:04 PM Subject: RE: MySQL-Front Discontinued I second that opinion. -Original Message- From: Gerald Jensen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 3:02 PM To: [EMAIL PROTECTED] Subject: MySQL-Front Discontinued I went to http://www.anse.de/mysqlfront/ today ... the notice posted on the site says MySQL-Front - This project has been discontinued. Too bad ... Ansgar Becker developed a truly useful, powerful MySQL database management tool for us Windoze users. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: MySQL-Front Discontinued
Maybe the code is horrendous. -mike -Original Message- From: Gabriele Carioli [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 3:22 PM To: MySQL Subject: Re: MySQL-Front Discontinued Hi. Too bad ... Ansgar Becker developed a truly useful, powerful MySQL database management tool for us Windoze users. The support forum is still active: http://mysqlfront.venturemedia.de/ According to the moderator, Ansgar is neither going to make it commercial nor willing to make it open source. I wonder why. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Notice: This e-mail and any attachments are intended only for the individual or company to which it is addressed and may contain information which is privileged, confidential and prohibited from disclosure or unauthorized use under applicable law. If you are not the intended recipient of this e-mail, you are hereby notified that any use, dissemination, or copying of this e-mail or the information contained in this e-mail is strictly prohibited by the sender. If you have received this transmission in error, please return the material received to the sender and delete all copies from your system. Thank you. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 on OS X PROBLEM!
hi rene, thanks for your reply. yes, i do it being root: mysql -u root -p and in phpMyAdmin i see that the grant option for root is enabled. and i am loged into phpMyAdmin as root also. i really wonder what's going on... i mean, am i missing the point in some way or another? cheers, phil Hmm, nothing springs out off the top of my head. You're logged into MySQL as a user that has the GRANT priv. before you issue the grant command, right? If MySQL silently ignores unpriv'd grant requests, that might cause the error you're seeing. Rene - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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.ini in RH Linux 7,2
In win98 mysql keep configuration in my.ini. Which is the same file in RH Linux 7.2? Thanx Do You Yahoo!? @yahoo.grhttp://www.otenet.gr - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: PD: The win admin for Mysql
Have a look at urSQL - http://www.urbanresearch.com/ursql On Wed, 11 Sep 2002, [iso-8859-2] Jêdrzej Kolesiñski wrote: Hi I'm looking for some software (under windows) that will connect to a sql - mysql base and make some drop of structure and data of a database Do you know any small free program like this ? TeQ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 in RH Linux 7,2
At 23:51 +0100 9/11/02, nick gatsis wrote: In win98 mysql keep configuration in my.ini. Which is the same file in RH Linux 7.2? /etc/my.cnf, or the my.cnf file in the server's data directory. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Data Type Advice
Hello mysql users: Would appreciate some advice on data types for a column. The value for the field would be a number that would never exceed 1000 but would have two decimal points limited to .25 increments e.g 5.25 or 7.75 There may be some simple calculations such as totals etc. What would be the appropriate data type, float(single precision), double, decimal etc. Of course accuracy in the calculations is important, but I assume double data type is overkill. Thanks -=Bryan=- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySql/InnoDB crashes after a Select...order by DESC... LIMIT...
Heikki, does this bug affect all versions or just the -max windows versions... we just installed 4.0.3-beta (unix-freebsd) to do some benchmarking/testing tonite on innodb and this would impact us. Thx. Rafa, - Original Message - From: [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, September 10, 2002 1:46 PM Subject: MySql/InnoDB crashes after a Select...order by DESC... LIMIT... Hello, I am working with mysqld-max-nt under windows 2000 and unsing InnoDb tables. After running the following select: Select cod,nom from grupos where cod '005' order by cod desc limit 1 mysqld crashes. Also it crashes whith limit 10, limit 50, or whatever limit you indicate. However, the following selects run ok: Select cod,nom from grupos where cod '005' order by cod desc (without limit) Select * from grupos where cod ’D01’ order by cod desc limit 1 Select * from grupos where strcmp(cod,’005')0 order by cod desc limit 1 Select * from grupos where cod 005 order by cod desc limit 1 Select * from grupos where cod 5 order by cod desc limit 1 This error only occurs with InnoDb tables and MySql 4.0.3 (with Mysql 3.23.52 it runs ok). With MyIsam tables it runs ok even under mysql 4.0.3 I enclose the file grupos.sql with the table definition and data. thank you for a very detailed bug report. The bug, assertion failure in btr0pcur.ic, happened because InnoDB did not store the cursor position in this case. The cursor needs to move downward in the alphabetical order. I have now pushed the fix to the 4.0 source tree. Thanks in advance, Rafa. P.D: Sorry for my english. Best regards, Heikki Innobase Oy sql 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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/InnoDB crashes after a Select...order by DESC... LIMIT...
Hi, AFAIK, all versions are affected since I reproduced the bug with 4.0.4-beta under linux. Regards, Jocelyn - Original Message - From: PR [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 12, 2002 1:53 AM Subject: Re: MySql/InnoDB crashes after a Select...order by DESC... LIMIT... Heikki, does this bug affect all versions or just the -max windows versions... we just installed 4.0.3-beta (unix-freebsd) to do some benchmarking/testing tonite on innodb and this would impact us. Thx. Rafa, - Original Message - From: [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, September 10, 2002 1:46 PM Subject: MySql/InnoDB crashes after a Select...order by DESC... LIMIT... Hello, I am working with mysqld-max-nt under windows 2000 and unsing InnoDb tables. After running the following select: Select cod,nom from grupos where cod '005' order by cod desc limit 1 mysqld crashes. Also it crashes whith limit 10, limit 50, or whatever limit you indicate. However, the following selects run ok: Select cod,nom from grupos where cod '005' order by cod desc (without limit) Select * from grupos where cod â?TD01â?T order by cod desc limit 1 Select * from grupos where strcmp(cod,â?T005')0 order by cod desc limit 1 Select * from grupos where cod 005 order by cod desc limit 1 Select * from grupos where cod 5 order by cod desc limit 1 This error only occurs with InnoDb tables and MySql 4.0.3 (with Mysql 3.23.52 it runs ok). With MyIsam tables it runs ok even under mysql 4.0.3 I enclose the file grupos.sql with the table definition and data. thank you for a very detailed bug report. The bug, assertion failure in btr0pcur.ic, happened because InnoDB did not store the cursor position in this case. The cursor needs to move downward in the alphabetical order. I have now pushed the fix to the 4.0 source tree. Thanks in advance, Rafa. P.D: Sorry for my english. Best regards, Heikki Innobase Oy sql 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 shutting down Mysql for upgrade
I'm running this on a RAQ. Here is the problem. Something very strange has happened to my older version of mysql (3.23.37). Not only can I not get it to shut down with /usr/share/mysql/mysql.server stop but even if I do a ps -ef | grep mysql and do a kill -9 on the pid, if I try to restart it, it tells me that a task is using that socket. On a linux based machine, how can I remove the task so that when I reboot it will not start? I have more questions regarding upgrading but first things are first. Thanks, Steve - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 shutting down Mysql for upgrade
Stephen Sokalski wrote: I'm running this on a RAQ. Here is the problem. Something very strange has happened to my older version of mysql (3.23.37). Not only can I not get it to shut down with /usr/share/mysql/mysql.server stop but even if I do a ps -ef | grep mysql and do a kill -9 on the pid, if I try to restart it, it tells me that a task is using that socket. On a linux based machine, how can I remove the task so that when I reboot it will not start? I have more questions regarding upgrading but first things are first. Thanks, Steve - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Setting up a web server wit Redhat 7.3
So far as I can tell the mysql files included in the CD set are: mysql-3.23.49-3.i386.rpm mysqlclient9-3.23.22-6.i386.rpm mysql-devil-3.23.49-3.i386.rpm mysql-server-3.23.49-3.i386.rpm Do these files include Innodb support? Are they sufficient to install mysql? I would be grateful for any advice and information. Regards Peter Goggin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Strange Problem: Need help shutting down Mysql for upgrade
Stephen Sokalski wrote: Stephen Sokalski wrote: I'm running this on a RAQ. Here is the problem. Something very strange has happened to my older version of mysql (3.23.37). Not only can I not get it to shut down with /usr/share/mysql/mysql.server stop but even if I do a ps -ef | grep mysql and do a kill -9 on the pid, if I try to restart it, it tells me that a task is using that socket. On a linux based machine, how can I remove the task so that when I reboot it will not start? I have more questions regarding upgrading but first things are first. Thanks, Steve - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Should I downgrade my client libraries?
Dan, I've got 4.0.3, and I compiled it from the source rpm. Seems that (at least with 4.0.3) mysql is statically linked, hence the lack of libmysqlclient. What you might want to do is make a soft line from libmysqlclient.so.11 to libmysqlclient.so.10 and see if that works. Ed Quoting Daniel Kasak [EMAIL PROTECTED]: Hi all! I want to try out the demo version of Rekall ( http://www.thekompany.com/products/rekall/ ) but it is linked against libmysqlclient.so.10. I have libmysqlclient.so.11 from MySQL-4.0.2, and for some reason I don't even have any libmysqlclient.so.x from MySQL-4.0.3, but anyway I need the client libraries from MySQL-4.0.1 (I assume). What effect would compiling these (from 4.0.1) with '--without-server' and installing them over my current ones (4.0.3) have? Is there another option for getting Rekall working with the old client libraries while still using my current ones for everything else? Thanks in advance! Dan -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.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 - This mail sent through IMP: http://horde.org/imp/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 in RH Linux 7,2
In the last episode (Sep 11), Paul DuBois said: At 23:51 +0100 9/11/02, nick gatsis wrote: In win98 mysql keep configuration in my.ini. Which is the same file in RH Linux 7.2? /etc/my.cnf, or the my.cnf file in the server's data directory. A quick way to find out is to run mysqld --help | grep cnf, which will print a line showing the places my.cnf is read. -- 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
3G³¬´óÈÝÁ¿Êý¾Ý¿â¿Õ¼ä£¬ÔùËÍ2Gµç×ÓÓʾ֣¡
×𾴵Ŀͻ§£º ÄúºÃ£¡Ê±´´ÍøÂçÇ¿Á¦ÍƳöASP.NET¸ß¼¶ÐéÄâÖ÷»ú£¬ÊÊÓÃÓÚ´óÐ͵ÄÆóÒµ¡¢´óÐÍ µç×ÓÉÌÎñÍøÕ¾¡¢´óÐ͸öÈËÍøÕ¾£¨´øÂÛ̳ ÉçÇøµÈ£©¡£ ÒÔÏÂΪÐéÄâרÓÃÐÍCµÄÏêϸÅäÖÃ×ÊÁÏ£º ½Å±¾Ö§³Ö£ºASP ASP.NET CGI Active Perl Front Page 2000 À©Õ¹ Êý¾Ý¿âÖ§³Ö£ºACCESS SQLSERVER 2000£¨MS SQL£©Êý¾Ý¿â ¿Õ¼äÈÝÁ¿£ºÍøÕ¾¿Õ¼ä3G£¬Êý¾Ý¿â¿Õ¼ä²»ÏÞ£¬¿É´ï3G ÆóÒµÓÊÏ䣺2GÈÝÁ¿£¬ÒÔ×Ô¼ºµÄÓòÃûΪºó׺£¬Ö§³ÖPOP WEBMAIL µÈ·½Ê½£¬½çÃæÃÀ¹Û£¬ ÓÐÊ®´ó¹¦ÄÜ£¡ ϵͳÅäÖ㺶ÀÁ¢´ø¿í£¬WINDOWS2000²Ù×÷ϵͳ ¼Û¸ñ£º4000Ôª/Äê »¹ÌṩÉÌÎñCÐ͵ÄÏêϸÅäÖÃ×ÊÁÏ£º ½Å±¾Ö§³Ö£ºASP ASP.NET CGI Active Perl Front Page 2000 À©Õ¹ Êý¾Ý¿âÖ§³Ö£ºACCESS SQLSERVER 2000£¨MS SQL£©Êý¾Ý¿â ¿Õ¼äÈÝÁ¿£ºÍøÕ¾¿Õ¼ä300M£¬Êý¾Ý¿â¿Õ¼ä50M ÆóÒµÓÊÏ䣺800mÈÝÁ¿£¬ÒÔ×Ô¼ºµÄÓòÃûΪºó׺£¬Ö§³ÖPOP WEBMAIL µÈ·½Ê½£¬½çÃæÃÀ¹Û£¬ ÓÐÊ®´ó¹¦ÄÜ£¡ ϵͳÅäÖãºWINDOWS2000²Ù×÷ϵͳ ¼Û¸ñ£º1600Ôª/Äê ×îÈ«ÃæµÄ½Å±¾Ö§³Ö£¬ÄÏ·½µçÐÅ×î¿íµÄ¹ú¼Ò»ú·¿£¬×îºÃµÄÐԼ۱ȣ¡ÔÚ10ÔÂ7ÈÕÇ°¹ºÂò ÒÔÉϿռ䣬»¹¿ÉÒÔÏíÊÜÎÒÃÇΪÄú×¼±¸µÄ´óÀñ°ü£¡ ÐéÄâרÓÃÐÍCËÍÒ»¸ö¶¯Ì¬¹ú¼ÊÓòÃû£¨¼ÛÖµ580Ôª£© ÉÌÎñCÐÍËÍÒ»¸ö¹ú¼ÊÓòÃû£¨¼ÛÖµ100Ôª£©+Ò»¸ö¶¯Ì¬×ÓÓòÃû£¨¼ÛÖµ150Ôª£© ×¢£º¶¯Ì¬ÓòÃû¿ÉÒÔʹ±ä»¯µÄIP±äΪ¹Ì¶¨µÄIP£¬Ê¹Óùú¼ÊÓòÃû¿ÉËæʱ·ÃÎÊÈκÎһ̨µçÄÔ£¬ ¼ÒÀïµÄµçÄÔÄÜÏóÍйÜÔÚµçÐÅÒ»Ñù£¡ ´Ë´ÎÓŻݻµ½10ÔÂ7ÈÕ½ØÖ¹£¬Ç븶¿îʱעÃ÷¡°asp.net¿Õ¼äÌײ͡±×ÖÑù£¬ ÒÔ±ãÎÒÃǾ¡¿ì´¦Àí£¡ »¶Ó·ÃÎÊ http://www.001isp.com E-mail:[EMAIL PROTECTED] Tel:0756-2125563 2125583 Fax:0756-2229669 Ä㻹¿ÉÒÔ½øÐÐQQ×Éѯ:108786611 77248929 108786612 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Good MySQL Webhosting Company
Hello All, Can any one suggest a good company to host a MySQL+PHP website ? 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: Good MySQL Webhosting Company
This get asked every couple of days. Check the archives. FWIW, I host with Experhost.com Justin on 12/09/02 3:34 PM, [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote: Hello All, Can any one suggest a good company to host a MySQL+PHP website ? 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
