…instance, simply decrease the values in the /etc/my.cnf file if you really want to try …is the excellent compression that RLE techniques provide. I have not loaded InnoDB compressed tables yet …size=64M transaction-isolation=READ-COMMITTED user=mysql wait-timeout=86400 To be continued You can now set…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 141 Comments
… million Since this is a predominantly SELECTed table, I went for MYISAM. My my.cnf variables were as follows on a 4GB RAM system…=32M query_cache_type=1 max_connections=1500 interactive_timeout=25 wait_timeout=10 connect_timeout=5 thread_cache_size=60 key_buffer=750M… will have to do this check in the application. Just my experience. I know some big websites are using MySQL, but we…
Comment: When is it a time to upgrade memory ?
December 9, 2009 By 11 Comments
… memory and this is slowing it down. I can tell because when I launch my application which is filling one table it’s… is that it’s difficult to tune this server because I have few reading queries but on large tables (~10 millions… is my.cnf: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql max_connections=600 connect_timeout=30 wait_timeout=15…
Post: Can we improve MySQL variable handling ?
February 18, 2012 By 8 Comments
…my.cnf to those server is currently running with. The problem however this only works well if settings are set in my.cnf…limit YES userstat FALSE verbose TRUE wait-timeout 28800 Which is however rather … | +—————————+ 1 row in set (0.00 sec) If I could only refer to “default” or …
Comment: Innodb Performance Optimization Basics
March 28, 2012 By 75 Comments
…, I am facing major issues with slow query output. The tables…param for InnoDB are [root@ng-lg-mdb1 ~]# cat /etc/my.cnf|grep innodb innodb_data_home_dir = innodb_data_file_…innodb_lock_wait_timeout = 50 A count command with approx 3 million records is taking too long and all my transactions are locked…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… results are quite interesting for me as I worked on some of the previous SpecJAppServer …most interesting: MySQL 5.0 Tuning in /etc/my.cnf (included in FDA) [mysqld] sql-mode = IGNORE_…innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 300 innodb_thread_concurrency = 0 innodb_sync_spin_…
Comment: Why MySQL could be slow with large tables ?
December 17, 2012 By 141 Comments
… solve performance issue in mysql database. problem is i am have a table with 10Lacks… where to set parameters to overcome this issue. my.cnf file contains the following information. [mysqld] innodb_buffer_…_flush_log_at_trx_commit=2 innodb_lock_wait_timeout=120 datadir=/var/lib/mysql socket=/var/lib/…
Comment: MySQL random freezes could be the query cache
March 29, 2009 By 23 Comments
… 5.1.32. Its a pretty high traffic site, but I‘ve never seen the DB server go above 20% CPU… help would be GREATLY appreciated, I honestly don’t know where to start. Here is our my.cnf: skip-name-resolve max_connections…/mysql-bin.log binlog-do-db=tp server-id=1 wait_timeout = 15 key_buffer = 16M key_buffer_size = 32M max_allowed…
Comment: How to estimate time it takes Innodb to Recover ?
June 25, 2008 By 7 Comments
…000086′ position: 4837623 080625 23:53:28 [Note] Slave I/O thread: connected to master ‘repl@10.16….64 x86_64 GNU/Linux Also currently: these config (my.cnf) were all disabled from 20 servers: # Uncomment the …8M #innodb_flush_log_at_trx_commit = 1 #innodb_lock_wait_timeout = 50 Thanks in adv, …
