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 ea
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
> essentiall
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 Bianch
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
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 b
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
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,
