Tagged Questions
1
vote
1answer
277 views
Very poor insert performance MySQL / Percona Server
I'm running a Percona-Server instance off an Ubuntu server install. I'm using an application that needs to access this database, and its having VERY poor performance. Once the database has been ...
1
vote
1answer
1k views
How to set a specific directory location for individual MySQL database?
Is it possible to set each database in MySQL to use a separate datadir?
I'm running a userdir development (sandbox) server and would like to put the MySQL data files for the database(s) for that user ...
1
vote
0answers
735 views
Why can I not start mysql server on ubuntu after change the innodb_flush_log_at_trx_commit value to be 2?
Why can I not start mysql server on ubuntu after change the innodb_flush_log_at_trx_commit value to be 2 ?
updated to answer the 3 questions:
mysql> show variables like 'version%';
...
5
votes
5answers
3k views
MySQL said “InnoDB: Initializing buffer pool, size = 128.0M”, does it mean it is using 128MB RAM?
I am just using a very few InnoDB tables (e.g. less than 1MB), but during MySQL startup, it said
InnoDB: Initializing buffer pool, size = 128.0M
Does it mean even I am using in such a small size, ...
