Side question: If I use a 64-bit MySQL build on a 64-bit kernel, is it safe
and sane to allocate say, 6GB to the InnoDB buffer pool?
On an 8GB box, 64-bit software stack, what is the optimum memory allocation for
a pure-InnoDB (* - MyISAM used only for grant tables) mysql server running as
the
I have a Windows 2000 host with 3.5 G of ram. I have configured MySQL
4.1.14 with innodb_buffer_pool = 1024M, when I start mysqld I get the
following error:
051013 16:46:00 InnoDB: Error: cannot allocate 1073758208 bytes of
InnoDB: memory with malloc! Total allocated memory
InnoDB: by InnoDB
Just recently (possibly since upgrading to MySQL 5.0.13 RC), I've been
getting the following error with queries like the one below.
Unknown column 'photos.id' in 'on clause' (1054)
SELECT photos.*
FROM photos
LEFT JOIN tags_photos ON tags_photos.photo = photos.id
WHERE 1
AND tags_photos.tag IN
Hi all
I'm back with a new subject may be the last one was not attractive :)
I'm using mysql 4.1.11-2 in Fedora Core 4. I need to set up mysql
connections over SLL I follow the mysql manual instructions, create
certificates and keys for the CA, the client and the server and modify
the /etc/my.cnf
"C.F. Scheidecker Antunes" <[EMAIL PROTECTED]> wrote on 10/16/2005
01:58:56 PM:
> I actually forgot something. I need a two statements into one. The
> reason is that table_two has multiple values, so I need the minimal ID
> from table 2.Thanks.
>
> Maybe I am working too much here and tired to
Errm, needed to take the grants table updates out of the repat loop:
CREATE PROCEDURE RenameDatabase (IN oldname CHAR(64), IN newname CHAR(64))
BEGIN
DECLARE sname CHAR(64) DEFAULT NULL;
DECLARE rows INT DEFAULT 1;
DECLARE total INT DEFAULT 0;
CREATE DATABASE IF NOT EXISTS newname;
REPEAT
Ananda Kumar <[EMAIL PROTECTED]> wrote on 10/17/2005 09:16:25 AM:
> Hi Friends,
> Any help on this would be of great help.
> regards
> anandkl
>
> On 10/17/05, Ananda Kumar <[EMAIL PROTECTED]> wrote:
> >
> > Hi All,
> > I am using version 5 of mysql on lunix. I have place my log files in
the
>
Shawn wrote
>I have a 2.1GB database with all InnoDB tables in it that I wanted
to
>change the name of. It took me longer to write my RENAME TABLE
>script than it did to actually move the data.
It's easier & less error-prone to do it in an sproc which prepares
& executes the rename cmds. On
We only upgraded to CentOS 4.1 due to an emergency data center migration... We
weren't prepared to undergo the risk of a 64-bit upgrade at the same time. I
believe we're experimenting with 64-bit kernel now as part of our efforts to
diagnose and resolve the I/O issue.
-JF
> -Original M
Jon,
I am not 100 % sure that the problem we saw was in a 64-bit Linux. It might
have been 32-bit.
Anyway, since CentOS is a clone of RHEL, this might be the same file cache
phenomenon. I do not know if one can force the file cache to stay smaller
than 4 GB. You can try running some dummy pr
Sorry to spam the group, but I just noticed that I asserted we were on a
2.4 kernel -- we're on 2.6.9-11 as part of CentOS 4.1...
-JF
> -Original Message-
> From: Heikki Tuuri [mailto:[EMAIL PROTECTED]
> Sent: Sunday, October 16, 2005 2:23 AM
> To: mysql@lists.mysql.com
> Subject: Re:
Jon,
I do not know. Why not install a 64-bit Linux in your computer?
Regards,
Heikki
Oracle/Innobase
- Alkuperäinen viesti -
Lähettäjä: "Jon Frisby" <[EMAIL PROTECTED]>
Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>;
Lähetetty: Monday, October 17, 2005 8:46 PM
Aihe: RE: Non-line
Actually, I believe we're running 32-bit, with bigmem... Does similar
behavior occur in such a scenario?
-JF
> -Original Message-
> From: Heikki Tuuri [mailto:[EMAIL PROTECTED]
> Sent: Sunday, October 16, 2005 2:23 AM
> To: mysql@lists.mysql.com
> Subject: Re: Non-linear degradation i
About 6GB... Is there any way to forcibly limit this?
-JF
> -Original Message-
> From: Heikki Tuuri [mailto:[EMAIL PROTECTED]
> Sent: Sunday, October 16, 2005 2:23 AM
> To: mysql@lists.mysql.com
> Subject: Re: Non-linear degradation in bulk loads?
>
> Jon,
>
> your hardware/OS combi
Hello.
This is a frequently asked question. See:
http://lists.mysql.com/mysql/188094
For more solutions search in the archives at:
http://lists.mysql.com
Octavian Rasnita wrote:
> Hi,
>
> Is there a command for renaming a MySQL database?
>
> Thank you.
>
> Teddy
>
Shaun wrote:
Hi,
When I create a table using my ISP's web control panel and I create a column
with a type of TINYINT it automatically creates a column with a value of
TINYINT(4).
After looking at the documentation on the MySQL site it is not exactly clear
what this means:
http://dev.mysq
Hi Shaun,
Am Montag, 17. Oktober 2005 16:56 schrieb Shaun:
> http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html
>
> Is TINYINT(4) the same as an INT(4)?
No, they only have the same display width, see the following
quote form the manual:
"Another extension is supported by MySQL for optiona
Robert L Cochran <[EMAIL PROTECTED]> wrote on 10/17/2005 11:00:33 AM:
> And, of course, you need to grant permissions for the new database name.
>
> Bob
>
> [EMAIL PROTECTED] wrote:
>
> >Robert L Cochran <[EMAIL PROTECTED]> wrote on 10/17/2005 07:37:26
AM:
> >
> >
> >
> >>I think you can just
And, of course, you need to grant permissions for the new database name.
Bob
[EMAIL PROTECTED] wrote:
Robert L Cochran <[EMAIL PROTECTED]> wrote on 10/17/2005 07:37:26 AM:
I think you can just rename the directory that that database lives in.
If you read the documentation for CREATE DATAB
Hi,
When I create a table using my ISP's web control panel and I create a column
with a type of TINYINT it automatically creates a column with a value of
TINYINT(4).
After looking at the documentation on the MySQL site it is not exactly clear
what this means:
http://dev.mysql.com/doc/refman/5
Hellou!
I have MySQL(charset is utf-8) + PHP 5.0.5. Latvian symbols(auczsnsczikl) not
correctly viewed in MySQL Query Browser, but in 'phpmyadmin' its ok. When i use
php to viewed data with latvian symbols in IE, then latvian symbols(aui.)
is converted to ? symbols.
Please Help!
Ar cienu,
yes..exactly thats what i am planning to do now.
Thank you
sujay
_
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, October 17, 2005 7:35 PM
To: Sujay Koduri
Cc: mysql@lists.mysql.com
Subject: Re: Datatype conversion
Sujay Koduri <[EMAIL PROTECTED]> wrote on 10/17/2
Sujay Koduri <[EMAIL PROTECTED]> wrote on 10/17/2005 06:25:58 AM:
> hi all,
>
> i have a strange problem here. I have around 600 tables in Oracle DB(On
8i,
> so i am not able to use mysql migration tool kit!!). Now i want move all
of
> these to mysql. I am initially trying to convert the schema
Robert L Cochran <[EMAIL PROTECTED]> wrote on 10/17/2005 07:37:26 AM:
> I think you can just rename the directory that that database lives in.
> If you read the documentation for CREATE DATABASE in dev.mysql.com,
> you'll see they discuss renaming the directory (although it does not
> directly
Hi Friends,
Any help on this would be of great help.
regards
anandkl
On 10/17/05, Ananda Kumar <[EMAIL PROTECTED]> wrote:
>
> Hi All,
> I am using version 5 of mysql on lunix. I have place my log files in the
> same disk of datafiles, can you please let me know how i can move log files
> into a
Gleb Paharenko wrote:
Hello.
I get 142k rows back in just over 4 seconds.
It means that on the server side query works, so the problem
probably is in PHP.
Good call. I did some testing, and sure enough, the mysql_query() is
successful. The failure comes in trying to retrieve the rows u
I think you can just rename the directory that that database lives in.
If you read the documentation for CREATE DATABASE in dev.mysql.com,
you'll see they discuss renaming the directory (although it does not
directly say this can be done to rename the database, but it comes
really close to that
C.R. Vegelin wrote:
What about renaming the folder indicating the database name.
I work with Windows XP and renaming a folder works well.
Cor,
Have you tried it with InnoDB tables or anything other than MyISAM
tables? InnoDB uses a single tablespace per server (unless specified
that it shoul
What about renaming the folder indicating the database name.
I work with Windows XP and renaming a folder works well.
Regards, Cor
- Original Message -
From: "Jigal van Hemert" <[EMAIL PROTECTED]>
To: "Octavian Rasnita" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, October 17, 2005 12:11 PM
Su
Thanks. I want to rename the database in order to keep it as a backup, then
to temporarily create a new one with the same name as a test, because more
programs use that database name.
Teddy
- Original Message -
From: "Jigal van Hemert" <[EMAIL PROTECTED]>
To: "Octavian Rasnita" <[EMAIL
Hello:
After haveing a look at the `show processlist`
I realized that querys will be locked if there
is an update or insert statement otherwise
the `STATUS` is as regular "copying to temp",
"sorting" etc. So that not all querys will be
locked automatically. (But when checking there
where lots of i
hi all,
i have a strange problem here. I have around 600 tables in Oracle DB(On 8i,
so i am not able to use mysql migration tool kit!!). Now i want move all of
these to mysql. I am initially trying to convert the schema from oracle to
mysql. My problem is, in the existing oracle DB, for storing b
Octavian Rasnita wrote:
Is there a command for renaming a MySQL database?
Sorry, there is no command for that. For small databases you can use
administration tools like phpMyAdmin, etc. which will do it for you by
duplicating the database structure and data, and then drop the 'old'
database.
Ok, I have DBDesigner4 libs under /usr/local/lib/DBDesigner4. I tried to
do what you want and I found that I already have a link to
libmysqlclient.so.14.0.0
Maybe this is the problem, don't you think? I don't know wich program
uses that lib...
Ady Wicaksono wrote:
> If you have libmysqlclient.so.
Turn off your auto commit (if using innodb) and run the queries. See how
many rows it updates and compare them. If it matches commit it. Else
rollback.
C.F. Scheidecker Antunes wrote:
Another thing is that table2 might not have a match.
C.F. Scheidecker Antunes wrote:
I actually forgot somet
Hi, joerg
Thanks for your patient answer!
I hope that we will have the ability to run the test suite on windows
system early.
Best regards
luming
_
与联机的朋友进行交流，请使用 MSN Messenger: http://messenger.msn.com/cn
--
MySQL G
If you have libmysqlclient.so.10.0.0 for example at /usr/lib/
try to add new symbolic link
ln -s /usr/lib/libmysqlclient.so.10.0.0 /usr/lib/libmysqlclient.so
and run /sbin/ldconfig
good luck
Bruno Cochofel wrote:
I have a symbolic link to libmysqlclient.so.10.0.0
When I run startdbd for th
I have a symbolic link to libmysqlclient.so.10.0.0
When I run startdbd for the first time symbolic links are created.
Thanks,
Bruno
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi!
lu ming wrote:
Hi!
I tried to run the perl scripts in the windows platform yesterday,but
an error occured [[...]]
I can just repeat:
This script is still under construction, and adaptions are still needed
to make tests work correctly on Windows platforms.
If you run it, you are on yo
Eric,
Thanks for the advise.
I was not reporting a bug. This is a live installation of a database I
have to get working. I was hoping somebody may give me some compilation
options to make MySQL understand IP addresses. Or something.
I cannot upgrade the database as this is our production
40 matches
Mail list logo
