Like the subject says, I am looking for any info regarding positive
or negative effects of using CPU affinity to lock the MySQL process
to a single processor (possibly hyperthreaded).
Anyone tried this? Learn anything interesting?
Thanks,
Jeff;
--
MySQL General Mailing List
For list archives:
I have a question about:
> If you want to regain some of the space used by the INNODB file you
> will have to convert all INNODB tables to MYISAM (or dump them to
> a SQL file), recreate the INNODB file (s) and then recreate the
> original INNODB tables.
So, just to be clear, is this the right
If I have a MyIsam table that is not subject to modification,
is a series of select calls like this:
select * from table limit 0,100;
select * from table limit 100,100;
select * from table limit 200,100;
...
Guaranteed to return each row in the table exactly once (as long
as I keep going until the
I recently found the MySQLStat page (http://www.mysqlstat.org/en). The
screen
shots look very appealing, but the code has not been updated for over 2
years.
Is anyone using this code with MySQL version 4? Is there another web
application
with similar or better functionality?
Thanks,
Jeff;
--
*
I have a script on my site that I call "smalltables". When run, it
echoes out the names of all of the tables _except_ for the large
ones that I don't back up. I then use this in the mysqldump
command line:
/usr/local/mysql/bin/mysqldump -q --user=UUU --host=localhost
--password=PPP DB_NAME `small
Is there a way to customize the way that MySQL treats various characters
when
it builds a fulltext index? I am using version 4.0.18.
I would like to treat a "." as part of a word, rather than as a
separator character.
Ideally, I would like to set this for just one index of one table.
I have a
