I need some one to help me to Make mysql work faster in a point of sale environment,
The program is in java, and communicates to mysql, it sends all information and transactions to my sql db
This is the issue. if Im using my program in 1 computer and the local server, it works perfect with no issues, if I add a second computer, it still works perfectly fine. But if I add a third computer that's when I start having problems like for example, very slow to print the receipt, sometimes I got the error time out. and finally the only way to resolve the problem is by resetting the server and start working fine for couple of hours. I need to fix this permanent I already add this
--skip-name-resolve, this helped I little but not enough. I searched all over the internet for any idea, so the freelancer who take this task must know what his doing. no Google fix please. I know is not big issue.
7 freelancers are bidding on average $60 for this job
Hey, I am an expert MySQL DBA and performance tuning expert. I can sort this error in MySQL. I am a teach speaker and a blogger too ([url removed, login to view]). You can have a view at my feedbacks in freelancer pro Daha Fazla
Hiii.. i have read your requirements and it seems you have problem with your java code which makes slow fetching the data from database i think you are using older java drivers or you are creating connections object Daha Fazla
Hi Sir, I am an expert Java/J2EE developer with 5+ years of experience. I can do this quick for you as per your satisfaction. Looking forward to help you on the same....
Hi, From the way you describe the slowness problem, it's most likely in the architecture of your system. Especially that the problem arises when you add more than 2 computers... Which is a very low number. I wou Daha Fazla
I think i can solve this, a year ago i experienced this kind a problem in company i worked, the solution is to optimize the mysql to handle multiple client, table type change to innodb rather than myisam, and always ch Daha Fazla