Re: store transaction rollback information

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 Photographer -- MySQL General Mailing

Re: Commit commands with SELECT

, 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 submit to the database

Re: Tuning mysql

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: importing mysql structures only or restore ignoring non-existing tables and columns?

- 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 -- MySQL General Mailing List For list archives: http

Re: add index to slave but not master

. 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: how to understand seconds_behind_master

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://lists.mysql.com

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 tpol...@engineyard.com wrote

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

ideas. Kind regards, -- Luis Motta Campos On 23 Oct 2011, at 23:27, Claudio Nanni claudio.na...@gmail.com 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' by unique mutexes

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

in the future. Kind regards, -- Luis Motta Campos

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

(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 regards, -- Luis Motta Campos is a DBA, Foodie

Re: Triggers - Accessing all NEW data

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.mysql.com/mysql?unsub=arch

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

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 LuisMottaCampos). Cheers -- Luis Motta Campos is a software engineer, Perl Programmer, foodie and photographer. -- MySQL

Database Migration Path / Activity List?

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

Re: Database Migration Path / Activity List?

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 fanatic evangelist, and amateur {cook, photographer} -- MySQL General

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 looks like you have planned well for all but using