Re: store transaction rollback information

ted, the changes are permanent. Rolling it back may still be possible, but it will be complicated and extremely expensive, computationally speaking. I strongly recommend you to review your design choices. I hope this helps. Kind regards, -- Luis Motta Campos is a DBA, Foodie, and Photographe

Re: Commit commands with SELECT

like I am, benchmark, benchmark, benchmark. My 0.02€. Kind regards, -- Luis Motta Campos is a DBA, Foodie, and Photographer On 9 Apr 2012, at 20:47, Karen Abgarian wrote: > I vote 1) yes 2) no > > It could be result of the app developer's convenience to just wrap anything > they

Re: Tuning mysql

(if you're not one of them) and take into consideration all the information you have at hand. I hope this helps with getting started. Good luck, and kind regards. -- Luis Motta Campos is a DBA, Foodie, and Photographer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: add index to slave but not master

tions. Good luck. Cheers! -- Luis Motta Campos is a DBA, Foodie, and Photographer -- Luis Motta Campos is a DBA, Foodie, and Photographer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: importing mysql structures only or restore ignoring non-existing tables and columns?

he trick if I back-up data -> > import structure -> restore the data.) You can use SELECT...INTO DUMPFILE and LOAD DATA INFILE... to achieve what I believe you're asking here, save the eventual misunderstanding. ;-) Cheers -- Luis Motta Campos is a DBA, Foodie, and Photographer -

Re: how to understand seconds_behind_master

different indexes than the master; or with locked tables because of long-running-queries), this will be as precise as seconds-behind-master, no more than a lousy estimate. Cheers. -- Luis Motta Campos is a DBA, Foodie, and Photographer -- MySQL General Mailing List For list archives: http:

Re: 5.1.51 Database Replica Slows Down Suddenly, Lags For Days, and Recovers Without Intervention

same for you in the future. Kind regards, -- Luis Motta Campos

Re: 5.1.51 Database Replica Slows Down Suddenly, Lags For Days, and Recovers Without Intervention

and fresh ideas. Kind regards, -- Luis Motta Campos On 23 Oct 2011, at 23:27, Claudio Nanni wrote: > Luis, > > Very hard to tackle. > In my experience, excluding external(to mysql) bottlenecks, like hardware, > o.s. etc, 'suspects' are the shared resources 'guarded

Re: 5.1.51 Database Replica Slows Down Suddenly, Lags For Days, and Recovers Without Intervention

The data size is about 200 GB. I would have noticed increase on writes. No backup activity is running (actually I don't do conventional backups). Any theories? Thank you for your interest. Kind regards, -- Luis Motta Campos On 23 Oct 2011, at 14:06, Tyler Poland wrote: > Luis,

5.1.51 Database Replica Slows Down Suddenly, Lags For Days, and Recovers Without Intervention

sue both on severs with and without workload (apart from the usual replication load). I am sure no changes were applied to the server or to the cluster. I'm looking forward for suggestions and theories on the issue - all ideas are welcome. Thank you for your time and attention, Kind r

Re: Triggers - Accessing all NEW data

s this possible or do I > need to write a function? Hi, You'll have to write your own function for that. Cheers -- Luis Motta Campos is a DBA, Foodie, and Photographer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mys

Re: How much memory can mysql 5.1 take advantage of?

bugs and half-implemented standards that plague 5.0.45 (the latest pre-compiled stable version available for CentOS 64 bits). Please feel free to address me if you need more information about that, either here or at the FreeNode's #mysql IRC channel (my nick there is LuisMottaCampo

Re: Database Migration Path / Activity List?

Baron Schwartz wrote: > On Jan 2, 2008 10:04 AM, Luis Motta Campos wrote: >> Baron Schwartz wrote: >>> What are the biggest changes you anticipate? I'd say they will be >>> the version upgrade, converting to InnoDB, and using >>> replication. It loo

Re: Database Migration Path / Activity List?

d definitely experiment with > replication. Thanks for the advice. I will start reading right away. I would like to read more comments from the members of this list. Thank you all for your patience and help. Cheers! -- Luis Motta Campos (a.k.a. Monsieur Champs) is a software engineer, Perl fa

Database Migration Path / Activity List?

ction Restore Database Using the Restore Procedure Test Database in Production Environment Start Database in Production Environment Database Monitoring Follow Up Database Behavior and Performance - END TASK LIST - -- Luis Motta Campos (a.k.a. Monsieur Champs)