Re: default table type = innodb is stable??
- Original Message - From: Hiu Yen Onn [EMAIL PROTECTED] if i uncomment it, then mysql server wont start at all. if i comment it, then, that's ok. please advise. thanks again If the mysql server does not start it will probably leave a lot of messages in the error log. If you send the section of the error log about such a failed start to the list people here can most likely help you find the problem with your server. Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Connectivity problem (?), mysql_ping ()
Hi, Is mysql_ping () suppose to restore a db connection even after a db restart? Thnx, Lefteris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: compound foreign key(s)
Hello. Please, send the output of the following statements: SHOW CREATE TABLE country; SHOW CREATE TABLE lang; Include the CREATE statement for countrylang table and exact error number. Guy Brom wrote: I have the following innoDb tables: country has `id` as PK lang has `id` as PK I want to have a 3rd innoDb table: countrylang with `cid,lang` as compound key with both `cid` and `lang` as foreign (cascade-delete) keys to the master tables. However mysql throws error (Cannot create table..) when I try to define `cid` as a foreign key to country.id country.id and countrytext.cid are both smallint(5) Any help? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [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 with GRANT not working.
Hello. Enable a General log and find out what is MySQL thinking about the host from you're connecting to it. Ben Clewett wrote: Dear MySQL, A new installation of 4.1.9 on AIX 5. I have a GRANT that is not working. Connecting from foreign server 'pho.com' with IP of '192.168.1.1', I should be able to GRANT using either: mysql GRANT all ON test.* TO test@'192.168.%' IDENTIFIED BY 'test'; mysql GRANT all ON test.* TO test@'%.com' IDENTIFIED BY 'test'; The second version '%.com' allows access. The first version access by IP '192.168.%' does not work. This always has worked on 4.1.9 before. There is nothing in the manual to elaborate on this problem. As far as I can see, this should work perfectly. Would any users be able to suggest a solution to this? Regards, Ben Clewett. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [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 with GRANT not working.
Hello. It looks very weird for me. I don't have an access to AIX machine, so I suggest you to use gdb and research where MySQL is getting such an interesting result. See sql/hostname.cc file from the source distribution and: http://dev.mysql.com/doc/refman/4.1/en/debugging-server.html Ben Clewett wrote: A little more information: If I use --skip-name-resolve then I get an odd error: ERROR 1045 (28000): Access denied for user 'me'@'0.0.0.0' (using password: YES) This seems to suggest that MySQL thinks my client is from '0.0.0.0' and hence cannot match any GRANT syntax I use. Why would MySQL think my client is from '0.0.0.0'? Thanks in advance for any person who can offer a solution to these problems. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [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: syntax of bind_address
Hello. Unfortunately, you can bind only to a single specific address. Daniel Schaerli wrote: Hi, How is the sintax to in my.cnf listen only to specified ip-addresses or ip-ranges? I tried: bind_address 127.0.0.1 192.168.0.10 192.168.0.20 and bind_address 127.0.0.1, 192.168.0.10, 192.168.0.20 and bind_address 127.0.0.1 192 bind_address 192.168.0.10 bind_address 192.168.0.20 Non of them worked. Could anyone help me please? Thanks in advance Daniel -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [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: Maximum execution time?
Hello. There is no builtin possibility for this, but you may write your own tool which will be parsing the output of 'mysqladmin processlist' and invoke 'mysqladmin kill' for long threads. John Ricci wrote: Hi Is there a way to setup a maximum query execution time per user. I understand the options max_connections and max_questions. But I am looking for a way to kill a query per user if it takes longer than XX minutes! Thanks John -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [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: default table type = innodb is stable??
Hello. i saw /usr/share/mysql/my-innodb-heavy-4G.cnf file, then, i replacethe existing one (/etc/my.cnf). but, it failed to start the mysql server. please advise. thanks? What is in the error log? See: http://dev.mysql.com/doc/refman/4.1/en/error-log.html http://dev.mysql.com/doc/refman/4.1/en/starting-server.html InnoDB engine is stable and used in heavily loaded environments all over the world. What version of MySQL do you use? RHEL is known to ship an old 3.23 version in its distribution without compiled InnoDB support. Use the official binaries of the latest release. i have a machine with 6G memory, What is the architecture of the server? x86? Hiu Yen Onn wrote: hi, i have a machine with 6G memory, loaded with RHEL4. now, my question is mysql support innodb as the default table type? will be stable running RHEL4? i saw /usr/share/mysql/my-innodb-heavy-4G.cnf file, then, i replace the existing one (/etc/my.cnf). but, it failed to start the mysql server. please advise. thanks? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [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: a question about system page.
Hello. If you want to enable large pages in the Linux kernel, run a quick search in Google. I've found these links (ignore the 'DB2' and 'oracle' in the URL:) http://www.linux.com/howtos/DB2-HOWTO/kernels.shtml http://linux.inet.hr/oracle10g_on_debian.html Íõ Ðñ wrote: I learn configuring the mysql server in the manul 5.3.1.I notice there is a parameter --large pages.Please tell my how do i alter linux system memory pages . _ Ãâ·ÑÏÂÔØ MSN Explorer: http://explorer.msn.com/lccn -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [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: Query dies silently
Hello. I get 142k rows back in just over 4 seconds. It means that on the server side query works, so the problem probably is in PHP. However, when I run this query using PHP through the browser, I get nothing at all. Occasionally, I get get an error about not being able to store the result, but this error does not always display. Isn't the PHP level logging high enough? Increase the memory_limit variable in you php.ini. Erich C. Beyrent wrote: Hi all, I have a rather strange problem that I cannot seem to figure out. When I run the following query from the MySQL console: SELECT Inventory.ID as InventoryID, Inventory.Name, Inventory.Capacity, Inventory.Beds, Avails.ID as AvailabilityID, Avails.ResortID, Avails.Cost, Avails.OpenWhen FROM Inventory, Avails WHERE Avails.InvID = Inventory.ID AND Avails.OpenWhen NOW() AND (Avails.StatusCode = 'GREEN' OR Avails.StatusCode = 'YELLOW') ORDER BY Avails.ResortID, Avails.InvID, Avails.OpenWhen; I get 142k rows back in just over 4 seconds. However, when I run this query using PHP through the browser, I get nothing at all. Occasionally, I get get an error about not being able to store the result, but this error does not always display. Is there some kind of query size limit that I am running into, or perhaps a temp table limit that is too low? mysql show variables; ++---+ | Variable_name | Value | ++---+ | back_log | 5 | | connect_timeout| 5 | | basedir| / | | datadir| /var/lib/mysql/ | | delayed_insert_limit | 100 | | delayed_insert_timeout | 300 | | delayed_queue_size | 1000 | | join_buffer| 131072| | flush_time | 0 | | key_buffer | 8388600 | | language | /usr/share/mysql/english/ | | log| OFF | | log_update | OFF | | long_query_time| 10| | low_priority_updates | OFF | | max_allowed_packet | 1048576 | | max_connections| 100 | | max_connect_errors | 10| | max_delayed_insert_threads | 20| | max_join_size | 4294967295| | max_sort_length| 1024 | | max_write_lock_count | 4294967295| | net_buffer_length | 16384 | | pid_file | /var/lib/mysql/mysqld.pid | | port | 3306 | | protocol_version | 10| | record_buffer | 131072| | skip_locking | ON| | skip_networking| OFF | | socket | /var/lib/mysql/mysql.sock | | sort_buffer| 2097144 | | table_cache| 64| | thread_stack | 65536 | | tmp_table_size | 1048576 | | tmpdir | /tmp/ | | version| 3.22.32 | | wait_timeout | 28800 | ++---+ Please note that this database is on a host, and the version of the DB is out of my control. -Erich- -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [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: Mysql with SSL connections
Hello. The fact is that I cant start mysql with ssl support using the /etc/ec/d/init.d/mysql script. But the interesting thing is that if I copy First of all, you should find the error log. See: http://dev.mysql.com/doc/refman/4.1/en/error-log.html Israel Fern$ndez Cabrera [EMAIL PROTECTED] wrote: Hi folk! I'm new to mysql and to databases... I'm using Fedora Core 4 with mysql 4.1.11-2 I need some application clients to connect the server using SSL connections. I've created and tested x509 certificates using the way mysql documentation explain, I've modified the /etc/my.cnf [mysqld] and [client] sections with the certificates that are located in /etc/pki (I've made some test with the certificates in /usr/pki too). The fact is that I cant start mysql with ssl support using the /etc/ec/d/init.d/mysql script. But the interesting thing is that if I copy the same script to any different folder it works. If it is in the init.dfolder I always get an SSL connection error. running mysqld, mysqld_safe by hand work perfectly and SSL works too. This is annoying I'll appreciate any help in respect. thanks in advance and best regards... -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [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: confirm subscribe to mysql@lists.mysql.com
Am Samstag 15 Oktober 2005 13:11 schrieb [EMAIL PROTECTED]: To confirm that you would like [EMAIL PROTECTED] added to the mysql mailing list, please click on the following link: http://lists.mysql.com/s/mysql/4350e3d50d20d7fc/tommi=tntnet.org This confirmation serves two purposes. First, it verifies that we are able to get mail through to you. Second, it protects you in case someone forges a subscription request in your name. --- Administrative commands for the mysql list --- I can handle administrative requests automatically. Please do not send them to the list address! Instead, send your message to the correct command address: For help and a description of available commands, send a message to: [EMAIL PROTECTED] To subscribe to the list, send a message to: [EMAIL PROTECTED] To remove your address from the list, just send a message to the address in the ``List-Unsubscribe'' header of any list message. If you haven't changed addresses since subscribing, you can also send a message to: [EMAIL PROTECTED] or for the digest to: [EMAIL PROTECTED] For addition or removal of addresses, I'll send a confirmation message to that address. When you receive it, simply reply to it to complete the transaction. If you need to get in touch with the human owner of this list, please send a message to: [EMAIL PROTECTED] Please include a FORWARDED list message with ALL HEADERS intact to make it easier to help you. --- Enclosed is a copy of the request I received. Received: (qmail 23837 invoked by uid 48); 15 Oct 2005 11:11:17 - Date: 15 Oct 2005 11:11:17 - Message-ID: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Unsubscribe request From: [EMAIL PROTECTED] This message was generated because of a request from 85.212.17.179. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Statement-metadata for decimal-column
Hi, I have a problem with the statement-api. I try to select a value of type decimal(12,2) from a mysql-database. To get information about this column, I use mysql_stmt_result_metadata. The problem here is, that the type of the column is 0. When I try to use it in a MYSQL_BIND-structure and call mysql_stmt_bind_result, I get error 2036: Using unsupported buffer type: 0. For other column-types I get reasonable values. I attach a minimal program, which reproduces the error. My configuration: Mysql-version 4.1.13 on SuSE-Linux 10.0, x86-64. Table-structure: mysql show columns from PRODUCTS; ++---+--+-+-++ | Field | Type | Null | Key | Default | Extra | ++---+--+-+-++ | PROD_ID| int(11) | | PRI | NULL| auto_increment | | CATEGORY | tinyint(4)| | MUL | 0 || | TITLE | varchar(50) | | MUL | || | ACTOR | varchar(50) | | MUL | || | PRICE | decimal(12,2) | | | 0.00|| | SPECIAL| tinyint(4)| YES | MUL | NULL|| | COMMON_PROD_ID | int(11) | | | 0 || ++---+--+-+-++ 7 rows in set (0.00 sec) Tommi #include stdio.h #include mysql.h #include stdlib.h #include string.h #define HOST localhost #define USER web #define PASSWORD web #define DATABASE DS2 #define PORT 3306 /* PRICE is of type decimal(12,2) */ #define SELECT SELECT PRICE FROM PRODUCTS void checkError(MYSQL* mysql, const char* fn, int ret) { if (ret != 0) { fprintf(stderr, %s %d: %s \n, fn, mysql_errno(mysql), mysql_error(mysql)); exit(1); } } void checkErrorStmt(MYSQL_STMT* stmt, const char* fn, int ret) { if (ret != 0) { fprintf(stderr, %s %d: %s \n, fn, (int)mysql_stmt_errno(stmt), mysql_stmt_error(stmt)); exit(1); } } int main() { MYSQL mysql; MYSQL_STMT* stmt; MYSQL_BIND result[1]; MYSQL_RES* metadata; MYSQL_FIELD* fields; char price[64]; unsigned long price_length; int ret; my_bool bool_ret; mysql_init(mysql); printf(mysql_real_connect\n); ret = (int)mysql_real_connect(mysql, HOST, USER, PASSWORD, DATABASE, PORT, NULL, 0); checkError(mysql, mysql_real_connect, !ret); printf(mysql_stmt_init\n); stmt = mysql_stmt_init(mysql); if (stmt == 0) { fprintf(stderr, out of memory); exit(1); } printf(mysql_stmt_prepare\n); ret = mysql_stmt_prepare(stmt, SELECT, strlen(SELECT)); checkErrorStmt(stmt, mysql_stmt_prepare, ret); printf(mysql_stmt_execute\n); ret = mysql_stmt_execute(stmt); checkErrorStmt(stmt, mysql_stmt_execute, ret); printf(mysql_stmt_result_metadata\n); metadata = mysql_stmt_result_metadata(stmt); if (metadata == 0) { fprintf(stderr, no metadata available); exit(1); } printf(mysql_fetch_fields\n); fields = mysql_fetch_fields(metadata); printf(field-type=%d\n, (int)fields[0].type); printf(initialize result\n); memset(result, 0, sizeof(MYSQL_BIND)); result[0].buffer_type = fields[0].type; result[0].buffer = price; result[0].buffer_length = sizeof(price); result[0].length = price_length; printf(mysql_stmt_bind_result\n); bool_ret = mysql_stmt_bind_result(stmt, result); checkErrorStmt(stmt, mysql_stmt_bind_result, bool_ret); } mmm: mmm.o CC=gcc CFLAGS=`mysql_config --cflags` LDFLAGS=`mysql_config --libs` -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Killing a thread -- Urgent
hi all.. I started a select count(1) command on a table in mysql, assuming it will end soon within the off peak time.. But now the peak load time is about to start, so i tried to kill that query.. logged into mysql as root. show processlist for getting the thread id. kill 85300 (thrad_id) After doing this the state of the query has changed to killed, but still it is showing like this 85300 | root | localhost | db_name | Killed | 23055 | Sending data | select count(1) from I have issued the kill command almost 1hour back..but still it is showing up this query..And the iowait on the DB server is touching 60%..generally in off peak times it should be 35%. (i seriously suspect this query for the high iowaits) Any help is greatly appreciated. Thank you sujay
DBDesigner4 under Linux
I am able to run DBDesigner4 under Windows but now good under Linux. Try .rpm, .tar.gz, home install, all users install, still the same error: Unable to load libmysqlclient.so Put this in ld.so.conf, run ldconfig, nothing... Changed startdbd script to force dirs path and nothing. Need help on this? Or perhaps if someone point me out in the direction off ODBC connect to MySQL? I've never did this so don't know where to start... Thanks, Bruno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: DBDesigner4 under Linux
Hi, and you have a libmysqlclient.so ? sometimes the lib is installed only with a libmysqlclient.so.xxx, and the packages don't install the libmysqlclient.so file, so all you have to do is ln -s the lib to libmysqlclient.so Verify this, mpneves On Saturday 15 October 2005 16:05, Bruno Cochofel wrote: I am able to run DBDesigner4 under Windows but now good under Linux. Try .rpm, .tar.gz, home install, all users install, still the same error: Unable to load libmysqlclient.so Put this in ld.so.conf, run ldconfig, nothing... Changed startdbd script to force dirs path and nothing. Need help on this? Or perhaps if someone point me out in the direction off ODBC connect to MySQL? I've never did this so don't know where to start... Thanks, Bruno -- Merlin, the Mage http://www.sites-favoritos.com/user/merlin http://www.cultodavida.online.pt http://www.code.online.pt Carpe Vitam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Killing a thread -- Urgent
Hello. Do you have other queries which are running at this moment on the server? The show-processlist.html says that thread could be in Killed state if it is locked by another thread. What version of MySQL do you use? What storage engine does your table have? Sujay Koduri [EMAIL PROTECTED] wrot hi all.. I started a select count(1) command on a table in mysql, assuming it will end soon within the off peak time.. But now the peak load time is about to start, so i tried to kill that query.. logged into mysql as root. show processlist for getting the thread id. kill 85300 (thrad_id) After doing this the state of the query has changed to killed, but still it is showing like this 85300 | root | localhost | db_name | Killed | 23055 | Sending data | select count(1) from I have issued the kill command almost 1hour back..but still it is showing up this query..And the iowait on the DB server is touching 60%..generally in off peak times it should be 35%. (i seriously suspect this query for the high iowaits) Any help is greatly appreciated. Thank you sujay -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [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: Connectivity problem (?), mysql_ping ()
Hello. In my opinion it depends on the value of reconnect flag (the part of MYSQL structure). I've written a simple program which connects to MySQL server, waits a bit and executes mysql_ping. While it is waiting, MySQL server is being restarted. If mysql.reconnect = 1, mysql_ping() returns success, otherwise we have Server has gone away. Here is the test program: #includestdio.h #includemysql/mysql.h int main() { MYSQL mysql; char c; printf(Begin\n); mysql_init(mysql); mysql_options(mysql,MYSQL_READ_DEFAULT_GROUP,mysql); if (!mysql_real_connect(mysql,localhost ,root , ,test ,0 ,NULL ,0)) { fprintf(stderr, Failed to connect to database: Error: %s\n, mysql_error(mysql)); } mysql.reconnect = 0; c=getchar(); if( mysql_ping(mysql) != 0) { printf(Error: %s, mysql_error(mysql)); } else { printf(Ok!\n); } } Lefteris Tsintjelis wrote: Hi, Is mysql_ping () suppose to restore a db connection even after a db restart? Thnx, Lefteris -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [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: upload images / mp3 more Than 1 MB capacity ---- please help
For an PHP example of how to import data getting around max_packet_size, performance, etc. issues.. Be sure to read this article. Also linked from: http://dev.mysql.com/doc/refman/4.1/en/blob.html Article @ http://php.dreamwerx.net/forums/viewtopic.php?t=6 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connectivity problem (?), mysql_ping ()
Hi, I have just tried your routine, I use something very similar, (I have changed the localhost to 127.0.0.1 so it will not use the pipeline) but I am still expiriencing the same exact problem, weather reconnect is set or not, the error remains the same. That is what got me wondering in the first place. --- (MySQL shutdown) Begin Failed to connect to database: Error: Can't connect to MySQL server on '127.0.0.1' (60) (MySQL startup with mysql.reconnect = 1/0) Error: MySQL server has gone away --- This is always what I am getting. Does reconnect work right for you? Regards, Lefteris Gleb Paharenko wrote: Hello. In my opinion it depends on the value of reconnect flag (the part of MYSQL structure). I've written a simple program which connects to MySQL server, waits a bit and executes mysql_ping. While it is waiting, MySQL server is being restarted. If mysql.reconnect = 1, mysql_ping() returns success, otherwise we have Server has gone away. Here is the test program: #includestdio.h #includemysql/mysql.h int main() { MYSQL mysql; char c; printf(Begin\n); mysql_init(mysql); mysql_options(mysql,MYSQL_READ_DEFAULT_GROUP,mysql); if (!mysql_real_connect(mysql,localhost ,root , ,test ,0 ,NULL ,0)) { fprintf(stderr, Failed to connect to database: Error: %s\n, mysql_error(mysql)); } mysql.reconnect = 0; c=getchar(); if( mysql_ping(mysql) != 0) { printf(Error: %s, mysql_error(mysql)); } else { printf(Ok!\n); } } Lefteris Tsintjelis wrote: Hi, Is mysql_ping () suppose to restore a db connection even after a db restart? Thnx, Lefteris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: default table type = innodb is stable??
Jigal van Hemert wrote: - Original Message - From: Hiu Yen Onn [EMAIL PROTECTED] if i uncomment it, then mysql server wont start at all. if i comment it, then, that's ok. please advise. thanks again If the mysql server does not start it will probably leave a lot of messages in the error log. If you send the section of the error log about such a failed start to the list people here can most likely help you find the problem with your server. Regards, Jigal. this is my error log file. A mysqld process already exists at Sun Oct 16 09:33:39 BNT 2005 051016 9:36:14 [Note] /usr/sbin/mysqld: Normal shutdown 051016 9:36:14 InnoDB: Starting shutdown... 051016 9:36:17 InnoDB: Shutdown completed; log sequence number 0 43977 051016 9:36:17 [Note] /usr/sbin/mysqld: Shutdown complete 051016 09:36:17 mysqld ended 051016 09:36:17 mysqld started InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes InnoDB: than specified in the .cnf file 0 268435456 bytes! 051016 9:36:18 [ERROR] Can't init databases 051016 9:36:18 [ERROR] Aborting 051016 9:36:18 [Note] /usr/sbin/mysqld: Shutdown complete 051016 09:36:18 mysqld ended 051016 09:37:41 mysqld started InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes InnoDB: than specified in the .cnf file 0 268435456 bytes! 051016 9:37:41 [ERROR] Can't init databases 051016 9:37:41 [ERROR] Aborting 051016 9:37:41 [Note] /usr/sbin/mysqld: Shutdown complete 051016 09:37:41 mysqld ended 051016 09:39:02 mysqld started InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes InnoDB: than specified in the .cnf file 0 268435456 bytes! 051016 9:39:03 [ERROR] Can't init databases 051016 9:39:03 [ERROR] Aborting 051016 9:39:03 [Note] /usr/sbin/mysqld: Shutdown complete 051016 09:39:03 mysqld ended -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]