MySQL 6.0.2-alpha and Falcon and possible bug/problem

Hi All, I have started using MySQL 6.0.2 with Falcon on Linux with Debian 4. I have compiled the source code for 64 bit executable. The system is an Intel 2 cpus 4 cores each, with 8 GB of RAM. I have started creating tables (without partitioning) whit engine type Falcon. After having created ap

Re: Fulltext Index / Index .. both?

Justin wrote: I'm wanting to add a new field to my table that I will both be grouping by, searching with full text hits and plain likes.. I know I'll need a FULL TEXT index, but will that full text index also index like a normal index will? or should I also add an index too.. You'll need to ad

Fulltext Index / Index .. both?

I'm wanting to add a new field to my table that I will both be grouping by, searching with full text hits and plain likes.. I know I'll need a FULL TEXT index, but will that full text index also index like a normal index will? or should I also add an index too.. thanks.

Re: Use of slave server for read only queries

Ashok Chauhan wrote: Hi All, I'm using Mysql 5 (with replication) on CentOS 4.4 OS with 2 CPU and 8GB of RAM. Master & Slave servers have same hardware configration. Now i want to know, should i use slave server for fetching read only queries. if yes, then how ?. Thanks Ashok The simple wa

RE: Using MAX function to fetch primary id

> -Original Message- > I need to select a max value for a group of records and I > also need the > primary key for that record. > > I am wondering if this can be done with a single query? e.g > > Table_x > > id count cat_id > 110 1 > 220 2 > 335

Using MAX function to fetch primary id

Hi, I need to select a max value for a group of records and I also need the primary key for that record. I am wondering if this can be done with a single query? e.g Table_x id count cat_id 110 1 220 2 335 2 415 1 with SELECT id, cat_id, max

RE: changes in tables (developemnt -> production)

What I do here is: Back up the production DB. Restore it on the development server. Do the development. When a schema change is needed I write SQL to alter(upgrade) the development DB to match development needs. When development is done, restore the production DB to the development server again. M

Re: Slow MySQL Table Inserts

Chris Portka wrote: I'm trying to create a table in MySQL with a few simple requirements, but my table loads data very slowly. I need two columns, one of them a 10 digit string and another a very large integer. These pairs must be unique. There must be an index on the 10 digit string for fas

Slow MySQL Table Inserts

I'm trying to create a table in MySQL with a few simple requirements, but my table loads data very slowly. I need two columns, one of them a 10 digit string and another a very large integer. These pairs must be unique. There must be an index on the 10 digit string for fast lookups. Here's h

Kjbzukxhytopdho

Dear user mysql@lists.mysql.com, Mail system administrator of lists.mysql.com would like to inform you that: We have received reports that your email account was used to send a huge amount of spam during this week. Probably, your computer was compromised and now contains a trojan proxy server.

Re: Use of slave server for read only queries

It seems that the trunk version supports RO/RW splitting: http://jan.kneschke.de/2007/8/1/mysql-proxy-learns-r-w-splitting and http://jan.kneschke.de/2007/8/26/mysql-proxy-more-r-w-splitting -- Augusto Bott On 9/7/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > On Fri, 07 Sep 2007 07:05:3

MySQL Proxy Topics

I'd like to speak/write with someone, off the list, on the MySQL Proxy project who might be involved in the following topics I found on the MySQL Proxy Cookbook: # (TODO) Advanced - Use a Proxy between master and slaves to monitor replication traffic # (TODO) Guru - Use a Proxy between master

Re[2]: Mysql Web interface for normal Users

Hi! Just wanted to bring up an old topic - the situation with mysql web clients is the same as last year or is there any new good software? Something that would be easy to use and look nice to the users? I'm also looking for something quite simple yet enough customizable. Thanks! Martins Tuesd

Re: Use of slave server for read only queries

> On Fri, 07 Sep 2007 07:05:31 +0200, Ashok Chauhan <[EMAIL PROTECTED]> > wrote: > >> Hi All, >> >> I'm using Mysql 5 (with replication) on CentOS 4.4 OS with 2 CPU and 8GB >> of RAM. >> Master & Slave servers have same hardware configration. >> >> Now i want to know, should i use slave server for

table based replication into a different db

Hi all, i would like to replicate just tables beginning with a certain prefix while the replication slave host's database name also differs. i remember i once read something about it, but can't really find it on the net anymore, so does anyone have a hint for me here, or even know exactly what