Re: how to creat stored procedure ??

2001-05-23 Thread Frank Schroeder
Neither triggers, views or stored procedures are supported by MySQL. However you can write your application in a way so that you don't need either of them. Alice wrote: > Hi, i am a new user of mySQL, however i have experience in MSSQL server. > > i have difficulties on creating stored procedu

Re: MYSQL performance question

2001-05-21 Thread Frank Schroeder
I'm currently running MySQL with tables that contain ~10 million rows. Each row has 50 columns and the table has 27 indexes. The data size of what you're describing doesn't seem so big. There are some arithmatics in the MySQL manual on how much disk space is used per row. If the tables you hav

Re: I am newbie and I can't resist anymore !!!!

2001-05-18 Thread Frank Schroeder
You're MySQL server is not running. Start the MySQL server. Linux: /etc/rc.d/init.d/mysql start (as root) If you're trying to access MySQL on another host then you need to specify that host on the command line: mysqladmin -h Radu Adam schrieb: > so ... this is another story: > > mysqladmin:

Re: Bug Report: 3.23.37: Innobase crashes on large table

2001-05-17 Thread Frank Schroeder
Thanks for the hint. I'll try it with more tablespace. The indexes have been optimized pretty much. I have to check whether I can send you the table layout. Just for your information. 3.23.38 has the same problem. Heikki Tuuri wrote: >Frank, > >there is obviously a bug in the insert buffer co

Bug Report: 3.23.37: Innobase crashes on large table

2001-05-16 Thread Frank Schroeder
Hi, I'm trying to load a large table with 7 million records, 50 columns and 27 indexes into an innodb table. Works fine for MyISAM. Compressed size of the data file is about 280MB (830MB uncompressed) and 1.5 GB for the index file. Platform is RedHat Linux 6.2 with kernel 2.2.16-3 and MySQL is 3.