Re: [nyphp-talk] Performance and Troubleshooting

2010-06-24 Thread Mitch Pirtle
On Thu, Jun 24, 2010 at 1:22 PM, Kevin Sheurs wrote: > you can try the innodb table type which uses row-level locking vs the > table-level locking of myisam. Actually you HAVE to do this for the jos_sessions table, and if you have a lot of users logging in you will need to do this for jos_users a

Re: [nyphp-talk] Performance and Troubleshooting

2010-06-24 Thread Kevin Sheurs
you can try the innodb table type which uses row-level locking vs the table-level locking of myisam. kevin On Thu, Jun 24, 2010 at 1:14 PM, Nicholas Hart wrote: > Hi, > > I am having some trouble lately with table locking and performance in mysql > server. I am using the MYSQL PERFORMANCE TUNIN

[nyphp-talk] Performance and Troubleshooting

2010-06-24 Thread Nicholas Hart
Hi, I am having some trouble lately with table locking and performance in mysql server. I am using the MYSQL PERFORMANCE TUNING PRIMER -- By: Matthew Montgomery - to help me configure this server to peak performance. However, I am still having same problems and am looking for some help. Any sug