….cnf # sammple MySQL config file for very large systems. # # # This is for a large system with memory of 1G-2G where the…/ #innodb_log_arch_dir = /usr/local/mysql/data/ innodb_data_home_dir = /db innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /db innodb_log_arch_dir = /db # You can…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
… 1GB, 2GB, and 4GB. For these tests I left Innodb with a 256M buffer pool, or roughly with 9% of… the db only when required. I tested with a memcached size of 1GB, 2GB, and 4GB. For these tests I left Innodb…, but the # of writes in MySQL coupled with the still large # of reads takes its toll. Another place where I have…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…there are still a large number of MySQL …> show processlist; +—-+———-+———–+——+———+——+———————————+————————————————————-+ | Id | User | Host | db | …increment primary key) ENGINE=InnoDB; Query OK, 0 rows affected …
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
… the data. There is replicate-do-db and replicate-ignore-db options which closely mirror behavior of their …it would be waste to pull binary logs to large variety of slaves? This is the case when …tables. If you have Innodb tables you’re normally OK because you can use –skip-innodb on the filtering …
Comment: Should you move from MyISAM to Innodb ?
February 1, 2010 By 59 Comments
Business Continuity / Disaster Recovery using InnoDB? We use an internal process based on mysqldump and innodb file-per table. Our “Database File… a dedicated instance, mixing engines is not an issue. All DBs are fronted by memcached machines (64 instances). All applications are… their SYNC is completed. Therefore, the HUGE/SLOW restore of large InnoDB tables is not an issue, My suggestion to use all…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
… identify potential causes. Is it working with large blobs ? Using user variables ? Prepared Statements ? memory tables…: 7234 TABLE_SCHEMA: test TABLE_NAME: my ENGINE: InnoDB NAME: #sql516_1c42_2 TABLE_ROWS: 0… pages 8252672 Old database pages 3046376 Modified db pages 23419 I’m using the information…
Comment: MySQL Partitioning - can save you or kill you
July 2, 2012 By 45 Comments
… saved files on disk. This does not interact with the DB at all. The second App server has to interact with both the DBs, storing records @ 800 rps. deletion from NDB database has to happen very frequently. Deletion from MyISAM/InnoDb would happen… per 1 min – worst case). Have inserted large number of records into the new InnoDb table as mentioned before, using load infile…
Comment: Performance problem with Innodb and DROP TABLE
February 4, 2011 By 23 Comments
… – was dropping a database with approx 150 tables, some large that were InnoDB. The CPU hit the roof so I killed the job. But I was still stuck with the problem of unneeded dbs… the table & when finished dropped the db. The cpu never climbed above 3 and the db server was usable for other databases…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
July 25, 2008 By 29 Comments
… efficiently loading very large file? BTW – I am NOT heavy DB programmer and don’t know much about DB. If you donâ… fields (Avg 15 GB), which need to be inserted into InnoDB table every min. I am using LOAD command to accomplish… LOAD file get bigger and bigger and eventually, I get DB gone away error and the program abort. Any suggestions. Kye…
Comment: Should you have your swap file enabled while running MySQL ?
April 8, 2008 By 31 Comments
… central DB server, we only have swap enabled because of…starting though..(innodb_buffer_pool_size=31G): InnoDB: HugeTLB: Warning: Failed to allocate 33286012928 bytes. errno 12 InnoDB HugeTLB: … “cannot allocate memory” If anyone has experience with large_pages like this, please email me or post here…
