Hi Before creating the index.
set this at you mysql prompt.
set sort_buffer_size=1;
This will enable ordering of index happen in the memory and index creation
will be faster.
regards
anandkl
On 8/11/07, Mike Zupan <[EMAIL PROTECTED]> wrote:
>
> Yes it will take a long time depending o
hello
is it possible to make aliases for types, so that for instance:
"uint" means "int unsigned not null default 0"
it makes table definitions unreadable having to write those long
definitions all the time.
thanks!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Actually, that buffer is only for sorting queries that use an ORDER BY.
Only MyISAM tables can build an index via sorting, and the
configuration parameter for that is myisam_sort_buffer_size.
If the table is InnoDB, let it complete, no matter how long it takes.
If you kill it, it will have to
*From: VeeJay* <[EMAIL PROTECTED]> To: mysql@lists.mysql.com,
[EMAIL PROTECTED]
Date: Fri, Aug 10, 2007 at 8:19 AM
Hello there
I have a problem. When I try to select some names starting with extra
alphabets (Å Æ Ø Ä Ö, etc), I simply don't get required results i.e.,
if I give a select command
I am running a MySql server, ver. 4.1.7-max on a P3 with 512meg of RAM.
It has been running fine for the past year, nice and quick. Now it seems
like its running slowly. Is there a tool to test the db and/or install and
see if there are any problems???
Or would upgrading help?
Anyone have
turn on slow query logging.. maybe one or more of the db's got too big and
your queries are running slow
Mike
On 8/10/07, Steve Grosz <[EMAIL PROTECTED]> wrote:
>
> I am running a MySql server, ver. 4.1.7-max on a P3 with 512meg of RAM.
>
> It has been running fine for the past year, nice and qui
On 8/10/07, Stut <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I'm working on a site at the moment that experiences a strange problem
> when the traffic passes a certain point.
>
> Active connections are usually < 50, but at about 9pm every evening (our
> peak time) they suddenly leap up to max_connecti
