As Ananda mentioned, key_buffer is used for myisam. However I don't
think that's the reason. :-) Maybe mysql5.0 is the reason, or any
other system limitation?
On 7/25/08, Dominik Klein <[EMAIL PROTECTED]> wrote:
> Unfortunately, right now I can't.
>
> Someone mentioned getting rid of myisam config
Unfortunately, right now I can't.
Someone mentioned getting rid of myisam configuration values might help.
Which ones would that be?
Regards
Dominik
Xuekun Hu wrote:
I can alloc 14GB to innodb_buffer_pool_size, even 15GB on my 16GB
system. However I used mysql6.0, not mysql5.0. Maybe you can
I can alloc 14GB to innodb_buffer_pool_size, even 15GB on my 16GB
system. However I used mysql6.0, not mysql5.0. Maybe you can try newer
mysql version.
Thx, Xuekun
On 7/24/08, Ananda Kumar <[EMAIL PROTECTED]> wrote:
> Hi,
> U can use max of 80% of your Memory to Mysql, as OS needs the remaning.
>
Now mysql's version is 5.0.45
Any reply is appreciated.
--
I'm a MySQL DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn
Hi.
There are 1 store procedures in my database,and prepared statement was
used within procedure's definition.
But when our concurrency is higher,mysqld's memory grows very fast.
PS:I have explicitly used drop prepare .. statement in procedure's
definition.
Anybody can tell me why this happen
I had created a Memory table by joining 3 tables together. For some reason
it was giving me only 25% of the rows that I should have been getting and
there were no errors (I checked the error log). So I was missing a few
thousand rows from the memory table. I switched the table to MyISAM and got
Yes and No !!!
I say no because temp table are visible neither in the INFORMATION_SCHEMA nor
in "SHOW TABLES".
I say yes because you can do "show create table \G" or "describe
;" to a temp table even if you cannot see it.
So the answer is YES !!!
-Original Message-
From: Jay Blanchard
I am not finding a quick reference to this, but I wanted to DESCIBE a
TEMPORARY TABLE so that I can make sure the index was properly applied.
Can this not be done?
TIA!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL P
On Thu, Jul 24, 2008 at 1:17 AM, Sivasakthi <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> how to Get file modified time and date of file by using builtin function or
> procedure in sql?
In a related thread from earlier today you were advised that any
interaction with the filesystem should be done via a
Peter Brawley wrote:
>> to get the latest value for each id i have queries like:
>
>> select * from tab A where timestamp = (select max(timestamp) from tab
>> B where B.id=A.id) group by id ;
>
> See "Within-group aggregates" at
> http://www.artfulsoftware.com/infotree/queries.php.
>
> PB
>
Sivasakthi wrote:
Ananda Kumar wrote:
which file are u talking about.
regards
anandkl
Ordinary temp file.. say example in C:\output.txt
Actually i have given that file as input to some procedure, based on
that modification time we have calculate some details.
It sounds like you are usi
to get the latest value for each id i have queries like:
select * from tab A where timestamp = (select max(timestamp) from tab B where
B.id=A.id) group by id ;
See "Within-group aggregates" at
http://www.artfulsoftware.com/infotree/queries.php.
PB
walter harms wrote:
hi list,
i have tab
>how to Get file modified time and date of file by using builtin
function or procedure in sql?
On Codd's rules, it oughtn't to be possible---it'd be a backdoor. If
there is a need to know the datetime of the last mod to a table, that
info ought to be in a column in a table.
PB
--
MySQL Gene
>-Original Message-
>From: Pedro [mailto:[EMAIL PROTECTED]
>Sent: Wednesday, July 23, 2008 6:48 PM
>To: Dan Nelson
>Cc: mysql@lists.mysql.com
>Subject: Re: Log
>
>I need to pass the user of my application pro bank.
>I want to log the user's application and value of new fields or fields
>upd
On Thu, 2008-07-24 at 14:49 +0200, walter harms wrote:
> hi list,
> i have tables that look like this( <10.000 entries) :
>
> id,
> timestamp,
> value
>
>
> to get the latest value for each id i have queries like:
>
> select * from tab A where timestamp = (select max(timestamp) from tab B where
Hi
If you're searching for, effectively, %123% you probably can't use IN(). You
could get away with wildcard patterns - if it's a heavily used field
consider an index to increase performance. Hard to tell if this may be a FK
of sorts, but if so you should use it as one which may involve normalisin
hi list,
i have tables that look like this( <10.000 entries) :
id,
timestamp,
value
to get the latest value for each id i have queries like:
select * from tab A where timestamp = (select max(timestamp) from tab B where
B.id=A.id) group by id ;
on a fast system it takes round 4 sec to complet,
I accept that.. but my requirement is , I have some no of Excel files..I
just need to check the modified time of the files ,if it is modified
currently then I need to open those files and convert the excel data to
database.. otherwise i didnt change anything in my database..
how can i going
Martijn Tonies wrote:
Hey,
How do I get the file names from a certain directory in SQL?
It seems to me that you're trying to do things that are beyong SQL
really. SQL is about the database, not about a file system.
Yes, by creating a DBMS that allows you to write functions that
inte
On Thu, 2008-07-24 at 17:36 +0530, Sivasakthi wrote:
> Hi all,
>
> How do I get the file names from a certain directory in SQL?
SQL is designed to deal with RDBs, not the rest of the computer system.
I suggest you switch to a modern language such as Perl, Python, Ruby, or
even PHP. Each has a g
If windows u can use
dir
Volume in drive C has no label.
Volume Serial Number is 9822-5D20
Directory of C:\
07/26/2005 02:26 AM 1,442 archival_s.pls
1 File(s) 1,442 bytes
0 Dir(s) 5,230,874,624 bytes free
in unix
ls -ltr
ls -ltr abc.
Hey,
> How do I get the file names from a certain directory in SQL?
It seems to me that you're trying to do things that are beyong SQL
really. SQL is about the database, not about a file system.
Yes, by creating a DBMS that allows you to write functions that
interact with the file system, you c
On Thu, 2008-07-24 at 09:34 +0530, Sivasakthi wrote:
> How can we normalize the tables? could you explain bit more?
>
>
> Thanks,
> Siva
>
>
Normalization is a complex subject. I suggest you search the web for
tutorials. Try the search terms: RDBM normalization
--
Just my 0.0002 milli
Hi all,
How do I get the file names from a certain directory in SQL?
Thanks,
Siva
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Ananda Kumar wrote:
you can do that using OS command, any specific reason u want to use
stored proc to get this information.
OS Command? could you explain with examples? because, I have more # of
input files.. thats why iam going to procedure..
--
MySQL General Mailing List
For list archives
Hi,
U can use max of 80% of your Memory to Mysql, as OS needs the remaning.
Also you can exclude Myisam parameter like key_buffer, as this i only
INNODB.
On 7/24/08, Dominik Klein <[EMAIL PROTECTED]> wrote:
>
> Hi
>
> I installed a 64bit Linux and compiled and installed 5.0.51b. This is to be
> a
you can do that using OS command, any specific reason u want to use stored
proc to get this information.
On 7/24/08, Sivasakthi <[EMAIL PROTECTED]> wrote:
>
> Ananda Kumar wrote:
>
>> which file are u talking about.
>> regards
>> anandkl
>>
>>
> Ordinary temp file.. say example in C:\output.txt
>
Hi
I installed a 64bit Linux and compiled and installed 5.0.51b. This is to
be an innodb only system.
The machine has 16 GB of memory and I can see all of that with "free".
Except for mysql, there is nothing running on that system.
free -m
total used free shared
Ananda Kumar wrote:
which file are u talking about.
regards
anandkl
Ordinary temp file.. say example in C:\output.txt
Actually i have given that file as input to some procedure, based on
that modification time we have calculate some details.
--
MySQL General Mailing List
For list archiv
which file are u talking about.
regards
anandkl
On 7/24/08, Sivasakthi <[EMAIL PROTECTED]> wrote:
>
> Hi All,
>
> how to Get file modified time and date of file by using builtin function or
> procedure in sql?
>
>
> Thanks,
> Siva
>
>
> --
> MySQL General Mailing List
> For list archives: http:/
Hi All,
how to Get file modified time and date of file by using builtin function or
procedure in sql?
Thanks,
Siva
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
31 matches
Mail list logo
