when switch from 5.0.1 to 5.0.2 (without any config /my.ini change)
it used 100% cpu for a single command "show tables" (i've 42 tables)
and running forever (ate more and more memory)
So get back to 5.0.1 and things are fine.
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus
Greetings,
I am running MySQL (version 4.0.15 max) database on Linux (RH9) box. This
linux box is a dedicated database server with following h/w configuration:
CPU: 2 * 2.4 Ghz Xeon Processor, 512 K 533 FSB
Ram :6GB
Hdd:36GB * 5 raid config
Typically, this databa
Hi:
I am using MySQL under FC2 on Intel P4. I created one table using
the following command
CREATE TABLE subscriber (
phplib_id varchar(32) NOT NULL default '',
$USERCOL varchar(64) NOT NULL default '',
domain varchar(128) NOT NULL default '',
password varchar(25) NOT NULL default '',
fir
Something is wrong, but it's hard to say what. It seems unlikely you entered
exactly those commands and got an error only on the last ALTER TABLE.
First, you need InnoDB tables to support foreign keys, but you don't specify
the table engine in your CREATE statements. The default is MyISAM, unle
Steve,
which MySQL version did you use? Both statements work with MySQL-4.1.8 on
Linux.
[EMAIL PROTECTED]:~/mysql-4.1/client> ./mysql test
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.8-debug-log
Type 'help;' or '\h' for help. Type
Hello everybody,
I have just installed a MySQL Server 4.1.7 on my machine (Win XP SP2 de)
to try out my software with the new version. Everything works fine with
4.0.x and I store all data UTF-8 encoded into the tables. This produces
a wrong sorting order, but that's not a big issue.
Now I have
I just installed 4.7.1 for XP Pro. I am unable to Start Service. I do not
find any error files?
I get: "Cannot Create Windows Service for MySQL.Error:0"
Any ideas?
Thanks,
Jerry
I just installed 4.7.1 for XP Pro. I am unable to Start Service. I do not
find any error files?
I get: "Cannot Create Windows Service for MySQL.Error:0"
Any ideas?
Thanks,
Jerry
Hi folks,
I'm trying phpmyadmin 2.6.0-pl3 with mysql 4.0.15
I notice that when I setup and use the pma user in the config, I cannot create
database even when I login with root (using cookie auth).
But if I don't use the pma options, I can create database.
Can you shed a light on me pls? Thanks.
-
No help for 3.23, but in 4.1 you could use
INSERT INTO dailycounters (trackingdate, thingid, count)
VALUES (, , 1)
ON DUPLICATE KEY UPDATE count = count + 1;
assuming a UNIQUE index on the combination of trackingdate and thingid.
Michael
Jim McAtee wrote:
Ah, I see what you're saying. Each
I am unable to define a foreign key with the following three tables. I am
unable to find the error having searched the documentation and tried several
variations.
Note that I created the first two tables with and without the index clause in
the table ddl with no difference in outcome.
The t
Hi All,
I need to backup and restore MySQL database using ODBC from my client
machine. My database is in the remote server.
I am building my backup command using C program.
Example: My backup will have the following.
Mysqldump -h host name -u username -p password --databases > dump.dmp
I am trying to install ODBC and it does nothing. I am running version 4.1.7
on XP Pro.
PPM hangs when I query Tk as well.
What is going on?
Thanks,
Jerry
Hi Paul,
> Generally this happens when you upgrade to a newer version of MySQL
> but don't upgrade the grant tables. See bullet 4 on this page:
>
> http://dev.mysql.com/doc/mysql/en/Upgrade.html
Arghh OK!!! Thank you very much. It is ok after I run
mysql_fix_previlege_table.
--bk
--
MySQ
14 matches
Mail list logo
