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
> desi
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. N
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.
>
>
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 t
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 on
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
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 w
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 b
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 to
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 gener
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 article
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:
http://debaday.debian.net/2007/12/26/mytop-a-top-clone-
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 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 optimizat
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
http://debaday.debian.net/2007/12/26/mytop-a-top-
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
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 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 tabl
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 c
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 ( val
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
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 transla
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
stopped at log
'mysql-bin.000256' position 4
May 4 09:30:06 localhost mysqld[29920]: 060504 9:30:06
[ERROR] Slave I/O thread 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 'm
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
To
lso goes 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 done
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
w
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 is
Original 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
>
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 t
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 ($bumpnumber<4) {
print ("display this");
}else {
print ("display that");
}
mysql_close ($Link);
Anyone have any idea
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 s
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 list
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 of
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
mother-bin.*
files on it and it gets the mysql user dir from the master. Is this
correct?
Stumped.
Thanks,
John Hunter
Master mysql version: 3.23.37
Slave mysql version: 3.23.36
Error message:
020315 9:30:52 Slave: connected to master '[EMAIL PROTECTED]:3306', replication
started
> "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 i
concern is about the machine names. The slave thinks the master
server is named eg, master.name.com, but the master server thinks it
is named master.internal.domainname. So I am wondering if this will
muck things up.
Has anyone done this before?
Thanks,
John Hunter
Master: mysql Ver 11.13
> "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
, really sure there is no way to get at this
information 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
one can 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:
h
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?
_
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
thin the given GROUP 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
One further question. 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
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
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-databa
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 desi
Are you saying that the current version of gcc for RedHat Linux 7.1
(i.e. 2.96) is not working for you and thus preventing the rpm from
building? Thats awfully interesting, and you should report the bug, if
that is indeed what you are seeing, to bugzilla...
Sinisa Milivojevic wrote:
>
> Florin A
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 lo
The RPMS supplied by RedHat with version 7.1, work flawlessly. However,
on a redhat linux system, do an RPM install, making sure you meet all
the dependency requirements (i.e. libmysqlclient, etc). Most recent RPMs
already have a configuration to have the MySQL daemon automagically
start on boot..
othing, but if we use
group 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
ype char(3) not null,
flags char(3) not null,
mac varchar(20) not null,
mask char(1) not null,
device varchar(8) not null,
updated datetime not null,
key (id),
key (ip),
primary key (ip);
unique index id_idx (id)
);
--
Best regards,
T
t. Processes with status 'D' cannot 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
o back and read 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,
host | fatfreeradio | Query | 3870 | Locked |
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
I have to do 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,
ied to compile PHP against the new mySQL libraries, but that won't even
build (I have a help request in on their mailing list...).
Are there enough differences between 3.23.23 and 3.23.36 that might be
causing connections to not drop?
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 PROTECTE
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: &
27;s no fun. Anything anyone could do to help would be great.
Hunter
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread,
right 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
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
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
x27;s in the processlist.
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&#x
a deadlock somewhere, 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
so, checks enroll_course to see 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.mys
>>>>> "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
---
> "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 t
c.d/init.d/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
,
contact char(64),
address 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),
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 from
77 matches
Mail list logo
