Spreading Database across multiple disks

Howdy all, We're looking at building a new database server and I'm looking into strategies for optimizing disk i/o. Bit of background. We will be running a single database on this box under MySQL 5.0.15. All of the tables are INNODB. We have about 130 tables in the db. I've read that it's a

MySQL on AMD Althelon Dual Core processors

Hello, I'm looking to replace and aging an aging database server and was wondering if anyone has any advice about AMD Opteron dual/quad core processors and MySQL on a 64 bit box. We're currently running MySQL 5.0.15 and we'd like to stay with that release. Are there any problems with running

INNODB Question

Howdy all, I'm trying to clean up a development server so that we can retask it. I tried dropping a very large but no longer necessary database that uses INNODB tables exclusively. Unfortunately the disk usage on the box didn't change. We're using a completely default MySQL 5.0.15 install on the

Query optimization

Howdy all, I've got a question regarding optimizing a query. I've got two tables: listing and listing_city_xref listing is a pretty wide table with many fields that can be queried by users. There is a subset of fields that are always in queries of this table but there are many additional

Re: Query optimization

Jim, here's an example query: SELECT COUNT(listing.listing_id) AS listing_count FROM listing_city_xref INNER JOIN listing ON listing.listing_id = listing_city_xref.listing_id AND listing.group_id = listing_city_xref.group_id WHERE listing_city_xref.group_id =2 AND listing_city_xref.city_id IN

RE: Lost Connection executing query

message, for list of things to try. http://dev.mysql.com/doc/refman/5.0/en/gone-away.html Ed -Original Message- From: Tripp Bishop [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 03, 2006 4:45 PM To: mysql@lists.mysql.com Subject: Lost Connection executing query Howdy all

RE: Lost Connection executing query

MySQL Optimizes WHERE Clauses Early detection of invalid constant expressions. MySQL quickly detects that some SELECT statements are impossible and returns no rows. Ed -Original Message- From: Tripp Bishop [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 04, 2006 11:01 AM

Lost Connection executing query

Howdy all, First off, We're running 5.0.15. Theres a particular update statement that we run that updates data in several tables. On our mac OSX test server (also running 5.0.15) the query executes quickly and without any errors or warnings. On our linux box, which is our production box, we get

Upgrading to 5.0.15

Howdy all, I've got a MySQL 4.0.24 database that I'd like to upgrade to 5.0.15. Is it possible to backup the tablespace file in the mysql data directory and then install the new database then move the backed up files into the new installations data directory? Are we stuck running a mysqldump

Re: Declare Cursor Question

Howdy all, I've got a question about declaring cursors. In particular is there a way to allow the select statement used to populate the cursor be variable? I've tried a couple of the obvious approaches with no luck. Failing that, is there a way to have a cursor be an input parameter to a stored

Re: Declare Cursor Question

Rhino, Sorry about that. I'm running 5.0.15. I'll explore the prepared statement angle. Cheers, Tripp --- Rhino [EMAIL PROTECTED] wrote: - Original Message - From: Tripp Bishop [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Monday, December 19, 2005 3:45 PM Subject: Re

Declare Cursor Question

Howdy all. I need to define a cursor in a stored procedure but I don't know what the nature of the select statement is going to be until runtime. I need to do something like the code below: IF (INSTR(city_name, ',') 0) THEN DECLARE cur_neighborhood CURSOR FOR SELECT DISTINCT neighborhood

Connection Problem

Hello all, Suddenly in the last hour or so the connection speed between our webserver and database server has skyrocketed to the point that our site is no longer usable! Just trying to connection via the mysql client takes a long time. Once the connection is established, however, queries seem to

Re: Connection Problem

was captured from our PHP logs. Not sure what that's on about. We'll just have to monitor it and see if pattern develops. Thanks for your help. Cheers, Tripp --- Michael Stassen [EMAIL PROTECTED] wrote: Tripp Bishop wrote: Hello all, Suddenly in the last hour or so the connection speed

Re: Grant confusion

[EMAIL PROTECTED] wrote: Tripp Bishop wrote: Simple question: I'd like to create a user that has all privileges for just one database on the server. When I try the following: grant all privileges on my_db.* to 'myuser'@'%.mydomain.com' identified by 'foobar'; the statement

Grant confusion

Simple question: I'd like to create a user that has all privileges for just one database on the server. When I try the following: grant all privileges on my_db.* to 'myuser'@'%.mydomain.com' identified by 'foobar'; the statement runs fine. If I think try to connect to the server through the