RE: MySQL in read-only mode

This will be not that easy as there is a large array of different users accessing the DBA at different time during the day/night. CL t 11:58 AM 8/3/2007, Edward Kay wrote: > -Original Message- > From: Clyde Lewis - DBA [mailto:[EMAIL PROTECTED] > Sent: 03 August 2007 16:55 &g

Re: MySQL in read-only mode

Lewis - DBA wrote: Is this possible with MYSQL using the innodb engine? If so, what is the command/process to make this happen. Thanks in advance, ~ Clyde Lewis Database Administrator ~ Clyde Lewis Database Administrator

MySQL in read-only mode

Is this possible with MYSQL using the innodb engine? If so, what is the command/process to make this happen. Thanks in advance, ~ Clyde Lewis Database Administrator

Multiple binary log files question

log file and not knowing which database the changes are associated with while attempting to reapply the changes. Thanks in advance ~ Clyde Lewis Database Administrator

Re: Reapply bin-log question( Help Please)

t;. or from binlog_sql.sql, check the insert or update that is giving "foreign key fail" error, know the position just before this sql and recovery till that position and then recovery from position after this sql still till the end of file. regards anandkl On 6/20/07, Clyde Lewis - DBA &

Reapply bin-log question( Help Please)

Thanks in advance, ~~~~~ Clyde Lewis Database Administrator

Query question

Guys, I have the following table that contains some information about a cars. I'm trying to write a query to determine: the number of make(name of car), number of models per make(name of car) and the average number of models/make(name of car) sold in a particular period. The two queries belo

Re: MySQL Benchmarking

ld be the best idea. Again, thanks. CL At 06:39 PM 3/15/2007, Alex Greg wrote: On 3/14/07, Clyde Lewis <[EMAIL PROTECTED]> wrote: System Configuration: Sun Microsystems sun4u Sun Fire E2900 System clock frequency: 150 MHZ Memory size: 65536 Megabytes CPU: 12 @ 1200 MHz I'm looking

MySQL Benchmarking

same machine. Any help of ideas would be greatly appreciated with this decision. Thanks in advance, *** Clyde Lewis Database Administrator General Parts, Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysq

Gaining statistics from MySQL

el, but am not currently aware of how to move for forward. Release: 4.1.20 OS: Solaris 10 Thanks in advance, ******* Clyde Lewis Database Administrator General Parts, Inc. 919-227-5100 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscrib

[JOB] MySQL DBA, Raleigh, NC

this position please submit your resume, salary requirements, and a paragraph highlighting your skills/experience as it pertains to this job to [EMAIL PROTECTED] *** Clyde Lewis Database Administrator General Parts, Inc.

RE: Find foreign key for a table

t wrote: show create table ? -Original Message----- From: Clyde Lewis [<mailto:[EMAIL PROTECTED]>mailto:[EMAIL PROTECTED] Sent: Tue 11/14/2006 10:16 AM To: MySQL List Subject: Find foreign key for a table Hello, How can I find the foreign keys for a table? I would like to be able to fin

Find foreign key for a table

Hello, How can I find the foreign keys for a table? I would like to be able to find, for any table, the columns that are foreign keys and what tables/columns the foreign keys are related to. Basically what I am trying to do is this. My developers want to allow logical deletes of data. I don't wan

MySQL Swapping problem

A little confused as to why MySql is swapping when there is more than enough real memory still available on the server. I'm having a serious problem with a production server running out of swap space and in turn causing mysql to crash with the following error message. According to the TOP repor

Re: MySQL Read_only Mode

with just select right and use him? "Clyde Lewis" <[EMAIL PROTECTED]> escreveu na mensagem news:[EMAIL PROTECTED] > All, > > Does MySQL have an option where the database can startup in READ-ONLY > mode? The idea is to have the server running with users connected, but >

MySQL Read_only Mode

e. If someone can point me in the right direction, it would be greatly appreciated. Thanks in advance, *** Clyde Lewis Database Administrator -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Cannot kill Query process

T pobRecvQty = CASE WHEN (prtStkQty < 0) Thanks in advance *** Clyde Lewis Database Administrator General Parts, Inc. 919-227-5100

Re: Show row number

Excellent explanation. Thanks again. CL At 02:00 PM 1/25/2006, [EMAIL PROTECTED] wrote: Clyde Lewis <[EMAIL PROTECTED]> wrote on 01/25/2006 01:41:30 PM: > Is there a command in mysql that will return the row number. I > tried rownum and rownum() > No, "rows" do n

Show row number

Is there a command in mysql that will return the row number. I tried rownum and rownum()

General logging vs. bin logging

Hello, I'm trying to get a handle on who is making what changes in my database, but cannot seem to find user/account info in the bin-logs besides the actual update that was made. Is there a way in which MySQL logs not only the changes, but also the user account that updated a record in the da

Re: copy database other than mysqldump

You could copy the entire mysql directory structure to an isolated area on disk. This will involve stopping the instance though. Luke Vanderfluit wrote: Hi. I'm using 4.0.18 and for legacy reasons I can't upgrade that. However I'm upgrading the database to a new schema. I want to copy the da

Re: Verify DML(Mysterious DROP TABLE command in production)

I did check the binlog and saw that the command ran along with the timestamp. Is there a way to figure out who ran the command? [EMAIL PROTECTED] wrote: Clyde Lewis <[EMAIL PROTECTED]> wrote on 09/26/2005 02:44:40 PM: Guys, Our production database had a table that was suddently d

Verify DML(Mysterious DROP TABLE command in production)

Guys, Our production database had a table that was suddently dropped "a mystery". I need to find out if there is a way to find the user account that performed this function. No one is taking ownership and I need to know if there is a way to find out. Thanks in advance -- MySQL General Mai

Mysql to Oracle migration

Does anyone know of a straght forward approach to migrate a mysql(4.1.11) Schema to Oracle(9i release 2). Also, please provide any best practices. Thanks in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PR

stopping drop index command on table

What are the consequences of cancelling(stopping) the drop index on table command if any at all? The process is running on a 9GB table and need to stop the process (dev environment). Thanks in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

innodb thread concurrency size

Hey guys, I'm looking for any best practices or a formula that is commonly used in setting the value for thread concurrency in the configuration file. I have 24 instances running on a sun 2900 server with 32GB or ram. Here is a sample of my configuration file. #use this line mfor mysql 4.1 old

Re: Index update process 20+ hrs

, `prtDoNotReturn` enum('N','Y') NOT NULL default 'N', `prtSalesHistTot` int(10) NOT NULL default '0', `prtSalesHistPrd` smallint(5) NOT NULL default '0', PRIMARY KEY (`prtPNID`), UNIQUE KEY `prtUPN` (`prtPN`,`prtStore`,`prtMfg`), KEY `prtSort` (`prtSort`), KEY `sku1` (`prtSKU`,`prtStore`), KEY `prtIPN` (`prtStripped`,`prtStore`,`prtMfg`), KEY `prtDESC` (`prtDesc`,`prtStore`), KEY `prtWrtyTypeID` (`prtWrtyTypeID`), KEY `prtStore` (`prtStore`,`prtMfg`), CONSTRAINT `parts_f1` FOREIGN KEY (`prtStore`) REFERENCES `c

Index update process 20+ hrs

Guys, I have a huge table to which I'm attempting to update the foreign key and index. It is taking me more than 20 hrs to complete the process and would like to know if someone can point me in the right direction. Please let me know of any additional information that I should provide. mysq

Multiple my.cnf files

Does anyone have any experience using multiple my.cnf files on a single box? If so, how is the my.cnf specified during startup and shutdown? I need multiple my.cnf files to test ibbackup software because it does not currently support using mysqld_multi. CL -- MySQL General Mailing List For lis

Import problem

I used mysqldump with the -t option to only dump the raw data. I'm in the process of importing the dump to a new database with seed data loaded. I'm attempting to override the existing dataset but continue to get the following message when the import encounters a duplicate entry: Duplicate entry

Multiple database backup solution

I'm in need of a hotbackup solution that supports multiple instances on the the same server. Currently, I'm dumping the databases nightly and would like to know if anyone know of an alternative. I've tested innodb, but have not had any success getting it to work with more than one group(mysqld[GN

Ibbackup question

I'm in the process of testing this backup utility and need to know if anyone have any experience using it as their primary backup solution. Any help would be greatly appreciated. Thanks in advance. *** Clyde Lewis DBA General Parts (919)227-5100 [EMAIL PROTECTED] --

Ibbackup and GNR

databases. I'm still testing and have not yet purchased support, but thought that I could get some feedback from this list. Any help would be greatly apprecciated in helping me move forward with this testing. ******* Clyde Lewis DBA General Parts (919)227-5100 [EMAIL PROTECT

Installing Mysql GUI

Hello, I was able to download the .gz file, but was not able to go any further with the installation. Is there an installation guide available online. Looking forward to using this tool. * Clyde R. Lewis Database Mana