Memcached and fetching from MySql

Question

PHP

There is a table with 10 million records. It stores some data + key1 and key2. With some action on the site, two parameters param1 and param2 come to the script. And you need to check if there is a string in the database that satisfies the condition key1=param1 and key2=param2. If not, insert these parameters into the table.
The question is:
1) will it be correct to store the whole table in Memcached? Or is it better to store the keys as $key = md5(serialize($options)), where $options describes all the query options.
2) If you store the entire table, then how to check that Memcached has a key corresponding to the condition key1=param1 and key2=param2

Answer 1

Memcached, in principle, can be excluded from here.
In the database, it is enough to make a composite index on the fields key1 and key2 - the selection will be fast
dev.mysql.com/doc/refman/5.0/en/multiple-column-in...
if in memcached - then $key = $key1 .'_ '. $key2 - there will be a selection from memcached by parameters, and already necessary serialized data will be put into the value

Answer 2

1. As a memcached key, you can use the concatenation of key1 and key2.
2. Are you sure you need memcached? Selecting by key from a 10 million table in MySQL does not take much time. If there is a composite index on key1+key2.

Answer 3

There are more than 10M in the database (auto parts), fields key1 + key2
Everything flies fine