 | | | MySQL General | | "Daevid Vincent " <daevid@(protected) > wrote
> It has come to my attention that we have maxed out our keys due to a stupid
> update script bug. It seemst that we 've not been explicitly naming our key
Thanks to all who helped me out. It seems I missed an essential AND
statement in my query. Including it brought me from 32 seconds to about 1-2
seconds and all seems to be doing fairly well. I 'm aRemember14a@(protected) wrote
> I use following code
> use databasea
>
> load data infile "abcd.txt ' into table databasea.tablename
>
> Data gets loaded in table however at the end of each recCan you roughly outline the schema of the two tables?
If the key value doesn 't have to match from the input to the final result
you can always insert into a list of fields skipping the auto_incr i have a table this is 50 Million has 10 indexs some are on varchar 's
disk space is 34 GB for the MYD and 6.5 GB for the MYI. Granted I have
a pretty old box 2x660 Mhz P3 's and a RAID array just out of curiousity
have you tried the 4.1.1 version?
there may (or may not) be something from 4.1.0 to 4.1.1
could be a total waste of time but you never know.
Dan.
On Mon 29 Mar 200Joshua
----- Original Message -----
From " "Joshua Thomas " " <jthoma10@(protected) >
Newsgroups mailing.database.myodbc
Sent Monday March 29 2004 7 48 PM
Subject mysqld keeps crashing
Hi
Does anyone know of the fastest way to get the size of a single table row in
bytes?
Im currently using the following query (this query takes 7 seconds which is
not efficient).
SELECT
I am by no means an accomplished MySQL user and generally deal with rather
simple queries having no need for anything particularly complex until now.
I have been working on a query this past wee "Jayme Jeffman Filho " <jjeffman@(protected) > wrote
> I 've got an unespected behavior using MySQL server-version 3.23.52 with PHP
> 4.3.0 (Apache/1.3.27 (Win32) PHP/4.3.0 running... ) if I submit an Hello buddy
try installing
MySQL-shared-compat for your platform
HTH....
Nitin
----- Original Message -----
From "Timothy Venn " <tim@(protected) >
To <mysql@(protected) >
Sent MonEarlier on I thought I could use rand () as follows
SELECT rand () FROM Products LIMIT 2
_____________
0.2036000.....
0.125689......
____________
2 rows
Your suggestion worked ok.
TI (a total newbie on sql) try to populate my tables by "load data local "
-syntax from a text file (saved in ANSI-coding) with swedish characters
(vocals ? ? ?) but "select * from table " reveals tha
"B. Fongo " <mysql@(protected) > wrote on 29/03/2004 13 54 54
> Does MySQL provide a way of selecting a limited number of rows at
> random? From a query that might return several rows Tom?? P?ral <paralt@(protected) > wrote
> Hi
> I want to store data in czech in mysql 4.0.18. I use property
> default-character-set czech set in my.ini on localhost and all run well.
> But my Jonas Lind?n <jonas.linden@(protected) > wrote
> Hello list I have successfully installed mysql5 on my windows box and my aim is set on replicating my mysql5 linux system. I think I am on the righHi
I want to combine to result-sets with 'union ' but I don 't know how to get the
'group by ' right. I tried it like the example with 'order by ' but that
doesn 't work.
So I want to get somethiplease include the query you are using with no success and also specify the
version of your mysql.
Nitin
----- Original Message -----
From "Ed Reed " <ereed@(protected) >
To <mysql@(protected)
Scott Haneda wrote
> Wonder if there is a more efficient way of dealing with the following...
>
> I have a user table and a serial_numbers table
>
> User table has name address state ziAt 16 23 -0600 3/28/04 unruhtech wrote
>the following works
>SELECT to_days( curdate() + 0 ) to_days( curdate() + 3 ) FROM table
>732033 732036
That 's correct.
>
>but this does not
>SAt 7 48 -0800 3/28/04 Khashan wrote
>Hello All
>I have MySQL 4.0.16 on Windows 2000 pro.
> I am trying to create a table in an existing database.
>according to the manual I can use one of At 13 41 3/28/2004 A Mathias wrote
>Preferably one that is for begginers to medium and thats covers both mySQL
>and PHP
>
>Thanks
I like the Welling & Thomson book
http //tinyurl.com/3cpk5
Hello
I have written a little backup tool for mysql databases with a graphical user
interface. It is written in Qt and only supports very basic features.
Perhaps some of you would like to helpIn 4+ you can use SQL_CALC_FOUND_ROWS flag
http //www.mysql.com/doc/en/SELECT.html
-----Original Message-----
From Steffan A. Cline [mailto steffan@(protected)]
Sent Sunday March 28 2004 8 4Hello
I just upgraded to MySQL 4.0.18. I have a question about the new
query-cache. The documentation says
"The FLUSH TABLES statement also flushes the query cache. "
What does that mean exVery Sorry!!!
I sent a Tomcat request to this list by mistake. Please ignore it.
Thanks
-Richard
--
MySQL General Mailing List
For list archives http //lists.mysql.com/mysql
To unsubI downloaded the Linux RPM binaries for MySQL 4.1.1 and all except
MySQL-shared-4.1.1-0.i386.rpm and MySQL-shared-compat-4.1.1-0.i386.rpm
installed correctly. The -shared RPM failed on missing depYour file is attached.
--
MySQL General Mailing List
For list archives http //lists.mysql.com/mysql
To unsubscribe http //lists.mysql.com/mysql?unsub mysql@(protected)Hi Folks --
Been working on this issue for a while and not making much headway so I
thought I 'd throw it out to the list and see what wisdom came back )
Problem I 'm trying to find a way t-----BEGIN PGP SIGNED MESSAGE-----
Hash SHA1
Richard S. Huntrods wrote
> I need to access a specific directory from within tomcat but I 'm having
> a specific problem and require some advice |
|
|
