Advanced Indexing

Is there a way to only include certain matching conditions in indexes? Example if I have a row I want to index that is mysql dates (2007-06-07) and I only want to include CURRENT and FUTURE dates in the index and ignore any past dates. Is that possible at all? The issue I have is that the

Using Triggers to Maintain a Table to prevent complex join statements...

We have a statement that joins 8 different tables to pull multiple rows from each table. I have heard of people using triggers to create, update and delete records in a table based on statements in other tables. The obvious result of this would be to SPEED up results right? :) I'd love to

Re: 2 ways replication

Here are some links for you... http://www.howtoforge.com/mysql_master_master_replication http://sequoia.continuent.org/ http://www.howtoforge.com/loadbalanced_mysql_cluster_debian_p5 --- Rilawich Ango [EMAIL PROTECTED] wrote: Hi all, I know it is an old question and I have read from the

Managing Excess Connections

I'm having an issue where an application will open multiple connections to mysql that will remain open. Eventually, the server will get bogged down with these connections or reach the max connections and stop allowing new connections. I'm working with the application vendor to resolve the issue

Re: Managing Excess Connections

Rolando, You are my hero! Thank you very much, this was extremely helpful. --- Rolando Edwards [EMAIL PROTECTED] wrote: 1) Are you opening connections and properly (explicitly) closing them ??? If you are using PHP, Please make sure you close all mysql_query requests with two(2) calls

Re: comparing two databases

I use SQLBalance for MySQL. It's got a couple of minor bugs, but it's been great for us. http://www.dswsoft.com/sqlbalance.php Steve Buehler [EMAIL PROTECTED] wrote: Is there a program out there that I can use to compare two databases? Just the structure, not the content. Thanks Steve

Re: Best MySQL client for Linux?

Omnipilot, the makers of the LASSO application server now offer a free developer version of lasso professional. It has the best web-based database browser and SQL utility that I've ever seen. It has native MySQL connectors, it's a snap to get up and running. Cory Scott Baker [EMAIL

Anyone tried solidDB for MySQL?

I've heard absolutely wonderful things about this transaction-safe storage engine. We're using InnoDB now and are always looking for the best solution as we scale our DB operations. Has anyone tried the SolidDB for MySQL beta stuff yet? What do you think of it? Cory.

Re: ugly SQL for a report...

Slightly new query.. Here's the new query and results of an explain.. I'm thinking that some indexing would help.. However, I don't really know where to start. --- EXPLAIN SELECT pnr.ID ID_pnr, pnr.reservationdatetime, pnr.conf_number, pnr.created_by,

Re: ugly SQL for a report...

SELECT pnr.ID ID_pnr, pnr.reservationdatetime, pnr.conf_number, pnr.created_by, GROUP_CONCAT(pp.name_last,', ',pp.name_first ORDER BY name_last DESC SEPARATOR 'br') names, (SELECT SUM(pf.base_fare*(SELECT COUNT(1) FROM pnr_passengers pp WHERE pp.ID_pnr=pnr.ID )) FROM pnr_fares

Best field type for exact matches on alphanumeric fields.

I'm runnung MySQL-Cluster 5.0.15 on Linux. I have to do some re-design of a website database that has quickly outgrown itself. I'm trying to migrate to MySQL Cluster 5.0.15. Mostly I've used VarChar fieldtypes in the past, but I want to make sure I'm using the best fieldtype for

Re: cluster or replication

Is it possible to have cluster and replication? (ie clusters at each location and replication to sync each location) Alan Williamson wrote: I've 10 server in differents locations, I want to make a broadcast, I would like to have always datas synchronized between this network, each database

RE: cluster or replication

of the box' MySQL package will do what you want -- I could be wrong though. It seems to me that this is something that is going to become more and more popular so I'd be really surprised is MySQL-AB isn't already cooking something up. -Cory Robin, SkyVantage Corporation -Original Message

Re: Recommendations on new hardware

Brent Baisley wrote: If you do go the new hardware route, I wouldn't go with SCSI is you only have $2K to spend. S-ATA2 based drives would give you similar performance to SCSI, but at a big cost savings. SCSI's big performance advantage was in command queueing which SATA2 drives now

Re: Default setup on new system

did you start mysql with --initial ?? Dotan Cohen wrote: Hi list, I just setup mysql and apache on my Fedora Core 4 machine. I intend to use MySQL through php. I understand that I must first create a user, but I can't find out how! Even on the mysql site the tutorial starts off assuming that

Need help with a query..

or it searches through 5 days (+- 3 on search date) I hope this makes sense.. I'm new to all this stuff. Eventually I'm going to do the same thing for times as well.. Thanks in advance for any help! Cory Robin SkyVantage -- MySQL General Mailing List For list archives: http://lists.mysql.com

MySQL (SQL) Newbie.. Need help with a Query

I'm trying to return all records between two dates.. The fields are datetime fields... Which is better? The following or using BETWEEN? (A little lost here) SELECT * FROM passengers WHERE reservation_date_time = '2005-01-01 12:10:00' AND reservation_date_time = '2005-05-01 12:10:00'; --