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
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
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:
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
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.