At 5:46am -0400 on Wed, 17 Sep 2008, Jeffrey Santos wrote:
I'm developing an application
that will require information from various sources. Since what
might be considered required information about those sources will
vary (occasionally dramatically), I'm unsure as to the correct
design
At 2:11pm -0400 on Tue, 26 Aug 2008, John Smith wrote:
So how bad is this? The mentioned query will be the query which is used
the most in my application (yes, it is going to be a forum).
Should I break normalization and save the date of the root in each node row?
My recommendation is no.
At 12:42p -0400 on Sat, 26 Jul 2008, mos wrote:
At 09:14 AM 7/26/2008, you wrote:
The reproducible part is very important, because without it, it's
suspect to be just your individual case, as with a bug in *your*
application code, your hardware, or generally something in your setup.
Well, I
At 5:52p -0400 on Fri, 25 Jul 2008, mos wrote:
[Adding index to memory table silently loses data]
First thing, what version are you using?
Second thing, although it would still be broken, did you read the MySQL
docs to make sure that the Memory table type supports the index *type*
you attempted
At 1:43p -0400 on Wed, 21 May 2008, bruce wrote:
The basic goal of the project is to be able to track the sites that I'm
visiting via a Firefox extension. I want to be able to implement something
like the breadcrumbs extension, but I want to be able to go a lot further.
If this is for a
At 2:49a -0400 on Fri, 16 May 2008, Ananda Kumar wrote:
it goes without saying
Eh, not to those who don't know. Hence the list and question. :-D
Krishna, the short answer is that it depends on your data, and the
queries against it that you run. Test/benchmark on your own DB and data
to see
At 5:32a -0400 on Fri, 16 May 2008, Ananda Kumar wrote:
2 Index would do range scan, which would be comparitivly slower.
Not exactly. This, again, depends on implementation and the
data against which queries are run. An index is an index.
Remember, a primary key is implemented by the MySQL
At 12:23a -0500 on Sat, 08 Mar 2008, obed wrote:
Use \ to escape.
mysql insert into table1 values ('algo\,otra');
As an aside, I'm curious why the parser doesn't understand that the
comma is part of the string in this context? It's already between two
single quotes ... ? Shouldn't that be
At 11:44a -0500 on 18 Jan 2008, Alex K wrote:
To summarize one table vs. many tables with one to one relations?
As per usual, it depends on your needs. For most flexibility, and to
give the DB the best chance to give the best plan for the possible
requests I might make in the future, I
Hmm. If we're talking pure DB theory, then the whole point is to apply
the DRY principle as much as possible. At the point you have multiple
copies of the same data, unless your programmers are perfect (and they
aren't, I promise), you *will* have stale data. Better to have only one
place
At 3:25a -0500 on 17 Jan 2008, Ben Clewett wrote:
I need to know why MySql does this. If any person knows how I an
identify the problem, please let me know!
I think this package helped another person out on this list a couple
days ago:
I can't speak to the exact internals of MySQL, but in database practice
one *generally* uses prepared statements for two reasons:
1. Security
2. Speed
If your system is at all exposed to the outside world *and you at all
value your data*, your biggest concern should /absolutely/ be security.
At 12:08p -0500 on 17 Jan 2008, Ben Clewett wrote:
The package you show gives the same output as the 'SHOW PROCESSLIST'
output, which I included in my previous email :)
Heh, that'll teach me to actually /use/ the package before recommending
it. :-P (I just found out about it when that
At 6:47a -0500 on 08 Jan 2008, Gunnar R. wrote:
Concerning slow queries, it seems there's a couple of different queries
that's being logged.
I haven't tried it yet, but this recently went by on debaday.debian.net:
mytop: a top clone for MySQL
At 3:51p -0500 onGunnar R. wrote, On 01/08/2008 03:51 PM:
That tool tells me 100% of the data is read from memory, not a byte from
disk... would there still be any point in getting more memory?
Any suggestions to where to go from here?
I dunno. My hunch is that could do some query
At 7:45a -0500 on 17 Dec 2007, Marcus Füg wrote:
Tabelle Sales (s) mit jede Menge Abverkaufsdaten.
ArtikelNr,Kassenbon,HändlerID,Datum
Jetzt sollen alle zu einem gekauften Artikel ebenfalls augelistet
werden, d.h. was wurde mit dem Artikel zusätzliche gekauft
Bisher habe ich das mit PHP
At 5:53p -0400 on 11 Jun 2007, Gordan Bobic wrote:
I don't understand this never-ending fascination with re-inventing
a square wheel for an application for which the standard round type
has already been kindly provided since year dot.
I imagine the reason for this never-ending fascination
At 12:31a -0400 on 28 May 2007, Dan Nelson wrote:
In the last episode (May 27), Yves Goergen said:
I'm thinking about using a MySQL table to store an Apache access log
and do statistics on it. Currently all access log files are stored as
files and compressed by day. Older log files are
At 5:45a -0400 on 28 May 2007, Yves Goergen wrote:
On 28.05.2007 09:06 CE(S)T, Kevin Hunter wrote:
In particular, I imagine a lot of the HTTP requests would be the
same, so you could create a table to store the requested URLs, and
then have a second table with the timestamp and foreign key
At 9:06p -0400 on 30 Apr 2007 John Kebbel wrote:
I'm having problems understanding NULL. I grasp what a NULL value is,
A NULL value is rather an oxymoron. It'd be more accurate to say
that NULL means absence of a value.
but I can't get NULL to perform correctly. For instance, if I do a
Caveat emptor: I haven't tested this in about a year.
Are you perchance using a table type of MyISAM? I seem to recall
that MyISAM has a hard time actually representing NULL
internally. [ ... Thinks for a minute ... ] I remember
something about spaces, like, I think I did
INSERT (
On 20 Mar 2007 at 12:50p -0400, nikos wrote:
Does any body knows how to select not the LIMIT 20 records but the
rest of them?
MySQL version is 4.1.21-standard and I cant make a VIEW.
In Venn-speak, you are asking for Circle A less(, minus, or subtract)
Circle B. In SQL, this would
On 07 Mar 2007 at 3:57p -0500, Alexander Lind wrote:
imagine a large system where pdf-files are accessed by clients a lot.
say 1 pdf file is access per second on average.
also say that your database is on a machine separate from the
webserver(s) (as is common).
do you really think its a good
killed while reading event
May 4 09:30:06 localhost mysqld[29920]: 060504 9:30:06
[ERROR] Slave I/O thread exiting, read up to log 'mysql-bin.000256',
position 6268185
Hunter Peress
[EMAIL PROTECTED]
Web
SELECT sum(if(eventtype='click',1,0)) as
clicks,sum(if(eventtype='view',1,0)) as view from xy group by somethingelse
note the conditional inside the sum. wheres a good source of information on
complex statistical queries like this
the issue was because i was viewing the database through cocoamysql,
which registered the timestamps as null.
stupid me viewing the database through the commandline showed up
fine
---
Hunter Peress
i may just
have to dump/load instead of copy files.
---
Hunter Peress
[EMAIL PROTECTED]
Web Programer
The Santa Fe New Mexican, Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
for the other tables in the database.
Is there something else I can do to track down what may be going
wrong?
Thanks,
John Hunter
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Could someone have a look at this syntax and give me some guidance what I
may be overlooking?
SELECT * from $TableName WHERE machinename != 'FIND_ME' OR machinename !=
'OPEN'
I can make the statement work individually, but when I try to add the 'OR'
statement it fails to 'remove' the designated
Well, I know you stated that you do not find M$ Access all that good, but
you could use Access as a GUI Front end to the MySQL backend. Just a
thought.
If you are looking at doing that, I suggest you read up on MyODBC since that
is what is needed to get the two to talk to each other. I have
With what little info you presented allow me to try and answer this one:
$db_server: I am assuming that the script you are using is a premade one
that can handle different types of database backends, if this is the case,
you will need to look at the documentation that came with the script to see
This being the first time I have tried to do a JOIN statement (and still not
yet fully understanding it). If someone could take a look at the below code
and see what I may be doing wrong.
I have the actual code working and it displays the information from
$TableName2.notes, however in this table
Message-
From: Hunter, Jess [SMTP:[EMAIL PROTECTED]
Sent: Sunday, December 14, 2003 11:34 AM
To: [EMAIL PROTECTED]
Subject: Help with JOIN and Record Display
This being the first time I have tried to do a JOIN statement (and still
not
yet fully understanding it). If someone could
OK, Have another small issue that maybe someone could help me out with.
When using a JOIN I can pull records from a second table without a problem
(now).
I am wanting to display two fields ( id and notes) however I only want the
id field to display once and all the notes to be displayed.
Here
Using PHP as the front end I am creating a form with a dropdown box that
displays information from one table to be inserted into another table.
That's PHP and I have gotten that part down with no issue.
However, in the table a person could be listed multiple times and I only
want a user to be
Jeff,
The first example worked perfectly, Thanks for the quick response
Jess
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]
Sent: Friday, December 12, 2003 10:02 AM
To: Hunter, Jess
Subject: Re: How to keep multiple instances of the same information
from
I keep getting the following error when I try to run an if statement
Warning: 2 is not a valid MySQL-Link resource in then give the filename
Here is what I am trying to do.
if ($bumpnumber4) {
print (display this);
}else {
print (display that);
}
mysql_close ($Link);
Anyone have any idea what I
Being real new to MySQL I am having difficulty finding information on how to
retrieve data from the last record in a database.
I have tried using the SELECT LAST_INSERT_ID() statement but that only works
on a per connection basis and doesn't help all the times.
Basically I want to goto the end
Hello,
Is it possible to install MySQL binary distribution on Solaris into a
directory of my chosing without the need to access /usr/local?
Paul Hunter
* [EMAIL PROTECTED]
* 01473 605476
-
Before posting, please check
(
2472160,
'2001-3-9',
'101.bmp',
2
Which is the line that the slave is complaining about.
When I sync my data dirs, the slave dir also has the mother-bin.*
files on it and it gets the mysql user dir from the master. Is this
correct?
Stumped.
Thanks,
John Hunter
Van == Van [EMAIL PROTECTED] writes:
Van No. Just have the slave connect to the master using the ip
Van address.
I have set up the master and slave now and am getting a problem. When
the slave tries to connect, it appears to be attempting to enter a
value that is already in one of
offer some quick help or tell me to go to a
backup (too old :-( ) or go drown my sorrows in a beer.
Thanks,
John Hunter
mysql version 3.23.37
sql,select (keywords to match spam filter)
-
Before posting, please check:
http
with mysql? It has not been deleted from the filesystem
yet...
Thanks,
John Hunter
sql, select (spam filter evador)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
Joel == Joel Rees [EMAIL PROTECTED] writes:
Joel This begins to sound like a job for Perl. Of course, it
Joel would be nice if you could get someone familiar with the
Joel internal formats mysql uses to give you some hints
Yes, I am having trouble deciphering the primary key (type
Have a Redhat 7.2 system. Trying to install MySQL 4.0.1 version of the
server and client rpms via the KDE package manager. Am getting a dependency
failure but it does not indicate which package, library etc. that I am
missing. Any one have a suggestion?
to get the closing quote. I have a fairly large
data base (almost 400MB) and am wondering if there is a better way
than reverse sorting the whole table into a temporary table.
My approach is below. Comments are welcome since I am trying to
learn/improve my SQL (pun intended).
Thanks,
John Hunter
BY
ticker/day.
Thanks,
John Hunter
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe
to modify the table in place to remove the duplicates?
If not, how do I create a temporary table with duplicates suppressed,
and then rename/copy this table to the original table name?
Thanks,
John Hunter
-
Before posting, please check
. Will this automatically keep my rows ordered by
the primary key with future inserts?
Thanks for your help,
John Hunter
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
using mysqlimport
Usage: mysqlimport [OPTIONS] database textfile...
HTH
--
Bill Omer wrote:
I was able to use mysqldump to 'dump' the databases in to a file. However,
I'm not able to figure out how I can recreate the databases on the new server
using this file.
Any suggestions?
This depends on the method of install (tar ball source, RPM, etc) and
the distro you are running. Please provide a bit more information so
that we may assist you by giving you the appropriate response.
HTH
simon joas, vorstand/ceo: sjn AG wrote:
hallo!
how do i update my mysql-database to
Actually that is incorrect syntax...the following is the correct syntax
to ensure that mysqld is running at boot in the different run levels:
/sbin/chkconfig --level 345 mysqld on
as it is a daemon, you need to use 'mysqld' not mysql, and you also need
to pass to chkconfig the runlevels you
I did a search and i do not have that file on my system, and i have been
running RedHat for about 6 years now. And this is a redhat-7.1 box
HTH
--
Dane Knudson wrote:
I have installed mysql during the install of RH linux. When I try and
start the service, there is an entry in the error log
by mac having count(mac) 1
Then we get the number of different mac's using an ip.
Can then query the mac for different IP's used. It would be nice to
roll it all into one query and I'll work on that. Thanks again.
--
Best regards,
Tony Hunter
be killed.
What can I do about this? I've had to restart this server twice today and
it's a production Web server. Not fun.
Any help is GREATLY appreciated.
Hunter
-
Before posting, please check:
http://www.mysql.com
|
select * from song_files where uri ='Enemy_You-Lock_out-24.mp3
The rest of the list is just SELECTs. So, does that mean the first select
got a lock, somehow got hung up talking to the server and never released the
lock?
What can I do to further diagnose this problem?
Hunter
all the table locking stuff in the manual...
Do updates/inserts lock the table so that others can't read it? If so, is
there a way to make an update/insert fail if it just takes too long?
Hunter
From: Sander Pilon [EMAIL PROTECTED]
Date: Wed, 25 Apr 2001 22:51:06 +0200
To: 'Hunter Hillegas
Running mysqladmin -p proc reports:
too many connections...
That's why I can't diagnose it.
I'm logging in as root. How else would I get process_priv? I haven't changed
any parameters so I should be able to get in but I cannot.
What am I doing wrong?
Hunter
From: Andrew Schmidt [EMAIL
I'm running PHP4.0.4pl1 - the latest version.
Web users are logging in as a user called dummy.
I guess I'll have to look in the manual to see how to remove the
process_priv(). I don't think they need it...
Thanks,
Hunter
From: Andrew Schmidt [EMAIL PROTECTED]
Date: Wed, 25 Apr 2001 15:13:24
to install
the RPMs? Any kind of prep?
Hunter
database
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL
I have several mysqld processes that have 'D' status as shown by ps aux.
From my limited understanding, that means they are waiting for disk and are
uninterruptible?
How do they get this way and what can I do to fix this?
Hunter
there)...
Anyway, I'm getting the Got an error reading communication packets in my
log files...
What can I do to solve this?
Hunter
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
list.
I'm trying to discover the best way to troubleshoot this problem. I tried
upping the user max_connections variable but that didn't help... It's hard
to troubleshoot since I don't know what's going on.
Any help would be appreciated
I have mySQL threads that are sleeping with LONG times from a PHP app. What
kind of PHP call could sleep that long w/o dying?
Hunter
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
, probably with an INSERT?
What's the best way to figure this out if I can't get into the server at all
when it locks up?
Hunter
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists
if they've been met, and if
not, return a list of the courses that have not been met.
Is this even possible with one query?
Hunter
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
"Atle" == Atle Veka [EMAIL PROTECTED] writes:
Atle You say you go to runlevel 5 at boot? In that case, you need
Atle to put the S99mysql into the rc5.d/ directory..
That worked.
Thanks,
John Hunter
-
Befo
/mysql.server*
Is there some other incantation I need to make to get this to start
properly at boot? I enter runlevel 5 by default at boot.
Thanks,
John Hunter
Here is the exact sequence I did at install and configure:
/usr/sbin/groupadd mysql
/usr/sbin/useradd -g mysql mysql
cd /usr/local/src
"Atle" == Atle Veka [EMAIL PROTECTED] writes:
Atle You say you go to runlevel 5 at boot? In that case, you need
Atle to put the S99mysql into the rc5.d/ directory..
Ok, thanks, I'll try that. But I thought the runlevel 5 stuff was
only executed after the runlevel 3 stuff, so that I
dress char(64),
city char(64),
stateId int(10) unsigned,
zipcode char(11),
phone char(15),
fax char(15),
email char(64) NOT NULL,
password char(64) NOT NULL,
PRIMARY KEY (id),
UNIQUE email (email),
KEY email_2 (email)
);
On the slave err log I have:
010128 11:04:28 Slave: Failed reading log event, reconnecting to retry,
log 'FIRST' position 4
010128 11:04:28 Slave: reconnected to master
'repl@glenastle:3306',replication resumed in log 'FIRST' at position 4
010128 11:04:28 Slave: received 0 length packet
71 matches
Mail list logo