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

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

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 To: MySQL

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)

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 [EMAIL PROTECTED] wrote: Guys, I'm

Reapply bin-log question( Help Please)

, ~ 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

Re: MySQL Benchmarking

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 for a tool

MySQL Benchmarking

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.mysql.com

Gaining statistics from MySQL

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 unsubscribe:http

[JOB] MySQL DBA, Raleigh, NC

in 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.

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

RE: Find foreign key for a table

wrote: show create table tablename? -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

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

MySQL Read_only Mode

. 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]

Re: MySQL Read_only Mode

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 now allowing any updates to me applied

Cannot kill Query process

(prtStkQty 0) Thanks in advance *** Clyde Lewis Database Administrator General Parts, Inc. 919-227-5100

Show row number

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

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 not exist in the base data

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

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

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

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 dropped

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

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

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

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.

Re: Index update process 20+ hrs

`) | +---++-++-++-+-+--+---++-+-++---+--++---+ 1 row in set (0.11 sec) [EMAIL PROTECTED] wrote: Clyde Lewis [EMAIL PROTECTED] wrote on 08/29/2005 01:47:11 PM: 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

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

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

Ibbackup and GNR

. 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 PROTECTED] -- MySQL

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] -- MySQL

Binary Log and Load Data Local

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 - Before posting, please check: http://www.mysql.com

When are MyIsam Tables physically updated?

on this - but at 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

Windows Users FeedBack

is that 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

Merge Table weird result - bug?

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 part of the problem, because if I remove the index and re-create the files, all is OK

Lock Tables Query

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 this scenario. Any Ideas. Thanks Clyde England

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 out value? Thanks Clyde England

Re: Lock Tables Timeout value?

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 (the manual) http://lists.mysql.com/ (the list archive

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

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 the number or words

Select * from names where words(name) = 3

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 Engalnd PS: one obvious solution is to add

How to Unlock a row?

not 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 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 select * from customer where cusomerID=1 for update

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 Oct 2001, Clyde Jones wrote

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

: 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 adding the \n. Now the | result

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

) | 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 adding the \n. Now the | result is: | | +--+-+ | | id | replace(nome_hotel