Hi Ulf,
>> I have read the "MaxDB performance tuning primer". Twice. Looked again.
>> Tried a lot. HELP! How can I invoke the tools mentiones there? OK,
>> "EXPLAIN" is SQL. "x_cons" has been described. But where and how can I
>> issue the "DIAGNOSE MONITOR" and "DIAGNOSE ANALYSE" commands? I tried
>
> Valid point.
>
> "The system tables should be cleared with the following ----> SQL
> statement <--- before you turn on the DIAGNOSE MONITOR in order to
> remove data collected during previous runs.
> DIAGNOSE MONITOR CLEAR"
>
> For DIAGNOSE ANALYSE I do not mention this explicitly but, it's the
> same. It's a special SQL statement. We should update the article at this
> point. Thanks for pointing us to it.
Well, this was my first thought, but what happens is this:
----------------------------------------------
[EMAIL PROTECTED] bin]$ ./sqlcli -d WFMC -u dba,*****
Welcome to the MaxDB interactive terminal.
Type: \h for help with commands
\q to quit
sqlcli=> DIAGNOSE ANALYSE CLEAR ALL
* -3008: Invalid keyword or missing delimiter SQLSTATE: 42000
sqlcli WFMC=> DIAGNOSE ANALYSE CLEAR ALL;
* -3008: Invalid keyword or missing delimiter SQLSTATE: 42000
----------------------------------------------
But wait, I just got an idea: Yeah! You have spelled "ANALYSE" wrong in
your article:
----------------------------------------------
sqlcli WFMC=> DIAGNOSE ANALYZE CLEAR ALL
* -5001: Missing privilege:DBA SQLSTATE: 42000
----------------------------------------------
Now I only have to get the priviledges, "dba" doesn't seem to be enough...
>> "dbanalyzer, but after asking me for a databse and credentials, it
>> simply does nothing. What am I to do?
>
>
> "Once you've turned the Database Analyzer on, the Database Analyzer
> starts to write values into 17 files."
>
> What do you mean? You might have successfully turned it on. You finished
> the wizard. That's it. Now it's upto you to interpret the data that's
> recorded every X seconds.
I tried "dbanalyzer" hoping to get some prompt where I could issue the
"DIAGNOSE ANALYSE" commands, hence my disappointment. I understand that
it serves a different purpose, this was just a desperate try.
Thanks,
Michael
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
