| Question: |
SQLSTATE[HY000]: General error: 1615 Prepared statement needs to be re-preparedВот this problem on your server, clearly the problem is on Your side, it`s either an old version of Mysql, 5.1 had such problems. Either the MySql is badly configured, the server shows your version 5.1.73. PS a Personal question, please do not ignore, too, on what the target audience oriented with your hosting, on a regular Cmserv whether to expand your system for YII2 which is dynamically outgrowth of the load, as will be administer the data that is already running third-party services? |
| Answer: |
Hello Where you see this error? the mysql version 5.1.73 ? and it is not updated on the current server if you have something that will dynamically increase the load that can offer You vps server. projects that create burden should not be on serviceobama hosting |
| Question: |
This error appears when double - triple update any page where there are Select queries in the database load, there is no. But the error climbs. If you don`t update the server then you need to at least raise the limits of the cache, although I don`t understand why everyone uses the old versions.I have many client projects, just info. sites with 300 hosts, but I doubt the translation here, as he quickly by clicking on the links cause the departure of sql server, or your server is considered a heavy load? |
| Answer: |
we have not just one server, we have servers with newer versions of mysql , but they are all on cpanel . explain what to do triple update page? You are on a shared hosting server, elimite nustrini so that You would not interfere with other projects on the server. if you need special settings and conditions, I can offer You vps servers http://www.ukrline.com.ua/tarif_vps.php |
| Question: |
Are you serious? that is, if the site will be 1 host per day but he decides to quickly click on links, moving between pages, he will lock the mysql server, is this normal? Is the load you concurentiale you though where the competition is met? |
| Answer: |
your website will not affect other sites. |
| Question: |
I realized that it doesn`t affect other sites, You answer me, it is normal that clicking on the links or refreshing the page a couple of times quickly, zapiraetsya MySql server and the website climbs error. This is the usual select to a table where a few records. You do is found at least somewhere on the dead servers? And would like to hear the answer whether the problem as it is solved? For tests you can see yourself here http://uds.parsit.pro ... are developing the engine under a site, the load creates when you update the page that would survive a calculator from the 90s, and saperet your MySql server. Please click on F5, look in the logs as it was loading. And tell will you something to take? Or sites that use a database via PDO, for you it is clients VPS. And hosting is to display Html pages. |
| Answer: |
this is not face every day and using PDO sites University as work. Have you tried to optimize the queries? |
| Question: |
Have you tried to optimize the queries видаselect * from check where id = 7что is there to optimize? There are no complex queries, if the queries created load you would be able to monitor. Squeaking works everywhere except your server. queries run in milliseconds, but when you create multiple queries from a browser throws out this error. |
| Answer: |
And on some of the queries I get an error? |
| Question: |
Yes, I described all many times, and threw the link. for example. You can see by the logs, there are some queries. Why the server is locked, or you have a really tiny limits on the cache, or at the problem with the version. At the office site MySql even have this information on 5.1 version had problems with PDO. Why don`t you just update it? Why use something old? |
| Answer: |
we can not upgrade regardless of the panel, as it is fraught with loss of stability . we can open you an account on the server with a different version of mysql . your case edinenii for all time sushestvovaniya servers, we can not only for you to change the settings of the whole server with hundreds of sites risking its stability. |
