Concurrent Inserts with merged table

I'm working on a system that uses merged tables with insert method LAST, and occasionally the application runs a LOAD DATA INFILE with a pretty big input data set. During the load data, other users running selects are blocked. As it stands at this time, some of the constituent merged tables in the

Re: insert question

On Tue, Feb 24, 2009 at 8:53 PM, PJ wrote: > Is there a way to insert several rows into a table with one statement? > I have this: > $sql2 = "INSERT INTO authors >(first_name, last_name, ordinal) VALUES > ('$first_nameIN', '$last_nameIN', '1')"; >$result2 = mysql_query(

insert question

Is there a way to insert several rows into a table with one statement? I have this: $sql2 = "INSERT INTO authors (first_name, last_name, ordinal) VALUES ('$first_nameIN', '$last_nameIN', '1')"; $result2 = mysql_query($sql2, $db); I want to avoid doing another insert lik

Re: mysqlimport huge table

Thanks for the resource! However, I am loading into a MyISAM table, while logging is disabled. In a matter of fact, I was able to load the data at the end, after disabling the keys. But now, as I try to create the keys, it takes a huge amount of time. there are 250 Million rows in one of the

Upgrade story / request for insight

My ultimate goal is to upgrade a production server (MySQL 4.1.22 on CentOS) to a modern 5.1 release. My development system is a Windows Vista x86 machine, and although the process is not that similar I decided to try an upgrade there. (I've never done one.) I figured this would give me some insight

Re: [PHP] Re: how to deal with multiple authors for one book

On Tue, Feb 24, 2009 at 8:59 AM, PJ wrote: > Reinhardt Christiansen wrote: > > > > > > > >> From: PJ > >> To: MySql > >> Subject: how to deal with multiple authors for one book > >> Date: Mon, 16 Feb 2009 17:20:54 -0500 > >> > >> In my db there are a number of books with several authors; so, I

Re: mysqlimport huge table

Hello Shuly, Try this. http://www.mysqlperformanceblog.com/2008/07/03/how-to-load-large-files-safely-into-innodb-with-load-data-infile/ On Tue, Feb 24, 2009 at 1:08 PM, Shuly Avraham wrote: > Hi, > > I have a huge table with about 50 millions of rows. > I dumped the table using mysqldump -T ,

mysqlimport huge table

Hi, I have a huge table with about 50 millions of rows. I dumped the table using mysqldump -T , as text dump, and now trying to import it to a database on another server, but it keeps hanging. Are there any options or server variables I can set to help out with it? Thanks, Shuly. -- MySQL Ge

Re: Best RAID for a DB + LVM?

SCSI/FC/SAS drives are absolutely faster, especially at 15kRPM. Your requirement of IOPS vs Usable space may actually make it less expensive to use FC drives (ex. if you don't have to retain much data but need it to be really fast _all_ the time). This can be especially true if you take datacente

Re: how to get text SQL log

thank you for your reply :) I've roughly read some source codes about MYSQL_BIN_LOG & Log_Event. It seems that the way which mysql writes binlog in is per Log_Event. In that case, records are stored in sequence, just like plain text logs does. So, even if I can write pure SQLs into an another plai

Mysql server [ERROR] Can't create interrupt-thread (error 22, errno: 22)

>Description: I am running unstable and I did an upgrade on Monday the 23. When I did this it upgraded mysql-server-5.0. Once the upgrade was done mysql would not start. I then did a dist-upgrade and mysql-server will still not start. This is the version it is trying to install: mysql-server-5.0

Re: how to deal with multiple authors for one book

Reinhardt Christiansen wrote: > > > >> From: PJ >> To: MySql >> Subject: how to deal with multiple authors for one book >> Date: Mon, 16 Feb 2009 17:20:54 -0500 >> >> In my db there are a number of books with several authors; so, I am >> wondering how to set up a table on books and authors to be

Re: how to get text SQL log

Hi, On Mon, Feb 23, 2009 at 11:10 PM, Cui Shijun wrote: > hi, >  I've been using mysql-5.1.22 in my project, which processes a lot of > read operations but little write operations. I got the idea from some > of my coworkers that binlog has a chance to be corrputed so that > mysqlbinlog can't proc

Re: Best RAID for a DB + LVM?

Hi Waynn, On Sun, Feb 22, 2009 at 7:46 AM, Waynn Lue wrote: > I currently have a RAID 5 setup for our database server.  Our space is > running out, so I'm looking to increase the disk space.  Since I'm doing > that anyway, I decided to re-evaluate our current disk array.  I was told > that RAID 5

case when then

table_1 id pid nid --- 1 60 2 05 table_2 (referer -> pid) id title body --- 1 title1 body_text1 2 title2 body_text2 3 title3 body_text3 4 title4 body_text4 5 title5 body_text5 6 title6 body_text6 7 title7 body_text