mysql performance report
Guys my mysqlreport says : Buffer used 205.00k of 16.00M %Used: 1.25 Current 2.04M%Usage: 12.76 Write hit 100.00% Read hit 97.90% __ Questions ___ Total 5.08k16.6/s * Com_ 2.68k 8.8/s %Total: 52.74* QC Hits 1.84k 6.0/s 36.20 DMS 528 1.7/s 10.39 COM_QUIT 40 0.1/s0.79 -Unknown 6 0.0/s0.12 Slow (1)0 0/s0.00 %DMS: 0.00 Log: ON - the com_ is spinning and taking a lot of time/resource from my mysql (or seem like it does) Any idea what might be causing this or if this is bad? or just normal? This web-site is under development and not much hits coming in so low DMS makes senseright? -- Sulochan Acharya
Problem with character set and connection collation
Hello all, here is my problem: I am trying to set mysql to unicode character, so that i can get my dictionary application to look at words in Nepali. here is my setting: mysql charset: utf-8 unicode when i make a new database: mysql connection collation is utf8-general-ci and my new database collation is also utf-general-ci i import tables into this database using mysql command : source /path to file when i browse the tables in this database i dont see nepali world instead it seems like mysql cant read the characters; please help!! best, sulo
