Re: Loading date takes a long time after replication

2010-12-06 Thread Raj Shekhar
In infinite wisdom Sairam Krishnamurthy wrote: > [1 ] > All, > > I have a situation. We have a very large database(gigabytes). When we > load the data in to the table, it will be huge again (20 million rows). > So in order to get good backup we set up a replication(master-slave > setup). But

Re: MySql - crashes daily

2010-12-06 Thread Raj Shekhar
In infinite wisdom Basil Daoust wrote: > Any help greatly appreciated. > > Our mysql is restarting a LOT! > Here is what is in the log, it doesn't seem to give much help. > Do you have the coredump from this crash? If yes, can you load the core dump into gdb and run "bt" (backtrace) and see w

Re: Loading date takes a long time after replication

2010-12-06 Thread Sairam Krishnamurthy
Thanks Guys. Let me check these options and will get back with the results. Thanks again. Thanks, Sairam Krishnamurthy +1 612 859 8161 On 12/06/2010 04:47 AM, Ananda Kumar wrote: Also, make sure your /tmp folder is on a separate and fast disk. We had similar issues and we moved /tmp folder fr

Tüzifa fabrikett zsákosszén

2010-12-06 Thread brikettnagyker . hu
TÜZIFA - FABRIKETT - ZSÁKOSSZÉN Meghozzuk az otthon melegét. www.tuzelonagyker.hu Tisztelt Hölgyem/Uram . Engedje meg hogy figyelmébe ajánljam kínálatunkat. Nálunk megtalálja a megoldást, ha... - Ön tüzelõt keres a családi háza gazdaságos, kényelmes és biztonságos fûtésére a fûtési s

Using MySQL in the Cloud? Help us by answering a short survey and win a T-shirt

2010-12-06 Thread Avigail Ofer
Hello! With the rise of cloud computing and "big data", database scalability issues are becoming critical to the growth and success of many applications. Xeround's MySQL Cloud Database is an elastic, always-on database that lets you run your existing MySQL-based application in the cloud. As we

Re: Loading date takes a long time after replication

2010-12-06 Thread Ananda Kumar
Also, make sure your /tmp folder is on a separate and fast disk. We had similar issues and we moved /tmp folder from Local to SAN storage and it was quite fast. regards anandkl On Mon, Dec 6, 2010 at 4:10 PM, Johan De Meersman wrote: > Are you saying that mass inserts go much slower now that you

Re: Loading date takes a long time after replication

2010-12-06 Thread Johan De Meersman
Are you saying that mass inserts go much slower now that you've set up replication? In that case, I suspect you have your binlogs on the same disk as your data. Put the binary logs on separate disks, and you'll notice a dramatic increase in performance. On Mon, Dec 6, 2010 at 7:17 AM, Sairam Kri