Re: only update if values different
Hello, with good indeces 100 000 rows is basically nothing. Give it a try. Peter Nick Meyer wrote: > What is the best way to UPDATE a row only if values are different? We > have a mainframe extract that literally has 100,000 rows and am worried > about the performance of just running INSERTs each night. > > Is there a simple comparison command or would you have to nest a SELECT > statement? Thank you, > > Nick > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: OT: LAMP appliance for non-profit use
I think you look for something like: http://directadmin.com/ Peter Saqib Ali wrote: > Hello All, > > I know this is little bit off-topic but I think users of this group > can give good advice on this topic. > > We have a in-house built application using MySQL + PHP + Apache. It is > essentially a elaborate collection of online forms that will be used > for managing school scholarship in the 3rd world countries. The > student/teachers will either come to the office or fill out the forms > online. > > We have identified few pilot location and would like to deploy this > application. However due to lack of IT support at the location we have > decided to use a pre-configured appliance which support the LAMP > stack. All we want to do is directly ship the appliance to the > location, and remotely install our app. > > We want the appliance to require minimal maintenance and > administration, and have a auto-update feature to get security patches > etc. > > I had previously worked on a similar project and used Sun Cobalt 550 > servers. But now I think Sun has stopped making them and you can only > buy them refurbished and the auto-update features are severely > limited. > > Any other suggestion??? We want the appliance to cost us $1,000 / unit. > > Thanks > saqib > http://www.full-disk-encryption.net > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Show the engine/table type for the specific table...
show table status; Carlos On 12/10/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Hi friends, How to show the engine/table type of the one table in my database?? I want to know the engine/table type (InnoDB, MyIsam.) for the tables that I did in my database. Thanks. Wagner Bianchi -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Show the engine/table type for the specific table...
Hi friends, How to show the engine/table type of the one table in my database?? I want to know the engine/table type (InnoDB, MyIsam.) for the tables that I did in my database. Thanks. Wagner Bianchi
Re: Differnt logs for each databse
Sachin Sharma a écrit : > > Hi, > > Is it possible to have logs for each database into differnt files ? > Rather on single file with log=/var/log/mysqld.log. It's not possible no... Maybe you should look at running different mysql instance for each of them that need separate lock! (Prevent join between the db but allow for tuning of param for each, and allow more memory to be used than the 3-4G limit per process on 32bits architecture) mysqld_multi allows easy management of those kind of setup! -- Mathieu Bruneau aka ROunofF === GPG keys available @ http://rounoff.darktech.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: only update if values different
On 09/12/06, Nick Meyer <[EMAIL PROTECTED]> wrote: What is the best way to UPDATE a row only if values are different? We have a mainframe extract that literally has 100,000 rows and am worried about the performance of just running INSERTs each night. Is there a simple comparison command or would you have to nest a SELECT statement? Thank you, Nick You have to check the line first, then compare and update if neseccary. I've been through that recently, and decided that it was better to just UPDATE. Of course, I had much less rows than you do. Maybe you could store an array of changed rows in whatever language you are programming, then update from that? Or a text file, another DB, whatever... Dotan Cohen http://what-is-what.com/what_is/digg.html http://dramatherapy.info -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
only update if values different
What is the best way to UPDATE a row only if values are different? We have a mainframe extract that literally has 100,000 rows and am worried about the performance of just running INSERTs each night. Is there a simple comparison command or would you have to nest a SELECT statement? Thank you, Nick -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]