Split the lock_wait flag into two, adding a checkpoint_wait flag

Sometimes, when running a table drop, it is valuable to wait for other schema operations to complete when running a workload that creates/drops a lot of tables.

In the above workload it is valuable to not wait on the checkpoint lock, but we should wait for acquisition of the schema/table lock.