Mysql Table partitioning

hi all, I want to know some information about table partitioning. consider following script create table `customers`( `CustomerID` varchar(40) not null, `TimeCreated` DATETIME not null default 0, `TimeModified` datetime not null default 0, `isActive` tinyint not

RE: Mysql Table partitioning

Try it and see where the data goes. It amazing how much you learn by doing it. The first problem that you will see is the PK and unique keys in partitioning have to have the partition key as part of the index. So your PK would have to be CustomerID, TimeCreated -Original Message-

mysql replication....

hi... a quick question that i haven't found an answer to. i can use replicate-do-db=foo in a my.cnf file for replication, to replicate the master foo db on the slave. but this requires that i use/have a my.cnf set on the slave. is there a way to dynamically set this attribute/parameter within

Re: mysql replication....

bruce wrote: hi... a quick question that i haven't found an answer to. i can use replicate-do-db=foo in a my.cnf file for replication, to replicate the master foo db on the slave. but this requires that i use/have a my.cnf set on the slave. is there a way to dynamically set this

Re: mysql replication....

You can only do that in the my.cnf file. On Nov 27, 2007 9:50 AM, bruce [EMAIL PROTECTED] wrote: hi keith... i recognize you can't do multiple masters to a single slave with mysql's replication. but you can setup separate mysql slave dbs that are independent, and that yo can then

RE: mysql replication....

ok... you guys have convinced me!! my.cnf it is! so, one more question. is there an attribute i can use to run/restart mysql using a given my.cnf file... i can simply have a number of separate my.cnf files, and point to them when i run/restart mysql.. /etc/init.d/mysqld --??? myown.cnf is

RE: mysql replication....

hi keith... i recognize you can't do multiple masters to a single slave with mysql's replication. but you can setup separate mysql slave dbs that are independent, and that yo can then iteratively walk through each slave/master, one at a time, and then do the sync/update for each one... this

Re: SELECT Speed

At 05:57 PM 11/26/2007, you wrote: The second query might be faster due to caching. This can be verified by executing: RESET QUERY CACHE before executing the second query. This will clear the queries from the cache. Mike -- MySQL General Mailing List For list archives:

Re: mysql replication....

The relevant options are... [EMAIL PROTECTED] ~ $ mysqld --help --verbose | grep default --no-defaults Don't read default options from any options file --defaults-file=# Only read default options from the given file # --defaults-extra-file=# Read this file after the global files

Re: SELECT Speed

On Nov 27, 2007 10:21 AM, mos [EMAIL PROTECTED] wrote: At 05:57 PM 11/26/2007, you wrote: The second query might be faster due to caching. This can be verified by executing: RESET QUERY CACHE before executing the second query. This will clear the queries from the cache. No need to blow

Spfile in Mysql......

Hello, The dynamic changes made on mysql server instance gets vanished once the instance goes down...!! Is there any way for mysql to store the dynamic changes on my.cnf file automatically ..?(like Oracle) , so on next startup mysql automatically pickup the dynamic changes made from my.cnf

Re: Spfile in Mysql......

On Nov 27, 2007 11:44 AM, Shanmugam, Dhandapani [EMAIL PROTECTED] wrote: Hello, The dynamic changes made on mysql server instance gets vanished once the instance goes down...!! Is there any way for mysql to store the dynamic changes on my.cnf file automatically ..?(like Oracle) , so on next

Re: MySQL master-master replication on windows platform information wanted

At 12:01 PM 11/27/2007, you wrote: Who has experience with setting up master-master replication with MySQL between two Windows-servers. I would like to try setting it up and am looking for experiences, tips an possibly a hands-on manual. Arno Bouwman. Arno, The search engine is your

mysql_library_init() and threading

I'm using the C API to write a client, and I'm having trouble getting my connection to work in a worker thread. I'm confused by manual's tutorial for threading. I don't believe I need any of the thread-safe measures, because while the worker thread is running, the main thread doesn't make any

Re: Spfile in Mysql......

Hi, Mysql should bring this as there new feature in there next release! Regards, Sujatha On Nov 27, 2007 11:44 AM, Shanmugam, Dhandapani [EMAIL PROTECTED] wrote: Hello, The dynamic changes made on mysql server instance gets vanished once the instance goes down...!! Is there any way

mysql client command \G and blob fields

I've been experimenting with storing image data in blob fields, and I was surprised that using the mysql client to select the field with a semi-colon query terminator resulted in the binary data being dumped to the terminal (with lots of beeping) while using the \G query terminator resulted in

Re: Spfile in Mysql......

Sujatha S wrote: Mysql should bring this as there new feature in there next release! Unlikely. Dynamic changes are, well, dynamic. Permanent stuff goes in the my.cnf. -jay Regards, Sujatha On Nov 27, 2007 11:44 AM, Shanmugam, Dhandapani [EMAIL PROTECTED] wrote: Hello, The

Re: Spfile in Mysql......

Yes! I think in oracle the dynamic changes are recorded in spfile.. so that it uses on instance startup.. rather making an permanent entry in pfile. Regards, On 11/28/07, Jay Pipes [EMAIL PROTECTED] wrote: Sujatha S wrote: Mysql should bring this as there new feature in there next release!

Re: Spfile in Mysql......

This has probably already been over-talked about :) but I will throw my two cents in. I would be very much opposed to a situation where changes made on-the-fly are stored permanently in the my.cnf file. If I decide to keep a change to a server setting I am very much capable of doing it

Re: Spfile in Mysql......

persisting session-specific configuration items to system wide data stores does appear to be problematic.. perhaps sujatha could explain the reasoning behind this shift? M- - Original Message - From: B. Keith Murphy [EMAIL PROTECTED] To: 'mysql list' mysql@lists.mysql.com Sent: Tuesday,

preferred way to backup a 20GB MySQL database

Hi, What is the preferred way to backup a 20GB database daily, without taking offline ? MySQL 4.1 MyISAM - (will be updated to MySQL 5) 133 table(s)  Sum 115,416,561  latin1_swedish_ci  20.1 GB Thanks, Andras -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: preferred way to backup a 20GB MySQL database

Andras Kende wrote: Hi, What is the preferred way to backup a 20GB database daily, without taking offline ? MySQL 4.1 MyISAM - (will be updated to MySQL 5) 133 table(s) Sum 115,416,561 latin1_swedish_ci 20.1 GB Mysqlhotcopy -- MySQL General Mailing List For list archives:

Re: preferred way to backup a 20GB MySQL database

I'd strongly recommend setting up replication, and then taking your backups from the replica. mysqlhotcopy works great, I used it for years myself, but it does require freezing your database while the copy happens. And no matter how you do it, copying 20 GB takes a little bit of time. Dan On

V6.0.3 XML files

LOAD XML LOCAL INFILE 'test.xml' INTO TABLE bids ROWS IDENTIFIED BY 'Bid'; Above command is now valid in V6.0.3 cleanly ingests properly formatted XML files. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: preferred way to backup a 20GB MySQL database

I would echo what Dan says. In addition, from the slave server, you might look at running the new mysql-parallel-dump tool that Baron Schwartz has developed. It essentially does a dump with a thread running (by default) for each CPU core you have. A dual core box will run two threads and

show slave staus

hi.. simple question!! mysql show slave status returns a number of fields, with information on the status of the slave. is there a way to only return the field(s) i'm interested in... i thought that i had figured this out, but i can't recall, and it's been awhile since i've played with this!

Re: show slave staus

You can set pager command to grep out unwanted fields. On 11/28/07, bruce [EMAIL PROTECTED] wrote: hi.. simple question!! mysql show slave status returns a number of fields, with information on the status of the slave. is there a way to only return the field(s) i'm interested in... i

RE: show slave staus

hi alex.. thanks for the reply. but i thought i had seen a way in mysql, to specify the given field that i want. the show slave status cmd obviously displays a list of fields, so i'm pretty sure that there should be a way of just displaying the targeted field, without having to parse using

Re: show slave staus

mysql show slave status returns a number of fields, with information on the status of the slave. is there a way to only return the field(s) i'm interested in... i thought that i had figured this out, but i can't recall, and it's been awhile since i've played with this! My slave server isn't

Re: Spfile in Mysql......

Hi all The same thing mysql also uses it own defaults file if my.cnf is not found. It uses its own defaults-extra-file configurations to start the db. Yeah but only specific variables can be changed globally or session wise. Others needs recycling of db. :-) - Original Message

RE: Mysql Table partitioning

Thanks Joe, I have edit the script and added primary key (CustomerID, TimeCreated ) and did partitionong on (TimeCreated) by range. I inserted some records according to partition year . How would i know which partition contains what record? (as i am using Windows Xp