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

The idea here is to perform this change without restarting the server. Is that possible? I know that by updating the config file, then restarting will allow the database to be in read-only mode, but need to know if it is possible without restarting. Thanks, CL At 11:46 AM 8/3/2007, Clyde

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

Binary Log and Load Data Local

le" local or otherwise has HUGE implications when you are looking at a backup strategy. Am I missing some thing here? Are there any work arounds, or should it be said that if you want EXACT replication of data DON'T use "Load data infile"? Thanks Clyde England -

Windows Users FeedBack

it would be lucky to be 5% but I would sure like to know if someone has some statistical data on this. Thanks Clyde England - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

When are MyIsam Tables physically updated?

this stage I just need to know how/when MySql Physically writes the tables to disk. Thanks Clyde England - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Merge Table weird result - bug?

the merge table I used mysqldump and then cut and paste. This was also the method I used to create table2 from table1, so I am quite sure all the table definitions are the same. Could this be a bug? Am I missing something here? Thanks Clyde England PS I get the feeling it is the index that is

Lock Tables Query

ing to hang. Better still if there is a system variable or something I can check first to see if the file is locked - but I can't seem to find this in the docs. Most other databases I have used have a timeout value (like the record lock for innodb) so I am having trouble dealing with thi

Re: Lock Tables Timeout value?

This behavior occurs with record locks using InnoDB files. I would have thought a similar approach would have applied to File locks? Thanks Clyde England - Before posting, please check: http://www.mysql.com/manual.php (

Lock Tables Timeout value?

Hi, I have searched the docs but can't seem to find information on the time out value for "Lock Tables" (probably just me) When using "Lock Tables" how long does MySql wait before giving up if it can't get a lock? Is there any way of changing this time ou

Re: Select * from names where words(name) = 3

near instant on my now aging P500 256mb PC) Thanks again. Clyde England *** REPLY SEPARATOR *** On 8/01/2003 at 11:45 PM Dan Nelson wrote: >In the last episode (Jan 09), Clyde England said: >> I have a database of names and would like to do a selection based on >>

Select * from names where words(name) = 3

uch a function as words(string) which returned the number of words in a string then the simple select syntax would be: select * from names where words(name) = 3 Of course in MySql there is no such function (that I am aware of) - so any ideas how I can achieve this result. Thanking You Clyde Engaln

Re: How to Unlock a row?

Clyde, - Original Message - From: ""Clyde"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Saturday, January 04, 2003 11:47 AM Subject: How to Unlock a row? > Hi, > > Using MySql with InnoDB files you can lock rows for update. > Eg se

How to Unlock a row?

want to go ahead with the update. Scenario: User selects records to update. User changes mind (clicks on cancel button) Now we have locked rows that need to be unlocked. How to do this? Thanks Clyde - Before posting

Re: how to get the correct result -- Thrid Time --

On Sat, 20 Oct 2001, Adrian D'Costa wrote: | Date: Sat, 20 Oct 2001 12:04:53 +0530 (IST) | From: Adrian D'Costa <[EMAIL PROTECTED]> | To: Clyde Jones <[EMAIL PROTECTED]> | Cc: [EMAIL PROTECTED] | Subject: Re: how to get the correct result -- Thrid Time -- | | On Fri, 19

Re: how to get the correct result -- Thrid Time --

ct 2001, Adrian D'Costa wrote: | Date: Fri, 19 Oct 2001 10:43:31 +0530 (IST) | From: Adrian D'Costa <[EMAIL PROTECTED]> | To: Clyde Jones <[EMAIL PROTECTED]> | Subject: Re: how to get the correct result -- Thrid Time -- | | Hi, | | Thanks. It gave an error but it work after a

Re: how to get the correct result -- Thrid Time --

n Fri, 19 Oct 2001, Adrian D'Costa wrote: | Date: Fri, 19 Oct 2001 10:43:31 +0530 (IST) | From: Adrian D'Costa <[EMAIL PROTECTED]> | To: Clyde Jones <[EMAIL PROTECTED]> | Subject: Re: how to get the correct result -- Thrid Time -- | | Hi, | | Thanks. It gave an

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