Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MySql
 Just converted and need help
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

endomorph
Junior Member

United Kingdom
128 Posts

Posted - 27 February 2010 :  10:00:40  Show Profile
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  Show Profile
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
Go to Top of Page

endomorph
Junior Member

United Kingdom
128 Posts

Posted - 04 March 2010 :  15:40:35  Show Profile
Anyone ?

Need help with your Snitz ? Most Snitz & ASP custom coding undertaken. Email for info | Search Engine Optimisation
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 04 March 2010 :  18:28:05  Show Profile  Send ruirib a Yahoo! Message
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.07 seconds. Powered By: Snitz Forums 2000 Version 3.4.07