MySQL query for getting blog records/content Drupal7?
The limit is controlled through a variable called default_nodes_main. You can change it by executing the following code:

// This would increase the number of nodes on the blog page to 20.
variable_set('default_nodes_main', 20);


If you have Devel module installed, you can do this at /devel/php.