MarCPlusPlus
  • Member for 4 years, 6 months
  • Last seen more than a month ago
Statement based updates to a server using row based logging
Accepted answer
2 votes

The logs will be applied in the format which they are consumed, so on Server B statement based execution is applied. Whether or not Server B even produces binary logs depends on whether or not binary ...

View answer
Will mariadb use mutliple cores at all?
2 votes

The short answer is yes. It will use a thread per connection by default which you can delegate queries to concurrently, which will utilize multiple cores on the operating system level. Slave ...

View answer
Best practice for sharing data over differenet mysql/mariadb databases
Accepted answer
2 votes

If the "common" tables on the secondary "app instances" are being accessed read only, then your easiest option will be doing a traditional master slave(s) configuration with a replicate_ignore_table = ...

View answer
Is restoring a mysql database backup faster at removing white space than running OPTIMIZE?
Accepted answer
1 votes

Both will achieve essentially the same thing. If your exact db version doesn't offer online OPTIMIZE then the dump and restore could be useful if you restore into a new table and then DROP the old one ...

View answer
Nothing changed; always get connection timeout on alter table in MariaDB
Accepted answer
1 votes

Which version of MariaDB are you upgrading from? It could be that there has been a table or index format change between the versions. Or it could be that the newer version is using the ONLINE alter ...

View answer
How to add 100 to all strings starting with a digit in an attribute
1 votes

UPDATE doc_properties SET value = CONCAT( IF(value LIKE "0%", "0", ""), CONCAT(CONVERT((CONVERT(value, UNSIGNED INTEGER) + 100), CHAR(50)), "s") ) WHERE value REGEXP "^[0-9]" Explanation: This update ...

View answer
InnoDB: mmap failed; errno 12
1 votes

You are probably running the service on Linux. I've had similar problems with allocating large amounts of memory on Linux (as opposed to BSD) even if the amount of memory I was trying to allocate was ...

View answer
How does MySQL evict pages from the buffer pool?
Accepted answer
1 votes

Flushing and evicting are entirely different. https://dev.mysql.com/doc/refman/5.5/en/glossary.html#glos_flush MySQL will flush dirty pages in accordance with innodb_max_dirty_pages_pct. The default ...

View answer
Application considerations when using a multi-primary innodb cluster
Accepted answer
1 votes

The short answer is no, unfortunately. Have you considered using Galera instead? It has mature synchronous replication and can virtually guarantee consistency across nodes. I would highly recommend it....

View answer
AWS Aurora MySQL Serverless CPU utilisation is above 10 even it is not processing any requests
1 votes

Run show processlist or an analogous command. 10% doesn't seem unreasonable but the database is obviously doing something at this time. It seems as though this product puts a large emphasis on ...

View answer
Parallel replication is not working on a 5.7 slave from a 5.7 master
1 votes

MySQL can only use as many threads as are actually needed for replication given your database workload. The fact that those threads are visible would imply that parallel execution is in effect. Take a ...

View answer
Data sync across Local and Cloud Database
1 votes

If the "Local DBs" were only read slaves then this would be feasible using replication filters. https://dev.mysql.com/doc/refman/7.0/en/change-replication-filter.html However since you have some sort ...

View answer
3 different queries from 2 tables
0 votes

Using sub queries this should extract all ID_Ps which only occur in the Layout table once and then INNER JOIN them with all ID_Bs which only occur in the Layout table once... essentially returning ...

View answer
Migrating 300 GB mysql database from one server to another cleanly with minimum downtime
0 votes

xtrabackup I've been in similar situations before and it really makes this so much easier. As to exactly how you'll utilize it to minimize downtime will be up to you to decide but one possible ...

View answer