Hello Martin,
On 9/5/2014 7:52 AM, Martin Gainty wrote:
... snip ...
MG>My development is identical ..Development on Windows..Production on Linux
MG>When google routes me to Vladimir Putins site for "Official Windows Mysql
Stack" you download god knows what
MG>solution is to give the customer
MG>My development is identical ..Development on Windows..Production on Linux
MG>When google routes me to Vladimir Putins site for "Official Windows Mysql
Stack" you download god knows what
MG>solution is to give the customer an in-between solution such as mysqld,
mysqladmin and mysql shell sc
> From: m.ton...@upscene.com
> To: j...@ecoreality.org; mysql@lists.mysql.com
> Subject: Re: database developer tool "Database Workbench 5" now available
> Date: Fri, 5 Sep 2014 07:57:37 +0200
>
> Hello Jan, list,
>
> >> From: "Martijn Toni
Hello Jan, list,
From: "Martijn Tonies (Upscene Productions)"
Database Workbench now comes in multiple editions with different
pricing models, there's always a version that suits you!
Unless you don't do Winblows.
Please put Windows dependency clearly in your announcements and on your
webs
Hello Nicu,
On 4/6/2014 1:51 AM, Nicolae Marasoiu wrote:
Hi,
A directory in datadir does not show up as database. Please help!
drwx-- 2 mysql root 24576 oct 9 00:34 *opendental*
drwx-- 2 mysql mysql 4096 mar 22 19:54 performance_schema
drwx-- 2 mysql root 4096 mar 22
Hi,
Data migration made last night.
Use of a new MySQL instance has been quite useful to operate, the outage
was about 7 minutes.
ibdata1 is now using 58 MiB of disk space ! each table having a proper
.ibd file and full data directory from 13GiB to 3.2GiB ...
Server load divided by 3 ~ 4 ;).
I
Hi Shawn, and thanks for this concise anwser ;) .
Le 22/03/2014 05:35, shawn l.green a écrit :
>
> The system is operating exactly as designed. The ibdata* file(s) contain
> more than just your data and indexes. This is the common tablespace and
> it contains all the metadata necessary to identify
Hello Christophe,
On 3/21/2014 4:47 PM, Christophe wrote:
Hi list,
I'd like your advice, (one more time ;) ) about this case :
The context is :
A huge database using InnoDB engine from filling about several years
(without possible shrinking, as I've seen, except dropping all databases
to recr
.
>>
>> Please have the slowlog turned on. There could be extra, useful, info in it.
>>
>>
>>> -Original Message-
>>> From: spameden [mailto:spame...@gmail.com]
>>> Sent: Tuesday, July 02, 2013 7:28 PM
>>> To: Singer Wang
>>
t; -Original Message-
>> From: spameden [mailto:spame...@gmail.com]
>> Sent: Tuesday, July 02, 2013 7:28 PM
>> To: Singer Wang
>> Cc: Andy Wallace; mysql list
>> Subject: Re: database perfomance worries
>>
>>>
>>>> We are on
have the slowlog turned on. There could be extra, useful, info in it.
> -Original Message-
> From: spameden [mailto:spame...@gmail.com]
> Sent: Tuesday, July 02, 2013 7:28 PM
> To: Singer Wang
> Cc: Andy Wallace; mysql list
> Subject: Re: database perfomance worries
&
>
> > We are on a quest to improve the overall performance of our database.
> It's
> > generally
> > working pretty well, but we periodically get big slowdowns for no
> apparent
> > reason. A
> > prime example today - in the command line interface to the DB, I tried to
> > update one
> > record, an
Am 03.07.2013 01:25, schrieb Andy Wallace:
> Thanks for the response:
>
>> how large is your database?
> about 33GB, and growing
>
>> how large is innodb_ubber?
> from my.cnf:
># You can set .._buffer_pool_size up to 50 - 80 %
># of RAM but beware of setting memory usage too high
>i
O
On 2013-07-02 5:31 PM, "Andy Wallace" wrote:
> We are on a quest to improve the overall performance of our database. It's
> generally
> working pretty well, but we periodically get big slowdowns for no apparent
> reason. A
> prime example today - in the command line interface to the DB, I tried
Thanks for the response:
> how large is your database?
about 33GB, and growing
> how large is innodb_ubber?
from my.cnf:
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size=2048M
innodb_additional_mem_pool_siz
Am 02.07.2013 23:28, schrieb Andy Wallace:
> mysql> update agent set number_of_emails = 5 where acnt = 'AR287416';
> Query OK, 1 row affected (36.35 sec)
> Rows matched: 1 Changed: 1 Warnings: 0
>
> 36 seconds to update one table? The primary key is `acnt`. If I run the same
> (ba
When you say locked, do queries on the other databases fail with an
error? If so, whats the error? Is it all queries, or just inserts?
Also, how are you doing your export and import?
Sent from my iPad
On Sep 10, 2012, at 2:38 AM, Roland RoLaNd wrote:
>
> Dear all,
>
> I realize this is a very
Hello Daevid,
Any plans to add sqlite to your list of supported DBs there?
I develop Android and use LAMP as the server backend. Currently I use
SQLYog
as I have for like 10 years. But I would really like one GUI to work on
both
the android sqlite and the mysql backend since they usually ti
Any plans to add sqlite to your list of supported DBs there?
I develop Android and use LAMP as the server backend. Currently I use SQLYog
as I have for like 10 years. But I would really like one GUI to work on both
the android sqlite and the mysql backend since they usually tie together.
> -O
No SQLite support?
http://www.sqlite.org/
Seems curious you wouldn't have this yet, especially given its popularity on
both embedded systems and Android to say the least.
> -Original Message-
> From: Martijn Tonies [mailto:m.ton...@upscene.com]
> Sent: Tuesday, August 16, 2011 6:56 AM
> T
Hi Richards .
Here are some of my codes. You can do some changes whatever you want.
http://blog.chinaunix.net/u/29134/showart_1002486.html
David Yeung, In China, Beijing.
My First Blog:http://yueliangdao0608.cublog.cn
My Second Blog:http://yueliangdao0608.blog.51cto.com
My Msn: yueliangdao
HI All
Just to give you some idea of what I have tried thus far:
mysql> delimiter //
mysql> create procedure select_delete_id (in dt date, out id bigint)
begin select max(id) into id from archive_collections where utc < dt;
end//
Query OK, 0 rows affected (0.00 sec)
mysql> delim
On 9/1/2010 11:47 AM, Tompkins Neil wrote:
I do have a tabled which contains both the managers_id and teams_id for the
current teams managed. I think by adding the managers_id alongside the
fixture_result table will then allow me to find which points the manager
has accumulated alongside which f
I do have a tabled which contains both the managers_id and teams_id for the
current teams managed. I think by adding the managers_id alongside the
fixture_result table will then allow me to find which points the manager
has accumulated alongside which fixtures and teams.
Cheers
Neil
On Wed, Sep
I strongly suggest that you make a separate table for the manager <-> team
relationship, so you can keep a history. Put a date-stamp in there. This might
come in handy as you get further into your design.
I ran into this problem when one of our sales reps moved from one office to
another, and t
Hi Neil,
May be your question is too vague.
You have already identified the 'real world' objects that you want
represented in the database.
Have you identified the specific pieces of information that you want stored
for each object ? After you do that, you can then start to see what the
relation
Hi there,
I know you would like just a solution, but I want to give you just a little
bit of background.
Think in real life things(entities), think as you would have to do it on
paper.
[1]
You said you have:
managers, teams players and fixtures/results (matches)
these are your tables
plus...
> i guess my thinking is more along the lines of implementing
> a lustre interface
I'm sure that I'm vastly over-simplifying this, but I was thinking something
along the lines of:
1. Assemble the data being written, calculate its length
2. Check for any free pages in the database file, and use
mysql@lists.mysql.com
> Subject: Re: Database Quotas
>
> > if MYSQL attempts to insert more bytes than what is available
> > on disk you will get 28 ENOSPC No space left on device
> > http://dev.mysql.com/doc/refman/5.0/en/operating-system-error-codes.html
>
>
I ran out of space on a large, busy production database just a few weeks
ago. All tables are InnoDB and I experienced zero data loss.
It was actually running out of space for almost 2 weeks after a review of
the log file. As temp files were deleted transactions were able to continue
until all but
> if MYSQL attempts to insert more bytes than what is available
> on disk you will get 28 ENOSPC No space left on device
> http://dev.mysql.com/doc/refman/5.0/en/operating-system-error-codes.html
Does it figured that out before it tries to write a record? So, if I have 2KB
left on the device an
nt facilement être sujets à la manipulation, nous ne
pouvons accepter aucune responsabilité pour le contenu fourni.
> Date: Thu, 20 May 2010 18:09:42 -0700
> From: t...@soe.ucsc.edu
> To: noel.but...@ausics.net
> CC: mysql@lists.mysql.com
> Subject: Re: Database Quotas
>
> >
> First, generally speaking, putting a quota on an entire database means
> you are probably doing it wrong. In a perfect world, it seems to be
> that building a database which can maintain a size without constant
> mothering would be best, this doesn't always happen for one reason
> or another, but
Tim Gustafson wrote:
Hi,
I'm not sure if this is already an open issue or not - a Google search resulted
in various discussions but I didn't find any open support/feature request.
It would be really handy if during the "create database" statement, one could
specify something like:
CREATE DAT
On May 20, 2010 09:55:41 pm Tim Gustafson wrote:
> > Use postgres, you can assign tablespaces to a partition
> > of the size you want. When it gets full, writes are
> > refused. I'm not sure how nicely that is handled ( in
> > terms of error output ) but the advantage is that Pg is
> > ACID compli
> Use postgres, you can assign tablespaces to a partition
> of the size you want. When it gets full, writes are
> refused. I'm not sure how nicely that is handled ( in
> terms of error output ) but the advantage is that Pg is
> ACID compliant, so you won't lose data.
Wow, that's the first time I'
On May 20, 2010 08:32:56 pm Noel Butler wrote:
> On Thu, 2010-05-20 at 16:27 -0700, Tim Gustafson wrote:
> > Hi,
> >
> > I'm not sure if this is already an open issue or not - a Google search
> > resulted in various discussions but I didn't find any open
> > support/feature request.
> >
> > It w
> Ummm, you're going to have the same problem either way when
> the limit is reached, be it a MySQL quota or system quota,
> if its full, its full.
Yes, but mySQL could return a more friendly "you're out of space" message and
not corrupt the data files if a given statement would cause the databas
On Thu, 2010-05-20 at 16:27 -0700, Tim Gustafson wrote:
> Hi,
>
> I'm not sure if this is already an open issue or not - a Google search
> resulted in various discussions but I didn't find any open support/feature
> request.
>
> It would be really handy if during the "create database" statemen
Hi Phil
Yep, it looks like that will do.
Thanks
>> -Original Message-
>> From: freedc@gmail.com [mailto:freedc@gmail.com] On Behalf Of
>> Phil
>> Sent: 10 May 2010 13:53
>> To: mysql@lists.mysql.com
>> Subject: Re: Database tables for Ex
For the exchange rates only you don't really need more than one table. I
work with an enterprise financial system and we have exchange rate tables
which are updated with data every day.
Something like
BASE_CURR char(3)
NONBASE_CURR char(3)
EFF_DATE DATE
EXCH_RATE DECIMAL(15,6)-- or however
Ken D'Ambrosio wrote:
Hey, all. I've been using databases clear back to xBase days; that being
said, I've never had a solid foundation for relational databases. While I
can muddle by in SQL, I really don't have a good understanding of exactly
how keys are set up, the underpinnings of indexing,
Hey, all. I've been using databases clear back to xBase days; that being
said, I've never had a solid foundation for relational databases. While I
can muddle by in SQL, I really don't have a good understanding of exactly
how keys are set up, the underpinnings of indexing, and, oh, lots of
gro
I have two of Paul's books. They are both fantastic.
Mike O'Krongli
President and CTO
Acorg Inc
519 432-1185
- Original Message -
From: "Claudio Nanni"
To: "Ken D'Ambrosio"
Cc: "mysql"
Sent: Monday, December 28, 2009 10:33 AM
Subject:
Ken,
So, any suggestions -- books, courses, web sites, what-have-you -- that I
should be hitting up so I can have a better grasp of what's going on
behind the scenes?
http://dev.mysql.com/doc/refman/5.5/en/tutorial.html
Start at top left and work your way downwards & rightwards at
http://www
Hi Ken,
thanks for sharing!
If you want to start from scratch, I would go for a book like this:
http://www.amazon.com/SQL-Complete-Reference-James-Groff/dp/0071592555/ref=dp_ob_title_bk
I did not 'read' it thru, but this is the one I would buy.
If you want to embrace MySQL, in my opinion, the bes
>-Original Message-
>From: AndrewJames [mailto:andrewhu...@gmail.com]
>Sent: Saturday, September 12, 2009 1:20 AM
>To: Kyong Kim; Arthur Fuller
>Cc: Claudio Nanni; mysql
>Subject: Re: database design
>
>thank you all, i think
>
>"You probably wouldn&
directly."
>
> is my answer.
>
>
> --
> From: "Kyong Kim"
> Sent: Saturday, September 12, 2009 8:22 AM
> To: "Arthur Fuller"
> Cc: "Claudio Nanni" ; "AndrewJames"
> ; "mysql"
> Subject: Re:
Storing it directly will cause problems when you want to add a new Article
Type. IMO it's better to have an ArticleTypes table (AutoIncrement) and
store its values in the ArticleTypeID column in the Articles table.
A.
On Sat, Sep 12, 2009 at 1:19 AM, AndrewJames wrote:
> thank you all, i think
>
epter aucune responsabilité pour
le contenu fourni.
> Date: Fri, 11 Sep 2009 15:22:57 -0700
> Subject: Re: database design
> From: kykim...@gmail.com
> To: fuller.art...@gmail.com
> CC: claudio.na...@gmail.com; andrewhu...@gmail.com; mysql@lists.mysql.com
> > A) You
;Arthur Fuller"
Cc: "Claudio Nanni" ; "AndrewJames"
; "mysql"
Subject: Re: database design
A) You would probably want to populate the Article.Article_Type column
with Article_Type.ID. You probably wouldn't need Article_Type table if
you're going
A) You would probably want to populate the Article.Article_Type column
with Article_Type.ID. You probably wouldn't need Article_Type table if
you're going to store Article_Type value directly.
I would also consider the use of natural primary key vs surrogate
primary key. We've seen good results wi
I agree with Claudio. You have your design correct. The only other thing you
need is the uid qualifier. Presumably you are using PHP or some other front
end to present your data. Your front end would request the user's name and
password, saving the uid in a variable and then issuing the select with
A.J., It sounds good to me!
You can be a little confused but you did it well,
It seems you have all you need there.
A) Yes
B) select * from articles A left join article_types AT on A.article_type =
AT.article_types_id
Claudio
2009/9/11 AndrewJames
> This is a bit of a long shot, but i real
john.l.me...@gmail.com
Sent: Friday, September 04, 2009 6:09 PM
Subject: RE: Database design - help
> given the following table layouts
URLs:> URL_ID (primary key for URL)> URL_TEXT>> URL_CATEGORY> URL_ID
(key which points to URL.URL_ID)> CATEGORY_ID (key which
lworld.com ; mysql@lists.mysql.com
Cc: john.l.me...@gmail.com
Sent: Friday, September 04, 2009 6:09 PM
Subject: RE: Database design - help
> given the following table layouts
> URLs:> URL_ID (primary key for URL)> URL_TEXT>> URL_CATEGORY> URL_ID
> (key which
Thanks
Not sure how I'm reading this, but shouldn't the URL be linked to SubCategory
?
- Original Message -
From: Martin Gainty
To: bobsh...@ntlworld.com ; mysql@lists.mysql.com
Cc: john.l.me...@gmail.com
Sent: Friday, September 04, 2009 6:09 PM
Subject: RE
n seulement et n'aura pas n'importe
quel effet légalement obligatoire. Étant donné que les email peuvent facilement
être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité
pour le contenu fourni.
> From: bobsh...@ntlworld.com
> To: mysql@lists.mysql.com
&
helpful to me.
cheers
- Original Message -
From: "John Meyer"
To: "BobSharp"
Cc:
Sent: Monday, August 31, 2009 4:56 PM
Subject: Re: Database design - help
BobSharp wrote:
As a complete newbie in MySQL, I need a database
to store URLs related to Tenpin Bowling
BobSharp wrote:
As a complete newbie in MySQL, I need a database
to store URLs related to Tenpin Bowling.
There are several Categories ... Equipment Manufacturers,
Organistations, (UK) ProShops, (UK) Bowling Centres, Personal
Websites, Misc., Coaching & Instructional websites, etc.
There
Hi guys,
the easiest is to use MySQL Migration Toolkit, I've sucessfuly used it
with SQL Server (2000 and 2008) and Oracle 9i, all with simple
structures and simple data, but worked VERY well...
Regards,
Bruno B. B. Magalhães
Sócio-Diretor de Negócios e Tecnologia
BLACKBEAN CONSULTORIA
Rua
At 06:28 AM 3/24/2009, you wrote:
Hello @all.
I`ve got the question how mysql will have to be set up, that it can handle
round about 7.000.000 records most efficiently.
What do you think about the the hard and software requirements in order to
match the best combination?
The data will com
Hi Andrew,
You can do this with MySQL Administrator, but you have to look for
Catalogs in the left pane. After that right click in the bottom part of
the left pain and select 'Create Schema'. Provide a database name and
click on ok. That should do the trick.
Arjan
On Sun, 2008-09-21 at 21:26 -0
I would like to create my first mysql database. Is there a gui tool that
makes this easy to do?
Thanks,
Andrew
Try Toad - http://toadsoft.com/toadmysql/mysql_freeware.htm
This e-mail, including any attachments, may be confidential, privile
On Thu, 7 Aug 2008, [EMAIL PROTECTED] wrote:
Hello
I would like to create my first mysql database. Is there a gui tool that makes
this easy to do?
http://dev.mysql.com/downloads/gui-tools/5.0.html
-d
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscri
assuming this is for books/pages to be displayed on line...
how about if you just keep just important stuff in mysql
like chapter titles and how many pages the book has, author, edition,
etc
then you keep files for each page (or book) in the filesystem - xml,
txt, etc - and you just make a p
Can you send us the exact zabbix error?
On Sun, Apr 27, 2008 at 6:18 PM, Sergio Belkin <[EMAIL PROTECTED]> wrote:
> So anyone had ever had any problem with database cache? :)
>
> 2008/4/25 Sergio Belkin <[EMAIL PROTECTED]>:
>
>
> > Hi, I am using zabbix (monitoring software) with mysql. zabbix go
So anyone had ever had any problem with database cache? :)
2008/4/25 Sergio Belkin <[EMAIL PROTECTED]>:
> Hi, I am using zabbix (monitoring software) with mysql. zabbix goes
> zombie and complains with messages suggesting that Database cache
> perhaps is corrupted. How can I check and fix it?
Hi Paul,
You need to set up replication. Check
http://dev.mysql.com/doc/refman/5.0/en/replication.html
-Raj.
-Original Message-
From: Paul Ikanza [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 08, 2008 1:05 PM
To: 'mysql@lists.mysql.com'
Subject: Database Synchronisation Methods
Hi
> > Searching on-line is surprisingly unhelpful; the only things I've found
so
> > far which looks half-sensible are "Database is Depth" by Chris Date, and
> > "Expert mySQL" by Charles A. Bell (which looks more practical rather
than
> > theoretical).
>
> I have that book by Date. Heavy on theory
At 08:54 AM 1/16/2008, Baron Schwartz wrote:
On Jan 16, 2008 9:40 AM, Toby Douglass <[EMAIL PROTECTED]> wrote:
> I'm currently applying for a developer job with mySQL.
>
> I want to improve my database theory knowledge.
>
> Any book recommendations?
>
> Searching on-line is surprisingly unhelpful
On Jan 16, 2008 9:40 AM, Toby Douglass <[EMAIL PROTECTED]> wrote:
> I'm currently applying for a developer job with mySQL.
>
> I want to improve my database theory knowledge.
>
> Any book recommendations?
>
> Searching on-line is surprisingly unhelpful; the only things I've found so
> far which loo
Not necessarily theory but very good if you want to work with mysql is the
mysql 5.0 certification guide
olaf
On 1/16/08 9:40 AM, "Toby Douglass" <[EMAIL PROTECTED]> wrote:
> I'm currently applying for a developer job with mySQL.
>
> I want to improve my database theory knowledge.
>
> Any boo
I know now how to reply to all mail list
On Jan 2, 2008 9:53 PM, Luis Motta Campos <[EMAIL PROTECTED]>
wrote:
> Hey there
>
> I have a not-so-big (50GB, including indexes) database (MySQL 4.0.24,
> mixed MyISAM and InnoDB tables) that I need to migrate to a MySQL 5.1
> Master + Slave Replication
Can you say "codefendant"?
David T. Ashley
[EMAIL PROTECTED]
(This e-mail was sent from a
handheld wireless device.)
On Jan 2, 2008, at 5:20 PM, "Daevid Vincent" <[EMAIL PROTECTED]> wrote:
Do it anyways. Release it as Open Source. IBM is big into the FO
Do it anyways. Release it as Open Source. IBM is big into the FOSS
community, and I seriously doubt they will persue this.
Just because they have a patent, you can always build a better mouse trap.
You are allowed to improve upon an idea that is patented, or do it a
slightly different way the pate
Hi Luis,
On Jan 2, 2008 11:12 AM, Luis Motta Campos <[EMAIL PROTECTED]> wrote:
> Baron Schwartz wrote:
> > On Jan 2, 2008 10:04 AM, Luis Motta Campos wrote:
> >> Baron Schwartz wrote:
> >>> What are the biggest changes you anticipate? I'd say they will be
> >>> the version upgrade, converting to
Baron Schwartz wrote:
> On Jan 2, 2008 10:04 AM, Luis Motta Campos wrote:
>> Baron Schwartz wrote:
>>> What are the biggest changes you anticipate? I'd say they will be
>>> the version upgrade, converting to InnoDB, and using
>>> replication. It looks like you have planned well for all but
>>> u
Hi,
On Jan 2, 2008 10:04 AM, Luis Motta Campos <[EMAIL PROTECTED]> wrote:
> Baron Schwartz wrote:
> > What are the biggest changes you anticipate? I'd say they will be the
> > version upgrade, converting to InnoDB, and using replication. It
> > looks like you have planned well for all but using
Baron Schwartz wrote:
> What are the biggest changes you anticipate? I'd say they will be the
> version upgrade, converting to InnoDB, and using replication. It
> looks like you have planned well for all but using replication.
That's interesting. What kind of activities (besides configuration,
Hi Luis,
On Jan 2, 2008 8:53 AM, Luis Motta Campos <[EMAIL PROTECTED]> wrote:
> Hey there
>
> I have a not-so-big (50GB, including indexes) database (MySQL 4.0.24,
> mixed MyISAM and InnoDB tables) that I need to migrate to a MySQL 5.1
> Master + Slave Replication server, with InnoDB tables only,
Hi,
On Dec 29, 2007 5:28 PM, Kugel,Miriam <[EMAIL PROTECTED]> wrote:
> I am thinking to write a database cleanup tool.
> According to my research they are many application specific database
> cleaners but not a general one.
>
> I found a patent:
> US Patent Number *07188116* - METHOD AND APPARATU
It certainly seems that 5.0.44 and 5.0.45 are unstable. I have logged
this as bug http://bugs.mysql.com/bug.php?id=31008
A 64-bit Gentoo Linux box had just been upgraded from MySQL 4.1 to
5.0.44 fresh (by dumping in 4.1 and restoring in 5.0.44) and almost
immediately after that, during which t
Thank you for your replies. I attempted to restore again and most
oddly, mysql complained that it couldn't restore to a particular
table because it wasn't in the database, which, of course, it had to
be because the restore itself had just recreated it. So I blew away
the entire mysql directory
The checksum errors might be due to various reasons. We had similar issue
where we restored the database multiple times, replaced the ram sticks
nothing helped. Finally we drilled down the issue to the chassis. Recommend
testing the restore on a different machine to rule out any hardware issue.
--
Hi
This might be happening due to two reasons;
1 The system date might not be correct.
2. Some things wrong with log postion (Incorrect log position)
Regards,
Krishna Chandra Prajapati
On 8/31/07, Maurice Volaski <[EMAIL PROTECTED]> wrote:
>
> A 64-bit Gentoo Linux box had just been upgraded from
I concur. Also it makes it easier to remove a customer if they leave.
Finally your backups will only lock up one customer's database at time and
for a much shorter period.
On Thu, August 23, 2007 10:50, Jerry Schwartz said:
> Personally, I think I'd go with one DATABASE per customer. That way th
Personally, I think I'd go with one DATABASE per customer. That way the your
code would be the same, and easier to handle. It would be easier to manage
the security at the database level, I suspect. I'd set up a ../inc directory
outside the web server root that would have one file per customer, and
On 8/23/07, Jason Pruim <[EMAIL PROTECTED]> wrote:
>
>
> > b)Terminating TCP connections and ensuring that each PHP script
> > runs to
> > completion, anyway, and that the database isn't left in an
> > indeterminate
> > state due to this.
> >
> > Dave.
>
> What do you mean by "b"? If all the connec
On Aug 23, 2007, at 11:50 AM, David T. Ashley wrote:
On 8/23/07, Jason Pruim <[EMAIL PROTECTED]> wrote:
I am planning on having the database open to customers of mine to
store their mailing addresses on-line, and be able to manage the
records.
Is it safe, to have 1 database with lots of tabl
On Aug 23, 2007, at 11:28 AM, Rolando Edwards wrote:
Think about how your going to make backups.
1) Would you backup one database with all the mailing lists together ?
If I went the route of 1 database, Many tables, I would just backup
the entire database and all the tables in one shot. Un
On Aug 23, 2007, at 11:44 AM, Gary Josack wrote:
I'd never have a separate database for everyone or even a separate
table for everyone. Here's a rough idea of how I'd do it
mysql> CREATE TABLE customer (
-> `custid` INT NOT NULL AUTO_INCREMENT,
-> `lastname` VARCHAR(25) not null,
->
On 8/23/07, Jason Pruim <[EMAIL PROTECTED]> wrote:
>
> I am planning on having the database open to customers of mine to
> store their mailing addresses on-line, and be able to manage the
> records.
>
> Is it safe, to have 1 database with lots of tables? Or am I safer
> setting up separate database
I'd never have a separate database for everyone or even a separate table
for everyone. Here's a rough idea of how I'd do it
mysql> CREATE TABLE customer (
-> `custid` INT NOT NULL AUTO_INCREMENT,
-> `lastname` VARCHAR(25) not null,
-> `firstname` VARCHAR(25) NOT NULL,
-> PRIMARY KEY(
Think about how your going to make backups.
1) Would you backup one database with all the mailing lists together ?
2) Would you keep the backups of each user separate ?
3) Could users ask you to restore mailing lists from the past ?
You could make one mysqldump for everybody from one database if
Thanks for the leads. I'll double check my indices and check out the
following links.
> http://dev.mysql.com/doc/refman/5.0/en/server-parameters.html
> http://dev.mysql.com/doc/refman/5.0/en/innodb-tuning.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To u
for all your helps
T. Hiep
-Original Message-
From: Mogens Melander [mailto:[EMAIL PROTECTED]
Sent: Monday, July 02, 2007 3:45 PM
To: mysql@lists.mysql.com
Subject: Re: database structure
On Mon, July 2, 2007 21:10, Hiep Nguyen wrote:
take your advice, i looked in to JOIN and i got
: Mogens Melander [mailto:[EMAIL PROTECTED]
Sent: Monday, July 02, 2007 3:45 PM
To: mysql@lists.mysql.com
Subject: Re: database structure
On Mon, July 2, 2007 21:10, Hiep Nguyen wrote:
>
> take your advice, i looked in to JOIN and i got the idea. but i noticed
> that in order to use JOIN,
At 2:45 PM +1000 7/3/07, Daniel Kasak wrote:
On Mon, 2007-07-02 at 21:19 -0700, Ed Lazor wrote:
I have a 400mb database. The first query to tables takes about 90 seconds.
Additional queries take about 5 seconds. I wait a while and run a query
again; it takes about 90 seconds for the first
On Mon, 2007-07-02 at 21:19 -0700, Ed Lazor wrote:
> I have a 400mb database. The first query to tables takes about 90 seconds.
> Additional queries take about 5 seconds. I wait a while and run a query
> again; it takes about 90 seconds for the first one and the rest go quickly.
> I'm guessing d
1 - 100 of 611 matches
Mail list logo
