Dear Sir,
The status of mysql:
mysqlshow status;
+---+--+
| Variable_name | Value|
+---+--+
| Aborted_clients | 0|
| Aborted_connects | 0|
|
I will explain my problem in spanish and english.
Se deben Presentar los consumos por 24 horas de energia para su ingreso. Si
el usuario ha digitado 10 registros, se deben presentar estos mas los otros
14 correspondientes desde la hora 11 hasta la 24 con los consumos en cero.
Siempre un conjunto
Hi,
One of the databases I use just switched to using merge tables and now
my queries are painfully slow. One table, initially had about 2.5
million records and now with the change this information is spread
across about 1600 tables. A simple query, say select count(*) has gone
from .04 to about
Paul,
One of the databases I use just switched to using merge tables and now
my queries are painfully slow. One table, initially had about 2.5
million records and now with the change this information is spread
across about 1600 tables. A simple query, say select count(*) has gone
from .04 to
I guess u had 2.5 million records splited into 1600 tables if iam not wrong :)
Why you split the tables to 1600 is there any specific count ?
Why you moved to merge table reason behind ?
Since 2.5 million records to 1600 is a huge count on nos of tables :( instead
of one ;)
--Praj
On
Hello Paul,
I suggest you reply to the mailinglist :-) ...
The developer insists that for scalability issues, this was the
answer. It is likely, for example in my deployment, that these tables
would see upwards of 10 million records or more.
Well, if there are problems with scalability, I
Hi
Iam not sure about the answer correct me if iam wrong :(
Dont use single quotes in count_of_logons ..
Try : $sql = UPDATE members
SET count_of_logons = count_of_logons + 1
WHERE logon_id = '$logonid'
AND logon_pw= '$logonpw'
AND
Hi
Trying to dump a complete db where 1 of the tables contains about 88
million rows - When the dump runs on the command line the following
error is thrown
mysqldump: Out of memory (Needed 3543176 bytes)
mysqldump: Got error: 2008: MySQL client run out of memory when
retrieving data from
Hi Tom,
Use -q option on mysqldump ;)
-q Won't buffer query, It will dump directly to stdout.
--Praj
On Tue, 14 Mar 2006 11:56:42 +
Tom Brown [EMAIL PROTECTED] wrote:
Hi
Trying to dump a complete db where 1 of the tables contains about 88
million rows - When the dump runs on the
Hi Tom,
Are you using the --quick option?
--quick, -q
This option is useful for dumping large tables. It forces mysqldump to
retrieve rows for a table from the server a row at a time rather than
retrieving the entire row set and buffering it in memory before writing
it out.
From the manual at
Martijn Tonies [EMAIL PROTECTED] wrote on 14/03/2006 11:32:10:
Hello Paul,
I suggest you reply to the mailinglist :-) ...
The developer insists that for scalability issues, this was the
answer. It is likely, for example in my deployment, that these tables
would see upwards of 10
On 3/14/06, Martijn Tonies [EMAIL PROTECTED] wrote:
Hello Paul,
I suggest you reply to the mailinglist :-) ...
The developer insists that for scalability issues, this was the
answer. It is likely, for example in my deployment, that these tables
would see upwards of 10 million records or
The developer insists that for scalability issues, this was the
answer. It is likely, for example in my deployment, that these tables
would see upwards of 10 million records or more.
Well, if there are problems with scalability, I guess you could
split it up in a few (not 1600)
Paul Halliday [EMAIL PROTECTED] wrote on 14/03/2006 12:09:10:
As an example:
There was a table called event.
This table is now broken up like this:
event _sensor_date.
So for every sensor, and every day, there is now a new table. So if I
have 20 sensors, every day I will have 20
[EMAIL PROTECTED] wrote:
Paul Halliday [EMAIL PROTECTED] wrote on 14/03/2006 12:09:10:
As an example:
There was a table called event.
This table is now broken up like this:
event _sensor_date.
So for every sensor, and every day, there is now a new table. So if I
have 20 sensors, every
Are you using the --quick option?
--quick, -q
This option is useful for dumping large tables. It forces mysqldump to
retrieve rows for a table from the server a row at a time rather than
retrieving the entire row set and buffering it in memory before writing
it out.
thanks both - that did
nigel wood [EMAIL PROTECTED] wrote on 14/03/2006 13:09:08:
[EMAIL PROTECTED] wrote:
Paul Halliday [EMAIL PROTECTED] wrote on 14/03/2006 12:09:10:
As an example:
There was a table called event.
This table is now broken up like this:
event _sensor_date.
So for every
Is anyone running mySQL on Windows 2003 server platform. Are there any
known problems ?
Cheers
Neil
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[snip]
Is anyone running mySQL on Windows 2003 server platform. Are there any
known problems ?
{/snip]
The operating system? Yuck yuck! :)
It ran fine for me on 2k3 before I cam back to a *nix shop
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Is there a way to recreate the mysqld.sock file, it has gone missing from
:/var/run/mysqld . Now MySQL will not run.
Thanks
Jon L. Miller, ASE, CNS, CLS, MCNE, CCNA
Director/Sr Systems Consultant
MMT Networks Pty Ltd
http://www.mmtnetworks.com.au
Resellers for: Novell Gold Partner, Cisco
Hi Neil,
Neil Tompkins wrote:
Is anyone running mySQL on Windows 2003 server platform. Are there
any known problems ?
There is a known bug for Windows 2003 - bug #12071:
http://bugs.mysql.com/bug.php?id=12071
You should use 4.0.19 or 5.0.19.
Best regards
Mark
--
Mark Leith, Support
ElkinFernando Ortiz [EMAIL PROTECTED] wrote on 03/10/2006 12:26:57
AM:
I will explain my problem in spanish and english.
Se deben Presentar los consumos por 24 horas de energia para su ingreso.
Si
el usuario ha digitado 10 registros, se deben presentar estos mas los
otros
14
did u try restarting mysqld
Kishore Jalleda
On 3/14/06, Jon Miller [EMAIL PROTECTED] wrote:
Is there a way to recreate the mysqld.sock file, it has gone missing from
:/var/run/mysqld . Now MySQL will not run.
Thanks
Jon L. Miller, ASE, CNS, CLS, MCNE, CCNA
Director/Sr Systems
Hi,
I am having character set problems while trying to migrate my data
from a server running 4.0.25-standard to a server running 4.1.16. I
believe that the orginal database was using the latin1 character set
(not sure, is there any way to tell? show full column doesn't seem to
be
ElkinFernando Ortiz wrote:
How i calculate for union the other 14
register in the same Query?
...
SELECT e.Plant,e.Date,e.Hour,e.Consuption From Energy Where
e.Plant=Var_Plant AND e.Date=Var_Date GROUP BY e.Plant,e.Date,e.H
By having an hours table (hour tinyint) which you join to your energy
I'm a total newbie working through the tutorial in DuBois's _MySQL_.
I've got MySQL running on my PowerBook. In Terminal, I can use the
mysql client to get responses to things like SELECT NOW(). But the
command CREATE DATABASE sampdb; results in the following error.
ERROR 1044 (42000):
You need to set GRANTs to create on the host.
http://dev.mysql.com/doc/refman/5.0/en/grant.html
-Original Message-
From: Doug Pinkerton [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 14, 2006 1:26 PM
To: mysql@lists.mysql.com
Subject: Permissions block database creation
I'm a total
User ''@'localhost' just hasn't enough privileges to create databases.
http://dev.mysql.com/doc/refman/5.0/en/privilege-system.html
Doug Pinkerton wrote:
I'm a total newbie working through the tutorial in DuBois's _MySQL_.
I've got MySQL running on my PowerBook. In Terminal, I can use the
So did I Jim, on SuSE 9.2 pro.
So I downloaded the windows versions to my laptop instead.
Keith
In theory, theory and practice are the same;
In practice they are not.
On Tue, 14 Mar 2006, Jim Douglas wrote:
To: [EMAIL PROTECTED]
From: Jim Douglas [EMAIL PROTECTED]
Subject: Re: E/R Tool
Hi, Jon.
mysqld.sock is a unix socket. mysqld creates it while starting and
removes it when you stop the server.
Jon Miller wrote:
Is there a way to recreate the mysqld.sock file, it has gone missing from
:/var/run/mysqld . Now MySQL will not run.
Thanks
Jon L. Miller, ASE, CNS, CLS,
I am designing a simple accountability system so all the partners can have
direct access to it by intranet.
I was designing the data model, and came up with this:
CREATE TABLE `moviments` (
`moviment_id` int(20) NOT NULL auto_increment,
`moviment_date` date NOT NULL default '-00-00',
Further, your reporting will skew the data -- let's say once a day you
want to know the last time that row was read. Well, the first day,
you'll get accurate numbers. The second day, though, you'll end up
seeing that each row was read at latest the day before, because you
read it searching for
Hello Bruno,
I am designing a simple accountability system so all the partners can have
direct access to it by intranet.
I was designing the data model, and came up with this:
CREATE TABLE `moviments` (
`moviment_id` int(20) NOT NULL auto_increment,
`moviment_date` date NOT NULL
Hi Martijn,
well about the date default value being invalid, well it´s working here in
my system (MySQL 4.1.16, Mac OS X 10.4.5), and all my systens work with
this...
About the business logic I was thinking about showing the current month by
default, and if the user wants he can select diferent
Bruno B B Magalháes [EMAIL PROTECTED] wrote on 03/14/2006 12:41:35
PM:
I am designing a simple accountability system so all the partners can
have
direct access to it by intranet.
I was designing the data model, and came up with this:
CREATE TABLE `moviments` (
`moviment_id` int(20)
Hello Bruno,
well about the date default value being invalid, well it´s working here in
my system (MySQL 4.1.16, Mac OS X 10.4.5), and all my systens work with
this...
Yes, it's a valid value in MySQL, but it's an invalid date,
that's what I'm trying to say. Why have an invalid date
as the
Martijn Tonies [EMAIL PROTECTED] wrote on 03/14/2006 01:16:11 PM:
Hello Bruno,
well about the date default value being invalid, well it´s working
here in
my system (MySQL 4.1.16, Mac OS X 10.4.5), and all my systens work
with
this...
Yes, it's a valid value in MySQL, but it's an
Should you have a flag for the status movement complete ? I would say
yes but instead of a simple checkbox, you could store a date value. That
gives you two pieces of information
a) if the date is null then the movement is not complete.
b) if the date is NOT null then the movement is complete and
- Original Message -
From: Bruno B B Magalháes [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, March 14, 2006 12:41 PM
Subject: Accountability with MySQL
I am designing a simple accountability system so all the partners can have
direct access to it by intranet.
I was
I use Tomcat 5.0.28 on both Fedora and FreeBSD, MySQL 4.1.14,
J/Connector JDBC driver for MySQL 3.1.11 and JOTM 2.0.10. From time to
time I get the MySQL JDBC driver exception No operations allowed after
connection closed, after which DB calls from my application keep
failing. The stack trace
Hello Shawn,
well about the date default value being invalid, well it´s working here
in
my system (MySQL 4.1.16, Mac OS X 10.4.5), and all my systens work with
this...
Yes, it's a valid value in MySQL, but it's an invalid date,
that's what I'm trying to say. Why have an invalid date
as
- Original Message -
From: Martijn Tonies [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, March 14, 2006 1:16 PM
Subject: Re: Accountability with MySQL
Hello Bruno,
well about the date default value being invalid, well it´s working here
in
my system (MySQL 4.1.16, Mac
Apart from this are there any other known issues. When trialing mySQL on my
XP machine, I noticed all the tables were created in lower case ? Is this
normal ?
Cheers
Neil
From: Mark Leith [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Neil Tompkins [EMAIL PROTECTED]
CC:
- Original Message -
From: Martijn Tonies [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, March 14, 2006 1:28 PM
Subject: Re: Accountability with MySQL
Should you have a flag for the status movement complete ? I would say
yes but instead of a simple checkbox, you could
On 3/10/06, Jake Peavy [EMAIL PROTECTED] wrote:
On 3/7/06, C.R.Vegelin [EMAIL PROTECTED] wrote:
Hi Ariel,
Maybe this example helps you to create CSV output from MySQL.
The first SELECT generates the headerline; the second the data.
( SELECT 'FieldA','FieldB','FieldC', ... )
UNION
Neil Tompkins [EMAIL PROTECTED] wrote on 03/14/2006 01:42:32
PM:
Apart from this are there any other known issues. When trialing mySQL
on my
XP machine, I noticed all the tables were created in lower case ? Is
this
normal ?
Cheers
Neil
From: Mark Leith [EMAIL PROTECTED]
Jake Peavy [EMAIL PROTECTED] wrote on 03/14/2006 01:52:28 PM:
On 3/10/06, Jake Peavy [EMAIL PROTECTED] wrote:
On 3/7/06, C.R.Vegelin [EMAIL PROTECTED] wrote:
Hi Ariel,
Maybe this example helps you to create CSV output from MySQL.
The first SELECT generates the headerline; the
I am designing a simple accountability system so all the partners can
have
direct access to it by intranet.
I was designing the data model, and came up with this:
CREATE TABLE `moviments` (
`moviment_id` int(20) NOT NULL auto_increment,
`moviment_date` date NOT NULL default
Should you have a flag for the status movement complete ? I would say
yes but instead of a simple checkbox, you could store a date value. That
gives you two pieces of information
a) if the date is null then the movement is not complete.
b) if the date is NOT null then the movement is
On 3/14/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Jake Peavy [EMAIL PROTECTED] wrote on 03/14/2006 01:52:28 PM:
On 3/10/06, Jake Peavy [EMAIL PROTECTED] wrote:
On 3/7/06, C.R.Vegelin [EMAIL PROTECTED] wrote:
Hi Ariel,
Maybe this example helps you to create CSV
Hi,
I have figured out a way to get this to work. I am just posting what
I did in case anyone else stumbles across my original message. I am
sure there are other ways to get this to work, but this is the way
that worked for me:
###
# My
Sara Woglom wrote:
Thanks Shawn!!
You should be thanking Mladen Adamovic for pointing you to:
http://dev.mysql.com/doc/mysql/en/grant.html
This page holds your answer. From the error message you got
Telnet to port 3306: Host 'my-machine-name' is not allowed to connect to
this MySQL
Guys.
I just started having a problem, Im running
mysql-standard-4.1.12-pc-linux-gnu-i686 binaries under Fedora Core 3 and Ive
been having problem where during some parts of the day, /tmp/mysql.oskc goes
away, I can still see mysql running when I do a ps ax but when I try to
connect to it, it
Do you have any cron jobs that clear the /tmp directory during the day?
Regards
---
** _/ ** David Logan
*** _/ *** ITO Delivery Specialist - Database
*_/*
Have to develop form with over 100 input fields plus 40 different
drop downs. Seeking advice on technique to use. Thinking about
single form where user has to use the power bar to move deeper into
the form. This has benefit that every thing is written to the
database at one time, but the draw back
Both methods are commonly used.
Another method used is to have multiple pages like you've mentioned
but save all the data into a session (of just pass it from page to
page) until all 3 pages are complete and then write all the data at
once
The question to ask yourself is, do you want just
[EMAIL PROTECTED] wrote:
Yes, a ranged query should respond faster than a negation. In some cases
you can seriously improve query performance for a negation query if you
split it into two range queries unioned together. Here is a pseudo
example:
This query should be slow due to the table
Not wanting to be rude but this question would probably be answered
better in a php group. I realise there are many users of php that
subscribe to this list, but this is a mysql list not php.
If you go to http://www.php.net/support.php you will find a large number
of resources (including
No crons that would delete the tmp directory.. In fact, all the other files
stay there... Just mysql.sock goes away...
|-Original Message-
|From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED]
|Sent: Tuesday, March 14, 2006 3:15 PM
|To: Anton Krall; mysql@lists.mysql.com
On Tuesday 14 March 2006 22:24, fbsd_user wrote:
Have to develop form with over 100 input fields plus 40 different
drop downs. Seeking advice on technique to use. Thinking about
single form where user has to use the power bar to move deeper into
the form. This has benefit that every thing is
I understand the save the page form data into the session. But I
don't know what you mean by just pass it from page to page. Would
that mean having all the fields in regular form fields to accept the
entered data and also hidden corresponding fields to hide page 1
data in as page 2 is entered and
Well not wanting to be rude back. But the question is dealing with
how best to control the writing of data to mysql. No where do I say
anything about using php. I could be using perl for all you know.
But I respect your right to state your thoughts, but just don't
agree with it. I think this is a
Hello List,
I am restoring a MySQL backup (about 40MB), and its taking well over 2 hours
to restore.
the area where its really hanging is when its importing the BLOB
There are about 1200 records, totaling about 10mb in size for these blobs.
I am running MyISAM, my current memory settings read:
At 4:24 pm -0500 14/3/06, fbsd_user wrote:
user has to use the power bar to move deeper into the form
Out of curiosity, what's the power bar?
From a db perspective one single insert is preferable, IMO. Firstly you don't
have to declare as NULL required fields that will be entered in the second,
- Original Message -
From: Bruno B B Magalháes [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, March 14, 2006 2:07 PM
Subject: Re: Accountability with MySQL
I am designing a simple accountability system so all the partners can
have
direct access to it by intranet.
I
- Original Message -
From: Martijn Tonies [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Tuesday, March 14, 2006 2:16 PM
Subject: Re: Accountability with MySQL
Should you have a flag for the status movement complete ? I would
say
yes but instead of a
At 7:48 pm -0500 14/3/06, Rhino wrote:
Ah, so now things become clear, a NULL actually can mean
two things? So much for clarity then...
Come on; that's not fair. Unknown and not applicable are more like
different senses of the same thing, not two opposite things.
IIRC (but please don't ask for
Hello,everyone!
My table has a bigint column which needs store 8bytes integer.
I looked up in Mysql Menual. It seems that , if I use C API I can only use
preapared statement functions to insert bigint values.
I can not use mysql_real_query or mysql_query to insert bigint values because I
do
In the last episode (Mar 15), said:
Hello,everyone!
My table has a bigint column which needs store 8bytes integer.
I looked up in Mysql Menual. It seems that , if I use C API I can
only use preapared statement functions to insert bigint values.
I can not use mysql_real_query or
At 7:48 pm -0500 14/3/06, Rhino wrote:
Ah, so now things become clear, a NULL actually can mean
two things? So much for clarity then...
Come on; that's not fair. Unknown and not applicable are more like
different senses of the same thing, not two opposite things.
IIRC (but please don't
Basics of database design: store what you know.
Given that NULLs basically means the absence of a value
(eg: unknown), you shouldn't be storing NULLs.
Nonsense!!
That's a bold statement ...
That's simply wrong. A null means unknown or not applicable and is a
Ah, so now
71 matches
Mail list logo