> -Original Message-
> From: Gary W. Smith [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, February 14, 2007 8:01 PM
> To: mysql@lists.mysql.com
> Subject: InnoDB fixed file size, how much is left?
>
> I'm working on migrating an bunch of MyISAM tables over to InnoDB.
For
> development we wan
I'm working on migrating an bunch of MyISAM tables over to InnoDB. For
development we want to use a fixed amount of space. So I have specified
10 100MB files in my.cnf. I started replicating data over but what I
can't tell is how much space I have left. Running show innodb status\G
shows a lot
Hi,
I've used PHP with MySQL and I was able to count the rows of a table by
using the following code:
SELECT SQL_CALC_FOUND_ROWS * FROM MyTableName;
SELECT FOUND_ROWS();
However, I would like to do the same thing using Visual Basic 6...
When I set the RS.Source to the first SELECT statement
Carlos Soria wrote:
Hello,
I am working with MySQL 5.0.24 on Mandriva-Linux 2007. I can't compile book
example test1_libmysqld due to an incompatibility
gcc -g -W -Wall -I/usr/include/mysql -D_THREAD_SAFE -D_REENTRANT -static
test1_libmysqld.c -L/usr/lib/mysql -lmysqld -lz -lm -lcrypt -lpthrea
Yves Goergen wrote:
On 14.02.2007 08:00 CE(S)T, Colin Charles wrote:
The MySQL 5.0 release is available as a binary and is currently at
5.0.27. Grab it at: http://dev.mysql.com/downloads/mysql/5.0.html#downloads
I read in the news some time ago that MySQL 5.0 is only going to be
available as s
> I have a string ("word word bob jack") such that I want to pass to the
> store proc as a single entity,
> split it in the store proc, and do a specific action for each word.
> Any
> advice on how to do this? There is more going on that just that
single
> word so multiple calls isn't practical an
Hi List,
I have just published a performance benchmark paper which includes MySQL
in its tests.
http://devloop.org.uk/documentation/database-performance/
I hope you will find some of these results interesting, as I did.
I am planning on making a new set of tests, including various engines
(In
Hello,
I would like to create a setup program for my demo version that uses MySql
database.
I need to detect if the target computer has already got the MySql installed
because I don't want to ruin an existing database.
Is there any method to detect it?
Thank you in advance
--
Zsolt Csillag
I have a string ("word word bob jack") such that I want to pass to the
store proc as a single entity,
split it in the store proc, and do a specific action for each word. Any
advice on how to do this? There is more going on that just that single
word so multiple calls isn't practical and they stri
Carlos Soria wrote:
Hello,
I am working with MySQL 5.0.24 on Mandriva-Linux 2007. I can't compile
book
example test1_libmysqld due to an incompatibility
gcc -g -W -Wall -I/usr/include/mysql -D_THREAD_SAFE -D_REENTRANT -static
test1_libmysqld.c -L/usr/lib/mysql -lmysqld -lz -lm -lcrypt -lpthr
Hello,
I am working with MySQL 5.0.24 on Mandriva-Linux 2007. I can't compile book
example test1_libmysqld due to an incompatibility
gcc -g -W -Wall -I/usr/include/mysql -D_THREAD_SAFE -D_REENTRANT -static
test1_libmysqld.c -L/usr/lib/mysql -lmysqld -lz -lm -lcrypt -lpthread -o
test1_libmysqld
> Hi,
>
> on server B you need to set log-slave-updates to pass statements from
A
> over B to D.
>
> BTW: I can recommend you to use replicate-wild-do-table=db_name.*
> instead of replicate-do-db, otherwise statements with db prefix before
> tables won't replicate over B to D. RTM please
>
>
>
> You should have:
> log-slave-updates
>
> on the slave/master host(s)
>
>
> Best regards,
> Irek Slonina
Irek,
Thanks for the follow up. Someone else has mentioned it but I just noticed
that it was offlist.
Sorry for the double-post, but another thought if it's not obvious already:
with such a large dataset, making sure to employ striping and high-RPM disks
will be important for speed. I'd recommend looking at RAID 1+0 with dual
SCSI channels and 15K RPM disks if you're looking in the Dell PowerEdge
Rich, one consideration is of course disk space - you'll want to make sure
that 2.5 billion * row length will fit on your disks.
Offhand, you've got (referencing
http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html)
78 bytes in 3 varchars (50 + 10 + 15, + 3 for internal use)
16 bytes
hi,
keep on going through the documentation, the answer is there :)
or here:
http://dev.mysql.com/tech-resources/articles/4.1/prepared-statements.html
lars
On 2/14/07, balaraju mandala <[EMAIL PROTECTED]> wrote:
Hello everybody,
While i am going through the MySQL documentation i found thes
Hello everybody,
While i am going through the MySQL documentation i found these lines
SET @a=1;
PREPARE STMT FROM 'SELECT * FROM tbl LIMIT ?';
EXECUTE STMT USING @a;
can anybody please explain me what is these part mean and also PREPARE STMT.
On 14.02.2007 08:00 CE(S)T, Colin Charles wrote:
> The MySQL 5.0 release is available as a binary and is currently at
> 5.0.27. Grab it at: http://dev.mysql.com/downloads/mysql/5.0.html#downloads
I read in the news some time ago that MySQL 5.0 is only going to be
available as source version in th
Found the source of my problem.
I had an update trigger connected to this table which was trying to
create a new entry in another table instead of updating an existing one!
There we go!
Simon
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http:
Hi,
I have a table (structure below) which will hold 2.5 billion rows. I'm
currently choosing the hardware i'll need. Does anybody know what the
minimum spec of machine is likely to be that I comfortably use? I
imagine the table will have to be Innodb split across a number of files.
It will
Hi all,
I have a serious problem with MySQL 4.1.22 on Solaris 9, SPARC. I have a
database server with around 10 or so databases, each with roughly 20-50
tables. At fairly consistent intervals, MySQL gets stuck with 100s of
queries in the "Opening tables" state. I have checked the value of my
Open_
MySQL Users,
I know from the manual that I can change the collation set of a table
with the following command:
ALTER TABLE `mytable` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci
And that I can do this to alter a column of a table to change its collation:
ALTER TABLE `mytable` CHANGE `c
Hi,
on server B you need to set log-slave-updates to pass statements from A
over B to D.
BTW: I can recommend you to use replicate-wild-do-table=db_name.*
instead of replicate-do-db, otherwise statements with db prefix before
tables won't replicate over B to D. RTM please
Filip
I'm wor
Rodica Rosu Fridez wrote:
Bonjour,
Parlez vous anglais? Mon francais, est plutot limite.
Nous avons rencontré ce message d'erreur lorsqe l'on veut accéser notre plateforme e-commerce www.styltech.ch
La personne qui administrait le site ne travaille plus chez nous. J'ai trouvé la documentation
24 matches
Mail list logo
