Mysql – How many partitions should we create if there are around 100 millions rows

MySQLpartition

I have a 16 core , 12 GB ram, a SSD 500 MB/s
I have 1 millions rows in my "Pages" table

The pages contains 1 unique key that are HostID ( int ) and Page( varchar )

I use partitioning by key
and have created briefly about 100 partitions

But i'm not sure that how many partitions that i should create for best performance.

briefly about 70 GB of data
I use primary key to search : 

    select * from table where HostID = 1 AND Page = 'asdasd'

Best Answer

You might find the following answer which demonstrates how best to use clustered primary keys with the innodb engine of interest.

https://stackoverflow.com/questions/4419499/mysql-nosql-help-me-to-choose-the-right-one-on-a/4421601#4421601

Hope this helps :)

Related Topic