Hi all, after random times not only about high usage, i have this
message on Mysql Administrator ( Windows ), logged to my Dedicated
Database ( Linux ).
Here is a print of error:
http://img25.imageshack.us/img25/2342/mysqlthreaderror.jpg
Here is a print of putty using 'top' on dedicated server:
hi list,
i am wondering if there is a way to reduce the number of open files.
The database has InnoDB and MyISAM. I have a lot a partitions is that a problem
?
(To many open files causes problems for mysqldump)
running is vanilla 5.1.34
show status like '%open%' ;
Hello,
I would like save text (different languages) in a MySQL-Table and I
don't know, which Collation is the right one for me.
utf8_bin or utf8_general_ci?
OK, in utf8_general_ci I know that the Collation is CASE INTENSIVE but
it isn't a problem. But what is better for
Text in different
Here is the table structure.
CREATE TABLE `UP_UserEx` (
`UserId` INT(11) NOT NULL,
`UserNationality` CHAR(2) NOT NULL DEFAULT '',
`UserProvince` CHAR(2) NOT NULL DEFAULT '',
`UserCity` CHAR(4) NOT NULL DEFAULT '',
`HomePhone` VARCHAR(32) NOT NULL DEFAULT '',
`WorkPhone` VARCHAR(32)
Dear walter Harms,
Thanks for your valuable solution, but in the code which you
provided is printing only one row , if i try to print whole table, or 2, or
3, columns fully means its giving segmentation fault, kindly check the below
code for furthur information.
software used:
Ravi raj schrieb:
Dear walter Harms,
Thanks for your valuable solution, but in the code which
you provided is printing only one row , if i try to print whole table,
or 2, or 3, columns fully means its giving segmentation fault, kindly
check the below code for furthur
Hi All
I am kind of stuck with this query , cant expand my thinking. May this is a
limitation. Here it is
I have a database with many cols two of which are start and end position for
an event.
Now I have a list of event time stamps, I want to find all the info once the
current event time
Hi all
What is the equivalent in unix (more specifically python) to the compress()
function.
I am trying to make csv file for use with load data infile and am wondering
how to compress the strings that I would usually compress with compress() in
a regular sql statement. The field I am writing
aah okie I think I was trying to get too clever. Guess that won't work ...
Thanks,
-Abhi
On Fri, May 8, 2009 at 12:34 PM, Barney Boisvert bboisv...@gmail.comwrote:
You'll have to iterate over your two lists of timestamps and build a
set of ORed conditional pairs:
sql = select ... from ...
why not something like below. Assume you have 3 pairs of start/end
timestamps and you want to find everything within those 3 time periods:
select * from table_name where start = start1 and end = end1
union
select * from table_name where start = start2 and end = end2
union
select * from
Hi Jim
Unfortunately I have thousands of such points. So explicit statement calling
will be very expensive both computationally and in terms of writing..
Thanks,
-Abhi
On Fri, May 8, 2009 at 12:37 PM, Jim Lyons jlyons4...@gmail.com wrote:
why not something like below. Assume you have 3 pairs
Or even better, can I tell load data infile or somewhere in the table
definition to compress whatever is written to the file?
Thanks
Olaf
On 5/8/09 12:29 PM, Olaf Stein olaf.st...@nationwidechildrens.org wrote:
Hi all
What is the equivalent in unix (more specifically python) to the
Abhi,
I might not be understanding the problem but could you use the max
and min timestamp values and use something like
SELECT * FROM TABLE WHERE start BETWEEN max AND min AND end BETWEEN max AND min
or
SELECT * FROM TABLE WHERE START IN (1,2,3,4,5) AND END IN(1,2,3,4,5)
I might be
then either build the statement by way of a program like a perl script or
select all records with a start time after the min start time of all in your
list and an end time less than the max end time in your list then filter
them further either in a program or a store procedure.
On Fri, May 8,
14 matches
Mail list logo
