Benchmarking/optimization of MySQL

2004-03-02 Thread Bostjan Skufca (at) domenca.com
Hello, for the last few days I've been running benchmarks from sql-bench directory and tunning server parameters and I have few questions. Firstly I would like to note that benchmarks were run on two different but similar machines: Machine ONE: Dual Xeon 2.4 533MHz FSB 4GB RAM SCSI raid 10 (

Re: Weird behaviour

2004-03-01 Thread Bostjan Skufca (at) domenca.com
le to access > > additional databases matching the wildcard pattern, for example, GRANT > > ... ON `foo\_bar`.* TO > > Michael > > Bostjan Skufca (at) domenca.com wrote: > > Hello > > > > I am using MySQL 4.0.18 and i have come accross weird behaviour. &g

Weird behaviour

2004-03-01 Thread Bostjan Skufca (at) domenca.com
Hello I am using MySQL 4.0.18 and i have come accross weird behaviour. I created the databas and user like this: CREATE DATABASE dev_project; GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,REFERENCES,INDEX,ALTER,CREATE TEMPORARY TABLES,LOCK TABLES ON dev_project.* TO [EMAIL PROTECTED] IDENTIFIED