45 minutes to check table to complete
Hi, I've got a database that is closed to 7G. I'm using the Standard 4.1.14 version. The table was corrupt and I had to do a lot of moving of data to free up enough space on the partition as I discovered I needed at least twice the database size to do a recover. Well, using myisamchk -o worked. I then ran check table in the mysql client to see what it would say. It said all was well. I'm just suprised that it took 45 minutes to run. Anyone run check table on large databases? What kind of times did you encounter? I must say this is on an OLD box ... maybe 512 RAM and right now I don't now the disk drives used. Peter -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
does mysqlimport actually recreate the table schmea as well as import data?
Hi, A cohort wrote a script to import tab delimited files. He uses mysqlimport. He uses the -d option to ONLY empty the data from the table before importing the new data. My cohort believes that mysqlimport is also dropping the table and then recreating the table from somewhere and then inserting the new data. And the problem according to him is that apparently MySQL is using some older version of the table which has a different column structure so that when the new data is imported it goes into the wrong columns. Anybody familiar with this? He says it's an optimization of MySQL to drop the table first ... but I have seen no confirmation. Peter http://www.coremodules.com/ Web Development and Support at Affordable Prices 901-757-8322[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: capturing mysql errors in Perl
On 20 Apr 2001, at 14:16, yogi wrote: errors mySQL throws are not captured by the Perl CGI using mySQL, but are thrown regardless, meaning that a CGI that provokes an error in mySQL will produce an unspecified "Internal Server Error", which is not very helpful for debugging purposes. It looks as if mySQL goes straight to the OS with the error, instead of giving Perl the chance to handle it? And how can this be avoided? Thank you in advance, Yogi This should be obvious but I mention it because it works for me. Search for eval on this page, or just reread the whole page: http://www.oreilly.com/catalog/perldbi/chapter/ch04.html I don't think this is mysql specific as following the above instructions works for me with mysql. Peter All idioms must be learned. Good idioms only need to be learned once. --Alan Cooper - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Perl list
On 6 Apr 2001, at 15:03, Kristopher Briscoe wrote: Does anyone know of a good list(s) relating to PERL and MySQL? Also, any good repositories of example code? As you are using the DBI you should be on the DBI list: http://lists.perl.org/showlist.cgi?name=dbi-users but you might be interested in some other lists: http://lists.perl.org/ Peter --- "Reality is that which, when you stop believing in it, doesn't go away". -- Philip K. Dick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ISP
On 26 Mar 2001, at 19:48, Daniel Mercury wrote: Who knows any good ISP giving root access to Mysql? Best I know of is iserver.com. http://www.iserver.com/support/virtual/mysql/install.html Peter --- "Reality is that which, when you stop believing in it, doesn't go away". -- Philip K. Dick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ISP
On 26 Mar 2001, at 17:54, Curtis Maurand wrote: I would give you root access to your database, but not to Mysql as a whole unless you want a dedicated server. Too dangerous. I have used iserver.com for about the last 4 years. I can start mysql,create databases etc. I find the entire setup at iserver.com to be about as close to getting your own box as you can without paying for your own box. There are limitations (no imagemagick for instance) but we have about 90% of our websites there (only a few with their own box). http://www.iserver.com/support/virtual/mysql/install.html Peter __ Exercise Your Brain, Read a Book -- O Crazy Gringo, Ipanema, Brazil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php