Mysql takes server down

Hi everybody, I am running a LAMP installation with mysql 3.x installed. Since a few hours the szstem load goes up till the server crashes. I have to reboot it, and then 60 minutes later it is gone again! Server is running now for over 2 years. I do have the impession that mysql is the reason

about libmygis

Hi Jeremy Cole, I downloaded the source code about libmygis and compiled it on linux.I tried to use it ,but I don't know how to use it correctly,especially when i tried to import from shapefile data and associated files and generate MySQL commands in an output file . Can you tell me how to

RE: Configure options question

I am sorry if I was vague. I know my version of PHP supports .png images. My developers are having issues with extracting .png images files from a mysql database that's why I wanted to make sure it wasn't a support issue with mysql. They can upload the files into the database just fine.

Re: Configure options question

Lopez, Denise wrote: I am sorry if I was vague. I know my version of PHP supports .png images. My developers are having issues with extracting .png images files from a mysql database that's why I wanted to make sure it wasn't a support issue with mysql. They can upload the files into the

Re: Mysql takes server down

At 11:39 AM 4/12/2007, you wrote: Hi everybody, I am running a LAMP installation with mysql 3.x installed. Since a few hours the szstem load goes up till the server crashes. I have to reboot it, and then 60 minutes later it is gone again! Server is running now for over 2 years. I do have the

Mysql Hogging all system resources

I have a customer that loaded up a HUGE table and was doing all sorts of fancy stuff in it, and not waiting for the process to finish before sending the same query, and eventually loading up the server to the point where the only thing I could do was unplug it. Is there a way to prioritize or set

RE: Configure options question

-Original Message- From: Lopez, Denise [mailto:[EMAIL PROTECTED] Sent: Thursday, April 12, 2007 2:07 PM To: [EMAIL PROTECTED] Subject: RE: Configure options question I am sorry if I was vague. I know my version of PHP supports .png images. My developers are having issues with

Re: renaming database

Yeah, in SQL: RENAME DATABASE start_name TO new_name; -Micah On 04/12/2007 01:34 AM, Octavian Rasnita wrote: Hi, How can I rename a database if it contains InnoDB tables? I have tried renaming the directory where it is located, but it doesn't work this way. Is there a method that works

Why Is Autonumber Not Working With Following Query

I have the following query: INSERT INTO summaries (entity_name, job_type, job_status) (SELECT entity_name, GOV, Non-Workable FROM tmpSummaryTable); The only other column I have is id and it is primary key autonumber int. Why would I get the following error? ERROR 1062 (23000) at line 3:

Re: Why Is Autonumber Not Working With Following Query

Wow, I am a little tired... this is the query causing me the problem... INSERT INTO jobs (SELECT * FROM tmpJobs WHERE NOT EXISTS (SELECT * FROM jobs WHERE jobs.customer_number = tmpJobs.customer_number and jobs.job_number = tmpJobs.job_number)); Why is the id not creating distinct #s? On

alter engine

Now i want to change myisam table to innodb table using alter table ... engine innodb. But the process is too slow! Need i increase key_buffer_size? Need i increase innodb_buffer_pool size?

key_buffer_size and InnoDB tables

On the following page and in the example ini files installed with MySQL it's suggested that key_buffer_size is an option that affects MyISAM performance. http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html But on the following page about tuning MySQL server parameters, it says

Re: when rebuilding keys?

yes. before load data. You want to rebuild the indices after loading data, correct? Then what exactly is the question? Please write your answer BELOW, not above. Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle MS SQL Server Upscene

Re: when rebuilding keys?

- Original Message - From: Martijn Tonies [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, April 12, 2007 3:17 PM Subject: Re: when rebuilding keys? yes. before load data. You want to rebuild the indices after loading data, correct? Then what

can't import

I'm at total loss. apparently, error 13 relates to file permissions? what could possibly be preventing the import? http://paste.husk.org/8073 for: [EMAIL PROTECTED] ~]$ [EMAIL PROTECTED] ~]$ ll /tmp/abc.txt -rw-r--r-- 1 thufir thufir 33 Apr 12 06:59 /tmp/abc.txt [EMAIL PROTECTED] ~]$ cat

Re: can't import

Thufir wrote: I'm at total loss. apparently, error 13 relates to file permissions? what could possibly be preventing the import? Change to the mysql user (you might have to go to root and then mysql): # su - mysql then try it: cat /tmp/abc.txt what happens? -- MySQL General Mailing

renaming database

Hi, How can I rename a database if it contains InnoDB tables? I have tried renaming the directory where it is located, but it doesn't work this way. Is there a method that works faster than dumping it with mysqldump then re-create it under another name? Thanks. Octavian -- MySQL

Re: can't import

Hmmm, your LINES TERMINATED BY '/r/n'; should be: LINES TERMINATED BY '\r\n'; if the abc.txt file was generated on windows. If it was made on *nix/linux, it should be: LINES TERMINATED BY '\n'; -- Later Mogens Melander +45 40 85 71 38 +66 870 133 224 On Thu, April 12, 2007 09:58, Thufir

Re: Can I create a index on a column of Type datetime?

You should probably create two separate indexes, one on source_url and one on create_date. Unless you are frequently searching on both source_url and create_date. Remember that an index is really just sorted data that can be searched quickly.Since create_date will have pretty unique values, it

RE: when rebuilding keys?

From: wangxu Sent: Thu 12/04/2007 08:38 - Original Message - From: Martijn Tonies [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, April 12, 2007 3:17 PM Subject: Re: when rebuilding keys? yes. before load data. You want to rebuild the

Query Question

Hi, Suppose that there are two tables book and author: book id title author_id author - od title I want a query that returns all the books, but if there are more than 3 books with the same author_id, only 3 should be returned. For example if this is the contents of the book

InnoDB data log files

Hello all, I am looking after the installation of web-based software built using MySQL with mostly InnoDB tables. The software is currently installed in over 10 locations and has been running continually for several months in some of these. These installations vary from several thousand to

Re: Query Question

Behrang Saeedzadeh wrote: Hi, Suppose that there are two tables book and author: book id title author_id author - od title I want a query that returns all the books, but if there are more than 3 books with the same author_id, only 3 should be returned. For example if this is

Re: when rebuilding keys?

before load data. You want to rebuild the indices after loading data, correct? Then what exactly is the question? Please write your answer BELOW, not above. sorry ,my english is poor. There is a observable event. My table's engine is myisam. Rows above 100 in my

Re: Query Question

Hi Behrang, Behrang Saeedzadeh wrote: Hi Baron, Thanks. That that worked great. Is it possible to insert an empty row after the books by the same author? -Behi On 4/12/07, Baron Schwartz [EMAIL PROTECTED] wrote: Behrang Saeedzadeh wrote: Hi, Suppose that there are two tables book and

Re: InnoDB data log files

In the last episode (Apr 12), Andrew Simpson said: One server had a problem while creating a backup last week. The routine normally takes about 30 seconds, but in this case went on for over 30 minutes. During this, the application was responding correctly to other users. After a reboot,

Re: Query Question

Hi Baron, Please remember to reply to the list so others can read and benefit from answers to your questions. Also, though I don't care tremendously one way or another, many people think it's good form to place your response after the message instead of before (I tend to follow the pattern

MySQL Connector/J 5.1.0 Alpha has been released

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, MySQL Connector/J 5.1.0 a new alpha version of the Type-IV pure-Java JDBC driver for MySQL has been released. Version 5.1.0 is suitable for use with any MySQL version including MySQL-4.1, MySQL-5.0, MySQL-5.1 beta or the MySQL-5.2 Falcon

Configure options question

I have a beginner question for you all. I recently took over a server and would like to determine what configure options were given when MySQL was compiled. Currently the MySQL version is 4.1.10 and I would like to know whether the mysql server was compiled with .png support. Thanks in advance

RE: Configure options question

-Original Message- From: Lopez, Denise [mailto:[EMAIL PROTECTED] Sent: Thursday, April 12, 2007 12:51 PM To: [EMAIL PROTECTED] Subject: Configure options question I have a beginner question for you all. I recently took over a server and would like to determine what configure

MySQL 5.1.17 Beta has been released

Dear MySQL users, We are proud to present to you the MySQL Server 5.1.17 Beta release, a new Beta version of the popular open source database. Bear in mind that this is a beta release, and as any other pre-production release, caution should be taken when installing on production level systems or