| Author |
 Topic  |
|
|
endomorph
Junior Member
United Kingdom
128 Posts |
 Posted - 27 February 2010 : 10:00:40
|
Just converted from Access to MySQL5 after hitting 100Mb+ and have had a few problems which I believe I have now sorted out. However I have 2 things I need doing -
1. I have two users set up on the database, How do I change the status of a user to use as the forum U/P and restrict to read/write only, not full admin.
2. When viewing the db status, there are several figures in red -
Innodb_buffer_pool_reads 350 k
Innodb_row_lock_time_avg 216
Innodb_row_lock_time_max 1,218
Innodb_row_lock_waits 17
Handler_read_rnd 5,283 k
Handler_read_rnd_next 1,849 M
Qcache_lowmem_prunes 19 k
Slow_launch_threads 718
Created_tmp_disk_tables 14 k
Key_reads 158 k
Select_full_join 1,451
Sort_merge_passes 1,065
Opened_tables 54 k
Table_locks_waited 2,389
What are they and should I be concerned ?
If someone is willing to log in and have a look around I would be most appreciated and would reward your time.
|
Need help with your Snitz ? Most Snitz & ASP custom coding undertaken. Email for info | Search Engine Optimisation |
|
|
endomorph
Junior Member
United Kingdom
128 Posts |
Posted - 27 February 2010 : 11:00:45
|
| Oh and some of my dates are coming out now as MM/DD/YYYY |
Need help with your Snitz ? Most Snitz & ASP custom coding undertaken. Email for info | Search Engine Optimisation |
 |
|
|
endomorph
Junior Member
United Kingdom
128 Posts |
Posted - 04 March 2010 : 15:40:35
|
| Anyone ? |
Need help with your Snitz ? Most Snitz & ASP custom coding undertaken. Email for info | Search Engine Optimisation |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 04 March 2010 : 18:28:05
|
I am not a MySQL specialist but Snitz doesn't need the InnoDB engine, since it's meant to support transactions which Snitz does not use, so you may as well go with the MyISAM engine. Can't really say anything about the status vars, better ask for that on a MySQL support place.
There is no reason for dates to be different, just from the use of MySQL. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
| |
Topic |
|
Topic Locked
