Hi there,
Attached is my problem report.
Please help.
Thanks,
Tan.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi All,
Has anybody implemented Load Balancing Mysql with Foundry
Load Balancers, I know that the ServerIron series switches dont have a
way to do a Layer 7 health check for mysql, as it is not a default
port profile, any help from who has dome some work on foundry switches
would be grea
On 6/10/05, Andre Matos <[EMAIL PROTECTED]> wrote:
> I am getting slow connections between php4 and MySQL 4.1.9.
>
> There are some connections that are very fast, but others can take from 5 to
> 20 second or more (usually it takes less than 0.1 second to create a new
> connection). I tried to
Hi,
in versions less than 5.x, show table status gives informations about rows and
avg_row_length. The product gives you a correct approximation if the stats are
analyzed. This is for actions from the client.
another thing is the OS commands from your datadir (du -k).
Hope that helps.
Mathias
Hi list,
I am getting slow connections between php4 and MySQL 4.1.9.
There are some connections that are very fast, but others can take from 5 to
20 second or more (usually it takes less than 0.1 second to create a new
connection). I tried to identify if there is a pattern but it seems that i
If you are on 5.0.n there is an INFORMATION_SCHEMA which you can query
like this. A casual scan of the mysql tables don't show any sizes and I
don't know of a way to get table/database size via SQL.
mysql> select table_schema, sum(DATA_LENGTH) from
information_schema.tables group by 1;
+--
Yes, I know it is old & obsolete.
How do I query mysql to determine which hosts would benefit from a
FLUSH HOSTS command?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
More queries yes but not more disk i/o. The first query will never touch
a disk.
[EMAIL PROTECTED] wrote:
Eric Bergen <[EMAIL PROTECTED]> wrote on 06/09/2005 12:56:59 PM:
How about something like this:
mysql> select @t := now();
+-+
| @t := now() |
+
I think the answer to this is "You can't". So I guess what I can do is run a
query once every while and get the sizes of all the databases and if any
exceeds a predetermined size, revoke insert and update privilages.
What's is the SQL query like to get a database size and the SQL to get the
On Fri, 10 Jun 2005, Nico Alberti wrote:
> 2005/6/10, Atle Veka <[EMAIL PROTECTED]>:
> > The speed of the drive will have a lot to say on how long the queries run.
> > You haven't said anything about what type of master you have, OS, mysqld
>
> Thank you all for your answers. As I said before, I w
I think you might be confusing UPDATE and SELECT syntax. As far as I
ever knew, you couldn't specify a limit offset in an update statement.
I don't see in mysql update docs where it indicates offset is allowed.
kgt
David Legault wrote:
Hello,
I'm using the MySQL C API and I got the
Hello,
I'm using the MySQL C API and I got the following error for this query:
UPDATE tracks SET track_state='-2', track_cost='1.50' WHERE
track_flynum='10' AND track_testcase='45' ORDER BY track_step DESC LIMIT 0,1
SQL Error 1064 : You have an error in your SQL syntax; check the manual
Interesting document. The correct link is
http://www.fabalabs.org/research/papers/FabalabsResearchPaper-OSDBMS-Eval.pdf
PB
-
Dan Rossi wrote:
On 10/06/2005, at 8:09 PM, Martijn Tonies wrote:
For those interested, this makes a good read.
http://www.fabalabs.org/resear
Haven't used it in a while, but mytop is handy (think that was the name)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, June 10, 2005 12:09 PM
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: Which users eat cpu on Mysql
Hi,
SHOW PROCESSLI
At 16:47 +0300 10-06-2005, Gleb Paharenko wrote:
Hello.
Check that you have the latest version. There is a bug:
http://bugs.mysql.com/bug.php?id=7040
I downloaded yesterday the latest version of ODBC Connector.
Version:
mysql-max-4.1.8-pc-linux-i686 + MyODBC-3.51.11-2.i586.rpm
(libmy
Hi,
SHOW PROCESSLIST
Peter
Vahric MUHTARYAN wrote:
Hi Everybosy ,
I red user-resources but I could't find any mysql user cpu
usage limitation, instead of this How can I find out Who is sending too much
query and How much cpu and memory eat ?! You know top showing only mysql
pro
On 10/06/2005, at 8:09 PM, Martijn Tonies wrote:
For those interested, this makes a good read.
http://www.fabalabs.org/research/papers/FabalabsResearchPaper-OSDBMS-
Eval.pdf
"The "Institute for Applied Knowledge Processing" (http://www.faw.at)
in cooperation with "Fabalabs Software GmbH"
(
Hi Everybosy ,
I red user-resources but I could't find any mysql user cpu
usage limitation, instead of this How can I find out Who is sending too much
query and How much cpu and memory eat ?! You know top showing only mysql
process average but I want to learn inside of this process
If you're concerned about subtle data type differences you can also
run one "show create table myMergeTable"
statement for each source table and diff them.
Ed
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Sent: Friday, June 10, 2005 8:35 AM
To: mySQL list
Subject: Re: MERGE T
From: "Sebastian"
> i have a table with several thousand records. i want to know if adding
> an index will improve things, example:
>
> -
> | id | item | text | runtime | dateline
> -
>
> now say i create this query:
>
> $stats
Hello.
This is a good start point:
http://dev.mysql.com/doc/mysql/en/mysql-optimization.html
Sebastian <[EMAIL PROTECTED]> wrote:
> i have a table with several thousand records. i want to know if adding
> an index will improve things, example:
>
> --
Hello.
Check that you have the latest version. There is a bug:
http://bugs.mysql.com/bug.php?id=7040
Santino <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I have a segmentation fault using MySql with PHP/ODBC on Linux.
>
> I do a query with exec and I get a segmentation fault in "my_
Hello.
Here are some notes:
http://bugs.mysql.com/bug.php?id=9678
http://bugs.mysql.com/bug.php?id=4143
Ganesh <[EMAIL PROTECTED]> wrote:
> Hai
>
> Here is my Query.
>
> When the LAN goes down the client mysql
> process does not give any exce
Hello.
Similar questions are often asked on the list, but I don't remember
any solution for old versions.
"michael watson (IAH-C)" <[EMAIL PROTECTED]> wrote:
> Hi
>
> The subject says it all! My mysqlimport command reports 43 warnings,
> but I have no idea how to access them. "SHO
At 09:00 AM 6/10/2005, you wrote:
Hello everyone,
We're going to be using the "MERGE TABLE" option of Mysql when we
build our Data Warehouse. Basically (for you Oracle folks), we're going
to mimic PARTITIONS. My question is this: Other than dumping syntax
through a utility and comparing te
Sebastian wrote:
i have a table with several thousand records. i want to know if adding
an index will improve things, example:
-
| id | item | text | runtime | dateline
-
now say i create this query:
$stats = mysql_query(
Hello everyone,
We're going to be using the "MERGE TABLE" option of Mysql when we build our
Data Warehouse. Basically (for you Oracle folks), we're going to mimic
PARTITIONS. My question is this: Other than dumping syntax through a utility
and comparing text, is there any way I can read the
Hi
The subject says it all! My mysqlimport command reports 43 warnings,
but I have no idea how to access them. "SHOW WARNINGS" was only
implemented after MySQL version 4.1, and I have 4.0.15-standard-log.
Any help?
Many thanks
Mick
--
MySQL General Mailing List
For list archives: http://lists
i have a table with several thousand records. i want to know if adding
an index will improve things, example:
-
| id | item | text | runtime | dateline
-
now say i create this query:
$stats = mysql_query("
SELECT COUNT(*)
For those interested, this makes a good read.
http://www.fabalabs.org/research/papers/FabalabsResearchPaper-OSDBMS-Eval.pdf
"The "Institute for Applied Knowledge Processing" (http://www.faw.at)
> in cooperation with "Fabalabs Software GmbH"
> (http://www.fabalabs.org) have made a new Open Source
Hai
Here is my Query.
When the LAN goes down the client mysql
process does not give any exception.Instead of that
it hangs for Long time in UNIX.But in windows it
raise exception immediately.How to configure in Linux
or Unix to behave as like in windows.
Please re
Eric Bergen wrote:
How about something like this:
mysql> select @t := now();
+-+
| @t := now() |
+-+
| 2005-06-09 09:55:49 |
+-+
1 row in set (0.00 sec)
if the timestamp is not needed on the client with :
mysql> do @t := now(
2005/6/10, Atle Veka <[EMAIL PROTECTED]>:
> The speed of the drive will have a lot to say on how long the queries run.
> You haven't said anything about what type of master you have, OS, mysqld
Thank you all for your answers. As I said before, I was only curious,
as fortunately I don't have to rel
33 matches
Mail list logo
