mysql - CS-Cart 4 Site Performance Troubles. Can db caching be the culprit? -


We have launched our site prematurely and hit with some dirty performance issues. I'm a MS SQL Server Professional from Business, but this MySQL database has been worked to tune up. As I think the MyISAM database does not have row level locking and if you are editing data, then lock the entire table. Anyone can confirm or reject my beliefs ....

We have spent a lot of money on Google AdWords and are capable of generating some "useless" traffic on the site ... but at the same time In, our home staff are loading the site with new products all day. In the evening when no one is inputting, I have seen the site load around 2-3 seconds .. But when the people are input, the load time falls to 8-9 ... Sometimes load more than 10 seconds.

In addition to this, we have recently changed our CS-Cart caching from "File" to "ISSLL". This table is possibly missile ... Can this effect be demonstrated, as well as being from nature, write this table often. 

  As I understand that there is no row level locking in the MyISAM database if you have data If you are editing then the whole table will lock. Can someone confirm or reject my beliefs ....

You are right in MySam only table level lock InnoDB supports row level lock.

In fact, lock wait times can be important if many concurrent users can use the MyISAM tables but to prove / reject that you need to collect all the questions in a slow log (Set long_query_time to 0) and review the log with pt-query-digest, then you will see how much time of MySQL is spent, so the solution can be easy to find.


Comments

Post a Comment

Popular posts from this blog

ios - How do I use CFArrayRef in Swift? -

I am using Objective-class in my Swift Project through a bridging header. The method signature looks like this: - Some cement (some type) some parameters; I started by getting an example of class, calling method, and storing the value: var myInstance = MyClassWithThatMethod (); Var cfArr = myInstance.someMethod (some value); Then try to get the value in the array: var valueInArrayThatIWant = CFArrayGetValueAtIndex (cfArr, 0); However, I get the error unmanaged & lt; Cfarray & gt; Not like 'CFArray' . Unmanaged & lt; Cfarray & gt; also means? I looked, but I do not need to change the array in a fast array (though it would be good). I need to be able to get value from the array. I also tried CFArray method to pass in a function: func doSomeStuffOnArray (myArray: NSArray) {} Although I get the same error when using: doSomeStuffOnArray (cfArr); // unmanaged & lt; CFArray & gt; I am using CFArray because I want to sto...
Read more

eclipse plugin - Run java code error: Workspace is closed -

To create an automated project, I created a plug-in project with the following dependencies: Org.eclipse.core.resources org.eclipse.equinox.registry org.eclipse.core.runtime and the following The Java class is located in the src folder: Package Examiner; Import org.eclipse.core.resources.IProject; Import org.eclipse.core.resources.IWorkspaceRoot; Import org.eclipse.core.resources.ResourcesPlugin; Import org.eclipse.core.runtime.CoreException; Import org.eclipse.core.runtime.IProgressMonitor; Import org.eclipse.core.runtime.NullProgressMonitor; Public class tes {public static zero main (string [] args) {// TODO auto generated method stub IProgressMonitor progress monitor = new NullProgressMonitor (); IWorkspaceRoot root = ResourcesPlugin.getWorkspace (). GetRoot (); Ipoject project = root.jetproject ("desired projectname"); Try {Project.create (progress monitor); Project.open (progressMonitor); } Grip (CoreException E) {// TODO Auto generated blocking block e....
Read more

c - Error on building source code in VC 6 -

When I create my project in VC6, the BScMKE reports the following error Linking .. Creating Library ... .. / ... / PB / Bean / Debub / ICEERP.Lib and Object ........ P.B. / Bean / DBube / ICREPlay.APP Browse information file ... BSMMK: ​​error can not be read from BK 1505: file '../../PB/bin/TmpOut/ICReplay/Debug/ICReplay_PB.bsc' Error executing bscmake.exe Can someone help me? 2 Reason for reference from: "ICReplay_PB .bsc "file will be corrupted The trunk of the file will be happening with the compiler running out of disk space or is being interrupted when creating .sbr file I think this answer will help you!
Read more