I agree with @adityakatiyar that it is unwise to upgrade to Magento 2.0 to solve the slow loading issue.   Your best bet is to optimize the current Magento installation in order for it to perform faster.    Besides that, you will also need to make sure that your server itself is not slow as all your effort may not result in much improvements if the server itself is slow.  ... View more

I'm not sure if you considered this but maybe the users (or bots) register for an account from your website's frontend?    There's a Registration or Create An Account page with the URL "/customer/account/create/" at your website's frontend which allows anyone to register for an account.    If this is the page they register for an account, you can try to prevent bots from auto registering for an account by enabling CAPTCHA in your Magento Admin --> System --> Configuration --> Customers --> Customer Configuration --> CAPTCHA.   Do make sure you select "Create user" under "Forms" for the CAPTCHA to be used in the customer registration page.    ... View more

Your link is no longer loading on my end.    May I know if you are still facing the issue?  ... View more

With such a huge amount of products, shared hosting wouldn't cut it.    You may need to look for a more powerful server with guaranteed resource, which can either be a Cloud Server, Dedicated Server or VPS. Be sure to also look for a Managed solution as it will save you a lot of headache on server management, security, optimizations, etc.  ... View more

Sorry for the delayed reply as I was caught up with many projects at the end of last year so I have not been checking the forum until now.    May I know if you are still facing this issue?    Besides using the profiler to identify the scripts or extensions which are slowing down your website, you can also disable each script or extension one-by-one and test the loading speed in order to identify which of them are the culprit.  ... View more

Sorry for the delayed reply as I was caught up with many projects at the end of last year so I have not been checking the forum until now.    Did you manage to test if Memcached is actually doing it's work?    There are quite a few ways for you to test it as you can see here:- https://stackoverflow.com/questions/1690882/how-do-i-see-if-memcached-is-already-running-on-my-chosen-port https://stackoverflow.com/questions/631903/how-do-you-know-if-memcached-is-doing-anything ... View more

Do you have any firewall which is blocking port 3306 from connecting to the database server?  ... View more

Most of the guides are actually similar as which is generally as follows:- <memcached> <servers> <server> <host><![CDATA[127.0.0.1]]></host> <port><![CDATA[11211]]></port> <persistent><![CDATA[1]]></persistent> </server> </servers> <compression><![CDATA[]]></compression> <cache_dir><![CDATA[]]></cache_dir> <hashed_directory_level><![CDATA[]]></hashed_directory_level> <hashed_directory_umask><![CDATA[]]></hashed_directory_umask> <file_name_prefix><![CDATA[]]></file_name_prefix> </memcached> You will need to make sure that the Memcached is properly installed at the server level and it is listening to port 11211.      ... View more

It's not within Magento Admin. It's within your files which you can access either with FTP or your hosting control panel.  ... View more

One simple way where you can remove all sessions is to go to the var/sessions directory and remove all files within it.    As for the Index Management, if you can't reindex it from Magento's backend, you may want to try running reindexing using SSH:-   php -f shell/indexer.php reindexall ... View more

That's not how it works though. A system administrator will need to monitor your server, go through the logs, etc and tweak your configurations. Many users will give you a set of one-size-fit-all my.cnf config but those are just guidelines only.  ... View more

To be frank I highly doubt that your MySQL is optimized enough as having a default configuration which is the same across all servers may not cut it.    Without looking at your backend, my general suggestion is to try moving to faster storage drives and replace MySQL with a faster alternative like Percona.    Magento Community should have no problems in dealing with your configurations if the infrastructure is ready to handle it.  ... View more

Since they are managing your server, did you ask them to look into the problem for you?    There's no "fixed" MySQL configuration as it depends on your usages.    Scaling may or may not resolve the issue, depending on what is causing the issue in the first place.  ... View more

How's the overall CPU and RAM utilization rate?    Anyway I believe the issue can be easily resolved if your MySQL configurations are properly tweaked and optimized. Is there any reason on why you want to avoid doing this?  ... View more

May I know what issue do you face when you try to upgrade with Magento Connect?  ... View more

I wouldn't recommend that you install Magento 1.9.2.1 with the database of an older version like 1.8.1.0 as the database structure may have changed and the cores files are also different.    You will most likely need to reinstall Magento 1.8.1.0 with the database before upgrading to Magento 1.9.2.1.    Alternatively, you can install a blank Magento 1.9.2.1 and import all the data from the old installation.  ... View more

Are you familiar with PHP and Zend Framework or are you willing to learn as you go along?    Magento is a pretty complex application which can do a lot of things but may need to be customized to meet your needs.    If you are not familiar with these, you may want to hire a web developer to develop the website for you.  ... View more

@MagenX wrote: if you like cPanel and dedicated, then you have to check www.ovh.com SSD servers. it will cost you 5x less than any cloud server, and even any mid range enterprise box enough for many years.   The problem with providers like OVH is they are usually Unmanaged which is a big problem for most users who don't want to worry about server management and security.    Even if they do offer Managed services, they are not familiar with Magento so users will most likely need to hire another guy to do optimizations, etc which is unnecessary when they go with a Magento optimized provider.  ... View more