Re: innodb: storage requirements
Roman, - Original Message - From: Roman Neuhauser [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 11:46 PM Subject: Re: innodb: storage requirements # [EMAIL PROTECTED] / 2003-09-24 17:41:29 +0300: the row count in SHOW TABLE STATUS is only an estimate based on 8 dives into the index tree. ok. You had a typical symptom of a fragmented table: space usage much bigger than you would expect. that doesn't answer my questions :) notice the numbers: mysql SHOW TABLE STATUS LIKE 'editor_competence_product'\G *** 1. row *** Name: editor_competence_product Type: InnoDB Row_format: Fixed Rows: 225198 ^^ here, InnoDB thinks the table has 225198 rows. mysql ALTER TABLE editor_competence_product TYPE=InnoDB; Query OK, 187654 rows affected (47.34 sec) Records: 187654 Duplicates: 0 Warnings: 0 here, 187654 rows is reported. mysql SHOW TABLE STATUS LIKE 'editor_competence_product'\G *** 1. row *** Name: editor_competence_product Type: InnoDB Row_format: Fixed Rows: 187265 ^^ yet another number. what I don't understand is why the second and third number differ. ALTER TABLE reports an exact count. After the reorganization, also SHOW TABLE ... happens to report almost the right number. This is expected, because the reorganization packs pages full of records. If you insert rows ( 1000 bytes) sequentially in the order of the primary key, then actually SHOW TABLE STATUS is a good measure of fragmentation. If its estimate differs a lot from the real row count, that is a symptom of a f ragmented table. but this question is more important, and I'd really *love* to know an answer: Also, is there a way to *measure* the fragmentation of a table? If there is, how should the info be interpreted? Sorry, no. But adding such a feature would be easy: just look at page numbers, page fillfactors, and the total size of the 'segment' storing the B-tree leaf pages. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for MySQL Order MySQL technical support from https://order.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem compiling a small C program on Redhat-7.3
Does anybody have any idea why this program won't compile, it seems to be straightforward, but it I can't get it to compile on Redhat-7.3. It starts screaming about mysql.h immediately, I use this link to compile with, on my machine at the house, it compiles just fine and runs just fine, but I can't get it to compile on any of my other 7.3 machines, does anybody, know what I could be missing, I'm using up to Redhat rpms of mysql, and I have the devel rpm, so I have all the libraries and include files. but ??? RPMS on the machines mysql-devel-3.23.56-1.73 mysql-3.23.56-1.73 mysql-server-3.23.56-1.73 gcc -c -I/usr/include/mysql mysql1.c In file included from mysql1.c:3: /usr/include/mysql/mysql.h:127: parse error before `MEM_ROOT' /usr/include/mysql/mysql.h:127: warning: no semicolon at end of struct or union /usr/include/mysql/mysql.h:128: warning: data definition has no type or storage class /usr/include/mysql/mysql.h:168: parse error before `MEM_ROOT' /usr/include/mysql/mysql.h:168: warning: no semicolon at end of struct or union /usr/include/mysql/mysql.h:175: parse error before `}' /usr/include/mysql/mysql.h:175: warning: data definition has no type or storage class /usr/include/mysql/mysql.h:182: parse error before `MYSQL_DATA' -- cut -- the errors go on quite a bit, but the MEM_ROOT is pretty instant, and it's over before it begins... anybody ever had this problem, I've searched google quite a bit, but I can't find what the deal is and what the problem is. any help appreciated... /* client1.c - connect to and disconnect from MySQL server */ #include my_global.h #include mysql.h static char *opt_host_name = NULL; /* server host (default=localhost) */ static char *opt_user_name = username; /* username (default=login name) */ static char *opt_password = password; /* password (default=none) */ static unsigned int opt_port_num = 0; /* port number (use built-in value) */ static char *opt_socket_name = NULL; /* socket name (use built-in value) */ static char *opt_db_name = spamassassin; /* database name (default=none) */ static unsigned int opt_flags = 0; /* connection flags (none) */ static MYSQL *conn; /* pointer to connection handler */ int main (int argc, char *argv[]) { char sql_command[2048]; MYSQL_RES *result; MYSQL_ROW row; int state; int i; /* initialize connection handler */ conn = mysql_init (NULL); if(conn==NULL) { fprintf(stderr,mysql_init() failed (probably out of memory)\n); exit(1); } /* connect to server */ if(mysql_real_connect (conn, opt_host_name, opt_user_name, opt_password, opt_db_name, opt_port_num, opt_socket_name, opt_flags) ==NULL) { fprintf( stderr, mysql_real_connect() failed:\nEror %u (%s)\n, mysql_errno(conn), mysql_error(conn)); exit(1); } /* disconnect from server */ sprintf(sql_command, SELECT count(*) from spamassassin.badguys where badguy like '%s',argv[1]); state = mysql_query(conn, sql_command); if (state!=0) return 0; // must call mysql_store_result() before we can issue any other // query calls result = mysql_store_result(conn); if( (row=mysql_fetch_row(result)) != NULL) { printf(%s badguys found: %s\n,row[0],argv[1]); } // free the result set mysql_free_result(result); /* disconnect from server */ mysql_close (conn); exit (0); } -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Query Cache not being used...
Hi Daniel, Yes, query_cache_type is 1 by default if you don't set it. :-) It's not used by default, however, because query_cache_size is 0. You need to set query_cache_size to 16M, 32M, etc. Hope that helps. Matt - Original Message - From: Daniel Kasak Sent: Thursday, September 25, 2003 12:49 AM Subject: Query Cache not being used... Hi all. I've set an option in the my.cnf file ( for a 4.0.14 server ): [mysqld] query_cache_type = 1 and restarted the server. The query cache is supposed to be available. SHOW VARIABLES LIKE 'have_query_cache' returns 'YES' as described in the documentation. But all the qcache_* status indicators are always 0. Is there anything else I'm supposed to do to turn the query cache on? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Scalability question
Hi, Imagine I had a table with 50,000,000 rows, would it improve search speeds if I split it up into smaller tables of 10,000,000 rows each? This means if I had to search for a record, I'd have to query the 5 tables one after the other. I'd greatly appreciate any help. Gerald. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
phpMyAdmin request problem
hello ! I'm using my french host's phpMyAdmin and I'd like to create manually a new table using different character set and collation than default one. This is the code I've used : CREATE TABLE `ru` ( `pkey` INT(20) NOT NULL AUTO_INCREMENT PRIMARY KEY, `titre` TEXT NOT NULL ) CHARACTER SET koi8r COLLATION koi8r_general_ci; The first part has been generated by phpMyAdmin and I've just added CHARACTER SET koi8r COLLATION koi8r_general_ci like it's done in the example from this doc : http://www.mysql.com/documentation/mysql/bychapter/manual_Charset.html#Charset-cyrillic-sets . But I have a syntaxe error in this part of code ! Which is it ? -- Faites un voeu et puis Voila ! www.voila.fr -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: phpMyAdmin request problem
On Thu, 25 Sep 2003 10:11:27 +0200 (CEST) Artem Batoussov [EMAIL PROTECTED] wrote: The first part has been generated by phpMyAdmin and I've just added CHARACTER SET koi8r COLLATION koi8r_general_ci like it's done in the example from this doc : http://www.mysql.com/documentation/mysql/bychapter/manual_Charset.html#Charset-cyrillic-sets . But I have a syntaxe error in this part of code ! Which is it ? please, tell us what error message do you get and your version of MySQL server. --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Temporary tables
Due to complex query needs and the lack of subqueries in the current production version of MySQL i have to use temporary tables, but there is almost no information about the behavior of them in the manual.pdf documentation file of mySQL database. Does any one know where to find more information about temporary tables?. The questions i would like to answer are: 1) What happens if two (or more) users create a temporary table with the same name at the same time? 2) If i don't drop the tables, when are the tables droped by the server? 3) what are the memory and or performance issues of temporary tables? 4) Can i use session based temporary tables? Regards, FB
Re: Temporary tables
On Thu, 25 Sep 2003 02:26:28 -0600 [EMAIL PROTECTED] wrote: 1) What happens if two (or more) users create a temporary table with the same name at the same time? 2) If i don't drop the tables, when are the tables droped by the server? 3) what are the memory and or performance issues of temporary tables? 4) Can i use session based temporary tables? http://www.mysql.com/doc/en/CREATE_TABLE.html The temporary table is visible only to the current connection, and will be deleted automatically when the connection is closed. This means that two different connections can both use the same temporary table name without conflicting with each other or with an existing table of the same name. (The existing table is hidden until the temporary table is deleted.) From MySQL 4.0.2 on, you must have the CREATE TEMPORARY TABLES privilege to be able to create temporary tables. --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Scalability question
Imagine I had a table with 50,000,000 rows, would it improve search speeds if I split it up into smaller tables of 10,000,000 rows each? This means if I had to search for a record, I'd have to query the 5 tables one after the other. Which is likely to be slower. If you have good indexes for your search, and indexed search is likely to perfom of the order of log(number of rows) or better. Splitting the table will give a relatively small change in thsi figure, while having to be done 5 times. The whole poi t of a well indexed database is that absolute size is not, per se, a problem. Just give it lots of Ram so that it can cache its indexes in mamory, and it will perform very well. Alec -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Temporary tables
Thanks! Antony Dovgal [EMAIL PROTECTED] 25/09/2003 02:33 a.m. To [EMAIL PROTECTED] cc Subject Re: Temporary tables On Thu, 25 Sep 2003 02:26:28 -0600 [EMAIL PROTECTED] wrote: 1) What happens if two (or more) users create a temporary table with the same name at the same time? 2) If i don't drop the tables, when are the tables droped by the server? 3) what are the memory and or performance issues of temporary tables? 4) Can i use session based temporary tables? http://www.mysql.com/doc/en/CREATE_TABLE.html The temporary table is visible only to the current connection, and will be deleted automatically when the connection is closed. This means that two different connections can both use the same temporary table name without conflicting with each other or with an existing table of the same name. (The existing table is hidden until the temporary table is deleted.) From MySQL 4.0.2 on, you must have the CREATE TEMPORARY TABLES privilege to be able to create temporary tables. --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
Re: FULL Text Limitation issue!
Thank you very much Paul and Keith for your response , I guess I will have to use LIKE clause in SQL statement for searching the records then. Imran - Original Message - From: Keith C. Ivey [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Imran Aziz [EMAIL PROTECTED] Sent: Tuesday, September 23, 2003 5:36 PM Subject: Re: FULL Text Limitation issue! On 23 Sep 2003 at 17:07, Imran Aziz wrote: I have come to know that mySQL FULL TEXT search has the limitation of the search phrase to be more then 3 charators. In order to alter the default behavior one has to alter the variable ft_min_word_len. I am running MySQL 3.23.54 and the FULL Text search works fine , but I am unable to alter the variable ft_min_word_len either using the my.cnf file or by altering the variable value on mysql startup. The ft_min_word_len variable wasn't introduced until MySQL 4. See http://www.mysql.com/doc/en/Fulltext_Fine-tuning.html -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
compile error.
i'm trying to compile mysql-4.0.15a on my server and i'm getting the folowing error: gcc -DDEFAULT_CHARSET_HOME=\/usr/local/mysql\ -DDATADIR=\/data/mysql\ -DSHAREDIR=\/usr/local/mysql/share/mysql\ -DUNDEF_THREADS_HACK -DDONT_USE_RAID -DMYSQL_CLIENT -I. -I. -I.. -I./../include -I../include -I./.. -I.. -I.. /usr/local/openssl/include -O3 -DDBUG_OFF -c libmysql.c -MT libmysql.lo -MD -MP -MF .deps/libmysql.TPlo -fPIC -DPIC -o .libs/libmysql.lo gcc: cannot specify -o with -c or -S and multiple compilations make[2]: *** [libmysql.lo] Error 1 make[2]: Leaving directory `/usr/local/src/web/mysql-4.0.15a/libmysql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/local/src/web/mysql-4.0.15a' make: *** [all] Error 2 my configure command is this: ./configure \ --prefix=/usr/local/mysql \ --localstatedir=/data/mysql \ --enable-large-files \ --with-innodb \ --with-mysqld-user=mysql \ --disable-maintainer-mode \ --without-docs \ --without-debug \ --without-bench \ --enable-assembler \ --with-openssl=/usr/local/openssl \ --with-openssl-includes=/usr/local/openssl/include \ --with-openssl-libs=/usr/local/openssl/lib \ --with-named-z-libs=/usr/local/zlib/lib thanks in advance.
Primary Key Constraint Problem
Hi All, I have recently discovered that when you place a primary key constraint on a column of type CHAR(2) the constraint causes the following to happen when I add a new row to the table: if a key (AA) is already in the table then I can not add Aa, aA or aa this seams a bit wrong as 'A' != 'a' in the representation of CHAR Is this the way that primary key constraints are specified in ANSI SQL ? and is there a way of inserting AA and aa Kind Regards Jacques Buitendag
Load data: odd behaviour
Morning all, I've been using the same format of text files to import monthly text files using LOAD DATA LOCAL INFILE into a table. It's been working fine until today when it decided to import the rows from the text file in a semi-random order instead of working through the file from start to finish. Anyone heard of this behaviour before? Maybe a mysql config blip? Adrian ** Granada Sky Broadcasting Limited (GSB) Franciscan Court, 16 Hatfields, London SE1 8DJ Tel 020 7578 4040 Fax 020 7578 4035, Registered in England No: 3101815. This e-mail and any attachments may be confidential. If you have received this communication in error please tell us by return e-mail or at the number's above and delete it, and any copies of it. You must not use, disclose, distribute, print or rely on this email. Unless clearly stated that this disclaimer should not apply, this e-mail is not intended to create legally binding commitments on behalf of GSB, nor do its contents reflect the corporate views or policies of GSB. Although GSB routinely screens for viruses GSB makes no representation or warranty as to the absence of viruses in this e-mail or any attachments. Visit our website at http://www.gsb.co.uk ** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Primary Key Constraint Problem
Jacques Buitendag [EMAIL PROTECTED] wrote: I have recently discovered that when you place a primary key constraint on a column of type CHAR(2) the constraint causes the following to happen when I add a new row to the table: if a key (AA) is already in the table then I can not add Aa, aA or aa this seams a bit wrong as 'A' != 'a' in the representation of CHAR Is this the way that primary key constraints are specified in ANSI SQL ? and is there a way of inserting AA and aa CHAR columns are compared in case-insensitive fashion. Declare your column as BINARY: http://www.mysql.com/doc/en/CHAR.html -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem compiling a small C program on Redhat-7.3
At 02:55 AM 9/25/03 -0400, you wrote: Does anybody have any idea why this program won't compile, it compiles fine on my slak box with includes from 4.0.15 so the program is probably ok. ... It starts screaming about mysql.h immediately,... gcc -c -I/usr/include/mysql mysql1.c make sure the mysql.h and other .h files are in this directory. i am not familiar with red had rpm, but he or someone may not have put the right include files in the right place or may have left some old ones hanging around . hth --- ray tayek http://tayek.com/ actively seeking mentoring or telecommuting work vice chair orange county java users group http://www.ocjug.org/ hate spam? http://samspade.org/ssw/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: auto increment
Louie Miranda [EMAIL PROTECTED] wrote: When i exported the data, i found an option on the lower part of the sql code. ) TYPE=MyISAM AUTO_INCREMENT=0 ; I tried to make a table again, and when i entered it resets to whatever options i last type it on the AUTO_INCREMENT=0 value. You can use ALTER TABLE to reset auto_increment value for MyISAM table. I still didnt see how to reset it manually, when its live. And also changing increment numbers by date or similar. AUTO_INCREMENT is an attribute for integer columns. -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Scalability question
On Thu, 25 Sep 2003 [EMAIL PROTECTED] wrote: [...] Which is likely to be slower. Wow! [...] Just give it lots of Ram so that it can cache its indexes in mamory, and it will perform very well. Thanks for taking time to answer this. Cheers, Gerald -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fw: Secting according to values of previous records!
- Original Message - From: Anne Piotet To: [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 1:07 PM Subject: Secting according to values of previous records! Hi! I'm relatively new to MySQL and encounter the following problem: - I have a table (~300'000 records) containing process data (which I get under a given form from plants); a flag (1¦0) signals the start of a new series of trials , moreover another field indicates the waiting time between trial n and trial n+1; the following records should be excluded from the selection: - the first N (1,2,3,4,5...) of a series - if inside a series the waiting time is superior to a given value t0, the next M records in the series should be excluded Now, I should like to be able to parameter the values of N,t0 and M How should I go with that? Does MySQL support global variable? Thanks Anne
Secting according to values of previous records!
Hi! I'm relatively new to MySQL and encounter the following problem: - I have a table (~300'000 records) containing process data (which I get under a given form from plants); a flag (1¦0) signals the start of a new series of trials , moreover another field indicates the waiting time between trial n and trial n+1; the following records should be excluded from the selection: - the first N (1,2,3,4,5...) of a series - if inside a series the waiting time is superior to a given value t0, the next M records in the series should be excluded Now, I should like to be able to parameter the values of N,t0 and M How should I go with that? Does MySQL support global variable? Thanks Anne -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql compile error.
i'm trying to compile mysql-4.0.15a on my server and i'm getting the folowing error: gcc -DDEFAULT_CHARSET_HOME=\/usr/local/mysql\ -DDATADIR=\/data/mysql\ -DSHAREDIR=\/usr/local/mysql/share/mysql\ -DUNDEF_THREADS_HACK -DDONT_USE_RAID -DMYSQL_CLIENT -I. -I. -I.. -I./../include -I../include -I./.. -I.. -I.. /usr/local/openssl/include -O3 -DDBUG_OFF -c libmysql.c -MT libmysql.lo -MD -MP -MF .deps/libmysql.TPlo -fPIC -DPIC -o .libs/libmysql.lo gcc: cannot specify -o with -c or -S and multiple compilations make[2]: *** [libmysql.lo] Error 1 make[2]: Leaving directory `/usr/local/src/web/mysql-4.0.15a/libmysql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/local/src/web/mysql-4.0.15a' make: *** [all] Error 2 my configure command is this: ./configure \ --prefix=/usr/local/mysql \ --localstatedir=/data/mysql \ --enable-large-files \ --with-innodb \ --with-mysqld-user=mysql \ --disable-maintainer-mode \ --without-docs \ --without-debug \ --without-bench \ --enable-assembler \ --with-openssl=/usr/local/openssl \ --with-openssl-includes=/usr/local/openssl/include \ --with-openssl-libs=/usr/local/openssl/lib \ --with-named-z-libs=/usr/local/zlib/lib thanks in advance.
mysql compile error.
i'm trying to compile mysql-4.0.15a on my server and i'm getting the folowing error: gcc -DDEFAULT_CHARSET_HOME=\/usr/local/mysql\ -DDATADIR=\/data/mysql\ -DSHAREDIR=\/usr/local/mysql/share/mysql\ -DUNDEF_THREADS_HACK -DDONT_USE_RAID -DMYSQL_CLIENT -I. -I. -I.. -I./../include -I../include -I./.. -I.. -I.. /usr/local/openssl/include -O3 -DDBUG_OFF -c libmysql.c -MT libmysql.lo -MD -MP -MF .deps/libmysql.TPlo -fPIC -DPIC -o .libs/libmysql.lo gcc: cannot specify -o with -c or -S and multiple compilations make[2]: *** [libmysql.lo] Error 1 make[2]: Leaving directory `/usr/local/src/web/mysql-4.0.15a/libmysql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/local/src/web/mysql-4.0.15a' make: *** [all] Error 2 my configure command is this: ./configure \ --prefix=/usr/local/mysql \ --localstatedir=/data/mysql \ --enable-large-files \ --with-innodb \ --with-mysqld-user=mysql \ --disable-maintainer-mode \ --without-docs \ --without-debug \ --without-bench \ --enable-assembler \ --with-openssl=/usr/local/openssl \ --with-openssl-includes=/usr/local/openssl/include \ --with-openssl-libs=/usr/local/openssl/lib \ --with-named-z-libs=/usr/local/zlib/lib thanks in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Load data: odd behaviour
How did you determine this? I hope not by the order returned when you select them. There is no order to the set returned unless you use an ORDER BY clause. Adrian Sill wrote: Morning all, I've been using the same format of text files to import monthly text files using LOAD DATA LOCAL INFILE into a table. It's been working fine until today when it decided to import the rows from the text file in a semi-random order instead of working through the file from start to finish. Anyone heard of this behaviour before? Maybe a mysql config blip? Adrian ** Granada Sky Broadcasting Limited (GSB) Franciscan Court, 16 Hatfields, London SE1 8DJ Tel 020 7578 4040 Fax 020 7578 4035, Registered in England No: 3101815. This e-mail and any attachments may be confidential. If you have received this communication in error please tell us by return e-mail or at the number's above and delete it, and any copies of it. You must not use, disclose, distribute, print or rely on this email. Unless clearly stated that this disclaimer should not apply, this e-mail is not intended to create legally binding commitments on behalf of GSB, nor do its contents reflect the corporate views or policies of GSB. Although GSB routinely screens for viruses GSB makes no representation or warranty as to the absence of viruses in this e-mail or any attachments. Visit our website at http://www.gsb.co.uk ** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Load data: odd behaviour
No, raw viewing via phpmyadmin. We have some strange rules on our dates which mean that when it comes to processing the data its easier if it's in order before it goes in. for example, we have a schedule running 24 hours a day, but the dates associated with the entries run from 6am to 6am, would you believe! So Friday 26th starts at 6am. 4am tonight is classified as 2003-09-25. It just helps to have the transmission order in place right from the start! Thanks Adrian -Original Message- From: gerald_clark [mailto:[EMAIL PROTECTED] Sent: 25 September 2003 14:32 To: Adrian Sill Cc: [EMAIL PROTECTED] Subject: Re: Load data: odd behaviour How did you determine this? I hope not by the order returned when you select them. There is no order to the set returned unless you use an ORDER BY clause. Adrian Sill wrote: Morning all, I've been using the same format of text files to import monthly text files using LOAD DATA LOCAL INFILE into a table. It's been working fine until today when it decided to import the rows from the text file in a semi-random order instead of working through the file from start to finish. Anyone heard of this behaviour before? Maybe a mysql config blip? Adrian *** *** Granada Sky Broadcasting Limited (GSB) Franciscan Court, 16 Hatfields, London SE1 8DJ Tel 020 7578 4040 Fax 020 7578 4035, Registered in England No: 3101815. This e-mail and any attachments may be confidential. If you have received this communication in error please tell us by return e-mail or at the number's above and delete it, and any copies of it. You must not use, disclose, distribute, print or rely on this email. Unless clearly stated that this disclaimer should not apply, this e-mail is not intended to create legally binding commitments on behalf of GSB, nor do its contents reflect the corporate views or policies of GSB. Although GSB routinely screens for viruses GSB makes no representation or warranty as to the absence of viruses in this e-mail or any attachments. Visit our website at http://www.gsb.co.uk *** *** ** Granada Sky Broadcasting Limited (GSB) Franciscan Court, 16 Hatfields, London SE1 8DJ Tel 020 7578 4040 Fax 020 7578 4035, Registered in England No: 3101815. This e-mail and any attachments may be confidential. If you have received this communication in error please tell us by return e-mail or at the number's above and delete it, and any copies of it. You must not use, disclose, distribute, print or rely on this email. Unless clearly stated that this disclaimer should not apply, this e-mail is not intended to create legally binding commitments on behalf of GSB, nor do its contents reflect the corporate views or policies of GSB. Although GSB routinely screens for viruses GSB makes no representation or warranty as to the absence of viruses in this e-mail or any attachments. Visit our website at http://www.gsb.co.uk ** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql compile error.
On Thu, 25 Sep 2003 15:28:15 +0200 Richard Pijnenburg [EMAIL PROTECTED] wrote: i'm trying to compile mysql-4.0.15a on my server and i'm getting the folowing error: Richard, please, resend your letter one more time, we have real enjoy reading it again and again... =) --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysql compile error.
Sorry, but because I haven't got it I thought it didn't get here. Sorry! M.v.g. Richard Pijnenburg -Original Message- From: Antony Dovgal [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 3:42 PM To: [EMAIL PROTECTED] Subject: Re: mysql compile error. On Thu, 25 Sep 2003 15:28:15 +0200 Richard Pijnenburg [EMAIL PROTECTED] wrote: i'm trying to compile mysql-4.0.15a on my server and i'm getting the folowing error: Richard, please, resend your letter one more time, we have real enjoy reading it again and again... =) --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
multiple foreign key references on one column
Hi, I have three tables. One of the tables has a column that is a foreign key that references columns from the other two tables. This table is shown below. CREATE TABLE `pheno` ( `id` smallint(5) unsigned NOT NULL auto_increment, `relevant` enum('y','n') default NULL, `phenotype` varchar(50) NOT NULL default '', PRIMARY KEY (`id`,`phenotype`), KEY `id` (`id`), CONSTRAINT `0_125` FOREIGN KEY (`id`) REFERENCES `monogenic` (`phenotype_ID`) ON DELETE CASCADE, CONSTRAINT `0_127` FOREIGN KEY (`id`) REFERENCES `knockout` (`phenotype_ID`) ON DELETE CASCADE ) TYPE=InnoDB The problem is that I can't insert a record into this table unless the value of 'id' is present in both the mongenic and knockout tables. I receive the following error: Cannot add or update a child row: a foreign key constraint fails It doesn't make sense for entries in the pheno table to be duplicated in the monogenic and knockoout tables. I can only assume that a foreign key can only reference one table, although it allows me to create the key, just not to insert data. Is this correct? tia Rich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Table crashes after optimize
I am the admin of a Mysql 4.0.14-standard databas running on Solaris 9. A developer and I created a shell script that does a mysqldump of the database and then runs an optimize on the largest table we have. The command line is as follows: $EXECPATH/mysql --host=172.65.12.10 --user=user --password=pass --execute=optimize table MESSAGES test Here is the output we got this morning: test.MESSAGES optimizeerror 13 when fixing table test.MESSAGES optimizestatus Operation failed We ran this same script last night and it ran fine! Here is something the developer sent me. it is a description of the problems he sees in the database that seemed to be caused by the optimize: When I start mysql from command line and try to use test database, I get ... Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Didn't find any fields in table 'MESSAGES' Database changed When I try to desc MESSAGES or select some data, I get ... ERROR 1016: Can't open file: 'MESSAGES.MYI'. (errno: 144) When I run myisamchk on .MYI tables, I get ... Checking MyISAM file: /usr/local/mysql/data/test/MESSAGES.MYI Data records:5202 Deleted blocks: 0 myisamchk: warning: Table is marked as crashed and last repair failed - check file-size myisamchk: warning: Size of indexfile is: 34373632 Should be: 445440 myisamchk: warning: Size of datafile is: 38468336 Should be: 24260468 - check key delete-chain - check record delete-chain - check index reference - check data record references index: 1 myisamchk: error: Found 28440 keys of 5202 - check record links myisamchk: error: Record-count is not ok; is 28440 Should be: 5202 myisamchk: warning: Found 16653 deleted blocks Should be: 0 myisamchk: warning: Found 45093 parts Should be: 5203 parts MyISAM-table '/usr/local/mysql/data/test/MESSAGES.MYI' is corrupted Fix it using switch -r or -o Anyone have any ideas what is going on? I need help ASAP on this, if you can! Thanks, Ben Ricker -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Table crashes after optimize
On Thu, 25 Sep 2003 09:23:13 -0500 Ben Ricker [EMAIL PROTECTED] wrote: Here is the output we got this morning: test.MESSAGES optimizeerror 13 when fixing table test.MESSAGES optimizestatus Operation failed # perror 13 Error code 13: Permission denied check if it's allright with rights on this table ? --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Structuring a Load File
I'm using InnoDB tables and created a new one with an autoincrement field to use for a primary key. These tables are being loaded from text files that I create out of another database system (Lotus Notes). My question is what must I do in the text file structure to account for the autoincrement field? Do I include a first field with \N? If the MySQL table has 20 columns with the first being the autoincrement, can my load file be only 19 columns? Thanks. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Innodb: CREATE INDEX
Yes, i did that. It's given me something like si 200/300 so 300/500 It's a lot, doing my system going down. But i think that the problem is that i'm reserving too much memory for mysql... Or could exists another reason? Thx Alexis Quoting Per Andreas Buer [EMAIL PROTECTED]: [EMAIL PROTECTED] writes: I'm creating indexes in a table with 16 million rows (it's a fact table), and it takes a lot of time (2/3/4 hours), because my system is always swapping in/out (i think). If you run vmstat 2 while the index is created you will see if swap is beeing used or not (see the si and so columns and man vmstat for futher information). -- Per Andreas Buer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Using SQL variables
Thank you for your support. In fact the problem was in MySQL Front. I tried using SQLyog and it passed very well. The problem is that SQLyog will not facilitate me in buying since I have no credit card!!! I am in Africa and the best payment method I have access to is by Western Union (http://www.westernunion.com) Thanks Emery - Original Message - From: Petr Vileta [EMAIL PROTECTED] To: Director General: NEFACOMP [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 03:47 Subject: Re: Using SQL variables In mysql.exe type query and Enter and other query and Enter ... In MySQL-Front type more query on more rows and press F9. Every query runs in sequece from top to bottom as is typed on rows. See MySQL-Front help for using F9, Shift+F9 and Ctrl+F9 function. Other way is using some programming language as a Perl, Visual Basic, PHP and his appropriate libraries/packages. I preffer Perl, because it is very powerfull language, is free and exist for Windows and Linux too. Applications programed in Perl are portabled to Windows and Linux without any changes ;-) Petr Vileta http://www.practisoft.cz Ostatne soudím, ze letní cas musí být zrusen ! - Original Message - From: Director General: NEFACOMP [EMAIL PROTECTED] To: Petr Vileta [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 10:01 AM Subject: Re: Using SQL variables Yes you are right. I run the query in SQLyog and it came very nicely. Thanks for your time and help. Another question is: How do I send multiple queries at the same time the server? I mean, two instructions in the same query. Like SET @var = 0; SELECT (@var := @var + 1) AS Number, AnotherField FROM any_table_with_records; Thanks Emery - Original Message - From: Petr Vileta [EMAIL PROTECTED] To: Director General: NEFACOMP [EMAIL PROTECTED] Sent: Tuesday, September 23, 2003 18:55 Subject: Re: Using SQL variables Can you run this query and tell me if it works on your machine? SELECT (@var := @var + 1) AS Number, * FROM any_table_with_records; As per the manual, this should give something like: +-- NumberFieldOne 1Value 2Value 3Value ... But when I run it the error is :You have an error in your SQL syntax near 'NULL @var + 1) AS Number BLAH BLAH BLAH Yeah :-) You are using MySQL-Front, is it right? I get the same error in mysql-front but the syntax is right, test it using mysql.exe - a native mysql client in DOS mode. If you will use this syntax in some program in VisualBasic, PHP, Perl or other the command still work ok. If you preffer GUI interface for work you can test SQLyog on www.webyog.com Petr Vileta, Czech republic -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Ideas on creating connections
Hi groups, I need some experienced users to guide me on this issue. I am developping an Application that will be accessing a MySQL database through MyODBC. The application is developped using Visual Basic. Since my application will be used simultaneously by more than 200 users, I want to know the implication of using one of the following methods for connecting to the server: 1. At logon, I create a connection to the server and maintain it throught the application life. By the application life I mean that the connection stays open as long as the application is loaded in the memory. So, for a user who is online for 3 hours, the connection is on for those three hours, even if the user goes out for a coffee. 2. I create a connection only when a query is about to be sent to the server. That means, I create a connection when I want to create an ADO recordset and run a query against the server. After running my query, I distroy the connection. Currently I am using the first option since I don't exactly what it is required (time and resources) to make a connection to the server. Will you please tell me how fast is to connect to the server. If you advise me that this method is the best, I will add functions to reconnect a dead connection. Any ideas and advices are highly welcomed Thanks, __ NZEYIMANA Emery Fabrice NEFA Computing Services, Inc. P.O. Box 5078 Kigali Office Phone: +250-51 11 06 Office Fax: +250-50 15 19 Mobile: +250-08517768 Email: [EMAIL PROTECTED] http://www.nefacomp.net/
RE: Ideas on creating connections
My experience is this. I use DAO through MyODBC, and I also use the libmysql.dll with a custom recordset. Connection times through both options are extremely fast. Fast enough in my situation that it can basically can be ignored. There are times when I open several connections to the server at once and have yet to run into any problems. If you strictly want to use ADO though, I would suggest that you open one connection to the server and process your queries through that connection. Leave it open for the life of the program. While the program is open, the connection to the server will stay open and the thread for MySQL will be a sleep. Just my $0.02. Roger -Original Message- From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 11:57 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Ideas on creating connections Hi groups, I need some experienced users to guide me on this issue. I am developping an Application that will be accessing a MySQL database through MyODBC. The application is developped using Visual Basic. Since my application will be used simultaneously by more than 200 users, I want to know the implication of using one of the following methods for connecting to the server: 1. At logon, I create a connection to the server and maintain it throught the application life. By the application life I mean that the connection stays open as long as the application is loaded in the memory. So, for a user who is online for 3 hours, the connection is on for those three hours, even if the user goes out for a coffee. 2. I create a connection only when a query is about to be sent to the server. That means, I create a connection when I want to create an ADO recordset and run a query against the server. After running my query, I distroy the connection. Currently I am using the first option since I don't exactly what it is required (time and resources) to make a connection to the server. Will you please tell me how fast is to connect to the server. If you advise me that this method is the best, I will add functions to reconnect a dead connection. Any ideas and advices are highly welcomed Thanks, __ NZEYIMANA Emery Fabrice NEFA Computing Services, Inc. P.O. Box 5078 Kigali Office Phone: +250-51 11 06 Office Fax: +250-50 15 19 Mobile: +250-08517768 Email: [EMAIL PROTECTED] http://www.nefacomp.net/ --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.520 / Virus Database: 318 - Release Date: 9/18/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.520 / Virus Database: 318 - Release Date: 9/18/2003 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Ideas on creating connections
The general rule of thumb is that connection creation/destruction is the most costly part of approach #2. However, it is unlikely that each connection needs a dedicated connection, and therefore memory resources on the server for the entirity of the client's lifespan... if your clients are firing off many queries back-to-back, buy a lot of memory for your server, and go w/ your option #1. if it's a typical app, where the user queries data, looks through it for a bit, then queries more, yadda, yadda, yadda, then what you're probably going to want to do is #2. Without a central 'app server' as such, you can't really take advantage of connection pooling. The closest you can do is write into your app that if the connection is idle for x amount of time, then it closes the connection, and reestablishes it upon next data request. Hope this helps... Dan Greene -Original Message- From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 11:57 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Ideas on creating connections Hi groups, I need some experienced users to guide me on this issue. I am developping an Application that will be accessing a MySQL database through MyODBC. The application is developped using Visual Basic. Since my application will be used simultaneously by more than 200 users, I want to know the implication of using one of the following methods for connecting to the server: 1. At logon, I create a connection to the server and maintain it throught the application life. By the application life I mean that the connection stays open as long as the application is loaded in the memory. So, for a user who is online for 3 hours, the connection is on for those three hours, even if the user goes out for a coffee. 2. I create a connection only when a query is about to be sent to the server. That means, I create a connection when I want to create an ADO recordset and run a query against the server. After running my query, I distroy the connection. Currently I am using the first option since I don't exactly what it is required (time and resources) to make a connection to the server. Will you please tell me how fast is to connect to the server. If you advise me that this method is the best, I will add functions to reconnect a dead connection. Any ideas and advices are highly welcomed Thanks, __ NZEYIMANA Emery Fabrice NEFA Computing Services, Inc. P.O. Box 5078 Kigali Office Phone: +250-51 11 06 Office Fax: +250-50 15 19 Mobile: +250-08517768 Email: [EMAIL PROTECTED] http://www.nefacomp.net/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem compiling a small C program on Redhat-7.3
I found the answer in the archives: http://marc.theaimsgroup.com/?l=mysqlm=104770109826977w=2 /* client1.c - connect to and disconnect from MySQL server */ #include my_global.h #include my_sys.h /* - Added this and it all works fine now */ #include mysql.h thanks Paul :) KL Kelley Lingerfelt wrote: Does anybody have any idea why this program won't compile, it seems to be straightforward, but it I can't get it to compile on Redhat-7.3. It starts screaming about mysql.h immediately, I use this link to compile with, on my machine at the house, it compiles just fine and runs just fine, but I can't get it to compile on any of my other 7.3 machines, does anybody, know what I could be missing, I'm using up to Redhat rpms of mysql, and I have the devel rpm, so I have all the libraries and include files. but ??? RPMS on the machines mysql-devel-3.23.56-1.73 mysql-3.23.56-1.73 mysql-server-3.23.56-1.73 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Arabic character set
Michael sleibi [EMAIL PROTECTED] wrote: Could you please tell me what is the command to install the mysql 4.1 alpha with the default character sets arabic (cp1256) on windows . MySQL doesn't support cp1256 character set. You can use unicode for arabic language in v4.1. -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Ideas on creating connections
What is connection pooling? How big should my memory be if 200 connections may be required? Is there any limit of how many connections I can use in MySQL? I know one can set the max connections in MySQL. Does MySQL impose the limit I can tell it? I mean, may I set that number to let's say 1? Thanks Emery - Original Message - From: Dan Greene [EMAIL PROTECTED] To: Director General: NEFACOMP [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 18:17 Subject: RE: Ideas on creating connections The general rule of thumb is that connection creation/destruction is the most costly part of approach #2. However, it is unlikely that each connection needs a dedicated connection, and therefore memory resources on the server for the entirity of the client's lifespan... if your clients are firing off many queries back-to-back, buy a lot of memory for your server, and go w/ your option #1. if it's a typical app, where the user queries data, looks through it for a bit, then queries more, yadda, yadda, yadda, then what you're probably going to want to do is #2. Without a central 'app server' as such, you can't really take advantage of connection pooling. The closest you can do is write into your app that if the connection is idle for x amount of time, then it closes the connection, and reestablishes it upon next data request. Hope this helps... Dan Greene -Original Message- From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 11:57 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Ideas on creating connections Hi groups, I need some experienced users to guide me on this issue. I am developping an Application that will be accessing a MySQL database through MyODBC. The application is developped using Visual Basic. Since my application will be used simultaneously by more than 200 users, I want to know the implication of using one of the following methods for connecting to the server: 1. At logon, I create a connection to the server and maintain it throught the application life. By the application life I mean that the connection stays open as long as the application is loaded in the memory. So, for a user who is online for 3 hours, the connection is on for those three hours, even if the user goes out for a coffee. 2. I create a connection only when a query is about to be sent to the server. That means, I create a connection when I want to create an ADO recordset and run a query against the server. After running my query, I distroy the connection. Currently I am using the first option since I don't exactly what it is required (time and resources) to make a connection to the server. Will you please tell me how fast is to connect to the server. If you advise me that this method is the best, I will add functions to reconnect a dead connection. Any ideas and advices are highly welcomed Thanks, __ NZEYIMANA Emery Fabrice NEFA Computing Services, Inc. P.O. Box 5078 Kigali Office Phone: +250-51 11 06 Office Fax: +250-50 15 19 Mobile: +250-08517768 Email: [EMAIL PROTECTED] http://www.nefacomp.net/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Ideas on creating connections
I never use DAO. Is there any benefit over ADO? Thanks Emery - Original Message - From: Roger Davis [EMAIL PROTECTED] To: Director General: NEFACOMP [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 18:14 Subject: RE: Ideas on creating connections My experience is this. I use DAO through MyODBC, and I also use the libmysql.dll with a custom recordset. Connection times through both options are extremely fast. Fast enough in my situation that it can basically can be ignored. There are times when I open several connections to the server at once and have yet to run into any problems. If you strictly want to use ADO though, I would suggest that you open one connection to the server and process your queries through that connection. Leave it open for the life of the program. While the program is open, the connection to the server will stay open and the thread for MySQL will be a sleep. Just my $0.02. Roger -Original Message- From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 11:57 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Ideas on creating connections Hi groups, I need some experienced users to guide me on this issue. I am developping an Application that will be accessing a MySQL database through MyODBC. The application is developped using Visual Basic. Since my application will be used simultaneously by more than 200 users, I want to know the implication of using one of the following methods for connecting to the server: 1. At logon, I create a connection to the server and maintain it throught the application life. By the application life I mean that the connection stays open as long as the application is loaded in the memory. So, for a user who is online for 3 hours, the connection is on for those three hours, even if the user goes out for a coffee. 2. I create a connection only when a query is about to be sent to the server. That means, I create a connection when I want to create an ADO recordset and run a query against the server. After running my query, I distroy the connection. Currently I am using the first option since I don't exactly what it is required (time and resources) to make a connection to the server. Will you please tell me how fast is to connect to the server. If you advise me that this method is the best, I will add functions to reconnect a dead connection. Any ideas and advices are highly welcomed Thanks, __ NZEYIMANA Emery Fabrice NEFA Computing Services, Inc. P.O. Box 5078 Kigali Office Phone: +250-51 11 06 Office Fax: +250-50 15 19 Mobile: +250-08517768 Email: [EMAIL PROTECTED] http://www.nefacomp.net/ --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.520 / Virus Database: 318 - Release Date: 9/18/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.520 / Virus Database: 318 - Release Date: 9/18/2003 -- MySQL ODBC Mailing List For list archives: http://lists.mysql.com/myodbc To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 1000 rows in MySQLcc
Oscar (TOMCAT) [EMAIL PROTECTED] wrote: I'm using MySQLcc version 0.9.2-beta... I want to recover more than 1000 rows in a select statement... What is the command to alter this setting ??? Open the Register Server window, go to the MySQL Options, there you can find Automatically limit SELECT queries to. -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Innodb: CREATE INDEX
On Thu, Sep 25, 2003 at 03:55:26PM +0100, [EMAIL PROTECTED] wrote: Yes, i did that. It's given me something like si 200/300 so 300/500 It's a lot, doing my system going down. But i think that the problem is that i'm reserving too much memory for mysql... That's probably true and very easy to test. Try it with giving MySQL less memory. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 11 days, processed 423,773,355 queries (419/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Ideas on creating connections
On Thu, Sep 25, 2003 at 06:47:10PM +0200, Director General: NEFACOMP wrote: What is connection pooling? http://search.yahoo.com/search?ei=UTF-8fr=sfpp=what+is+connection+pooling How big should my memory be if 200 connections may be required? What memory? That depends on your platform. Different thread libraries have differently sized thread stacks. And it depends how large the per-thread memory settings are in your MySQL config file: http://www.mysql.com/doc/en/Memory_use.html Is there any limit of how many connections I can use in MySQL? Yes. I know one can set the max connections in MySQL. Does MySQL impose the limit I can tell it? I mean, may I set that number to let's say 1? If you set that limit, yes, MySQL will enforce it. What would be the point of the setting if it did not? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 11 days, processed 423,976,347 queries (419/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Ideas on creating connections
DAO is, I guess you would say, the predessor to ADO. I am currently in the process of getting rid of all the DAO code in the application and moving to a custom recordset using the libmysql.dll. Some of this is done in VB and it is still extremely fast for a VB based recordset. Although there are numerous ways to do this, it is really difficult to tell what would be the best in your situation. As has been mentioned before, if you are doing queries one after another in your application, then by all means connect once and pass all the queries through that connection. If you a making very few queries and you have limited resources on the server, then it would be best to connect only when you need to and drop the connection when you are done. These are of course only my opinions based on what I have experienced in the past. Your experience may vary. Void where prohibited. Roger -Original Message- From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 12:48 PM To: Roger Davis; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Ideas on creating connections I never use DAO. Is there any benefit over ADO? Thanks Emery - Original Message - From: Roger Davis [EMAIL PROTECTED] To: Director General: NEFACOMP [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 18:14 Subject: RE: Ideas on creating connections My experience is this. I use DAO through MyODBC, and I also use the libmysql.dll with a custom recordset. Connection times through both options are extremely fast. Fast enough in my situation that it can basically can be ignored. There are times when I open several connections to the server at once and have yet to run into any problems. If you strictly want to use ADO though, I would suggest that you open one connection to the server and process your queries through that connection. Leave it open for the life of the program. While the program is open, the connection to the server will stay open and the thread for MySQL will be a sleep. Just my $0.02. Roger -Original Message- From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 11:57 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Ideas on creating connections Hi groups, I need some experienced users to guide me on this issue. I am developping an Application that will be accessing a MySQL database through MyODBC. The application is developped using Visual Basic. Since my application will be used simultaneously by more than 200 users, I want to know the implication of using one of the following methods for connecting to the server: 1. At logon, I create a connection to the server and maintain it throught the application life. By the application life I mean that the connection stays open as long as the application is loaded in the memory. So, for a user who is online for 3 hours, the connection is on for those three hours, even if the user goes out for a coffee. 2. I create a connection only when a query is about to be sent to the server. That means, I create a connection when I want to create an ADO recordset and run a query against the server. After running my query, I distroy the connection. Currently I am using the first option since I don't exactly what it is required (time and resources) to make a connection to the server. Will you please tell me how fast is to connect to the server. If you advise me that this method is the best, I will add functions to reconnect a dead connection. Any ideas and advices are highly welcomed Thanks, __ NZEYIMANA Emery Fabrice NEFA Computing Services, Inc. P.O. Box 5078 Kigali Office Phone: +250-51 11 06 Office Fax: +250-50 15 19 Mobile: +250-08517768 Email: [EMAIL PROTECTED] http://www.nefacomp.net/ --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.520 / Virus Database: 318 - Release Date: 9/18/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.520 / Virus Database: 318 - Release Date: 9/18/2003 -- MySQL ODBC Mailing List For list archives: http://lists.mysql.com/myodbc To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL ODBC Mailing List For list archives: http://lists.mysql.com/myodbc To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.520 / Virus Database: 318 - Release Date: 9/18/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.520 / Virus
MySQL powered MailServer
Just wanted to know if anyone knows the status of the MySQL powered Mailserver found at http://www.mysql.com/portal/software/item-239.html Thanks, __ NZEYIMANA Emery Fabrice NEFA Computing Services, Inc. P.O. Box 5078 Kigali Office Phone: +250-51 11 06 Office Fax: +250-50 15 19 Mobile: +250-08517768 Email: [EMAIL PROTECTED] http://www.nefacomp.net/
Connect to 4.1 using MyOBDC
Please tell me it ain't so! My test user is using MyOBDC to connect to our 4.1.0 alpha server. She will be creating some Crystal Reports from the data. Her test DSN fails on an incompatible protocol error with a message that she should upgrade to the newest client. Do I have to download bitkeeper, a C compiler, and learn how to use them to get an OBCD driver that will work with our server? Thanks Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Ideas on creating connections
Thank you for your time. I don't want to be too much demanding. I currently have a problem with MyODBC 3.51. When my client machine is set to use French numbers (with a COMMA instead of a PERIOD or DOT for floats), MyODBC does not let the decimal part to pass. Venu told me he will try to look into this before the next release. It seems I am impatient!!! You said you are trying to move from DAO to using the MySQL DLL (libmysql.dll). Can we share some code using VB and the DLL? Just send me a piece of code doing the following: = - Creating a connection to the MySQL server, - Running a DELETE query on the server (or any other query that doesn't need to return values) - Running a SELECT query against the MySQL server and - Populating data of the RecordSet creating into a Flex grid - Closing and Distroying the RecordSet - Closing and Distroying the Connection = One time I saw such a code on http://www.vbmysql.com but it seems to have dissappeared. Thanks Emery - Original Message - From: Roger Davis [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 19:08 Subject: RE: Ideas on creating connections DAO is, I guess you would say, the predessor to ADO. I am currently in the process of getting rid of all the DAO code in the application and moving to a custom recordset using the libmysql.dll. Some of this is done in VB and it is still extremely fast for a VB based recordset. Although there are numerous ways to do this, it is really difficult to tell what would be the best in your situation. As has been mentioned before, if you are doing queries one after another in your application, then by all means connect once and pass all the queries through that connection. If you a making very few queries and you have limited resources on the server, then it would be best to connect only when you need to and drop the connection when you are done. These are of course only my opinions based on what I have experienced in the past. Your experience may vary. Void where prohibited. Roger -Original Message- From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 12:48 PM To: Roger Davis; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Ideas on creating connections I never use DAO. Is there any benefit over ADO? Thanks Emery - Original Message - From: Roger Davis [EMAIL PROTECTED] To: Director General: NEFACOMP [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 18:14 Subject: RE: Ideas on creating connections My experience is this. I use DAO through MyODBC, and I also use the libmysql.dll with a custom recordset. Connection times through both options are extremely fast. Fast enough in my situation that it can basically can be ignored. There are times when I open several connections to the server at once and have yet to run into any problems. If you strictly want to use ADO though, I would suggest that you open one connection to the server and process your queries through that connection. Leave it open for the life of the program. While the program is open, the connection to the server will stay open and the thread for MySQL will be a sleep. Just my $0.02. Roger -Original Message- From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 11:57 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Ideas on creating connections Hi groups, I need some experienced users to guide me on this issue. I am developping an Application that will be accessing a MySQL database through MyODBC. The application is developped using Visual Basic. Since my application will be used simultaneously by more than 200 users, I want to know the implication of using one of the following methods for connecting to the server: 1. At logon, I create a connection to the server and maintain it throught the application life. By the application life I mean that the connection stays open as long as the application is loaded in the memory. So, for a user who is online for 3 hours, the connection is on for those three hours, even if the user goes out for a coffee. 2. I create a connection only when a query is about to be sent to the server. That means, I create a connection when I want to create an ADO recordset and run a query against the server. After running my query, I distroy the connection. Currently I am using the first option since I don't exactly what it is required (time and resources) to make a connection to the server. Will you please tell me how fast is to connect to the server. If you advise me that this method is the best, I will add functions to reconnect a dead connection. Any
Re: Connect to 4.1 using MyOBDC
I use MyODBC 3.51.06 to connect my VB applications to MySQL and it works. Thanks Emery - Original Message - From: Randy Chrismon [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 19:20 Subject: Connect to 4.1 using MyOBDC Please tell me it ain't so! My test user is using MyOBDC to connect to our 4.1.0 alpha server. She will be creating some Crystal Reports from the data. Her test DSN fails on an incompatible protocol error with a message that she should upgrade to the newest client. Do I have to download bitkeeper, a C compiler, and learn how to use them to get an OBCD driver that will work with our server? Thanks Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Ideas on creating connections
As I understand, no new work is done with DAO and I think Microsoft dropped support for DAO.(I may be wrong). I've been using ADO for a while now and have had no problems with it. I used to use DAO when I started doing VB but I tend to like ADO much better. Also, as far as I know Just my $0.02 Regards, Miguel -Original Message- From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 12:48 PM To: Roger Davis; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Ideas on creating connections I never use DAO. Is there any benefit over ADO? Thanks Emery - Original Message - From: Roger Davis [EMAIL PROTECTED] To: Director General: NEFACOMP [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 18:14 Subject: RE: Ideas on creating connections My experience is this. I use DAO through MyODBC, and I also use the libmysql.dll with a custom recordset. Connection times through both options are extremely fast. Fast enough in my situation that it can basically can be ignored. There are times when I open several connections to the server at once and have yet to run into any problems. If you strictly want to use ADO though, I would suggest that you open one connection to the server and process your queries through that connection. Leave it open for the life of the program. While the program is open, the connection to the server will stay open and the thread for MySQL will be a sleep. Just my $0.02. Roger -Original Message- From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 11:57 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Ideas on creating connections Hi groups, I need some experienced users to guide me on this issue. I am developping an Application that will be accessing a MySQL database through MyODBC. The application is developped using Visual Basic. Since my application will be used simultaneously by more than 200 users, I want to know the implication of using one of the following methods for connecting to the server: 1. At logon, I create a connection to the server and maintain it throught the application life. By the application life I mean that the connection stays open as long as the application is loaded in the memory. So, for a user who is online for 3 hours, the connection is on for those three hours, even if the user goes out for a coffee. 2. I create a connection only when a query is about to be sent to the server. That means, I create a connection when I want to create an ADO recordset and run a query against the server. After running my query, I distroy the connection. Currently I am using the first option since I don't exactly what it is required (time and resources) to make a connection to the server. Will you please tell me how fast is to connect to the server. If you advise me that this method is the best, I will add functions to reconnect a dead connection. Any ideas and advices are highly welcomed Thanks, __ NZEYIMANA Emery Fabrice NEFA Computing Services, Inc. P.O. Box 5078 Kigali Office Phone: +250-51 11 06 Office Fax: +250-50 15 19 Mobile: +250-08517768 Email: [EMAIL PROTECTED] http://www.nefacomp.net/ --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.520 / Virus Database: 318 - Release Date: 9/18/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.520 / Virus Database: 318 - Release Date: 9/18/2003 -- MySQL ODBC Mailing List For list archives: http://lists.mysql.com/myodbc To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL ODBC Mailing List For list archives: http://lists.mysql.com/myodbc To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fw: No valid command found
Is everyone on the list receiving the message below? It is coming to me every time I send a message to the mysql list Thanks Emery - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 20:04 Subject: No valid command found Your message does not contain a valid command for this mail server to process. No action has been taken. Message-Id: [EMAIL PROTECTED] From: [EMAIL PROTECTED] Time-Stamp: Thu, 25 Sep 2003 19:40:58 +0200 : Message contains [1] file attachments -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL powered MailServer
Try here http://www.lencom.com/desc/indexN16185.html -Original Message- From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 1:18 PM To: [EMAIL PROTECTED] Subject: MySQL powered MailServer Just wanted to know if anyone knows the status of the MySQL powered Mailserver found at http://www.mysql.com/portal/software/item-239.html Thanks, __ NZEYIMANA Emery Fabrice NEFA Computing Services, Inc. P.O. Box 5078 Kigali Office Phone: +250-51 11 06 Office Fax: +250-50 15 19 Mobile: +250-08517768 Email: [EMAIL PROTECTED] http://www.nefacomp.net/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL powered MailServer
Or not, try here instead http://gd.tuwien.ac.at/graphics/sf/h/hmailserver/ -Original Message- From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 1:18 PM To: [EMAIL PROTECTED] Subject: MySQL powered MailServer Just wanted to know if anyone knows the status of the MySQL powered Mailserver found at http://www.mysql.com/portal/software/item-239.html Thanks, __ NZEYIMANA Emery Fabrice NEFA Computing Services, Inc. P.O. Box 5078 Kigali Office Phone: +250-51 11 06 Office Fax: +250-50 15 19 Mobile: +250-08517768 Email: [EMAIL PROTECTED] http://www.nefacomp.net/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Ideas on creating connections
Although I would love to share the code for this recordset, unfortunately, it is not completely ready for dissemination at this time. At some time in the future, I will release it under a GPL license but there is still quite a bit of work. I use recordset in the vaguest of terms as it somewhat acts as a recordset within VB. There is however no control binding and at the moment, you have to have a table with an auto_increment column for updating. Also, it is a per connection recordset, so every instance of the recordset creates a new connection to the server. (This is the part I am working on now, as it definately needs updating). Roger -Original Message- From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 1:41 PM To: Roger Davis; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Ideas on creating connections Thank you for your time. I don't want to be too much demanding. I currently have a problem with MyODBC 3.51. When my client machine is set to use French numbers (with a COMMA instead of a PERIOD or DOT for floats), MyODBC does not let the decimal part to pass. Venu told me he will try to look into this before the next release. It seems I am impatient!!! You said you are trying to move from DAO to using the MySQL DLL (libmysql.dll). Can we share some code using VB and the DLL? Just send me a piece of code doing the following: = - Creating a connection to the MySQL server, - Running a DELETE query on the server (or any other query that doesn't need to return values) - Running a SELECT query against the MySQL server and - Populating data of the RecordSet creating into a Flex grid - Closing and Distroying the RecordSet - Closing and Distroying the Connection = One time I saw such a code on http://www.vbmysql.com but it seems to have dissappeared. Thanks Emery - Original Message - From: Roger Davis [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 19:08 Subject: RE: Ideas on creating connections DAO is, I guess you would say, the predessor to ADO. I am currently in the process of getting rid of all the DAO code in the application and moving to a custom recordset using the libmysql.dll. Some of this is done in VB and it is still extremely fast for a VB based recordset. Although there are numerous ways to do this, it is really difficult to tell what would be the best in your situation. As has been mentioned before, if you are doing queries one after another in your application, then by all means connect once and pass all the queries through that connection. If you a making very few queries and you have limited resources on the server, then it would be best to connect only when you need to and drop the connection when you are done. These are of course only my opinions based on what I have experienced in the past. Your experience may vary. Void where prohibited. Roger -Original Message- From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 12:48 PM To: Roger Davis; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Ideas on creating connections I never use DAO. Is there any benefit over ADO? Thanks Emery - Original Message - From: Roger Davis [EMAIL PROTECTED] To: Director General: NEFACOMP [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 18:14 Subject: RE: Ideas on creating connections My experience is this. I use DAO through MyODBC, and I also use the libmysql.dll with a custom recordset. Connection times through both options are extremely fast. Fast enough in my situation that it can basically can be ignored. There are times when I open several connections to the server at once and have yet to run into any problems. If you strictly want to use ADO though, I would suggest that you open one connection to the server and process your queries through that connection. Leave it open for the life of the program. While the program is open, the connection to the server will stay open and the thread for MySQL will be a sleep. Just my $0.02. Roger -Original Message- From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 11:57 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Ideas on creating connections Hi groups, I need some experienced users to guide me on this issue. I am developping an Application that will be accessing a MySQL database through MyODBC. The application is developped using Visual Basic. Since my application will be used simultaneously by more than 200 users, I want to know the implication of using one of the following
Re: No valid command found
me too !!! - Original Message - From: Director General: NEFACOMP [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 1:52 PM Subject: Fw: No valid command found Is everyone on the list receiving the message below? It is coming to me every time I send a message to the mysql list Thanks Emery - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 20:04 Subject: No valid command found Your message does not contain a valid command for this mail server to process. No action has been taken. Message-Id: [EMAIL PROTECTED] From: [EMAIL PROTECTED] Time-Stamp: Thu, 25 Sep 2003 19:40:58 +0200 : Message contains [1] file attachments -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connect to 4.1 using MyOBDC
Seems to be a problem with the fact that the server is on a Linux box. I was having this problem connecting the mysql command environment to the linux server until I added -protocol=TCP to the login statement. Or maybe it's just that we use a TCP/IP network (doesn't everybody?). Anyway, my test user is using Win2K, accessing the MySQL server which resides on a Redhat 9 linux box. We are on the same network domain inside the firewall. Essentially, I believe I need some way to tell the ODBC driver (and also the mysql command center and the command line) that the protcol is TCP. Is their an environment variable that would do this? This is starting to make me look bad... Thanks. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL powered MailServer
It seems the developpers are no longer doing any work on this server. Their website is empty: http://www.halvar.com/ Thanks Emery - Original Message - From: Luc Foisy [EMAIL PROTECTED] To: Director General: NEFACOMP [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 19:51 Subject: RE: MySQL powered MailServer Try here http://www.lencom.com/desc/indexN16185.html -Original Message- From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 1:18 PM To: [EMAIL PROTECTED] Subject: MySQL powered MailServer Just wanted to know if anyone knows the status of the MySQL powered Mailserver found at http://www.mysql.com/portal/software/item-239.html Thanks, __ NZEYIMANA Emery Fabrice NEFA Computing Services, Inc. P.O. Box 5078 Kigali Office Phone: +250-51 11 06 Office Fax: +250-50 15 19 Mobile: +250-08517768 Email: [EMAIL PROTECTED] http://www.nefacomp.net/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Connect to 4.1 using MyOBDC
I can connect to my v4.1 MySQL server from Crystal Reports v8.5 using MyODBC v3.51. (Via selecting my DSN from the list of ODBC DSNs that Crystal shows me). -Holly -Original Message- From: Randy Chrismon [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 10:21 AM To: [EMAIL PROTECTED] Subject: Connect to 4.1 using MyOBDC Please tell me it ain't so! My test user is using MyOBDC to connect to our 4.1.0 alpha server. She will be creating some Crystal Reports from the data. Her test DSN fails on an incompatible protocol error with a message that she should upgrade to the newest client. Do I have to download bitkeeper, a C compiler, and learn how to use them to get an OBCD driver that will work with our server? Thanks Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL - foreign-keys - OpenOffice.org
Hi, I asked sometimes ago - I'ld be happy, if some of you knows an answer: does anybody uses OpenOffice.org with mysql and can start there the gui for foreignkeys? Kind regards Dieter -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
replication setting
Hi, I have question on replication setting in my.cnf what is the difference between relay-log and relay-log-index? If I do not set them, what will happen? thanks Hsiu-Hui -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
speed of cross-database queries
Hello, I'm doing this some in my application, and was wondering if anyone had any ideas about the efficiency of cross-database queries: Select * from db1.poems left join db2.users on poems.mid = users.mid My runtime variables do show 319 'change db' queries - but I don't know if that invalidates cached tables, indexes, or if its not a big deal at all... Ciao, Kevin Watt Community Manager, Allpoetry.com How do really small people call each other ? On Microphones How do you fix a broken chimp? With a monkey wrench -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: replication setting
These options are used to specify the location of the respective files. If you do not set them they go to your datadir e.g. /var/lib/mysql http://www.mysql.com/doc/en/Replication_Options.html relay-log=filename To specify the location and name that should be used for relay logs. You can use this to have hostname-independant relay log names, or if your relay logs tend to be big (and you don't want to decrease max_relay_log_size) and you need to put them on some area different from the data directory, or if you want to increase speed by balancing load between disks. relay-log-index=filename To specify the location and name that should be used for the relay logs index file - Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688 ---Original Message- --From: Hsiu-Hui Tseng [mailto:[EMAIL PROTECTED] --Sent: Thursday, September 25, 2003 11:28 AM --To: [EMAIL PROTECTED] --Subject: replication setting -- --Hi, -- --I have question on replication setting in my.cnf -- --what is the difference between relay-log and relay-log-index? If I do not --set them, what will happen? -- --thanks -- --Hsiu-Hui -- -- --MySQL General Mailing List --For list archives: http://lists.mysql.com/mysql --To unsubscribe: --http://lists.mysql.com/[EMAIL PROTECTED]
mysqld error
Folks, When I try to start MySQL the mysqld just crashes. I looked at /usr/lib/mysql/{hostname}.err file and I see the following: 030925 10:01:47 mysqld started 030925 10:01:47 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 030925 10:01:47 mysqld ended I can not make heads or tails out of what it is trying to tell me, or where the ./mysql/host.frm file is. Does anyone know? Joseph Donato -- Joseph Donato RUCS-NB Help Desk [EMAIL PROTECTED] 732-445-8706 A witty saying proves nothing, but saying something pointless gets people's attention -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: speed of cross-database queries
On Thu, Sep 25, 2003 at 11:46:49AM -0700, Kevin wrote: Hello, I'm doing this some in my application, and was wondering if anyone had any ideas about the efficiency of cross-database queries: Select * from db1.poems left join db2.users on poems.mid = users.mid They're no slower than cross-table queries in the same database. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 11 days, processed 428,759,895 queries (420/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
CAST with UNION
Hello, I am trying to select records from two tables, all the fields in both tables are varchar's but some of the fields I would like returned as DATETIME types. I have no problem using the CAST(field as DATETIME) function on one table, but as soon as I try to union two selects the CAST no longer functions. Does anyone have any sugestions on how to get around this problem. Here is a simplified query that i cant get to work and the original I simplified from. The main goal of the query is to select all records from both tables where the ID is uinique(it can be repeated in both tables, and I only want one copy of the record). Thank you for any help you might give. SIMPLIFIED (SELECT CAST(Patients.PatientDateTimeofBirth as DATETIME) AS patBirthDate FROM Patients) UNION (SELECT CAST(Orders.PatientDateTimeofBirth as DATETIME) AS patBirthDate FROM Orders) FULL QUERY ( SELECT Patients.PatientIDInternal AS patID, CAST(Patients.PatientDateTimeofBirth as DATETIME) AS patBirthDate, Patients.PatientIDInternal AS hisUnique FROM Patients LEFT JOIN Orders USING(PatientIDInternal) WHERE Patients.Imported = 1) UNION (SELECT Orders.PatientIDInternal AS patID, CAST(Orders.PatientDateTimeofBirth as DATETIME) AS patBirthDate, Orders.PatientIDInternal AS hisUnique FROM Orders LEFT JOIN Patients USING(PatientIDInternal) WHERE Patients.PatientIDInternal IS NULL AND Orders.PatientImported = 1) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysqld error
---Original Message- --From: Joseph Donato [mailto:[EMAIL PROTECTED] --Sent: Thursday, September 25, 2003 12:12 PM --To: [EMAIL PROTECTED] --Subject: mysqld error -- --Folks, -- --When I try to start MySQL the mysqld just crashes. I looked at --/usr/lib/mysql/{hostname}.err file and I see the following: -- --030925 10:01:47 mysqld started --030925 10:01:47 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' --(errno: 13) --030925 10:01:47 mysqld ended -- --I can not make heads or tails out of what it is trying to tell me, or --where the ./mysql/host.frm file is. Does anyone know? The host.frm file is the column definition file for lack of a better explanation. It's usually located in the datadir set by /etc/my.cnf. Look in /var/lib/mysql it might be there. Also set datadir correctly. -- -- Joseph Donato Joseph Donato RUCS-NB Help Desk [EMAIL PROTECTED] --732-445-8706 A witty saying proves nothing, but saying something --pointless gets people's attention -- -- -- --MySQL General Mailing List --For list archives: http://lists.mysql.com/mysql --To unsubscribe: --http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Noob Question: Error 1046
Evenin', Sorry to send noob questions, I know how annoying they can be, but we need help too ;) Anyways, Im using a self teach book to teach myself PHP, MySQL and Apache. The book is getting into MySQL and basic commands. Anyways, they gave an example, and I typed it in as shown in the book, but I get an error. I took a screenshot (I thought that would be easier) and posted it here: http://hostultra.org/brewer/mysql.jpg Any help would be very much so appreciated, thanks.
Re: MySQL powered MailServer
I don't know about the hMailServer, but you may look at dbMail too (dbmail.org). You can use MySQL or PostgresSQL as the backend. Although I think it's only for Unix/Linux systems. I've been meaning to try setting it up on OSX, but haven' gotten around to it yet. On Thursday, September 25, 2003, at 01:17 PM, Director General: NEFACOMP wrote: Just wanted to know if anyone knows the status of the MySQL powered Mailserver found at http://www.mysql.com/portal/software/item-239.html -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Multiple tablespace + subqueries
Hello all, We want to use MySQL (InnoDB) for a corporate/non-stop environment, but we really want/need multiple tablespace support + subqueries. When will both be available for a production environment? Only in 4.1.x? Any date? Thank you! Eduardo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: No valid command found
I know I have been. Adam Clauss [EMAIL PROTECTED] -Original Message- From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 12:52 PM To: [EMAIL PROTECTED] Subject: Fw: No valid command found Is everyone on the list receiving the message below? It is coming to me every time I send a message to the mysql list Thanks Emery - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 20:04 Subject: No valid command found Your message does not contain a valid command for this mail server to process. No action has been taken. Message-Id: [EMAIL PROTECTED] From: [EMAIL PROTECTED] Time-Stamp: Thu, 25 Sep 2003 19:40:58 +0200 : Message contains [1] file attachments -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hung Threads and Connection Reset Error
Ive been fighting some strange demons and I think they may be related. I am trying to benchmark our application by load testing with various numbers of users and threads. App is java/jsp and architecture is Tomcat and Mysql. Platform is Mac jaguar. First off I had the Too Many Open files error message. I got rid of this by changing the descriptors on the mac by typing (from shell) limit descriptors 2048. I also increased maxprocs by limit maxprocs 400. Open file issue went away... However, in its place I got a less nasty error, that did not knock over tomcat, Connection reset by Peer. This error I have researched and have not come up with a solution yet. However, I did find that mysql by design caches threads. So, what I Have is a database with large numbers of sleeping threads as seen by typing show processlist within mysql. No prob right? WRONG... If I dont bounce the database, the sleeping thread count keeps increasing and finally hangs mysql and tomcat falls over. These sleeping processes are holding resources, my thoughts are holding some connections. More searching leads me to adjust wait_timeout and interactive_timeout to something less than its default setting. According to the Mysql manual and a similar thread on this topic in the archives, this should remove the sleeping threads after the adjusted amount of timeout. However, the threads DO NOT get removed after the adjusted amount of timeout. They stay sleeping. My question is twofold: Can the cause of the Connection reset by peer be caused by sleeping processes taking up resources? If not what could cause this? How do I get rid of the sleeping threads = __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Noob Question: Error 1046
Charlie Brewer wrote: http://hostultra.org/brewer/mysql.jpg 'Error 1046: No Database Selected' means just that :-) So you have to select one -- see http://www.mysql.com/doc/en/USE.html HTH! -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqld error
Error 13 means that the file exista, but mysql has no permissions for the file. Make sure mysql is the owner of the data directory and all its subdirectories and files. Joseph Donato wrote: Folks, When I try to start MySQL the mysqld just crashes. I looked at /usr/lib/mysql/{hostname}.err file and I see the following: 030925 10:01:47 mysqld started 030925 10:01:47 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 030925 10:01:47 mysqld ended I can not make heads or tails out of what it is trying to tell me, or where the ./mysql/host.frm file is. Does anyone know? Joseph Donato -- Joseph Donato RUCS-NB Help Desk [EMAIL PROTECTED] 732-445-8706 A witty saying proves nothing, but saying something pointless gets people's attention -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
# processes vs. #threads, and memory usage
Hello, When I start mysql, the processlist shows 10 processes: Ps aux | grep mysql | wc -l 10 But 'mytop' (handy command line utility to see processes) shows only the number of threads I'm using. Anyone know why its using 10 processes if it only has 1 thread? I'm not familiar with how 'ps' tries to report on threads (since mysql technically supposedly has only 1 process). Is it doing something wrong? My main concern is for the reported memory usage. If ps is right, and it IS using that memory, what is it doing? 1 31454 mysql23M 2.1M 108M 23M 34819 S mysqld 2 31456 mysql23M 2.1M 108M 23M 34819 S mysqld .. continue until .. 29 31639 mysql23M 2.1M 108M 23M 34819 S mysqld 30 31709 mysql23M 2.1M 108M 23M 34819 S mysqld Thanks, Kevin Watt Community Manager, Allpoetry.com What happened to the cow who went for a drive? He got a Moo_ving violation What do you call someone who is crazy about hot chocolate? A cocoa nut What do bees use to cut wood? Buzz saws Who eats at underwater resturants ? Suba diners How do really small people call each other ? On Microphones How do you fix a broken chimp? With a monkey wrench -Original Message- From: Charlie Brewer [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 12:13 PM To: [EMAIL PROTECTED] Subject: Noob Question: Error 1046 Evenin', Sorry to send noob questions, I know how annoying they can be, but we need help too ;) Anyways, Im using a self teach book to teach myself PHP, MySQL and Apache. The book is getting into MySQL and basic commands. Anyways, they gave an example, and I typed it in as shown in the book, but I get an error. I took a screenshot (I thought that would be easier) and posted it here: http://hostultra.org/brewer/mysql.jpg Any help would be very much so appreciated, thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysql compile error.
I've installed now mysql-4.0.14 without any problems. So I think it's something about the .15 version. Does anyone know a thing about it? With kind regards, Richard Pijnenburg -Original Message- From: Richard Pijnenburg [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 3:28 PM To: [EMAIL PROTECTED] Subject: mysql compile error. i'm trying to compile mysql-4.0.15a on my server and i'm getting the folowing error: gcc -DDEFAULT_CHARSET_HOME=\/usr/local/mysql\ -DDATADIR=\/data/mysql\ -DSHAREDIR=\/usr/local/mysql/share/mysql\ -DUNDEF_THREADS_HACK -DDONT_USE_RAID -DMYSQL_CLIENT -I. -I. -I.. -I./../include -I../include -I./.. -I.. -I.. /usr/local/openssl/include -O3 -DDBUG_OFF -c libmysql.c -MT libmysql.lo -MD -MP -MF .deps/libmysql.TPlo -fPIC -DPIC -o .libs/libmysql.lo gcc: cannot specify -o with -c or -S and multiple compilations make[2]: *** [libmysql.lo] Error 1 make[2]: Leaving directory `/usr/local/src/web/mysql-4.0.15a/libmysql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/local/src/web/mysql-4.0.15a' make: *** [all] Error 2 my configure command is this: ./configure \ --prefix=/usr/local/mysql \ --localstatedir=/data/mysql \ --enable-large-files \ --with-innodb \ --with-mysqld-user=mysql \ --disable-maintainer-mode \ --without-docs \ --without-debug \ --without-bench \ --enable-assembler \ --with-openssl=/usr/local/openssl \ --with-openssl-includes=/usr/local/openssl/include \ --with-openssl-libs=/usr/local/openssl/lib \ --with-named-z-libs=/usr/local/zlib/lib thanks in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql compile error.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Thu, 25 Sep 2003, Richard Pijnenburg wrote: i'm trying to compile mysql-4.0.15a on my server and i'm getting the folowing error: gcc -DDEFAULT_CHARSET_HOME=\/usr/local/mysql\ -DDATADIR=\/data/mysql\ -DSHAREDIR=\/usr/local/mysql/share/mysql\ -DUNDEF_THREADS_HACK -DDONT_USE_RAID -DMYSQL_CLIENT -I. -I. -I.. -I./../include -I../include -I./.. -I.. -I.. /usr/local/openssl/include -O3 -DDBUG_OFF -c libmysql.c -MT libmysql.lo -MD -MP -MF .deps/libmysql.TPlo -fPIC -DPIC -o .libs/libmysql.lo gcc: cannot specify -o with -c or -S and multiple compilations make[2]: *** [libmysql.lo] Error 1 make[2]: Leaving directory `/usr/local/src/web/mysql-4.0.15a/libmysql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/local/src/web/mysql-4.0.15a' make: *** [all] Error 2 my configure command is this: ./configure \ --prefix=/usr/local/mysql \ --localstatedir=/data/mysql \ --enable-large-files \ --with-innodb \ --with-mysqld-user=mysql \ --disable-maintainer-mode \ --without-docs \ --without-debug \ --without-bench \ --enable-assembler \ --with-openssl=/usr/local/openssl \ --with-openssl-includes=/usr/local/openssl/include \ --with-openssl-libs=/usr/local/openssl/lib \ --with-named-z-libs=/usr/local/zlib/lib I think you need to install libtool to be able to successfully compile this. Please give it a try. Bye, LenZ - -- Lenz Grimmer [EMAIL PROTECTED] Senior Production Engineer MySQL GmbH, http://www.mysql.de/ Hamburg, Germany For technical support contracts, visit https://order.mysql.com/?ref=mlgr -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2 (GNU/Linux) Comment: For info see http://quantumlab.net/pine_privacy_guard/ iD8DBQE/c1b3SVDhKrJykfIRAt8+AJ48Y4CxHEjdLDZA7b0xVXn8/beTVwCbBVQQ W3+jVl+iTSVKqDejinKXxVM= =AEUA -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Low-Level access to MySQL data
Hello all, Has anybody had experience accessing MySQL tables via MyISAM library? I'm working on an application that has to have both SQL-like and ISAM-like (file-level) access to the table data. I thought that using MyISAM directly would be a good idea. If anybody has any better suggestions, I am all ears. Also, I was wondering if it's possible to use Berkeley DB tools and libraries to access MySQL data files, which are set to use BDB as the storage engine. If it is, can somebody point me at some examples (except what's in the source already). I have read several posts on the list from Sinisa and Sergei concerning use of HANDLER keyword, and there was one in early 2001 in which Sergei said that syntax for HANDLER WRITE and HANDLER DELETE was implemented as well. He then went on to say that he was wrong and only the read access was implemented via HANDLER. He also said that this might be a project for the future. Has there been any progress in that area? Thanks in advance. Regards, Mark. P.S. Both C/C++ and Delphi examples/URLs/pointers/ideas will work.
Re: # processes vs. #threads, and memory usage
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Thu, 25 Sep 2003, Kevin wrote: When I start mysql, the processlist shows 10 processes: Ps aux | grep mysql | wc -l 10 On Linux (I assume this is what we're talking about here), threads are shown as separate processes, too. On other OS'es you will only see one mysqld process in the process table. But 'mytop' (handy command line utility to see processes) shows only the number of threads I'm using. Yes, but only the threads that serve client requests. The MySQL daemon spawns a few other helper threads as well (e.g. some for InnoDB, some for replication). These are not shown in mytop, but the OS process list (if it supports showing threads as well) Anyone know why its using 10 processes if it only has 1 thread? I'm not familiar with how 'ps' tries to report on threads (since mysql technically supposedly has only 1 process). Is it doing something wrong? No, you're all fine. No worries :) My main concern is for the reported memory usage. If ps is right, and it IS using that memory, what is it doing? 1 31454 mysql23M 2.1M 108M 23M 34819 S mysqld 2 31456 mysql23M 2.1M 108M 23M 34819 S mysqld .. continue until .. 29 31639 mysql23M 2.1M 108M 23M 34819 S mysqld 30 31709 mysql23M 2.1M 108M 23M 34819 S mysqld That's the total number of memory for the mysqld process including all it's threads - it's just being repeated for every thread. Bye, LenZ - -- Lenz Grimmer [EMAIL PROTECTED] Senior Production Engineer MySQL GmbH, http://www.mysql.de/ Hamburg, Germany For technical support contracts, visit https://order.mysql.com/?ref=mlgr -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2 (GNU/Linux) Comment: For info see http://quantumlab.net/pine_privacy_guard/ iD8DBQE/c1kfSVDhKrJykfIRAmAeAJ9cvDKYQdOfqnScgN0HV68TTEb1wgCeNd8n TBF7g3cUQMYewTjv1tdgHtY= =5GT8 -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL powered MailServer
Never heard of that one, you might try http://www.dbmail.org Curtis On Thu, 25 Sep 2003, Director General: NEFACOMP wrote: It seems the developpers are no longer doing any work on this server. Their website is empty: http://www.halvar.com/ Thanks Emery - Original Message - From: Luc Foisy [EMAIL PROTECTED] To: Director General: NEFACOMP [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 19:51 Subject: RE: MySQL powered MailServer Try here http://www.lencom.com/desc/indexN16185.html -Original Message- From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 1:18 PM To: [EMAIL PROTECTED] Subject: MySQL powered MailServer Just wanted to know if anyone knows the status of the MySQL powered Mailserver found at http://www.mysql.com/portal/software/item-239.html Thanks, __ NZEYIMANA Emery Fabrice NEFA Computing Services, Inc. P.O. Box 5078 Kigali Office Phone: +250-51 11 06 Office Fax: +250-50 15 19 Mobile: +250-08517768 Email: [EMAIL PROTECTED] http://www.nefacomp.net/ -- -- Curtis Maurand mailto:[EMAIL PROTECTED] http://www.maurand.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: # processes vs. #threads, and memory usage
On Thu, Sep 25, 2003 at 01:18:12PM -0700, Kevin wrote: Hello, When I start mysql, the processlist shows 10 processes: Ps aux | grep mysql | wc -l 10 But 'mytop' (handy command line utility to see processes) shows only the number of threads I'm using. Anyone know why its using 10 processes if it only has 1 thread? I'm not familiar with how 'ps' tries to report on threads (since mysql technically supposedly has only 1 process). Is it doing something wrong? MySQL has a few threads that don't interact directly with clients. Are you using InnoDB? It adds a few more. My main concern is for the reported memory usage. If ps is right, and it IS using that memory, what is it doing? 1 31454 mysql23M 2.1M 108M 23M 34819 S mysqld 2 31456 mysql23M 2.1M 108M 23M 34819 S mysqld .. continue until .. 29 31639 mysql23M 2.1M 108M 23M 34819 S mysqld 30 31709 mysql23M 2.1M 108M 23M 34819 S mysqld They're threads. The memory is shared among them. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 11 days, processed 433,239,956 queries (422/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Multiple tablespace + subqueries
On Thu, Sep 25, 2003 at 04:35:29PM -0300, Eduardo D Piovesam wrote: Hello all, We want to use MySQL (InnoDB) for a corporate/non-stop environment, but we really want/need multiple tablespace support + subqueries. When will both be available for a production environment? Only in 4.1.x? Yes, in 4.1. Any date? Nope. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 11 days, processed 433,272,496 queries (422/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Noob Question: Error 1046
Ah apparently this silly book skipped that step. So when I do databases I get mysql and nuke. And figuring out how to make a new one wasnt very hard heh. Thanks, plenty more noob questions to come im sure :) - Original Message - From: Parker Morse [EMAIL PROTECTED] To: Charlie Brewer [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 3:09 PM Subject: Re: Noob Question: Error 1046 On Thursday, Sep 25, 2003, at 15:12 US/Eastern, Charlie Brewer wrote: and basic commands. Anyways, they gave an example, and I typed it in as shown in the book, but I get an error. I took a screenshot (I thought that would be easier) and posted it here: http://hostultra.org/brewer/mysql.jpg [The image shows Welcome to MySQL Monitor etc., the first command is a valid CREATE TABLE instruction, followed by ERROR 1046: No database selected] In order to create a table, MySQL needs to know which database to put it in. Since we can't see the command line you put in to execute, it's tough to know if you've actually got databases available, but assuming you do and you know which they are, you'd give the command mysql use [database]; before your CREATE, so you're in the relevant database. If you don't know which databases you have available, try mysql show databases; and see what happens. Like this (munged, obviously): [root bluebird]# mysql -h raven.example.com -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 39944 to server version: 4.0.14-standard-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show databases; +---+ | Database | +---+ | mysql | | test | +---+ 7 rows in set (0.04 sec) mysql use test; Database changed pjm -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Udf_Example.so compilation error with gcc
Hello All, I am trying to compile udf_example.cc or myfunc.cc (copy of udf_example) with gcc on Solaris 2.8 but facing following errors [EMAIL PROTECTED]:/usr/local/mysql-4.0.14/sqlgcc -shared -I/usr/local/mysql-4.0.14/include -o myfunc.so myfunc.cc In file included from myfunc.cc:122: /usr/local/mysql-4.0.14/include/my_global.h:70:23: my_config.h: No such file or directory In file included from myfunc.cc:122: /usr/local/mysql-4.0.14/include/my_global.h:456: syntax error before `;' token /usr/local/mysql-4.0.14/include/my_global.h:701: syntax error before string constant /usr/local/mysql-4.0.14/include/my_global.h:781: redeclaration of C++ built-in type `bool' In file included from myfunc.cc:123: /usr/local/mysql-4.0.14/include/my_sys.h:593: `func' was not declared in this scope /usr/local/mysql-4.0.14/include/my_sys.h:593: type specifier omitted for parameter `RETSIGTYPE()()' /usr/local/mysql-4.0.14/include/my_sys.h:593: invalid declarator /usr/local/mysql-4.0.14/include/my_sys.h:644: syntax error before `(' token /usr/local/mysql-4.0.14/include/my_sys.h:654: syntax error before `(' token /usr/local/mysql-4.0.14/include/my_sys.h:658: syntax error before `(' token I tried through make also. See below [EMAIL PROTECTED]:/usr/local/mysql-4.0.14/sql/usr/ccs/bin/make udf_example.o source='udf_example.cc' object='udf_example.o' libtool=no \ depfile='.deps/udf_example.Po' tmpdepfile='.deps/udf_example.TPo' \ depmode=none /bin/bash ../depcomp \ gcc -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr/local/mysql-4.0.14\ -DDATADIR=\/usr/local/mysql-4.0.14/var\ -DSHAREDIR=\/usr/local/mysql-4.0.14/share/mysql\ -DHAVE_CONFIG_H -I. -I. -I.. -I../innobase/include -I./../include -I./../regex -I. -I../include -I. -O3 -DDBUG_OFF -O3 -m64 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -fno-implicit-templates -fno-exceptions -fno-rtti -DUSE_MYSYS_NEW -DDEFINE_CXA_PURE_VIRTUAL -D_FILE_OFFSET_BITS=64 -DHAVE_CURSES_H -I/usr/local/mysql-4.0.14/include -DHAVE_RWLOCK_T -c -o udf_example.o `test -f udf_example.cc || echo './'`udf_example.cc In file included from udf_example.cc:122: ../include/my_global.h:70:23: my_config.h: No such file or directory In file included from udf_example.cc:122: ../include/my_global.h:456: syntax error before `;' token ../include/my_global.h:701: syntax error before string constant ../include/my_global.h:781: redeclaration of C++ built-in type `bool' In file included from udf_example.cc:123: ../include/my_sys.h:593: `func' was not declared in this scope ../include/my_sys.h:593: type specifier omitted for parameter `RETSIGTYPE()()' ../include/my_sys.h:593: invalid declarator ../include/my_sys.h:644: syntax error before `(' token ../include/my_sys.h:654: syntax error before `(' token ../include/my_sys.h:658: syntax error before `(' token *** Error code 1 make: Fatal error: Command failed for target `udf_example.o' Just for testing I commented out the code at error line number and got udf_example.so or myfunc.so file but when I tried to create function in mysql, it gave following error mysql CREATE FUNCTION myfunc_int RETURNS INTEGER SONAME myfunc.so; ERROR 1126: Can't open shared library 'myfunc.so' (errno: 0 ld.so.1: /usr/local/mysql-standard-4.0.14-sun-solaris2.8-sparc-6) Any tip will be highly appreciable. Regards, Sagar, Sanjeev.vcf -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Ideas on creating connections
try adding a '\' before the comma like a \n in c++ -Original Message- From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 10:41 AM To: Roger Davis; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Ideas on creating connections Thank you for your time. I don't want to be too much demanding. I currently have a problem with MyODBC 3.51. When my client machine is set to use French numbers (with a COMMA instead of a PERIOD or DOT for floats), MyODBC does not let the decimal part to pass. Venu told me he will try to look into this before the next release. It seems I am impatient!!! You said you are trying to move from DAO to using the MySQL DLL (libmysql.dll). Can we share some code using VB and the DLL? Just send me a piece of code doing the following: = - Creating a connection to the MySQL server, - Running a DELETE query on the server (or any other query that doesn't need to return values) - Running a SELECT query against the MySQL server and - Populating data of the RecordSet creating into a Flex grid - Closing and Distroying the RecordSet - Closing and Distroying the Connection = One time I saw such a code on http://www.vbmysql.com but it seems to have dissappeared. Thanks Emery - Original Message - From: Roger Davis [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 19:08 Subject: RE: Ideas on creating connections DAO is, I guess you would say, the predessor to ADO. I am currently in the process of getting rid of all the DAO code in the application and moving to a custom recordset using the libmysql.dll. Some of this is done in VB and it is still extremely fast for a VB based recordset. Although there are numerous ways to do this, it is really difficult to tell what would be the best in your situation. As has been mentioned before, if you are doing queries one after another in your application, then by all means connect once and pass all the queries through that connection. If you a making very few queries and you have limited resources on the server, then it would be best to connect only when you need to and drop the connection when you are done. These are of course only my opinions based on what I have experienced in the past. Your experience may vary. Void where prohibited. Roger -Original Message- From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 12:48 PM To: Roger Davis; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Ideas on creating connections I never use DAO. Is there any benefit over ADO? Thanks Emery - Original Message - From: Roger Davis [EMAIL PROTECTED] To: Director General: NEFACOMP [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 18:14 Subject: RE: Ideas on creating connections My experience is this. I use DAO through MyODBC, and I also use the libmysql.dll with a custom recordset. Connection times through both options are extremely fast. Fast enough in my situation that it can basically can be ignored. There are times when I open several connections to the server at once and have yet to run into any problems. If you strictly want to use ADO though, I would suggest that you open one connection to the server and process your queries through that connection. Leave it open for the life of the program. While the program is open, the connection to the server will stay open and the thread for MySQL will be a sleep. Just my $0.02. Roger -Original Message- From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003 11:57 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Ideas on creating connections Hi groups, I need some experienced users to guide me on this issue. I am developping an Application that will be accessing a MySQL database through MyODBC. The application is developped using Visual Basic. Since my application will be used simultaneously by more than 200 users, I want to know the implication of using one of the following methods for connecting to the server: 1. At logon, I create a connection to the server and maintain it throught the application life. By the application life I mean that the connection stays open as long as the application is loaded in the memory. So, for a user who is online for 3 hours, the connection is on for those three hours, even if the user goes out for a coffee. 2. I create a connection only when a query is about to be sent to the server. That means, I create a connection when I want to create an ADO recordset and run a query against the server. After running my query, I distroy the connection. Currently I am using the first option since I don't
REFERENCES question in mySQL 4.1 - Take 2
First, my apologies. I originally posted this to the mailing.databases.mysql newsgroup, not realizing that the newsgroup is just mirror of the mailing list. I have since figured out the answer to my second question (I think) - see below. My answer is: The Primary Key specification creates an index that the foreign key uses. I STILL have my first question - see below: I have two questions about REFERENCES: 1. It appears that mySQL treats REFERENCES associated with an attribute differently than FOREIGN KEY (blah) REFERENCES... Specifically, the first form does not appear to work, while the later does. Here's a simple example (slightly edited): mysql CREATE TABLE person (id char(5) primary key); Query OK, 0 rows affected (0.04 sec) mysql CREATE TABLE phone (id char(5) not null REFERENCES person(id), num char(10) not null, PRIMARY KEY (id, num)); Query OK, 0 rows affected (0.06 sec) mysql show create table phone; | phone | CREATE TABLE `phone` ( `id` char(5) NOT NULL default '', `num` char(10) NOT NULL default '', PRIMARY KEY (`id`,`num`) ) TYPE=InnoDB CHARSET=latin1 | 1 row in set (0.00 sec) mysql insert into phone value ('foo', 'bar'); Query OK, 1 row affected (0.04 sec) It appears that the constraint is not created and is certainly not enforced. Now consider what should be the same phone table. mysql drop table phone; Query OK, 0 rows affected (0.29 sec) mysql CREATE TABLE phone (id char(5) not null, num char(10) not null, PRIMARY KEY (id, num), FOREIGN KEY (id) REFERENCES person(id)); Query OK, 0 rows affected (0.09 sec) mysql show create table phone; | Table | Create Table | phone | CREATE TABLE `phone` ( `id` char(5) NOT NULL default '', `num` char(10) NOT NULL default '', PRIMARY KEY (`id`,`num`), FOREIGN KEY (`id`) REFERENCES `person` (`id`) ) TYPE=InnoDB CHARSET=latin1 | 1 row in set (0.00 sec) mysql insert into phone values ('foo', 'bar'); ERROR 1216: Cannot add or update a child row: a foreign key constraint fails Why are these different? 2. In the manual (and in several posts), it clearly states (see Section 7.5.4.2 of the 4.1.0-alpha manual) Both tables have to be InnoDB type and there must be an index where the foreign key and the referenced key are listed as the FIRST columns However, I did not create an indicies, but it worked. What's up? Thanks in advance __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql Problem in Windows 2000 advanced server
At 12:33 25/9/2003 +0900, Ganbold wrote: Hi, I installed mysql-4.0.15 in Windows 2000 Advanced server. Mysql-max-nt is working fine, except some problems. Sometimes when I try to use access web pages through php pages, mysql says Connection to server lost or Can't connect to mysql server or sometimes query error. Query is tested and works fine most of the time. And when I refresh web page again everything works fine. Mysql log says nothing. Is it problem related to mysql in Windows? Also I tested small C program to query mysql tables and it sometimes hangs. Is there any solution for this kind of problem? From the mysql.exe client: (C) Copyright 1985-2000 Microsoft Corp. c:\c:\mysql\bin\mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 4.0.15-max-nt-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show variables like %timeout%; +--+---+ | Variable_name| Value | +--+---+ | connect_timeout | 5 | | delayed_insert_timeout | 300 | | innodb_lock_wait_timeout | 50| | interactive_timeout | 28800 | | net_read_timeout | 30| | net_write_timeout| 60| | slave_net_timeout| 3600 | | wait_timeout | 28800 | +--+---+ 8 rows in set (0.01 sec) You can see above the net_read_timeout and net_write_timeout, if you are having queries that takes more than 30 seconds the server disconnect the client because the client remains passive and that time exceeds the net_read_timeout. From 4.0.15 was introduced for socket time outs that before on Windows didn't worked. So try to configure your server starting it with a more high value than the default according with the necessities. However, when retrieved with a client 4.0.15 the above don't works, please read: http://bugs.mysql.com/bug.php?id=1370 for further details and follow up. -- Regards, For technical support contracts, visit https://order.mysql.com/ Are you MySQL certified?, http://www.mysql.com/certification/ Miguel Angel Solórzano [EMAIL PROTECTED] São Paulo - Brazil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: REFERENCES question in mySQL 4.1 - Take 2
Ed, InnoDB does not support the 'short' syntax: CREATE TABLE phone (id char(5) not null REFERENCES person(id), num char(10) not null, PRIMARY KEY (id, num)); It simply ignores that REFERENCES definition. It is in the TODO list to add support for that syntax, too. Until then you have to use the 'long' syntax: CREATE TABLE `phone` ( `id` char(5) NOT NULL default '', `num` char(10) NOT NULL default '', PRIMARY KEY (`id`,`num`), FOREIGN KEY (`id`) REFERENCES `person` (`id`) ) TYPE=InnoDB Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for MySQL - Original Message - From: Ed Smith [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Friday, September 26, 2003 1:39 AM Subject: REFERENCES question in mySQL 4.1 - Take 2 First, my apologies. I originally posted this to the mailing.databases.mysql newsgroup, not realizing that the newsgroup is just mirror of the mailing list. I have since figured out the answer to my second question (I think) - see below. My answer is: The Primary Key specification creates an index that the foreign key uses. I STILL have my first question - see below: I have two questions about REFERENCES: 1. It appears that mySQL treats REFERENCES associated with an attribute differently than FOREIGN KEY (blah) REFERENCES... Specifically, the first form does not appear to work, while the later does. Here's a simple example (slightly edited): mysql CREATE TABLE person (id char(5) primary key); Query OK, 0 rows affected (0.04 sec) mysql CREATE TABLE phone (id char(5) not null REFERENCES person(id), num char(10) not null, PRIMARY KEY (id, num)); Query OK, 0 rows affected (0.06 sec) mysql show create table phone; | phone | CREATE TABLE `phone` ( `id` char(5) NOT NULL default '', `num` char(10) NOT NULL default '', PRIMARY KEY (`id`,`num`) ) TYPE=InnoDB CHARSET=latin1 | 1 row in set (0.00 sec) mysql insert into phone value ('foo', 'bar'); Query OK, 1 row affected (0.04 sec) It appears that the constraint is not created and is certainly not enforced. Now consider what should be the same phone table. mysql drop table phone; Query OK, 0 rows affected (0.29 sec) mysql CREATE TABLE phone (id char(5) not null, num char(10) not null, PRIMARY KEY (id, num), FOREIGN KEY (id) REFERENCES person(id)); Query OK, 0 rows affected (0.09 sec) mysql show create table phone; | Table | Create Table | phone | CREATE TABLE `phone` ( `id` char(5) NOT NULL default '', `num` char(10) NOT NULL default '', PRIMARY KEY (`id`,`num`), FOREIGN KEY (`id`) REFERENCES `person` (`id`) ) TYPE=InnoDB CHARSET=latin1 | 1 row in set (0.00 sec) mysql insert into phone values ('foo', 'bar'); ERROR 1216: Cannot add or update a child row: a foreign key constraint fails Why are these different? 2. In the manual (and in several posts), it clearly states (see Section 7.5.4.2 of the 4.1.0-alpha manual) Both tables have to be InnoDB type and there must be an index where the foreign key and the referenced key are listed as the FIRST columns However, I did not create an indicies, but it worked. What's up? Thanks in advance __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Question on rollback segment equivalent
Fareeda, - Original Message - From: fareeda [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Thursday, September 25, 2003 5:32 PM Subject: Question on rollback segment equivalent What is the equivalent of rollback segments (from Oracle) on MySQL? And if something is being used internally, can I change the size of this? I do not want to run into problems like exceeded rollback size or something like that. in InnoDB there is a 'rollback segment', which is the totality of the undo logs in the tablespace. But you do not need to tune it in any way, and it takes much less space than in Oracle. Any pointer appreciated Thanks Fareeda Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for MySQL -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Move a MySQL Database to another system
Rob, Spyros, you can simply copy .frm, .MYI, .MYD, ibdata files, and ib_logfiles between Windows and Linux. The binary formats on disk are the same. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for MySQL - Original Message - From: Rob Kings [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Thursday, September 25, 2003 2:20 PM Subject: Re: Move a MySQL Database to another system spyros Well I just did pretty much the opposite. From Linux to XP. Take a look at mySQLDump. I don't have the exact syntax in front of me, but I dumped out the database into a .SQL. This contains both the SQL to create the tables and the data. Then on the target machine I created the new database: C:\mysql\bin\mysqladmin create xyz -u root Where xyz was the name of the database I wanted to create. Then I imported the attached file using something like C:\mysql\bin\mysql xyz xyz.sql -u root You'll have to look up the mySQLdump documentation (you can dump the entire DB or just certain tables) and of course where I've used a DOS path yours will be something like /mysql/bin/whatever HTH Rob Spyros [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I want to move a MySQL Database 3.23.54-max-nt from a Windows 2000 Server to a 4.0.14-max on a Redhat Linux Server. Any idea will be welcome. Thanks Spyros -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Database quotas?
Another way I was thinking about by now is to periodically calculate the database's size and, if over quota, revoke the user's INSERT, UPDATE rights and so on. It's not real-time, too, but maybe a little more friendly since I don't know how MySQL behaves when running against fs quota writing to a file... And it's easily configurable for any MySQL user account. And this cron script wouldn't actually need system root privileges, just sufficient privileges on that MySQL server. -- Yves Goergen [EMAIL PROTECTED] Please don't CC me (causes double mails) On Thursday, September 25, 2003 12:32 AM CET, Steven Adams wrote: Its not, i ment to say mysql user. A cron will work, but it wont be up-to-date.. hmm, need to research it a bit more. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 1000 rows in MySQLcc
On Wednesday, September 24, 2003, at 03:25 PM, Oscar (TOMCAT) wrote: I'm using MySQLcc version 0.9.2-beta... I want to recover more than 1000 rows in a select statement... What is the command to alter this setting ??? You can always explicitly add the LIMIT clause to change this for your queries. The 1000 limit only kicks in as a default. ___/ / __/ / / Ed Leafe http://leafe.com/ http://opentech.leafe.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
CocoaMySQL slow after editing field content
I have CocoaMySQL running on my G4 Powerbook Mac OS 10.2.6, and I'm using it with a table imported from a 29MB .csv file. This database is a list of names and info and I am able to search quickly to look up names and emails and also able to import .csv files to this table with no trouble. The problem I'm having is if I want to edit some of the emails or names the table seems to be re-loading after the field is edited. I'll double click on the field and edit it and as soon as I click on another row it will start working. I have verified that the following options in CocoaMySQL preferences are disabled: reload table after editing a row reload table after adding a row reload table after removing a row The table does seem to be reloading itself after I edit or add/remove a row. Maybe these preferences in the CocoaMySQL are somehow not taking effect? I'd like to be able to edit the field data in CocoaMySQL and go on and edit another one without having to wait for the whole table to reload.. takes about 10 minutes each time. I appreciate any help offered. Thank you! Bobby [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql Problem in Windows 2000 advanced server
Thanks Miguel. I increased net_read_timeout and net_write_timout up to 300 sec, but problem still exists. My queries are executing only in few seconds, but sometimes mysql shows Can't connect to server, or Connection lost etc. I used mysql-4.0.14 server and client, but problem was same and I upgraded to mysql-4.0.15. Probably running mysql in Windows is not great as in Lunux/FreeBSD. It seems like it is better to switch into Linux/FreeBSD. Ganbold At 07:44 PM 9/25/2003 -0300, you wrote: At 12:33 25/9/2003 +0900, Ganbold wrote: Hi, I installed mysql-4.0.15 in Windows 2000 Advanced server. Mysql-max-nt is working fine, except some problems. Sometimes when I try to use access web pages through php pages, mysql says Connection to server lost or Can't connect to mysql server or sometimes query error. Query is tested and works fine most of the time. And when I refresh web page again everything works fine. Mysql log says nothing. Is it problem related to mysql in Windows? Also I tested small C program to query mysql tables and it sometimes hangs. Is there any solution for this kind of problem? From the mysql.exe client: (C) Copyright 1985-2000 Microsoft Corp. c:\c:\mysql\bin\mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 4.0.15-max-nt-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show variables like %timeout%; +--+---+ | Variable_name| Value | +--+---+ | connect_timeout | 5 | | delayed_insert_timeout | 300 | | innodb_lock_wait_timeout | 50| | interactive_timeout | 28800 | | net_read_timeout | 30| | net_write_timeout| 60| | slave_net_timeout| 3600 | | wait_timeout | 28800 | +--+---+ 8 rows in set (0.01 sec) You can see above the net_read_timeout and net_write_timeout, if you are having queries that takes more than 30 seconds the server disconnect the client because the client remains passive and that time exceeds the net_read_timeout. From 4.0.15 was introduced for socket time outs that before on Windows didn't worked. So try to configure your server starting it with a more high value than the default according with the necessities. However, when retrieved with a client 4.0.15 the above don't works, please read: http://bugs.mysql.com/bug.php?id=1370 for further details and follow up. -- Regards, For technical support contracts, visit https://order.mysql.com/ Are you MySQL certified?, http://www.mysql.com/certification/ Miguel Angel Solórzano [EMAIL PROTECTED] São Paulo - Brazil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
U Script, a lightweigt middleware for MySQL
Uscript Some months ago I developed a lightweight middle layer between MySql and the web. The purpose was experimentation with web programming without the complexity of a standard middleware layer. I will describe the system to you, and make the source available if anyone wants to experiment with the concept. The syntax is based on URL grammar. My hello program is: http://address/U?print= Hello World or if necessary http://address/U?print= Content-type: text/html\r\n\r\nHello World Either of these copied into the web address of the browser prints a screen with Hello World. The system relies on built in URL scripts, URL scripts stored in MySQL, and the original URL script arriving from the browser. Language characters: = Macro assignment Macro definition terminator $ Macro expansion _ External Macro expansion % escaping sequence Syntax: A Uscript is an arbitrary intermixing of the following: 1) plain text 2) $symbol _symbol 3) symbol= uscript The system works as a run time macro language. The language is a recursive macro define and expand. Plain text is emitted, macros defined special character define symbols which are expanded. a macro definition is: name= arbitrary text an expansion is: $name or if the macro is predefined in the MySQL data base. _name Similiar to M4, the U interpreter contains a formatter. The formatter is useful for filling in SQL and HTML templates for proper execution. Predefined macros are stored in the MySql as text in standard tables. The predefined macros are the special power of the macro language, and I have developed a collection of special- HTML and SQL templates which can be expanded as external macros. The parameters in the templates are substituted by macro expansion. Macro expansions follow expected recursive rules: $$name will expand $name then attempt to expand the result as a macro. When expansion is complete the resulting text is passed back to the browser. The macro processor has access to the web and to MySql. The input and output from the database is placed into a square buffer(s) which can be rotated, dot producted, and cross producted in various manners under a special ioctl macro that controls sql IO. Other special executive macros are built in. out , out_exec// Flush the buffer outb , outb_exec // Flush the buffer outf , outf_exec // Execute tha macro and flush form , format // Format the iop, iop_exec inner , inner_exec sqlio , sqlio_exec // Send expanded text to MySQL mode , mode_exec// Change the mode of the SQL square buffer parse , parse_exec // Execute the specified u script blob , blob_exec// Interpret a binary blob ioctl, ioctl_exec // Modify the operation of the square buffer Memory management. The system assumes text last for the life of the web page. Uscript output is kept in an output buffer until one of the output executives flush the system. Oldest symbols are garbaged when the symbol table fills. SQL input is flushes to a square buffers which are stacked. Special symbols are compiled into the U interpreter: There is no text manipulation, all symbols are managed with pointers to a text buffer. All 256 characters are valid, except U script special chars must be escaped to be treated as text. There are no NULL terminated strings, and zero is a valid text char. The Formatter: Aside from the Uscript parser, the system offers a separate formatter, similiar to the M4 formatter. This is used to fill in careful text strings needed for HTML and SQL templates. Some of the most frequent HTMS and SQL strings are stored in the parser itself at start up to speed the processing. These templates generally contain symbols that must be expanded. Example: HttpText= Content-type: text/html\r\n\r\nhtml head $css /headbody In this pre-defined template a style pointer is required for expansion. This allows compact html pages, for example: $out=css=StandardStyle $HttpText arbitary text $End would be activated with: http://address/U?$out=css=StandardStyle; $HttpText arbitary text $End Or if the desired page format is stored as the template css=StandardStyle $HttpText arbitary text $End in MySql then: http://address/U?$out=_css; works. Loading u script into sql tables The normal operation of sequences of html pages is activated by the user when an html tag issuse a valid Uscript. For example, the following template is stored in the SQL pre-defines. Its purpose is to provide the next and previous tags that appear at the bottom of a table of sql records. They can be utilized with the macro expansion _UpdateAnchor. The calling U script will predefine the appropiate symbols and the macro is emitted. For example, db defines the data base, tb the table, sql the query macro, html the output format. UpdateAnchor p a href=U?next=PageAnchorsdb=$dbtb=$tbsql=$sqlhtml=$htmllimit=$limitoffset=%0GOTO=_$PREVNext/a a
Can't execute code in VB 6.0
I'm trying to execute a code with multiple SQL statement over VB 6.0. The code includes the creation of temporary tables, multiple inserts and one final select... It looks like i can only excecut one single SQL statement... does any one know how to fix that? I can run the code with out problems using MySQL Control Center.