search for: binlog

Hello. El 11/10/14 21:19, Theodore Ts'o escribió: > If you are running some workload which is constantly calling fsync(2), > that will be forcing journal commits, and those turn into cache flush > commands that force all state to stable storage. Now, if you are > using CF cards that aren't guaranteed to have power-loss protection > (hint: even most consumer grade SSD's

Hi All I have an Asterisk 1.8.32.3 instance that will at random intervals stop logging CDR data to MSSQL via FreeTDS. On investigation I'll find that the FreeTDS module has been unloaded somehow. It is not listed in cdr show status or show module like. Trying module load cdr_tds results in module cdr_tds does not provide a license key and the module is not loaded. The only way to get

...??? If I understood it correctly, in a similar setup I could write to node1 and the write would be fast as a local write, but in background halo would propagate the write to the node in the other region just after my write. So this could be something similar to a master-master mysql asynchronous binlog replica: if you know that no one work on the same file/record on both nodes at the same time then it works. Stefano -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.gluster.org/pipermail/gluster-users/attachments/20171121/b0f7d392/attachment.html>

I run this prog (http://www.compcar.ru/forum/showthread.php?t=7342)and this error appears: Fatal error occurred in main thread. Address:0x004a1f11 Exception:0xc0000005 I added every library whitch Igo needed (native-builtin) / I found them by Ollydebuger in Windows 7/ , but no success :( Could I add some other info to solve this?

G'day, I'm backing up production MySQL database servers. The tables are almost all MyISAM. My plan is to use MySQL binary logging and then rsync the binary logs offsite hourly. The binary log files are only appended to, with new queries logged at the end of the file. So I'm assuming the rsync algorithm will be highly effective at reducing the bandwith required to transfer these

...test about MySQL''s Insert performance on ZFS, and met a big performance problem,*i''m not sure what''s the point*. Environment 2 Intel X5560 (8 core), 12GB RAM, 7 slc SSD(Intel). A Java client run 8 threads concurrency insert into one Innodb table: *~600 qps when sync_binlog=1 & innodb_flush_log_at_trx_commit=1 ~600 qps when sync_binlog=10 & innodb_flush_log_at_trx_commit=1 ~600 qps when sync_binlog=0 & innodb_flush_log_at_trx_commit=1 ~900 qps when sync_binlog=1 & innodb_flush_log_at_trx_commit=0* ~5500 qps when sync_binlog=10 & innodb_flush_log_a...

So I got dashboard up and running on our production system on Thursday before I left. Within 48 hours it had completed filled the /var filesystem. The ibdata1 file is currently at 8GB in size. 1. What size should I expect for ~500 nodes reporting every 30 minutes? 2. Are there some database cleanup scripts which I have managed to overlook that need to be run? -- Jo Rhett Net Consonance :

we have multiple servers approx 10 and each has about 100 GB of data in the /var/lib/mysql dir , excluding tar , mysqldump and replication how do we take backup for these databases on to a remote machine and store them datewise , ( the remote machine is a 2TB HDD ) currently tar is not feasible as the data is too huge and the same goes with mysqldump suggestion will be of great help --

...:45:37 InnoDB: Starting log scan based on checkpoint at Jun 18 08:45:37 lemodev mysqld[23733]: InnoDB: log sequence number 0 3800892. Jun 18 08:45:37 lemodev mysqld[23733]: InnoDB: Doing recovery: scanned up to log sequence number 0 3800892 Jun 18 08:45:38 lemodev mysqld[23733]: InnoDB: Last MySQL binlog file position 0 79, file name /var/log/mysql/mysql-bin.000 Jun 18 08:45:38 lemodev mysqld[23733]: 060618 8:45:38 InnoDB: Flushing modified pages from the buffer pool... Jun 18 08:45:38 lemodev mysqld[23733]: 060618 8:45:38 InnoDB: Started; log sequence number 0 3800892 Jun 18 08:45:40 lemodev m...

Hello, Is it possible to non-destructively change RAID types in zpool while the data remains on-line? -J