priate.
They're not interchangeable, and not intended to be.
Mark
--
http://www.markgoodge.uk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
om it into a separate folder), as
well as people who only need to contribute very infrequently and don't
want to have to subscribe in order to do so. But all this should, IMO,
be in addition to the core features of an email mailing list, rather
than a replacement for them.
Mark
--
http://w
ot;1" AND vDate = "2012-10-11"
Where I've aliased the SUBSTR of the date and then used the alias in the
WHERE clause of the query. I'm getting an error message now, but I'm
almost certain I've used that syntax before. Am I missing something?
--
Mar
ALTER TABLE t1 CHANGE c1 c1 BLOB;
ALTER TABLE t1 CHANGE c1 c1 TEXT CHARACTER SET utf8;
The above special characters are still in the body column when I view the
dump file with a hex editor.
Is there a way to replace these special characters with the appropriate
utf8 characters (eg “ -> 22 hex) w
apostrophe had been
converted into a question mark. (FWIW, the apostrophe was one of those
offending non utf-8 characters):
Before conversion: "I stepped into the observatory’s control room ..."
After conversion: "I stepped into the observatory?s control room..."
Is there a better
engine
from InnoDB to something else so I can optimize the tables on a regular
basis.
Is it worth the effort? Any caveats?
I've never really encountered this situation before and I'm curious to
see what others have to say on it.
Thanks in advance.
--
Mark Haney
Software Dev
-+
2 rows in set (3.62 sec)
This is better than the 20s+ I was getting before, but still not
acceptable for only 2 machines when I'll have 40+ at production time.
All I need is the most recent record for EACH machine ID, THEN to pull
the machine name from the table that has the
g part of the
query makes me stop and rethink the logic behind the query. So thanks
for that. My SQL brain is still fuzzy, and combined with Vicodin, I'm
no House. I can't function 100% on pain meds.
I'll take a look at this, and if I need any help, I'll holler, but t
I need, so I decided, in my vicodin soaked brain (I have a torn
rotator cuff and tendon in my shoulder) that I should hit the list
before I go any farther.
So, what's the best way, or the most common way to deal with this issue.
I'll be happy to clarify anything in here that doesn&
oiding joins because doing multiple selects in the code is
usually much faster)
Mark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
that, because the content of item_spine has to be
updated on a regular basis from external data and using autoincrement
means I can't do that using REPLACE INTO while still maintaining a key
association with item_detail.
Any thoughts? How would you do it?
Mark
--
Sent from my Turing-Flower
using both and
honestly haven't found any difference. There may be some difference at
really like transaction levels, but my DBs run pretty much the same
compiled with either.
YMMV.
--
Mark Haney
Software Developer/Consultant
AB Emblem
ma...@abemblem.com
Linux marius.homelinux 3.4
_id
AND b.format_id = '13';
or am I misunderstanding something?
Cheers,
Mark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
or to inserting the data
into the database and store the area code in a separate column.
Mark
--
Sent from my ZX Spectrum HD
http://mark.goodge.co.uk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
teacher_id and the data in the flights table. I need to change the data
model to allow for a many to many relationship between teacher_id and the
data in the flight table. What is the best way to do this?
Thanks,
Mark
No, the problem is not unique to your site. It's an easy mistake to make.
Please could you now give some indication of having read and understood
this reply.
Mark
--
Sent from my Babbage Difference Engine 2
http://mark.goodge.co.uk
--
MySQL General Mailing List
For list arch
I've had a DEVIL of a time with this problem and I'm sure it's something
simple, but I can't find it anywhere in the documentation or online what the
problem is. Let me explain.
I cannot get any WHILE loop to work from either a CLI or a script on MySQL
5.1.41. For example, this is a simple sc
27;%y-%m%-%d
%h:%i:%s') :-)
Mark
--
Sent from my Babbage Difference Engine
http://mark.goodge.co.uk
http://www.ratemysupermarket.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
; Howdy,
>
> Lydia
>
> On Oct 18, 2011 5:19 PM, "Mark, Ryan" wrote:
> Architecture question I'm having trouble finding an answer to:
>
> I run four WordPress websites. I have mysql setup in a write master/read
> replica slave configuration on Amazon. There
Did you issue a 'FLUSH PRIVILEGES;' before quitting the mysql session?
- Mark
-Original Message-
From: Tim Johnson [mailto:t...@akwebsoft.com]
Sent: woensdag 19 oktober 2011 1:02
To: MySQL ML
Subject: mysql server does not recognize user password
using 5.1.57 on Mac Lion.
Architecture question I'm having trouble finding an answer to:
I run four WordPress websites. I have mysql setup in a write master/read
replica slave configuration on Amazon. There is one master that all the
WordPress instances write to. I'm trying to figure out how to setup the read
replicas.
shing and restarting) then you may
have problems with the hardware - with the disk itself.
Mark
--
Sent from my Babbage Difference Engine
http://mark.goodge.co.uk
http://www.ratemysupermarket.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:ht
Hi
We use the --single-transaction switch thinking it does less locking or waiting
for a required table lock. You then get a snapshot without stopping.
Subject should have included the word 'hot'? Looking forward to other
suggestions.
Mark
On 2011/06/07 08:00, Adarsh Sharma wrote:
version of MySQL are you using?
5.0.7
Mark
--
Sent from my Babbage Difference Engine
http://mark.goodge.co.uk
http://www.ratemyairport.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ite which can be accessed by the server admins
without needing to have access to each site's own database.
Clues, anyone?
Mark
--
Sent from my Babbage Difference Engine
http://mark.goodge.co.uk
http://www.ratemyairport.com
--
MySQL General Mailing List
For list archives: http://lists.mys
contacts LIMIT 10
and all will be even more clear :-)
Mark
--
http://mark.goodge.co.uk
http://www.ratemysupermarket.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
s by changing your database is pointless and misdirected.
Cheers,
Mark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
table` DROP `myfield`;
ALTER TABLE `mytable` ADD `myfield` INT NOT NULL AUTO_INCREMENT PRIMARY KEY;
Mark
--
http://mark.goodge.co.uk
http://www.ratemysupermarket.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
module, implement this natively. For example, in PHP:
mysql_query("insert into mytable set name = 'foo'");
$id = mysql_insert_id();
the value of $id will be the auto-increment number from the line you
just inserted.
Mark
--
http://mark.goodge.co.uk
http://www.ratemysuper
On Dec 14, 2010, at 7:21 PM, Feris Thia wrote:
> Hi Mark,
>
> On Wed, Dec 15, 2010 at 8:10 AM, Mark Matthews
> wrote:
> Feris,
>
> *How* are you writing, via batch statements with rewriting, or directly, or
> via LOAD DATA INFILE? It seems you're off by about a
re you writing, via batch statements with rewriting, or directly, or via
LOAD DATA INFILE? It seems you're off by about a factor of 10-20x from what
I've seen performance-wise for writes.
-Mark
--
Mark Matthews
Principal Software Developer - MySQL Enterprise Tools
Oracle
http://
On 03/12/2010 16:56, Paul Halliday wrote:
On Fri, Dec 3, 2010 at 12:50 PM, Mark Goodge wrote:
Given a table containing a range of INT values, is there any easy way to
select from it the lowest non-zero number?
SELECT number FROM table WHERE number> 0 ORDER BY number ASC LIMIT 1;
Sorry
Given a table containing a range of INT values, is there any easy way to
select from it the lowest non-zero number?
Obviously, MAX(column) will return the highest, but MIN(column) will
return 0 if any row contains a 0, which isn't what I want.
Any clues?
Mark
--
http://mark.goodge.
7 on Centos. All the databases use MyISAM
exclusively.
Given the above, can anyone suggest any possible causes?
Thanks
Mark
--
http://mark.goodge.co.uk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
#x27;,YEAR) as MONTHYEAR, sum(QTY) as TOTAL
from MYTABLE
group by concat(ID,MONTH,YEAR)
Mark
--
http://mark.goodge.co.uk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
+
| id | title |
+--+-+
| 10 |foo |
+--+-+
| 3 |baz |
+--+-+
| 8 |bar |
+--+-+
| 5 | wibble |
+--+-+
| 1 | flirble |
+--+-+
Is this possible? If so, how?
Mark
--
http://mark.goodge.co.uk
x27;t possible.
Why do you want a duplicate record to be retrieved? There may be a
better way of doing it.
Mark
--
http://mark.goodge.co.uk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
mer and the total paid by the customer. These three should, of
course, be not only identical to each other but also to the sum of the
individual items, so there is not only duplication but the potential for
skew. But that, of course, is precisely *why* you store them, as any
discrepancy indicates an
inserted A and B:
UPDATE mytable SET C = A - B
http://dev.mysql.com/doc/refman/5.1/en/numeric-functions.html
Simples :-)
Mark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
be
>>> used.
>>> You must also specify the --ssl-ca option, and possibly the --ssl-cert and
>>> --ssl-key options.
>>> ##
>> This documentation appears to be wrong.
>> Anders
>
> Excellent logic.
>
> I have updated bug #3138 with a private comment
misunderstanding the example being given.
[1] I'd have a cart table with one line per cart, and then a separate
cart_contents table with one line per product and a cart_id column which
links it to the cart table. That also allows a separate cart_address
table which can have m
On Sun, Jul 25, 2010 at 8:49 PM, Nguyen Manh Cuong <
cuong.m...@vienthongso.com> wrote:
> Hi Mark,
> Please test this query:
> select test1.*, (select name from test2 where test2.id=test1.`v_id` limit
> 1) as name_1,
> (select name from test2 where test2.id=test1.`h_id` limi
sam C
Thanks!
Mark
search in Boolean mode.
http://dev.mysql.com/doc/refman/5.1/en/fulltext-restrictions.html
Mark
--
http://mark.goodge.co.uk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
, it's a
trivial piece of code to recreate it.
Mark
--
http://mark.goodge.co.uk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
application level as MySQL doesn't provide it
natively.
See the replication FAQ for more information:
http://dev.mysql.com/doc/refman/5.1/en/replication-faq.html
Mark
--
http://mark.goodge.co.uk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
;.',-1)
=> 'path'
SELECT SUBSTRING_INDEX('myfile.pth','.',-1)
=> 'pth'
or, in a version that's closer to real life usage:
SELECT SUBSTRING_INDEX(myfield,'.',-1) from mytable
http://dev.mysql.com/doc/refman/5.0/en/string-functions.htm
ly, and if so how to
implement them.
Mark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ion, there are cases where it's very useful but it's not a
substitute for storing the array values separately using the appropriate
table design where you do need to run queries against it.
Mark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ot;51" is too short to be included in the index by default, so will never
match. "Blue", on the other hand, is indexed and therefore is returned
by a search.
The default minimum word length is four characters. See
http://dev.mysql.com/doc/refman/5.0/en/fulltext-fine-tuning.html
gt; Well thats disappointing.
>
> sigh
> So what are we supposed to use for loadbalancing mysql.
>
> Thank you for your reply.
>
> Kind Regards
> Brent Clark
Brent,
Some clients (namely the JDBC driver, and the R-O-R adapter) have load
balancing built in.
-Mark
--
you're looking for is something involving a substring_index on the
Author column.
Mark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
uk/musings/422/locate-that-postcode/
for a topical twist on this)
Mark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
now if it would have the same
problem for US or Canadian data.
Mark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
skip-networking is OFF
On 1/22/2010 12:09 PM, Mark Matthews wrote:
On Jan 22, 2010, at 10:49 AM, Mark Witczak wrote:
Alright, here is the entire log entry:
Jan 21, 2010 9:40:35 PM org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: contextInitialized()
Jan 21, 2010 9
On Jan 22, 2010, at 10:49 AM, Mark Witczak wrote:
> Alright, here is the entire log entry:
>
> Jan 21, 2010 9:40:35 PM org.apache.catalina.core.ApplicationContext log
> INFO: ContextListener: contextInitialized()
> Jan 21, 2010 9:40:35 PM org.apache.catalina.core.ApplicationCon
startup?
On 1/22/2010 11:38 AM, Mark Matthews wrote:
On Jan 22, 2010, at 10:21 AM, Mark Witczak wrote:
[snip]
I create the WAR (jar cvf testapp.war *), undeploy the old version and redeploy
the new one through Tomcat Web Application Manager. Then restart Tomcat (sudo
/etc/init.d/tomcat
On Jan 22, 2010, at 10:21 AM, Mark Witczak wrote:
> [snip]
> I create the WAR (jar cvf testapp.war *), undeploy the old version and
> redeploy the new one through Tomcat Web Application Manager. Then restart
> Tomcat (sudo /etc/init.d/tomcat restart). The result is:
>
> Ja
'. There are no firewalls, that I can find, between
the servers.
What is going on here? What am I missing? What is going on here? How do
I fix it?
-Do I need to create a "foo" user in the tomcat-users.xml?
-Do I have to mess with the policy files? or security?
Thanks for you
ments doesn't
alter the need to comply with them - at least, not if you want to be
able to use their payment APIs.
Mark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
inflexible and generally bad database design. I'd be
somewhat surprised if PCI compliance really did require it.
Mark
--
http://mark.goodge.co.uk - blog
htp://www.good-stuff.co.uk - stuff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
last used within the past N days, for whatever value of N you
prefer.
Mark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
_INCREMENT = 6;
then the next inserted id will still be 10, not 6.
Mark
--
http://mark.goodge.co.uk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
lorsShadesNumbersShort
from tem126080739853 t
join products p on
t.ProdID=p.ID
Mark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
^
Look at the message, 0 rows changed and 1 warning.
You cannot have ID=0 if ID is an index.
You can, but not if it's an auto-increment field.
Mark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
typically 2Mb for PHP on
Apache, although the administrators can change that). But the source of
the file is irrelevant; so long as it's within the file upload limit
then it doesn't matter whether it was exported by phpMyAdmin itself or
created using mysqldump from the command line.
Thanks to Martin and John for their help!
Mark
On Sat, Oct 3, 2009 at 5:53 PM, Martin Gainty wrote:
> enforcing by username/password to the DB is your safest method
> and if you want to really be safe put ssh access onto the MySQL Server
>
> here is how to install SSH and MySQL
her. Would that argue for separate
>> databases?
>> Mark
>>
>
>
> Are the actions of a similar nature (i.e. they're all writing the same type
> of data and the databases themselves would be similar if not the same)?
Each user will write the same type of data to the sam
t that user a cannot get to user b's
data.
Can't I achieve the same level of security if each row has a userID, and all
queries use a "where userID=xxx" clause?
Mark
>
>
> > Date: Sat, 3 Oct 2009 14:38:25 -0700
> > Subject: Questions on Database Design
&g
On Sat, Oct 3, 2009 at 2:47 PM, John Meyer wrote:
> Mark Phillips wrote:
>
>> I am new at database design, and my question relates to the trade-offs
>> between putting all data in one database or several for mysql. For
>> example,
>> say I have an application
into one database (ie one set of tables) and with multiple userIDs? 10
users? 1,000 users? Never?
Thanks!
Mark
o of them that both have an 'ID'
field. This will work:
SELECT products.ID, Item
FROM products
JOIN categories ON categories.ID = products.Category
LIMIT 0 , 30;
Mark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
unction is
returning a 'null' where it should have a string.
Mark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
s
are defined as VARCHAR.
Does anyone have an answer to this? I, too, would like to know how to
use fulltext to compare data between two columns (as opposed to
comparing data between a column and a pre-defined string). Is there any
way to do this?
Mark
--
MySQL General Mailing List
For list arc
possible, and, if so, how?
Thanks
Mark
--
Stuff: http://www.good-stuff.co.uk
Blog: http://mark.goodge.co.uk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Join
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Depends on your OS, I guess. On FreeBSD you can just go to the
'php5-extensions' port, run a 'make config', and deselect everything but
the MySQL extension. Then it will only build mysql.so for you. Very easy.
:)
- Mark
From: Martin Gainty [mailto:mgai..
This isn't a MySL hell exclusively, btw. You'll get the same issue
upgrading PostgreSQL, or BerkeleyDB, etc. It's just the nature of the
beast.
- Mark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
i dont think that the init.d script will accept the argument.
you need to run /usr/bin/mysqld_safe --init-file=clouds.sql &
(or whatever the path to mysqld_safe is)
2009/4/29 Jason Todd Slack-Moehrle
> Hi Guys,
>
> i am still lost here:
>
> GRANT ALL ON mysql.* TO 'root'@'localhost' IDENTIFIE
t;
mysql>
mysql> show databases;
++
| Database |
++
| information_schema |
| hgallery |
++
2 rows in set (0.00 sec)
mysql>
Ok, so how do I disable that?
- Mark
-Original Message-
From: John Daisley [mailto:john.dais...@my
into this.
- Mark
-Original Message-
From: joerg.bru...@sun.com [mailto:joerg.bru...@sun.com]
Sent: woensdag 29 april 2009 8:14
To: Mark; mysql@lists.mysql.com
Subject: Re: 1135: Can't create a new thread (errno 35); if you are not out
of available memory, you can consult the ma
hey jason,
you need to restart the *server* with the init-file option, have a look at:
http://dev.mysql.com/doc/refman/5.0/en/server-options.html
2009/4/28 Jason Todd Slack-Moehrle
> I am trying to start MySQL with --init-file but i get that it is an invalid
> option. the 'man' page and --he
ow to Jörg's expertise on the matter. :)
- Mark
-Original Message-
From: Martin Gainty [mailto:mgai...@hotmail.com]
Sent: dinsdag 28 april 2009 14:44
To: Joerg Bruehe; maan...@gmail.com
Cc: ad...@asarian-host.net; mysql@lists.mysql.com
Subject: RE: 1135: Can't create a new thread (er
limit (and
'sysctl' it to higher if it's not sufficient). I'm always amazed how much
open files MySQL keeps. The amount of files MySQL reserves, way I recall,
is also directly related to max. connections; so you could lower that too,
temporarily, to see if it makes the error go
It would probably help if you told folks what MySQL version you are running.
:)
- Mark
-Original Message-
From: VeeJay [mailto:maan...@gmail.com]
Sent: dinsdag 28 april 2009 10:22
To: mysql@lists.mysql.com; VeeJay
Subject: 1135: Can't create a new thread (errno 35); if you are no
ases first. After that, the import succeeds, and all errors are gone.
Odd. It's been quite quiet on this list of late. I expected at least
someone to know the answer. If this is indicative of people's interest in
MySQL these days, then maybe it really IS a good idea to start using
st it can cause
crashes.
- Mark
From: zhu dingze [mailto:mysql.li...@gmail.com]
Sent: zondag 26 april 2009 16:40
To: Mark
Cc: mysql@lists.mysql.com
Subject: Re: Error : Incorrect key file for table 'X'
Hey Dude,
So many errors imply that there are some issues with your
C'mon, guys, there's gotta be someone who knows something about this. :)
Anyone? Anyone? Bueller? Bueller? I even did a complete mysqldump (from
the 5.0.77 mysqld) and imported it that way. To no luck, alas.
Thanks,
- Mark
-Original Message-----
From: Mark [mailto:ad...@asaria
this (FreeBSD). Anyone any idea what's happening?
Thanks,
- Mark
Repairing tables
albatross.banned
Error: Incorrect key file for table 'banned'; try to repair it
error: Corrupt
albatross.bridge
Error: Incorrect key file for table 'bridge
Okay, does anyone know of a hosting site that supports 'Image::Magick'?
(the Perl package). The salesrep at AwardSpace said they didn't have it.
P.S. This is probably getting a mite off-topic. So, feel free to reply to
me off-list, if you happen to know the answer.
Thanks,
- M
-Original Message-
From: Claudio Nanni [mailto:claudio.na...@gmail.com]
Sent: maandag 20 april 2009 22:29
To: Mark
Cc: mysql@lists.mysql.com
Subject: Re: A good US Hosting Site?
> Mark wrote:
> > Yeah, but a "Maximum file size limit 500 KB," what can you do with
>
-Original Message-
From: Claudio Nanni [mailto:claudio.na...@gmail.com]
Sent: maandag 20 april 2009 17:22
To: Mark
Cc: mysql@lists.mysql.com
Subject: Re: A good US Hosting Site?
> Well,
>
> not a joke for free hosting.
>
> But it is, for me, by far the best hosting site
-Original Message-
From: Claudio Nanni [mailto:claudio.na...@gmail.com]
Sent: maandag 20 april 2009 10:28
To: p...@pwilson.net
Cc: mysql@lists.mysql.com; Cameron Rogers; step...@kionic.com
Subject: Re: A good US Hosting Site?
> www.awardspace.com
>
> I have both free and paid hosting and
ike to have is the Hyperdrive 5 from
> http://www.hyperossystems.co.uk/. It is a DDR SSD and each drive has
> slots for 8 DIMM's which means it can hold up to 32GB (64GB if you can
> find 8GB DDR2's) per drive.
Too bad these aren't SCSI drives, so they could be used w
better idea if it's going
to work for your situation in it's current (and always changing)
state, and also to provide input into the direction of the developers.
Best regards,
-Mark
--
Mark Matthews, Architect - Enterprise Tools
MySQL @ Sun Microsystems, Inc., http://www.sun.co
to. Fix
the file permissions first, and then try starting mysqld. You'll then be
able to run mysql_upgrade to fix the missing table problem (which is a
warning, not a fatal error, hence why you need to have the server
running to be able to fix it).
Mark
--
http://www.good-stuff.co.uk -
_at is NULL" will do. You only need to compare expiration
dates with NOW() if they can be in the future - which, from your
description, isn't possible.
If an expiry date can be either future, past or non-existent, then your
existing selector is as good as any.
Mark
--
http://mark.
In a real-life situation, it's more important that the database design
reflects your actual workflow and business requirements. Having a field
that's empty 50% or more of the time is far less of a problem than not
being able to process a sale because your database structure is too
infl
Joerg Bruehe wrote:
Hi Mark, all!
Mark Goodge wrote:
I'd appreciate some advice on how best to handle a biggish dataset
consisting of around 5 million lines. At the moment, I have a single
table consisting of four fields and one primary key:
partcode varchar(20)
region varchar(10)
loc
cation is added or
removed, the only thing that changes is the value in qty).
Does anyone have any suggestions? My initial thought is to replace the
region and location varchar fields with int fields keyed to a separate
list of region and location names. Would that help, or is there a better
wa
1 - 100 of 1556 matches
Mail list logo
