Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: mySql - really slow - 100% cpu.. and wcf ??

  1. #1
    Join Date
    Mar 2003
    Posts
    207

    Default mySql - really slow - 100% cpu.. and wcf ??

    I seem to have things ALMOST working.. with mySql.. but every time a request hits it.. it shoots up to 100% and stays there. The dbms test also hang at the end, but report finished: ok when I kill mysqld. OF the webapps, I have all working except the Jpivot example. I have narrowed it down to the wcf taglib... the jsp page crashes with "mondrian/olap/SchemaReader" error when I try to use it. What db runs best here? (I'm on winXP 2.2Ghz, 1GB RAM.. so I don't think its my PC.. )

  2. #2
    Join Date
    Mar 2003
    Posts
    207

    Default RE: mySql - really slow - 100% cpu.. and wcf ??

    sorry.. plz ignore the duplicate.. or delete if possible...

  3. #3
    Join Date
    Jan 2000
    Posts
    2

    Default RE: mySql - really slow - 100% cpu.. and wcf

    Running Mondrian on the Foodmart database on MySQL was very slow. I don't know if this is inherent to that database or it performance can be improved (e.g. by adding indices). My advice to you if you plan to do some serious work on decent size data set is to use another database (I am sure Oracle, DB2 or SQL Server will all be fine).
    Alex

  4. #4
    Join Date
    Sep 2002
    Posts
    10

    Default RE: mySql - really slow - 100% cpu.. and wcf ??

    Yes, we had the same problem with Mysql. We found, that the table time_by_day is missing a primary key/index.
    Adding
    CREATE TABLE time_by_day (
    time_id int(11) NOT NULL PRIMARY KEY,
    ...
    CREATE UNIQUE INDEX i_time_by_day_id ON time_by_day ( time_id );
    yielded a much better performance.
    Hartmut

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.