Re: Extensive Project help

On Mon, 2007-07-30 at 10:06 -0500, Brian E Boothe wrote: > hi all > i have a pretty extensive Project Going on and it would be nice to get > some input on my tables and joins schema, i'd like to send someone my > SQL as for them to help me > thru the rough spots if they could, or i could pos

Re: inserting data - speed

The most obvious is to make sure you are doing bulk inserts, which you may already be doing. MyISAM tables use table locking, so you usually can't insert while a search is occurring. There are a few exceptions and v5 (5.1?) has another option you can set so inserts are always added to the e

Re: Best way to backup three live databases

Hi, The best two suggestions I can give you are LVM snapshots for binary backups, or using replication so you can back up the slave. Since you have InnoDB tables, my personal opinion is the safest way to get a good LVM snapshot is to shut down the server and take the snapshot; you can then b

Best way to backup three live databases

We've got a production system with three databases. The three databases together represent one logical set of data. The databases contain a mixture of MyISAM and InnoDB tables. What is the best way to backup the entire system (i.e. all three databases) to ensure that I get a coherent snapshot of

Re: Migration from Oracle to MySQL

Martijn Tonies wrote: LOL - an entertaining read! Entertaining? I feel to see the humor in his post. I thought it was concise and well written, with an undertone of "I know I'm swearing in church but...". So yes, I found it entertaining (I agree that it was not necessarily humorous

Re: inserting data - speed

At 04:37 AM 7/30/2007, Octavian Rasnita wrote: Hi, I made 2 similar programs that insert data continuously in 2 similar MyISAM tables, each one in its own table. Both tables have the same data (3.5 million records), but one of the tables is update much slower. The slower table is also access

Re: Log Files

of course you'll need to restart the server after making the changes to the options file.. On 7/30/07, Christian High <[EMAIL PROTECTED]> wrote: > set these options in the option file under the [mysqld] section > > log-slow-queries= > log= > > log= is the general query log > > i am not sur

Re: Log Files

set these options in the option file under the [mysqld] section log-slow-queries= log= log= is the general query log i am not sure what you mean by the mysql log. if you mean the error log than that would be log-error= if you mean the binary log that would be log-bin= if you don't enter anyt

Extensive Project help

hi all i have a pretty extensive Project Going on and it would be nice to get some input on my tables and joins schema, i'd like to send someone my SQL as for them to help me thru the rough spots if they could, or i could post the enitre SQL here for u to use, please someone respond as i woul

Re: Mysql monitering and performance tool

Hi Everybody, I tried to search for a script which can moniter as well as send an alerts (by email). But i am not able to found any good scripts which can give better informations for example the complete innodb status, deadlocks, mysql errors and warnings. If any body know such script which can c

Re: Mysql monitering and performance tool

Mark Leith wrote: Baron Schwartz wrote: Mark Leith wrote: Baron Schwartz wrote: I stand corrected. I don't know why I didn't think of this! So you guys had to go the route of parsing InnoDB status too, huh? Fun, isn't it! Indeed, it is a rather interesting thing to do ;) Made even better

Re: Mysql monitering and performance tool

Baron Schwartz wrote: Mark Leith wrote: Baron Schwartz wrote: I stand corrected. I don't know why I didn't think of this! So you guys had to go the route of parsing InnoDB status too, huh? Fun, isn't it! Indeed, it is a rather interesting thing to do ;) Made even better when it is limite

Re: Mysql monitering and performance tool

Mark Leith wrote: Baron Schwartz wrote: I stand corrected. I don't know why I didn't think of this! So you guys had to go the route of parsing InnoDB status too, huh? Fun, isn't it! Indeed, it is a rather interesting thing to do ;) Made even better when it is limited to 64K and truncated

Re: Mysql monitering and performance tool

Baron Schwartz wrote: I stand corrected. I don't know why I didn't think of this! So you guys had to go the route of parsing InnoDB status too, huh? Fun, isn't it! Indeed, it is a rather interesting thing to do ;) Made even better when it is limited to 64K and truncated with large transact

Re: Migration from Oracle to MySQL

> > Storage engines are unique to MySQL? yes. Is that good? YMMV. Most > > of the purported benefits can be achieved with Oracle's features > > without the compromises of balkanised storage engines. You're right, > > they're not offered by Oracle, or anyone else ... there's a reason no > > oth

RE: grants

Grant user for slave: GRANT REPLICATION SLAVE, REPLICATION CLIENT, RELOAD, SUPER on *.* TO 'username'@'IP Slave' IDENTIFIED BY 'password'; ToanDA -Original Message- From: Ananda Kumar [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 03, 2007 8:59 PM To: MySQL General Subject: grants Hi Al

inserting data - speed

Hi, I made 2 similar programs that insert data continuously in 2 similar MyISAM tables, each one in its own table. Both tables have the same data (3.5 million records), but one of the tables is update much slower. The slower table is also accessed by other programs for getting data from it.

Upgrading mysql questions

Hi, I'm currently running several Joomla websites and phpBB forums on an old FreeBSD server running mysql-server 3.23. Yesterday I upgraded the mysql installation to 4.0.27 successfully. No problems at all. First I made backups, then deinstalled mysql 3.23 and finally installed 4.0.27. I then ran t