Hello,
Does innodb_flush_log_at_trx_commit = 1 or 2 make a busy mysql server
bad performance?
We found that setting it to 0 will make disk IO decrease a lot.
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Setting this option is a trade-off between your durability requirement
and performance requirement.
http://dev.mysql.com/doc/refman/5.1/en/innodb-parameters.html#sysvar_innodb_flush_log_at_trx_commit
0 gives best performance (write + flush once every second). 1 gives best
durability (write +
MySQL List,
I'm running Ubuntu 10.10, and I have a LAMP server which is not connected to
the internet, but is just used for locally creating and testing web sites.
MySQL does not seem to be running, however. Check out the output from these
commands:
~$ sudo service mysql start
mysql
Check whether mysql is running:
ps aux | grep mysqld
If MySQL is not running, check /var/log/mysql/error.log for errors.
Have you changed /etc/mysql/my.cnf and/or /etc/mysql/conf.d/*.cnf or are
are you still using the default config files from Ubuntu?
On 10/16/2010 06:30 PM, Dave M G wrote:
Bruijne,
Thank you for responding.
The my.cnf file was fine, but when you mentioned it, it sparked a long
forgotten memory that there was something specific to Ubuntu that
affects who has access to files like my.cnf.
After a little web searching, I realized it is a security thing called
Hello,
I have a table which has the ID key with auto_increment and which is a
primary key.
If I insert the table with the id value which is generated by the
program, for example,
insert table (id, user_name, age) values (1000, 'kenn', 30);
the value 1000 is inserted forcely, not generated by
At 08:05 PM 10/16/2010, you wrote:
Hello,
I have a table which has the ID key with auto_increment and which is a
primary key.
If I insert the table with the id value which is generated by the
program, for example,
insert table (id, user_name, age) values (1000, 'kenn', 30);
the value 1000
At 08:55 PM 10/16/2010, you wrote:
After executing the SQL statement, the next Id inserted will be 1000.
Oops. I meant :
After executing the SQL statement, the next Id inserted will be 1001.
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Hi,
Is it possible to change this directive's value without modifition to
my.cnf and restart mysqld?
I remember there is a set @@variable syntax, but not sure.
Thanks.
2010/10/17 mos mo...@fastmail.fm:
At 08:55 PM 10/16/2010, you wrote:
After executing the SQL statement, the next Id inserted