I have moved to a complete multisite network after reading the documentation, forum, and a couple of trials and errors attempts to understand how multisite works compared with a single-installation. I have encountered very similar multisites issues to other users who have had their problems sorted in the forum so that was very useful also.
My query to more experience Super Admins is how do they identify the correct site numbers and SQL tables when they are dealing with hundreds of sites for example?
I am curious because at the moment I have created one root site and one subdomain. But I have deleted the subdomain site a couple of times to understand how the multisite system works. Each time you create a site the system assigns a site-number and a number of tables (wp_# with # the site-number) in the mySQL database. This is all done automatically and with no control from Super Admins as far as I understand.
The file paths are also assigned automatically also so at the moment my second subdomain upload files in:
/wp-content/blogs.dir/4/ and "4" is because I have deleted the site twice to explore things around. So when adding a new site, the system assigned 3 and 4 respectively to the new sites.
Is it possible to restart the counting so the assigns number replicates exactly the number of sites available?
I planning doing a Excel file or similar to create a spreadsheet information on the site and the numnber assigment so I can check that information as my network grows. Maybe there is a plugin, I am misssing something or there is a better way to deal with this.
Thanks a lot!