Hi all,
I've a server where between 1-2 there comes a high load from less than
1k queries there's a jump to 60+k queries. It all started after adding
more RAM to the server.
Anyone seen this before ?
Regards,
Toke Herkild
--
MySQL General Mailing List
For list archives: http://lists.mysql.c
Everyone,
So I have never seen this before. I set up a database yesterday. I added a user
today in the normal manner..
ie
grant usage on *.* to 'username'@'%' identified by 'password';
Here is the thing. You exit the console and try to log in with mysql -u
username -ppassword and it won't
Brent,
I tried this and it definitely boosted performance. On a test query
that would take 2+ seconds to run with 20 id's - it ran in 0.002
seconds.
Thanks everyone for your help and comments.
Erik
On Sep 21, 2007, at 2:01 PM, Brent Baisley wrote:
As others have mentioned, mysql doesn't
On Wed, 2007-09-26 at 10:55 -0400, Jerry Schwartz wrote:
> I don't know Linux that well, but I know that HP-UX lets you do most
> anything to an open file, including deleting it. The file will continue to
> exist as long as it is open by at least one process. If I remember
> correctly, this is all
> Oracle provides a stored procedure called DBMS_OUTPUT which primarily is
> used to write/print/display text string to StandardOut (a.k.a. the
> terminal).
> In V5 MYSQL is there a functional equivalent? If so, what is it called.
No, there isn't.
> I am willing to RTFM if somebody provides me
si cumple con la restricción en caso contrario debe de ser cero. Espero
me puedan dar luces por favor les doy las gracias por todo
Atentamente,
Ing. Marcelo Rodriguez S.
Jefe de Mejoras Continuas
Costos
__ Información de NOD32, revisión 2551 (20070926) __
Este mensaje h
Is this for debugging purposes?
Olaf
On 9/26/07 12:37 PM, "sol beach" <[EMAIL PROTECTED]> wrote:
> Oracle provides a stored procedure called DBMS_OUTPUT which primarily is
> used to write/print/display text string to StandardOut (a.k.a. the
> terminal).
> In V5 MYSQL is there a functional equiv
Hi Adhiraj,
I am going to assume that the keys and values are not static. If they
are, then this is just a matter of parsing XML into key, value
combinations.
A simple, but often less than ideal way of solving a problem like this
is to use several tables:
# The entries table is the equivilant of
Oracle provides a stored procedure called DBMS_OUTPUT which primarily is
used to write/print/display text string to StandardOut (a.k.a. the
terminal).
In V5 MYSQL is there a functional equivalent? If so, what is it called.
I am willing to RTFM if somebody provides me a clue as to which manual
conta
Hi All,
I'm trying to get Crystal Reports to connect to a MySQL server.
Windows 2003 Server R2 x64
Crystal Reports XI Professional
Disabled DEP for crw32.exe
mysql-connector-odbc-noinstall-3.51.20-winx64.zip
FreeBSD 6.2-RELEASE-p7 x64
mysql-client-5.0.45
mysql-scripts-5.0.45
mysql
Hi,
Manuel Vacelet wrote:
Hi all,
I have a list of values I get from my application and I want to
generate a record set based on this list (for an INSERT INTO ...
SELECT).
Today I have sth like:
SELECT 54, item.item_id, mdv.valueInt
FROM item i, metadata_value mdv
WHERE mdv.item_id = 20202
AN
I don't know Linux that well, but I know that HP-UX lets you do most
anything to an open file, including deleting it. The file will continue to
exist as long as it is open by at least one process. If I remember
correctly, this is all about the inode use count vs. the directory entry, or
something l
Hi all,
I have a list of values I get from my application and I want to
generate a record set based on this list (for an INSERT INTO ...
SELECT).
Today I have sth like:
SELECT 54, item.item_id, mdv.valueInt
FROM item i, metadata_value mdv
WHERE mdv.item_id = 20202
AND mdv.field_id = 54
AND i.ite
> Hi Baron,
> If the database is huge, the restoring from mysqldump would take lot of
> time.
> Is there any other alternative.
Well, not deleting the InnoDB files would be a good start.
The files were deleted, what do you expect?? Just continue running and
hoping no-one finds out?
Re-creatin
I cannot think of any safe alternative. Trying to recover files that
are in memory strikes me as very unwise with InnoDB.
Ananda Kumar wrote:
Hi Baron,
If the database is huge, the restoring from mysqldump would take lot of
time.
Is there any other alternative.
egards
anandkl
On 9/26/07, Ba
Hi Baron,
If the database is huge, the restoring from mysqldump would take lot of
time.
Is there any other alternative.
egards
anandkl
On 9/26/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
>
> >> How do I recover them, and do you think this is wise? At this point, I
> >> still think it might be
In MySQL 5.1.20 (the version we're actually testing=) a sql-statement longer
than 1024 byte is cut in the general_log.csv and in the "old" Logfile so it
seems to be incomplete. Execution and replication of the statement is working
right but I don't think it's a feature though it's really irritat
How do I recover them, and do you think this is wise? At this point, I
still think it might be a better idea to do a complete reinstall /
restore / transaction log run.
There's no need to reinstall :-) It's not MS Windows, it's just InnoDB.
As others have said, I'd try to do a global LOCK TAB
Hi All,
I wanted to know the possible ways in which an xml document can be stored in
the mysql database. So the keys in an xml are the columns in the database
and the key values in xml go as the values for columns. I dont want to use
java if thats possible.
Thanks in advance,
Adhiraj Joshi.
19 matches
Mail list logo
