Re: [Maria-discuss] Help to size: Best configuration for a lot read and write

Hi, 1. You have to start from metrics for your servers. Metrics from OS (cpu, memory, disk, network) and MySQL (grab 'show global status') 2. Look at them, think :) I think - without information from the first paragraph, good start point will be increasing innodb_buffer_pool_size

Re: [Maria-discuss] Help to size: Best configuration for a lot read and write

Hi Tristan, > I have some basics about SQL. But I need your help. > I must set up a SQL servers for a new web application. This web > application will make a lot of write and some reads the night and > enormously read and some writing on the day. > This is a complex case, as pure write workloads

[Maria-discuss] Help to size: Best configuration for a lot read and write

Hello everyone, I have some basics about SQL. But I need your help. I must set up a SQL servers for a new web application. This web application will make a lot of write and some reads the night and enormously read and some writing on the day. Here are my questions: - What is the best solution f