Re: Lost Connection each hour :(
Il giorno 16 gen 2008, alle ore 02:59, Moon's Father ha scritto: Post your error message here. (from php) Error message: mysql_connect(): Lost connection to MySQL server during query and I have that for _each_ apache2 thread/php-page opened MAS! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Lost Connection each hour :(
Enter your mysql shell and enter the command: set global max_allowed_packet=10M The value of the variable can be set whatever you want . On Jan 16, 2008 4:36 PM, MAS! [EMAIL PROTECTED] wrote: Il giorno 16 gen 2008, alle ore 02:59, Moon's Father ha scritto: Post your error message here. (from php) Error message: mysql_connect(): Lost connection to MySQL server during query and I have that for _each_ apache2 thread/php-page opened MAS! -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
Re: useCursorFetch
Cursors can fetch from procedure. On Jan 10, 2008 1:36 AM, Robert DiFalco [EMAIL PROTECTED] wrote: A while back there was a general consensus that useCursorFetch (with useServerPrepStmts) was somehow flakey? Is this still the case? I had heard from someone that MySQL will not even provide support for customers using these options in the JDBC driver. Is that true? TIA, Robert -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
Re: issues with replicating stored routines or triggers?
This means you should take care of the routine replication of this section. On Jan 13, 2008 6:04 PM, gengxy-douban [EMAIL PROTECTED] wrote: With MySQL's classic statement-based replication, there may be issues with replicating stored routines or triggers from : http://dev.mysql.com/doc/refman/5.1/en/replication-formats.html what's mean? -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
Re: Lost Connection each hour :(
Enter your mysql shell and enter the command: set global max_allowed_packet=10M I have it setted at 32M, but that is not the problem; the data are not too much ... and it's strange because _ALL_ clients seems to died/be disconnected each hour, when the hourly cron runs.. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Lost Connection each hour :(
You should give me an error message here. On Jan 16, 2008 4:44 PM, MAS! [EMAIL PROTECTED] wrote: Enter your mysql shell and enter the command: set global max_allowed_packet=10M I have it setted at 32M, but that is not the problem; the data are not too much ... and it's strange because _ALL_ clients seems to died/be disconnected each hour, when the hourly cron runs.. -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
Re: Lost Connection each hour :(
Marco, can you post values of wait_timeout and interactive_timeout variables. You can get them from SHOW VARIABLES output. If they are set to 3600 (1 hour in secs), set them to something bigger like one week and then you will see if it helps or not. You can read more about those timeouts also in manual. HTH, Dusan MAS! napsal(a): Can anyone help me to understand why my site (php 4.4.2 / ubuntu dapper) loose all connections to mysql server when /etc/cron/hourly starts? (there are no process to start hourly, the directory is empty) I have heavvy web/apache2 traffic on my site and that is not so nice for my users.. thank you in advance regards marco -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Lost Connection each hour :(
can you post values of wait_timeout and interactive_timeout variables. You can get them from SHOW VARIABLES output. If they are set to 3600 (1 hour in secs), set them to something bigger like one week and then you will see if it helps or not. You can read more about +--+---+ | 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 | | table_lock_wait_timeout | 50| | wait_timeout | 28800 | +--+---+ :( may be I have to increase the net_% variables? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: does 'disable networking' make mySQL faster?
Daevid Vincent schrieb: Huh? This doesn't make any sense to me. If I'm running a LAMP box (all services on the same box), and my PHP calls out to the mySQL database, I would expect it to use the fastest method possible (since it's LOCAL). If that's sockets, then that's what it should use. I would think this to be a horrible design flaw if the mere fact that I have networking enabled (for the times I want to connect SQLYog to the RDBMS to manually run SQL commands) should NOT slow down or hurt my PHP applications performance in any way, shape or form!? I seriously hope that by turning on networking, mySQL isn't stupid enough to then start trying to connect my PHP application to localhost via 127.0.0.1 or something equally assinine. Please tell me this isn't the case. PHP mysql functions do it like you tell them: 'localhost' uses sockets, 127.0.0.1 uses networking host Can be either a host name or an IP address. Passing the NULL value or the string localhost to this parameter, the local host is assumed. When possible, pipes will be used instead of the TCP/IP protocol. http://php.net/mysqli_connect -- Sebastian Mendel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Bigint
Performance wise, what is a BIGINT like in comparison to an INT on a 32 bit machine? Thanks. -- Richard Heyes http://www.websupportsolutions.co.uk Mailing list management service allowing you to reach your Customers and increase your sales. ** NOW OFFERING FREE ACCOUNTS TO CHARITIES AND NON-PROFITS ** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Bigint
I think it's the same. On Jan 16, 2008 6:03 PM, Richard Heyes [EMAIL PROTECTED] wrote: Performance wise, what is a BIGINT like in comparison to an INT on a 32 bit machine? Thanks. -- Richard Heyes http://www.websupportsolutions.co.uk Mailing list management service allowing you to reach your Customers and increase your sales. ** NOW OFFERING FREE ACCOUNTS TO CHARITIES AND NON-PROFITS ** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
Re: Lost Connection each hour :(
MAS! napsal(a): can you post values of wait_timeout and interactive_timeout variables. You can get them from SHOW VARIABLES output. If they are set to 3600 (1 hour in secs), set them to something bigger like one week and then you will see if it helps or not. You can read more about +--+---+ | 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 | | table_lock_wait_timeout | 50| | wait_timeout | 28800 | +--+---+ :( may be I have to increase the net_% variables? I don't think that slave_net_timeout can cause you those problems but you can increase its value and you will see if it it helps or not. But read about those timeouts anyway. Also try to look at: http://dev.mysql.com/doc/refman/5.0/en/gone-away.html Dusan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Bigint
I think it's the same. I seem to remember that a BIGINT id two INTs tacked together, so how is that possible? -- Richard Heyes http://www.websupportsolutions.co.uk Mailing list management service allowing you to reach your Customers and increase your sales. ** NOW OFFERING FREE ACCOUNTS TO CHARITIES AND NON-PROFITS ** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Innodb gets disabled
Hi all, In order to reclaim the free space from mysql innodb storage engine. I have stopped the mysql server, remove all the things from data (to create new datadirectory and log files) directory, added innodb_file_per_table component in my.cnf. Restarted mysql server. After restarting mysql -server innodb engine gets disabled. What can be the issue. Please help me, Even if any body know to enable innodb storage engine in mysql please let me know Thanks Krishna Chandra Prajapati
Re: Lost Connection each hour :(
Hi, On Jan 16, 2008 3:36 AM, MAS! [EMAIL PROTECTED] wrote: Il giorno 16 gen 2008, alle ore 02:59, Moon's Father ha scritto: Post your error message here. (from php) Error message: mysql_connect(): Lost connection to MySQL server during query and I have that for _each_ apache2 thread/php-page opened MAS! MySQL is probably crashing and restarting. Look in the error logs for clues. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Bigint
Hi, On Jan 16, 2008 5:13 AM, Richard Heyes [EMAIL PROTECTED] wrote: I think it's the same. I seem to remember that a BIGINT id two INTs tacked together, so how is that possible? MySQL uses BIGINT for most internal math. The data types influence only how the data is stored, not how MySQL does computations. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Innodb gets disabled
Hi, On Jan 16, 2008 7:52 AM, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote: Hi all, In order to reclaim the free space from mysql innodb storage engine. I have stopped the mysql server, remove all the things from data (to create new datadirectory and log files) directory, added innodb_file_per_table component in my.cnf. Restarted mysql server. After restarting mysql -server innodb engine gets disabled. What can be the issue. Please help me, Even if any body know to enable innodb storage engine in mysql please let me know You can probably find an error in the server's error logs. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
OT: Sun to buy Mysql
http://www.reuters.com/article/mergersNews/idUSWNAS661820080116 -- /Brett C. Harvey; /Creative-Pages.Net, President; /Facility Management Systems, CTO (www.waldo.com/www.fmsystems.biz); /Lasso Professional Alliance Member ID #LPA135259 (www.lassosoft.com); -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Innodb gets disabled
no errors are there in log file On Jan 16, 2008 6:38 PM, Baron Schwartz [EMAIL PROTECTED] wrote: Hi, On Jan 16, 2008 7:52 AM, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote: Hi all, In order to reclaim the free space from mysql innodb storage engine. I have stopped the mysql server, remove all the things from data (to create new datadirectory and log files) directory, added innodb_file_per_table component in my.cnf. Restarted mysql server. After restarting mysql -server innodb engine gets disabled. What can be the issue. Please help me, Even if any body know to enable innodb storage engine in mysql please let me know You can probably find an error in the server's error logs. -- Krishna Chandra Prajapati MySQL DBA, Ed Ventures e-Learning Pvt.Ltd. 1-8-303/48/15, Sindhi Colony P.G.Road, Secunderabad. Pin Code: 53 Office Number: 040-66489771 Mob: 9912924044 URL: ed-ventures-online.com Email-id: [EMAIL PROTECTED]
Re: OT: Sun to buy Mysql
Brett Harvey wrote: http://www.reuters.com/article/mergersNews/idUSWNAS661820080116 No offense, but this is definitely not off topic when it comes to MySQL -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject
Big fish eats the small fish.. :) Will this bring good things to MySQL? -Original Message- From: John Meyer [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 16, 2008 8:58 AM To: Brett Harvey; mysql@lists.mysql.com Subject: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject Brett Harvey wrote: http://www.reuters.com/article/mergersNews/idUSWNAS661820080116 No offense, but this is definitely not off topic when it comes to MySQL -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] This message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom it is addressed. It may contain sensitive and private proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. FXDirectDealer, LLC reserves the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them. Unless otherwise stated, any pricing information given in this message is indicative only, is subject to change and does not constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as preliminary only and subject to our formal confirmation. FXDirectDealer, LLC is not responsible for any recommendation, solicitation, offer or agreement or any information about any transaction, customer account or account activity contained in this communication. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject
Will this bring good things to MySQL? $800,000,000 tends to bring good things. Hopefully. :-) -- Richard Heyes http://www.websupportsolutions.co.uk Mailing list management service allowing you to reach your Customers and increase your sales. ** NOW OFFERING FREE ACCOUNTS TO CHARITIES AND NON-PROFITS ** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
database theory book recommendations?
I'm currently applying for a developer job with mySQL. I want to improve my database theory knowledge. Any book recommendations? Searching on-line is surprisingly unhelpful; the only things I've found so far which looks half-sensible are Database is Depth by Chris Date, and Expert mySQL by Charles A. Bell (which looks more practical rather than theoretical). -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: database theory book recommendations?
Not necessarily theory but very good if you want to work with mysql is the mysql 5.0 certification guide olaf On 1/16/08 9:40 AM, Toby Douglass [EMAIL PROTECTED] wrote: I'm currently applying for a developer job with mySQL. I want to improve my database theory knowledge. Any book recommendations? Searching on-line is surprisingly unhelpful; the only things I've found so far which looks half-sensible are Database is Depth by Chris Date, and Expert mySQL by Charles A. Bell (which looks more practical rather than theoretical). - Confidentiality Notice: The following mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. The recipient is responsible to maintain the confidentiality of this information and to use the information only for authorized purposes. If you are not the intended recipient (or authorized to receive information for the intended recipient), you are hereby notified that any review, use, disclosure, distribution, copying, printing, or action taken in reliance on the contents of this e-mail is strictly prohibited. If you have received this communication in error, please notify us immediately by reply e-mail and destroy all copies of the original message. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: database theory book recommendations?
On Jan 16, 2008 9:40 AM, Toby Douglass [EMAIL PROTECTED] wrote: I'm currently applying for a developer job with mySQL. I want to improve my database theory knowledge. Any book recommendations? Searching on-line is surprisingly unhelpful; the only things I've found so far which looks half-sensible are Database is Depth by Chris Date, and Expert mySQL by Charles A. Bell (which looks more practical rather than theoretical). I have that book by Date. Heavy on theory and ranting and being holier-than-thou, very little practical knowledge for practitioners IMO. The best books I've got for MySQL are Paul DuBois's MySQL, Pipes/Kruckenberk Pro MySQL, and Celko's SQL For Smarties. And you should definitely check out the upcoming 2nd edition of High Performance MySQL when it comes out. I'm one of the authors and I promise it will be an excellent book. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject
Richard Heyes schrieb: Will this bring good things to MySQL? $800,000,000 tends to bring good things. Hopefully. :-) ??? why, this payment goes to current owners and investors, not to MySQL itself ... but anyway, using Suns structures and power will help of course ... -- Sebastian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: [SPAM] - Re: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject - Email found in subject
Oracle and Sun has a tight relationship right? Wouldn't there be a conflict of interest? -Original Message- From: Sebastian Mendel [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 16, 2008 10:03 AM To: [EMAIL PROTECTED] Cc: Jerome O. Macaranas; mysql@lists.mysql.com Subject: [SPAM] - Re: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject - Email found in subject Richard Heyes schrieb: Will this bring good things to MySQL? $800,000,000 tends to bring good things. Hopefully. :-) ??? why, this payment goes to current owners and investors, not to MySQL itself ... but anyway, using Suns structures and power will help of course ... -- Sebastian This message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom it is addressed. It may contain sensitive and private proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. FXDirectDealer, LLC reserves the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them. Unless otherwise stated, any pricing information given in this message is indicative only, is subject to change and does not constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as preliminary only and subject to our formal confirmation. FXDirectDealer, LLC is not responsible for any recommendation, solicitation, offer or agreement or any information about any transaction, customer account or account activity contained in this communication. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: [SPAM] - Re: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject - Email found in subject
I was lurking on Sun's website.. they are also carrying PostgreSQL in their line of products.. Great!! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 16, 2008 10:07 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: RE: [SPAM] - Re: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject - Email found in subject Oracle and Sun has a tight relationship right? Wouldn't there be a conflict of interest? -Original Message- From: Sebastian Mendel [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 16, 2008 10:03 AM To: [EMAIL PROTECTED] Cc: Jerome O. Macaranas; mysql@lists.mysql.com Subject: [SPAM] - Re: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject - Email found in subject Richard Heyes schrieb: Will this bring good things to MySQL? $800,000,000 tends to bring good things. Hopefully. :-) ??? why, this payment goes to current owners and investors, not to MySQL itself ... but anyway, using Suns structures and power will help of course ... -- Sebastian This message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom it is addressed. It may contain sensitive and private proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. FXDirectDealer, LLC reserves the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them. Unless otherwise stated, any pricing information given in this message is indicative only, is subject to change and does not constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as preliminary only and subject to our formal confirmation. FXDirectDealer, LLC is not responsible for any recommendation, solicitation, offer or agreement or any information about any transaction, customer account or account activity contained in this communication. -- 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: database theory book recommendations?
At 08:54 AM 1/16/2008, Baron Schwartz wrote: On Jan 16, 2008 9:40 AM, Toby Douglass [EMAIL PROTECTED] wrote: I'm currently applying for a developer job with mySQL. I want to improve my database theory knowledge. Any book recommendations? Searching on-line is surprisingly unhelpful; the only things I've found so far which looks half-sensible are Database is Depth by Chris Date, and Expert mySQL by Charles A. Bell (which looks more practical rather than theoretical). I have that book by Date. Heavy on theory and ranting and being holier-than-thou, very little practical knowledge for practitioners IMO. The best books I've got for MySQL are Paul DuBois's MySQL, Pipes/Kruckenberk Pro MySQL, and Celko's SQL For Smarties. And you should definitely check out the upcoming 2nd edition of High Performance MySQL when it comes out. I'm one of the authors and I promise it will be an excellent book. Baron, I'm glad to hear there is going to be an update to High Performance MySQL. What MySQL versions will it cover and is there a table of contents available online? TIA Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: OT: Sun to buy Mysql
Dear Monty and David If you're surfing this listCongrats! You guys deserve every bit of it. Best, Michael [EMAIL PROTECTED] wrote: I was lurking on Sun's website.. they are also carrying PostgreSQL in their line of products.. Great!! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 16, 2008 10:07 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: RE: [SPAM] - Re: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject - Email found in subject Oracle and Sun has a tight relationship right? Wouldn't there be a conflict of interest? -Original Message- From: Sebastian Mendel [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 16, 2008 10:03 AM To: [EMAIL PROTECTED] Cc: Jerome O. Macaranas; mysql@lists.mysql.com Subject: [SPAM] - Re: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject - Email found in subject Richard Heyes schrieb: Will this bring good things to MySQL? $800,000,000 tends to bring good things. Hopefully. :-) ??? why, this payment goes to current owners and investors, not to MySQL itself ... but anyway, using Suns structures and power will help of course ... -- Michael DePhillips www.star.bnl.gov -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Innodb gets disabled
1) 'mysqldump' all databases to an SQL file 2) Drop all databases 3) Shutdown mysqld 4) Delete the ibdata1, ib_logfile0, ib_logfile1 5) Add innodb_file_per_table to my.cnf (which you already did) 6) Make sure you gave this setting in [mysqld] group of my.cnf innodb_data_file_path=ibdata1:10M:autoextend 7) Start mysqld mysqld should recreate ibdata1, ib_logfile0, ib_logfile1 8) Reload all the databases from the SQL file Give it a try !!! -Original Message- From: Krishna Chandra Prajapati [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 16, 2008 7:52 AM To: MySql Subject: Innodb gets disabled Hi all, In order to reclaim the free space from mysql innodb storage engine. I have stopped the mysql server, remove all the things from data (to create new datadirectory and log files) directory, added innodb_file_per_table component in my.cnf. Restarted mysql server. After restarting mysql -server innodb engine gets disabled. What can be the issue. Please help me, Even if any body know to enable innodb storage engine in mysql please let me know Thanks Krishna Chandra Prajapati -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
TOC for High Performance MySQL (was: database theory book recommendations?)
On Jan 16, 2008 10:35 AM, mos [EMAIL PROTECTED] wrote: Baron, I'm glad to hear there is going to be an update to High Performance MySQL. What MySQL versions will it cover and is there a table of contents available online? TIA It covers what we know well, which is 5.0, in great detail. We know 5.1 a little, but we don't pretend to know for sure about things that haven't been battle-tested and widely deployed. So we mention what we know about 5.1. Our focus is on how to build fast, reliable systems with MySQL. The other authors are Peter Zaitsev, Arjen Lentz, and Vadim Tkachenko, with an appendix on Sphinx from Andrew Aksyonoff, Sphinx's author. Pretty much the top experts in the world :-) Many other experts who aren't writing are helping review. Nothing official yet about TOC. You can browse my blog category on it, which has a lot of chapter outlines and so on: http://www.xaprb.com/blog/category/high-performance-mysql/ Marketing materials and pre-orders ought to be available fairly soon, but I won't promise anything I can't control :-) I'm biased, but I think this book is going to be very, very good. The best book on the topic by a wide margin. But I'll let people judge that for themselves when it's done. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
increase with inserts/updates in partitioned table when knowing which partition?
Hi, I have a partitioned table using hash. For the example lets say I have N partitions. Selects perform well due to the partitioning. However I noticed that inserts and updates slow down considerably when the number of partitions goes up. (I think because if needs to inspect / open all partitions of the table) Since hashing uses a modulo function I figured that if I inserted rows which have the same modulo N in batches each batch of rows is inserted in exactly one partition (correct?) I figured this would speed up inserts/ updates since only one partition needs to be inspected for every batch. However, some measurements show me that this doesn't matter at all. Could anyone tell me what's incorrect in my thinking, or what I am missing, Thanks in advance, Geert-Jan BTW: I already asked this question, but wasn't sure the header asked the correct question. -- View this message in context: http://www.nabble.com/increase-with-inserts-updates-in-partitioned-table-when-knowing-which-partition--tp14885273p14885273.html Sent from the MySQL - General mailing list archive at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: database theory book recommendations?
Searching on-line is surprisingly unhelpful; the only things I've found so far which looks half-sensible are Database is Depth by Chris Date, and Expert mySQL by Charles A. Bell (which looks more practical rather than theoretical). I have that book by Date. Heavy on theory and ranting and being holier-than-thou, very little practical knowledge for practitioners IMO. The best books I've got for MySQL are Paul DuBois's MySQL, Pipes/Kruckenberk Pro MySQL, and Celko's SQL For Smarties. And you should definitely check out the upcoming 2nd edition of High Performance MySQL when it comes out. I'm one of the authors and I promise it will be an excellent book. I very much enjoy reading An introduction to database systems by Date (Eight Edition), it goes back to the root and forward from there. Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle MS SQL Server Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Sun to buy Mysql
I tend to think this blogger is correct: Sun is directly competing with Red Hat to become the heart of the open-source business community. And Oracle may be in for a fight ... http://blogs.cnet.com/8301-13505_1-9851662-16.html -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 16, 2008 7:07 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: RE: [SPAM] - Re: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject - Email found in subject Oracle and Sun has a tight relationship right? Wouldn't there be a conflict of interest? -Original Message- From: Sebastian Mendel [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 16, 2008 10:03 AM To: [EMAIL PROTECTED] Cc: Jerome O. Macaranas; mysql@lists.mysql.com Subject: [SPAM] - Re: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject - Email found in subject Richard Heyes schrieb: Will this bring good things to MySQL? $800,000,000 tends to bring good things. Hopefully. :-) ??? why, this payment goes to current owners and investors, not to MySQL itself ... but anyway, using Suns structures and power will help of course ... -- Sebastian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Sun to buy Mysql - mysql press release
http://mysql.com/news-and-events/sun-to-acquire-mysql.html -- /Brett C. Harvey; /Creative-Pages.Net, President; /Facility Management Systems, CTO (www.waldo.com/www.fmsystems.biz); /Lasso Professional Alliance Member ID #LPA135259 (www.lassosoft.com); -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
compare and diff programs?
hi there, sorry if this email doesn't follow policy correctly, its my first post here. we had a master/slave setup between 2 servers and 98% of the data seems to have moved correctly, but there is a seemingly random 2% that didn't arrive in the right way. for example records with a higher ID are there and some with a lower IDs are missing concrete question is is there an excellent linux tool or method that allows for comparing missing records and moving just those? many thanks paul
Re: compare and diff programs?
Hi Paul, On Jan 16, 2008 12:19 PM, Paul Berry [EMAIL PROTECTED] wrote: hi there, sorry if this email doesn't follow policy correctly, its my first post here. we had a master/slave setup between 2 servers and 98% of the data seems to have moved correctly, but there is a seemingly random 2% that didn't arrive in the right way. for example records with a higher ID are there and some with a lower IDs are missing concrete question is is there an excellent linux tool or method that allows for comparing missing records and moving just those? Yes. Maatkit: http://maatkit.sourceforge.net/ The short and sweet: mk-table-checksum with --replicate on the master, then mk-table-sync to correct the differences. Baron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Storing Larger MySQL Backups
Hey all, I'm curious if anyone has any thoughts on how I can handle a data retention issue I've been facing with a larger dataset. My process, roughtly is run mysqldump against the DB and gzip the output. Then I transfer it off to a different machine for archival onto optical media (yes I know there's a shelf of the media life involved there). This is a secondary backup to the backup I'm doing for system recovery purposes - not the only method of backup, but I don't have access to that storage system as it's provided via the ISP. Recently the file has gotten so big it doesn't fit on a standard DVD-R media any longer. I've considered only backing up key data, but for the archive it's much more convenient to have the entire structure intact in one location - additionally, we occasionally build a test machine from this data so it's integrity is moderately important. Ideally, I'd like to be able to script the compression and slicing right on the server that does the backup, but I realize this may not be possible. I'm looking at using RAR to archive the output file and slice it into smaller segments so I can distribute the data over 2 DVD-R (or multiple CD-R's if so desired.) Does anyone have any feedback on this approach? Without laying out money for a higher capacity DVD/BlueRay drive or tape backup system, what options are you using for data retention? Thanks for your thoughts. Erik Giberti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: import from exel into mysql
But my test result is different with you,here is my test mysql truncate table c_t; Query OK, 0 rows affected (0.00 sec) mysql load data infile '/tmp/Book1.csv' into table c_t fields terminated by ',' lines terminated by 'w'; Query OK, 1 row affected (0.00 sec) Records: 1 Deleted: 0 Skipped: 0 Warnings: 0 mysql select * from c_t\G *** 1. row *** f1: ee f2: shit ll 1 row in set (0.00 sec) mysql truncate table c_t; Query OK, 0 rows affected (0.00 sec) mysql load data infile '/tmp/Book1.csv' into table c_t fields terminated by ',' lines terminated by '\n'; Query OK, 5 rows affected (0.01 sec) Records: 5 Deleted: 0 Skipped: 0 Warnings: 0 mysql select * from c_t\G *** 1. row *** f1: ee f2: shit *** 2. row *** f1: ll f2: ff *** 3. row *** f1: dd f2: ddss *** 4. row *** f1: ssd f2: fdfd *** 5. row *** f1: 34 f2: dsfas 5 rows in set (0.00 sec) mysql On 1/14/08, Jason Pruim [EMAIL PROTECTED] wrote: Hi Hiep, Here's what I do when I need to do that. First save it as a .csv file and then follow this: load data infile '/path/to/file' into table MyTable fields terminated by '\t' lines terminated by 'w' that has always worked for me. Hope it helps! On Jan 14, 2008, at 10:51 AM, Hiep Nguyen wrote: hi everyone, i have a large ms excel data (text) file that i need to import to my table in mysql. does any one have a suggestion how to do this? i'm try to export to csv file, then import to my table, but i have so much problems with delimeters thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 3251 132nd ave Holland, MI, 49424 www.raoset.com [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Sun and MySQL
Hello: Does this mean that MySQL is headed for closed source? re: Sun buys MySQL. And does it mean that someone may be wanting back licensing fees? Just curious, and too lazy to chase down links and stories. Jeff K -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
