Hi
Bing Du wrote:
In our situation, we have three or four separate MySQL servers running.
Each has 'skip-networking' configured. So mysql don't accept requests
coming from outside via network. Each mysql server also runs as web
server. 'Localhost' is used for communication between web
Hi John
John Nichel wrote:
The db is MySQL 4.1.20 and the column synonyms_misspellings has a
FULLTEXT index on it (the db is set to index on 3 characters). Can
anyone help me understand why it's not rating the one with the match
three times higher than the one with the match twice, and point
Hi Xian,
xian liu wrote:
ERROR 1295 (HY000): This command is not supported in the prepared statement
protocol yet
mysql drop procedure ct_tb//
Query OK, 0 rows affected (0.00 sec)
the same, drop function/trigger xxx is also not supported in prepare
statment.
Is it a lack of
Hi,
abhishek jain wrote:
I am having a database with varchar(255) columns named title,
extra_info1,extra_info2,extra_info3 .
I want to search all these columns with a search string given to me via a
form ,I am using PERL, the string will be like
+abhishek jain -abcd this should be exact
I
Grant Griffith wrote:
I am trying to add an autoincrement field to a table that already exists
and I keep receiving errors when trying to do it. Can someone point me
in the right direction on how I can do this? I have access via Webadmin
and phpMyAdmin, so I can try it however I need to.
Hi Murthy,
murthy gandikota wrote:
Can someone please tell me how to manage multiple disk partitions in mysql?
BTW, the mysql is version 4 or something like that.
When using InnoDB you can just add another tablespace on /var [1]. With
MyISAM it gets a bit more difficult, at least in pre
Hi,
Michael Fernández M. wrote:
2 CPU Pentium III 700 Mhz Aprox.
4 GB RAM.
Redhat 7.2
Mysql version: 4.0.14-standard-log
Kernel: Kernel 2.4.18-17.7 (highmem)
It is possible that mysqld could use up to key_buffer_size +
(read_buffer_size + sort_buffer_size)*max_connections = 3666809 K bytes
of
Hi JM,
JM wrote:
i got this results from show processlist
| 11186 | unauthenticated user | 192.168.1.106:36198 | | Connect | NULL |
login | |
| 11187 | unauthenticated user | 192.168.1.106:36200 | | Connect | NULL |
login | |
That's just
Hi,
Micol lupen wrote:
FOREIGN
KEY(of_idvillaggio),REFERENCES villaggio(idvillaggio)
^^^ check here!
ON UPDATE CASCADE ON DELETE RESTRICT)ENGINE=INNODB;
No comma before REFERENCES. REFERENCES is part of the foreign key
definition.
regards
Nils
--
MySQL General
Hi,
Jean-Sebastien Pilon wrote:
I would like to grow my innodb table space, the only problem that I have
is that I did not declare any size in the config file since we were not
using it to start with. If I modify the config file, will this override
the current innodb file or will it grow it ?
Hi,
Michael Fernández M. wrote:
key_buffer_size=402653184
read_buffer_size=2093056
max_used_connections=323
max_connections=800
threads_connected=55
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections
= 3666809 K
bytes of memory
Hi,
Michael Fernández M. wrote:
i use 32 Bits kernel.
Remember that you have to stay under 2GB total memory allocation! I
think you hit that limit.
innodb_additional_mem_pool_size = 500 MB.
innodb_buffer_pool_size = 8 MB
Before the innodb_additional_mem_pool_size was 1 MB, (the default
Michael Fernández M. wrote:
Remember that you have to stay under 2GB total memory allocation! I
think you hit that limit.
Sorry, but why do you say that?, because of the 32 bits kernel?
Yes exactly. Depending on kernel version you can allocate something
between 2 or 2.7GB. Until 2GB it's
Hi,
Nuno Oliveira wrote:
When I set the RS.Source to the first SELECT statement and open it, it
run OK but I need to close the RS and open it again using the second
SELECT statement.
After any of this operations I get a Recordset-RecordsCount = 1
That is actually a correct figure, SELECT
Nils Meyer wrote:
SELECT
SQL_CALC_FOUND_ROWS doesn't make much sense without a where clause by
the way.
LIMIT, not where.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Js,
js wrote:
Is there any easy way to implement 'NOT EMPTY' constraint?
There currently is no support for CHECK Constraints in MySQL, at least
to my knowing. So you'd have to go with a trigger.
regards
Nils
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Hi Faygal,
Fagyal Csongor wrote:
for (1..5) {
$dbh = DBI-connect($dsn, $user, $password, {'RaiseError' = 1} );
my $sth = $dbh-prepare('SELECT * FROM users');
}
I think you are simply running out of available outgoing ports with
that. Here is some more insight on that topic:
Hi Manuel,
Manuel Vacelet wrote:
I have query that joins 2 tables. I have an index on each part of the
join but unfortunately the 2 columns don't have the same type so the
index is not used for the join (I guess it's the reason why). On one
hand I have an INT and on the other and a VARCHAR.
Hi Kim,
Kim Christensen wrote:
The error I get while trying executing is Unknown column
'products.product_id' in 'on clause'. Since I am selecting all
columns from that table (products), I can't really see why there's a
fuss about it!
I'm thankful for every tip I can get, and please let me
Hi Shain,
Shain Lee wrote:
Now , i have to think about any perfect load balancing method , i can't
duplicate the databse in another machine. It's directly conflict with serving
contents for each request.
Why not use replication? If you don't want to do it on application level
(seperate
Hi Shain,
Shain Lee wrote:
ERROR 1 (HY000): Can't create/write to file '/home/shaine/Music_Details.csv'
(Errcode: 13)
I faced a problem as mentioned above. really got stucked. how can i solve that
problem ? is it a bug ?
Error 13 is Permission Denied. The MySQL daemon cannot write to your
Hi Richard,
Richard Reina wrote:
I am trying to update from one table to another but I get a syntax error when I
try:
UPDATE from maindb.orders o, altdb.orders ao SET o.price=ao.price WHERE o.ID=a.ID;
If update does not support aliases, is there another way to do this query? I am usin
Hi,
Nishant Gupta wrote:
[/usr/local/mysql-5.1.12-beta-hpux11.11-hppa2.0w]scripts/mysql_install_db
--user=mysql
chown: unknown user id mysql
Installing all prepared tables
061212 19:39:30 [ERROR] Fatal error: Can't change to run as user
'mysql' ;
Please check that the user exists!
Did you do
Hi Charles,
Charles Danko wrote:
Each entry consists of 2 medium_int and 1 tiny_int variables, and the
table
contains just over 100,000,000 rows. By my count, this makes just over
700MB of data. The machine I am using has 2GB, but I am still getting an
out of memory error. What am I doing
24 matches
Mail list logo