RAID or not?

: 723.720 Thanks, -Jackson -- jackson miller cold feet creative 615.321.3300 / 800.595.4401 [EMAIL PROTECTED] cold feet presents Emma the world's easiest email marketing Learn more @ http://www.myemma.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Raw partition with InnoDB on Windows 2000

- Reply: [EMAIL PROTECTED] -- jackson miller cold feet creative 615.321.3300 / 800.595.4401 [EMAIL PROTECTED] cold feet presents Emma the world's easiest email marketing Learn more @ http://www.myemma.com -- MySQL General Mailing List For list archives: http

Re: RAID or not?

the RAID? -Jackson jackson miller cold feet creative 615.321.3300 / 800.595.4401 [EMAIL PROTECTED] cold feet presents Emma the world's easiest email marketing Learn more @ http://www.myemma.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Optimizing imports

for CONCURRENT when using InnoDB? Isn't that the default for InnoDB? If not, does it lock the entire InnoDB table while the insert is running? -Jackson HansH -- jackson miller cold feet creative 615.321.3300 / 800.595.4401 [EMAIL PROTECTED] cold feet presents Emma the world's easiest

Re: PHP or Perl?

To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- jackson miller cold feet creative 615.321.3300 / 800.595.4401 [EMAIL PROTECTED] cold feet presents Emma the world's easiest email marketing Learn more @ http://www.myemma.com -- MySQL General Mailing List For list archives: http

Optimizing imports

rows at a time? If so, is there a magic number or range? The same would also go for updates. Thanks, -Jackson -- jackson miller cold feet creative 615.321.3300 / 800.595.4401 [EMAIL PROTECTED] cold feet presents Emma the world's easiest email marketing Learn more @ http://www.myemma.com

Re: Temporary Table Problem - Help

table not created); Any ideas why this might be happening? Anya Miretsky Computer Technology Dept. Brooklyn Botanic Garden 1000 Washington Avenue Brooklyn, NY 11225 (718)623-7265 [EMAIL PROTECTED] -- jackson miller cold feet creative 615.321.3300 / 800.595.4401 [EMAIL PROTECTED

Hardware recommendation

I am going to have to put MySQL on it's own box, and I am wondering what makes the biggest difference with hardware. I am hoping to set max_connections to 1000 at least (and I will probably use at least 500 several times a day). There are a few tables that are almost constantly running

mysqlcc LIMIT

mysqlcc has a limit of 1000 on all queries I run. I can understand this for SELECT queries, but it makes no sense for INSERT... SELECT queries. Is there a way to override this limit? -Jackson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: speeding up lookups on a table

This could be caused by table locking. If another Mysql process ha a lock on the table then other processes start to queue up. Maybe this query is getting stuck behind other queries or a single slow query. Just a thought. -Jackson On Saturday 26 July 2003 11:00, Bennett Haselton wrote: I

Re: How to export db or table structure?

mysqldump --opt -Jackson On Friday 25 July 2003 10:39, Jim McAtee wrote: We have a very large MySQL database, and the designer of the database no longer works for us. I need to re-create the same table structure, but without the content, on a separate machine. I know I can do a show

Re: How do I show column names in php?

Try: $result = mysql_query(SHOW COLUMNS FROM table_name); while ($row = mysql_fetch_array($result)) { foreach ($row as $key=value) { echo $key = $value; } } -Jackson On Wednesday 23 July 2003 9:32, Jake Johnson wrote: I am using php and mysql and I want to show the column

Upgrading to MySQL 4

I need to migrate a 3.23.52 MySQL server to a version with InnoDB (and row level locking). The catch is, I need to do it in a hurry (by the end of the week). It is a production system with over 300 users. Some tables have over 2,000,000 rows. The main question I have is should I take this

Getting table comments

I have a short and simple question that I can't find an answer to. Is there a way to return table comments with a query? Thanks, -Jackson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

More tables or more joins

I am working on a program that is essentially a contact management tool for multiple users. There are currently about 200 users and will be over 1000 eventually. Each user may have between 10 and 500,000 contacts. Where it gets interesting is that each user needs to have the ability to

Re: More tables or more joins

] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts. On Wed, 2 Jul 2003, Jackson Miller wrote: I am working on a program that is essentially a contact management tool for multiple