"Does splitting a large table (20 Million rows) growing at 5 million or more
a month into smaller tables improve performance given that the table can be
split in a logical way such that 95% queries don't need to look at data
spanning across the split tables"
Table Description:
20 Million
enum --Y
Process_priv enum --Y
File_priv enum --Y
Grant_priv enum --Y
References_priv enum -- Y
Index_priv enum --Y
Alter_priv enum -- Y
What else can I try?
Thanks.
Ronnie
-Original Message-
From: Egor Egorov
__
The user in question has the appropriate permissions. Thanks about al I
know.
Im sure this is such a simple problem, but unfortunately this molehill is my
mountain today.
Thanks in advance, and my apologies for posting what will be such a simple
problem.
Ronni
Can anybody please list known Forums with regard to "MySql C API"
programming and development, Interfacing with multi-language programming,
COBOL, PHP, GDK+, XForms, etc...
Help for newbies to C API, techniques, sample codes, creating wrappers, list
of great reference books (ones that are not padd
Hi there,
Lets say i do the following query:
mysql > select something from some_table;
Then i will get the results , how many rows and how much time it took to
perform the query.
My question is how can i get the time it took for perform the query.
I want that cuz i would like to put in a web pag
Hi everyone,
SQL
Iv'e been on innodb.com trying to find out the largest "ibdata" file size
acceptable to my system "RH Linux 7.2", at one part it states "data and log
files must be < 2GB", depending on the OS.
I specified 1M as the size for "ibdata", current "ibdata" size reflects1.8G.