On Tue, 23 Jun 2015 14:51:48 -0400, you wrote:
>
>
>On 6/23/2015 10:59 AM, Steve Matzura wrote:
>> I'm building a mail system with Dovecot, Postfix and Mailman with
>> MySQL. I have the other three products installed but not yet
>> configured. I'll do that after I get MySQL running.
>>
>> The docu
On 6/23/2015 10:59 AM, Steve Matzura wrote:
I'm building a mail system with Dovecot, Postfix and Mailman with
MySQL. I have the other three products installed but not yet
configured. I'll do that after I get MySQL running.
The documentation at
http://dev.mysql.com/doc/mysql-repo-excerpt/5.6/en
Hi Steve,
you haven't said what OS you are installing this on or how you have
installed MySQL. Normally you would use a version avaialable in your
OS distribution as this avoids any overly complicated installation and
will manage security and bug patches for you MySQL binaries. Ie
insta
I'm building a mail system with Dovecot, Postfix and Mailman with
MySQL. I have the other three products installed but not yet
configured. I'll do that after I get MySQL running.
The documentation at
http://dev.mysql.com/doc/mysql-repo-excerpt/5.6/en/linux-installation-yum-repo.html
was instrument
changed. If you want to store a
specific value you should use a datetime field."
http://stackoverflow.com/questions/409286/datetime-vs-timestamp
As a more general rule of thumb, use DATETIME unless you have a specific
application for which you know that TIMESTAMP is more appro
r any time in that hour I give. This makes me
>> think that I have not actually solved the problem for next year (I
>> can't test this to know).
>>
>> So my questions are:
>>
>> 1) How can I actually insert a timestamp value that will not be
>> affected by
ime in that hour I give. This makes me
> think that I have not actually solved the problem for next year (I
> can't test this to know).
>
> So my questions are:
>
> 1) How can I actually insert a timestamp value that will not be
> affected by the time change and not have the missi
time in that hour I give. This makes me
think that I have not actually solved the problem for next year (I
can't test this to know).
So my questions are:
1) How can I actually insert a timestamp value that will not be
affected by the time change and not have the missing hour?
2) Why is it not
On 17-03-2014 16:21, Mister Vlad wrote:
I am looking at building a dedicated MySQL server... was wondering about the
downside to using SSD drives?
My thoughts was going 2 servers, with 4 drives each in raid 5 (3+1)
configuration.
Is this a good idea? I was originally thinking about going Raid
I am looking at building a dedicated MySQL server... was wondering about the
downside to using SSD drives?
My thoughts was going 2 servers, with 4 drives each in raid 5 (3+1)
configuration.
Is this a good idea? I was originally thinking about going Raid5(3+1) and
Raid 1 (Mirrored) but that mig
Hi!
> "Ed" == Ed L writes:
Ed> Mysql newbie here, looking for some help configuring 5.0.45 master-slave
Ed> replication. Here's my scenario...
Ed> We have a heavily loaded 30gb 5.0.45 DB we need to replicate via
Ed> master-slave configuration to a new, beefier server running same mysql
if i u have LVM's then lock is held only for the duration of taking
snapshot, which would be few min, if there is very less activity on the db.
On Wed, Aug 28, 2013 at 3:08 PM, Ed L. wrote:
> On 8/28/13 2:00 PM, Ananda Kumar wrote:
>
>
> Why don't u try snapshot backups, where the lock held fo
On 8/28/13 2:00 PM, Ananda Kumar wrote:
Why don't u try snapshot backups, where the lock held for less
duration. Or can't u take mysql dumps during Night time when there is
less bd activity
I neglected to mention these systems are both CentOS linux systems.
Unfortunately, the 5.5 hour dumps
Why don't u try snapshot backups, where the lock held for less duration. Or
can't u take mysql dumps during Night time when there is less bd activity
On Thursday, August 29, 2013, Ed L. wrote:
>
> Mysql newbie here, looking for some help configuring 5.0.45 master-slave
replication. Here's my sce
Mysql newbie here, looking for some help configuring 5.0.45 master-slave
replication. Here's my scenario...
We have a heavily loaded 30gb 5.0.45 DB we need to replicate via
master-slave configuration to a new, beefier server running same mysql
5.0.45, and then cutover to the new server. Du
, then pay whatever the price is.
"If you hit a MySQL limit, you are probably mis-using MySQL."
> -Original Message-
> From: Paul Halliday [mailto:paul.halli...@gmail.com]
> Sent: Friday, January 04, 2013 5:12 AM
> To: mysql mailing list
> Subject: questions a
On Fri, Apr 6, 2012 at 2:46 PM, shawn green wrote:
> On 4/5/2012 3:14 PM, Wes Modes wrote:
>>
>> No one here has any experience with it?
We use the proxy between master/slaves for the last 3 years. I didn't
implement it, but I look after it. I'm just about to switch to 0.8.2,
but the only real
On 4/5/2012 3:14 PM, Wes Modes wrote:
No one here has any experience with it?
...
Probably not. If you notice the version number for MySQL Proxy still
starts with a "0." which the universally accepted indicator that it is
of pre-production quality. Thanks to the corporate changes of the las
No one here has any experience with it?
W.
On 4/4/2012 2:17 PM, Claudio Nanni wrote:
> Wes,
> Thanks for these questions about this 'ghost' of the MySQL world, it
> seems more a legend than a real thing!
> I am sorry I do not have the answers but I would love to hear some
Wes,
Thanks for these questions about this 'ghost' of the MySQL world, it seems
more a legend than a real thing!
I am sorry I do not have the answers but I would love to hear some.
All I can say is that MySQL Proxy is currently (still) in Alpha
http://dev.mysql.com/downloads/mysql-pr
or u can use "for loop", have only the database to be exported and use that
variable in --database and do mysqldump of each database.
On Thu, Sep 15, 2011 at 6:27 PM, Carsten Pedersen wrote:
> On 15-09-2011 10:31, Chris Tate-Davies wrote:
>
>> Adarsh,
>>
>> 1)
>>
>> When restoring a mysqldump you
On 15-09-2011 10:31, Chris Tate-Davies wrote:
Adarsh,
1)
When restoring a mysqldump you have the option of which database to
restore.
mysql database1 < backup.sql
Admittedly, it's been a few years since I last used mysqldump, but I
suspect that it will contain USE commands - as such, it wil
Adarsh,
1)
When restoring a mysqldump you have the option of which database to restore.
mysql database1 < backup.sql
2)
You might be able to use the --ignore-table command. I'm not sure if
this would work
mysqldump --all-databases -q --single-transaction
--ignore-table=databasetoignore.*
Dear all,
Today i backup my all databases (25) by using the below command :-
mysqldump --all-databases -q --single-transaction | gzip >
/media/disk-1/Server11_MysqlBackup_15September2011/mysql_15sep2011backup.sql.gz
Now I have some doubts or problems that I need to handle in future :
1. Is
n, 1/17/11, Eric Bergen wrote:
From: Eric Bergen
Subject: Re: Innodb table space questions
To: "Angela liu"
Cc: mysql@lists.mysql.com
Date: Monday, January 17, 2011, 10:09 PM
reply inline
On Mon, Jan 17, 2011 at 9:30 PM, Angela liu wrote:
> Folks :
>
> two questions:
>
>
reply inline
On Mon, Jan 17, 2011 at 9:30 PM, Angela liu wrote:
> Folks :
>
> two questions:
>
> 1. can Innodb create per database table space , not per table table space?
No. The only available options are creating a global tablespace which
can be many files or a file per tabl
Folks :
two questions:
1. can Innodb create per database table space , not per table table space?
2. can we store table on specific tablespace like Oracle or DB2 when creating
table?
Many thanks.
Absolutely. You don't want to obscure the cause by just throwing more
hardware at things.
That approach just buys you time until a bigger pile hits the fan if
the underlying issue remains unresolved.
At the same time, though, 8 MB production innodb buffer pool
allocation should be fairly high on th
On Wed, Jun 9, 2010 at 8:04 PM, Kyong Kim wrote:
> If the memory is available, why not use it? It seems like the default
> buffer pool size out of the box was just never changed.
Agreed, of course, but if something happens on a system that is out of
the ordinary, it's very good practice to hunt t
On Tue, Jun 8, 2010 at 10:57 PM, Machiel Richards wrote:
> Good morning all
>
>
>
> I would like to try and find out how you can see what is using the
> query cache.
>
>
>
> My reason for asking is the following:
>
>
>
> On one of our client databases, the quer
Good morning all
I would like to try and find out how you can see what is using the
query cache.
My reason for asking is the following:
On one of our client databases, the query cache is set to
128Mb and the usage always varied between 5% and 53%
-8388608 to 8388607
# SMALLINT SIGNED = -32768 to 32767
# TINYINT SIGNED = -128 to 127
# TINYTEXT = 255
# TEXT = 65535
# MEDIUMTEXT = 16777215
# LONGTEXT = 4294967295
# TEXT fields are NOT case sensitive, whereas BLOB fields are.
# Always try to use UNSIGNED integers whenever possible.
Anyways
> -Original Message-
> From: Elim PDT [mailto:e...@pdtnetworks.net]
> Sent: Monday, March 29, 2010 5:57 PM
> To: mysql@lists.mysql.com
> Subject: timezone questions
>
> data from one server in timezone A ported to another server
> in timezone B, what will hap
data from one server in timezone A ported to another server in timezone B,
what will happen for the records with datetime columns?
What is the recommended way of handling this kind of issues? Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
2010/1/3 Ashley Sheridan :
> On Sun, 2010-01-03 at 15:10 +0800, Edward S.P. Leong wrote:
>
>> Dear All,
>>
>> If the OS is Windows 2003 64Bit (IIS)...
>> So, which php package must download and how to config it for running
>> with IIS ?
>> Due to I don't quite the online manual:
>> http://www.php.n
On Sun, Jan 3, 2010 at 08:10, Edward S.P. Leong wrote:
> Dear All,
>
> If the OS is Windows 2003 64Bit (IIS)...
> So, which php package must download and how to config it for running
> with IIS ?
> Due to I don't quite the online manual:
> http://www.php.net/manual/en/install.windows.iis.php
> Whi
There are instructions on the Microsoft IIS site on installing php as
well. http://php.iis.net/
Bilal
On Sun, 2010-01-03 at 14:15 +, Ashley Sheridan wrote:
> On Sun, 2010-01-03 at 15:10 +0800, Edward S.P. Leong wrote:
>
> > Dear All,
> >
> > If the OS is Windows 2003 64Bit (IIS)...
> > So, w
Dear All,
If the OS is Windows 2003 64Bit (IIS)...
So, which php package must download and how to config it for running
with IIS ?
Due to I don't quite the online manual:
http://www.php.net/manual/en/install.windows.iis.php
Which installation mode is suitable of it ?
Thanks !
Edward.
--
MySQL
We are looking to install on windows.
Sent from my iPod
On 11 Oct 2009, at 18:02, muhammad subair wrote:
Hi,
Maybe, first you can check MySQL documentation [0], [1]
[0] http://dev.mysql.com/doc/refman/5.0/en/secure-using-ssl.html
[1] http://dev.mysql.com/doc/refman/5.0/en/secure-basics.htm
Hi,
Maybe, first you can check MySQL documentation [0], [1]
[0] http://dev.mysql.com/doc/refman/5.0/en/secure-using-ssl.html
[1] http://dev.mysql.com/doc/refman/5.0/en/secure-basics.html
--
Muhammad Subair
On Thu, Oct 8, 2009 at 6:03 PM, Tompkins Neil
wrote:
> Hi
>
> I wondered how you are ge
Try the tutorial:
http://dev.mysql.com/doc/refman/5.0/en/tutorial.html
Regards,
Gavin Towey
-Original Message-
From: John Oliver [mailto:joli...@john-oliver.net]
Sent: Thursday, October 08, 2009 2:19 PM
To: mysql@lists.mysql.com
Subject: Some MySQL questions
1) When I select * from
On Thu, Oct 08, 2009 at 02:33:34PM -0700, Carlos Proal wrote:
> On 10/8/2009 4:19 PM, John Oliver wrote:
> > 1) When I select * from whatever; is there a way to have the results go
> > by one screen at a time?
> >
>
> You can limit output by delimiting your search ie
>
> select * from users li
On 10/8/2009 4:19 PM, John Oliver wrote:
1) When I select * from whatever; is there a way to have the results go
by one screen at a time?
You can limit output by delimiting your search ie
select * from users limit x,y;
x=offset
y=rows after the ofset
2) In reference to the above, is ther
1) When I select * from whatever; is there a way to have the results go
by one screen at a time?
2) In reference to the above, is there a way to just display the row
that shows the names of each column?
I need to drop one row from a table with a few thousand rows. I
guessing I want to:
delete f
Hi
I wondered how you are getting on with installing SSL for mysql 5.1 server.
We are looking to install it too. Do you have any pointers/recommendations
?
Regards
Neil
On Tue, Sep 8, 2009 at 11:36 PM, qt4x11 wrote:
> I'm trying to set up my mysql 5.1 server to work over ssl, I'm following
>
And an answer to 2): http://www.maatkit.org/doc/mk-query-digest.html
On Tue, Oct 6, 2009 at 02:59, Brown, Charles wrote:
> Questions Folks:
> (1) What do you about un-index searches. How can one report and monitor them?
> (2) What do you do with the slow-query log. Are there any uti
Meyer; Mark Phillips
Subject: Questions on un-index searches and slow-query-log
Questions Folks:
(1) What do you about un-index searches. How can one report and monitor them?
(2) What do you do with the slow-query log. Are there any utilities or scripts
out there to filter and manage this log
Questions Folks:
(1) What do you about un-index searches. How can one report and monitor them?
(2) What do you do with the slow-query log. Are there any utilities or scripts
out there to filter and manage this log?
Thanks
This message is
donné que les email
> peuvent facilement être sujets à la manipulation, nous ne pouvons accepter
> aucune responsabilité pour le contenu fourni.
>
>
>
>
>
>
> > Date: Sat, 3 Oct 2009 18:11:59 -0600
> > From: john.l.me...@gmail.com
> > To: m...@phillipsmarketi
Mark Phillips wrote:
On Sat, Oct 3, 2009 at 3:06 PM, Martin Gainty wrote:
depends on the relationship of the Data Tables and the Users that use them
for instance if I was to setup a table of outgoing calls from 2 distinct
individuals :
Me> calls to HarvardMedicalSchoo
On Sat, Oct 3, 2009 at 4:02 PM, John Meyer wrote:
>
> John,
>> Thanks. The data is private to each user; there is no sharing of data. I
>> am not sure what you mean by "are the actions related" Each user is
>> reading/writing independently of each other. Would that argue for separate
>> database
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
John,
Thanks. The data is private to each user; there is no sharing of data.
I am not sure what you mean by "are the actions related" Each user is
reading/writing independently of each other. Would that argue for
separate databases?
Mark
Are the actions of a similar nature (i.e. they're
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 where a users login from their mobile
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 where a users login from their mobile phones and
read/write data to a database. Say there are roughly 1
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 where a users login from their mobile phones and
read/write data to a database. Say there are roughly 10-15 tables in the
data
I'm trying to set up my mysql 5.1 server to work over ssl, I'm following the
directions at http://dev.mysql.com/doc/refman/5.0/en/secure-connections.html.
I've confirmed that my server supports ssl
mysql> SHOW VARIABLES LIKE 'have_ssl';
+---+---+
| Variable_name | Value |
+---
We outputted the bin log using the following command:
mysqlbinlog -v --base64-output=DECODE-ROWS oo-mysql1-bin.87
We then looked in this file and found some odd things. For example
there is the below insert statement:
### INSERT INTO panel.history
### SET
### @1=-182667600 (4112299696)
##
>
>
> If you are finding replication stops after a reboot then I think you have a
> serious problem, but don't know what that might be. Post some more info and
> someone on the list can probably help,
>
> just a 'skip-slave-start' in my.cnf does the trick.
2> Is there a way to get a slave to auto
BTW there is a list specially dedicated to replication configurations:
http://lists.mysql.com/replication
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
:S
Hi Bryan
Actually changing the slave setup after a reboot is a very bad
idea, you will have inconsistent data on your slave because every
transaction made from when you rebooted the server to when you reset
the position will not be copied from the master. Thats the point of
the posi
The information is there and the replica can connect on a reboot but
only if that information has not changed correct?
e.g. I reboot the slave, and on the master just run "reset master;"
the bin.01 could change to bin.02 and the pos change from 98
to 15443 or some such. If I do that do I
When you start up replication the data should be recorded in the
master.info in your data dir.
[r...@someserver ~]# cat /var/lib/mysqldata/master.info
14
MASTERHOST-bin.01
MASTERPOS
192.168.0.2
REPLICATION_USER
REPLICATION_PASSWORD
3306
60
0
I am not familiar with any setups where the master.
Do I jsut need to monitor better and manually add it should the log
and pos change?
-Bryan
On Wed, Mar 11, 2009 at 7:05 PM, Baron Schwartz wrote:
> That's deprecated too :-)
>
> On Wed, Mar 11, 2009 at 9:17 PM, Cui Shijun wrote:
>> hi,
>> #2. try adding the information of master into my.cnf t
That's deprecated too :-)
On Wed, Mar 11, 2009 at 9:17 PM, Cui Shijun wrote:
> hi,
> #2. try adding the information of master into my.cnf then restart the
> server.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?un
hi,
#2. try adding the information of master into my.cnf then restart the server.
thanks
2009/3/12 Bryan Irvine :
> I've got 2 questions about my newly set up master->slave replica.
>
> 1> When I run "load data from master;" I get an error that I do not
> h
On Wed, Mar 11, 2009 at 4:03 PM, Bryan Irvine wrote:
>
> I've got 2 questions about my newly set up master->slave replica.
>
> 1> When I run "load data from master;" I get an error that I do not
> have RELOAD privileges and then it boots the slave offline.
&g
I've got 2 questions about my newly set up master->slave replica.
1> When I run "load data from master;" I get an error that I do not
have RELOAD privileges and then it boots the slave offline.
I've run GRANT SELECT, PROCESS, FILE, SUPER, REPLICATION CLIENT,
REPLICATI
Robert,
I know you have had other answers, but as to the database name, yes, you can
remove the CREATE DATABASE statement and change the USE statement to the
right database name.
N.B. In our environment the students have only one database each, and will
install blogs and wiki's etc. using that one
then: dump, import locally, rename and dump again. Still feels a bit
safer then parsing though it might be a bit more work.
OlinData: Professional services for MySQL
Support * Consulting * Administration
http://www.olindata.com
On Sun, Feb 1, 2009 at 9:42 PM, Robert D. Crawford wrote:
> Walter
Walter Heck writes:
> Might be a bit late,
Better late than never.
> but on the naming issue: why not rename the tables on the old database
> before doing the dump? that would save you from potentially messing
> with your data due to parsing problems.
A good idea, but it wouldn't have worked
Might be a bit late, but on the naming issue: why not rename the
tables on the old database before doing the dump? that would save you
from potentially messing with your data due to parsing problems.
Just a thought :)
Walter
OlinData: Professional services for MySQL
Support * Consulting * Admini
Olaf Stein writes:
> I think he only has one DB, I guess that is a provider restriction...
True. I would create a separate db for each application if I could.
rdc
--
Robert D. Crawford rd...@comcast.net
--
MySQL General Mailing List
For list archives:
I think he only has one DB, I guess that is a provider restriction...
On 1/30/09 8:52 AM, "Claudio Nanni" wrote:
> Robert,
>
> keep the two databases separated,
>
> that is on different mysql database (or schema as they are also called).
>
> If the wordpress blog is on a database named 'wpbl
Robert,
keep the two databases separated,
that is on different mysql database (or schema as they are also called).
If the wordpress blog is on a database named 'wpblog' for example
import your dump in another newly created database.
Could just use those statement in the dump file
CREATE DATAB
Hello, Olaf,
"Stein, Olaf" writes:
> the import of the dump will not remove your other tables unless there
> is a naming conflict, then the table will be overwritten. As far as
> the prefix goes you can edit the dump file, find the create table
> statement for each table and add the prefix. If y
: mysql@lists.mysql.com
Subject: questions about merging
Hello all,
I hope I get the terminology right. I am not sure merge is what I want,
so let me describe what I need.
I have a sql dump from a db that is a mediawiki. I cannot upgrade the
software on the old server and need to move it to a
Hello all,
I hope I get the terminology right. I am not sure merge is what I want,
so let me describe what I need.
I have a sql dump from a db that is a mediawiki. I cannot upgrade the
software on the old server and need to move it to a new server. I have
only one db available to me on the new
command line level
--
Jacques Brignon
> -Message d'origine-
> De : mik...@qualityadvantages.com [mailto:mik...@qualityadvantages.com]
> Envoyé : samedi 13 décembre 2008 15:13
> À : mysql@lists.mysql.com
> Objet : MediumBlob / phpMyAdmin / hex dumps Questions
>
>
Hello and Greetings mysql list,
A few weeks ago, I posted a question here about importing a database
to my local XP pro system and getting loads of MySQL server went away
errors during the import. I got suggestions about increasing max
packet size and a few other parameters which I followed but st
query.
>
>
> >
> > On 9/17/08, Bard Aase <[EMAIL PROTECTED]> wrote:
> >>
> >> On Wed, Sep 17, 2008 at 11:54 AM, Uwe Kiewel <[EMAIL PROTECTED]>
> wrote:
> >> > Bard Aase schrieb:
> >> >> On Wed, Sep 17, 2008 at
rd Aase schrieb:
>> >> On Wed, Sep 17, 2008 at 11:37 AM, Uwe Kiewel <[EMAIL PROTECTED]>
>> >> wrote:
>> >>> Hi,
>> >>>
>> >>> I have two questions regarding the query cache:
>> >>>
>> >>> 1. What is the d
e <[EMAIL PROTECTED]> wrote:
>
> On Wed, Sep 17, 2008 at 11:54 AM, Uwe Kiewel <[EMAIL PROTECTED]> wrote:
> > Bard Aase schrieb:
> >> On Wed, Sep 17, 2008 at 11:37 AM, Uwe Kiewel <[EMAIL PROTECTED]>
> wrote:
> >>> Hi,
> >>>
>
On Wed, Sep 17, 2008 at 11:54 AM, Uwe Kiewel <[EMAIL PROTECTED]> wrote:
> Bard Aase schrieb:
>> On Wed, Sep 17, 2008 at 11:37 AM, Uwe Kiewel <[EMAIL PROTECTED]> wrote:
>>> Hi,
>>>
>>> I have two questions regarding the query cache:
>>>
&g
Bard Aase schrieb:
> On Wed, Sep 17, 2008 at 11:37 AM, Uwe Kiewel <[EMAIL PROTECTED]> wrote:
>> Hi,
>>
>> I have two questions regarding the query cache:
>>
>> 1. What is the difference between query_cache_limit and query_cache_size?
>
> query_cache_li
On Wed, Sep 17, 2008 at 11:37 AM, Uwe Kiewel <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have two questions regarding the query cache:
>
> 1. What is the difference between query_cache_limit and query_cache_size?
query_cache_limit is the maximum size of a single resultset in the
Hi,
I have two questions regarding the query cache:
1. What is the difference between query_cache_limit and query_cache_size?
mysql> show variables like '%query_cache%';
have_query_cache | YES |
query_cache_limit| 1048576 |
query_cache_min_res_un
On Thu, Aug 28, 2008 at 1:14 PM, Jose Estuardo Avila <[EMAIL PROTECTED]> wrote:
> My point is that on my process lists there are no writes being done at that
> time only reads and actually only one read all other reads are locked as
> well as writes.
Sure, that's because the reads are in line behi
My point is that on my process lists there are no writes being done at
that time only reads and actually only one read all other reads are
locked as well as writes. I've gone through every single one of the
queries in my processlist at any given time when more than 500 process
pile up and i
On Thu, Aug 28, 2008 at 10:59 AM, Jose Estuardo Avila
<[EMAIL PROTECTED]> wrote:
> I understand that reads are locked by writes but nowhere does of mention
> that reads also block reads.
How could they not? You can't simultaneously read and write the same
data -- the read would get half-written g
In the last episode (Aug 28), Jose Estuardo Avila said:
> On Aug 28, 2008, at 5:48 AM, "Perrin Harkins" wrote:
> > On Wed, Aug 27, 2008 at 8:21 PM, Jose Estuardo Avila wrote:
> >> Hi, I've been trying to find information on how myisam handles
> >> locks. I though myisam had locking only on writes a
I understand that reads are locked by writes but nowhere does of
mention that reads also block reads. Boy queries y posted to the list
are selects.
Jose E. Avila(tachu)
Yuku/Kickapps
Sent from mobile device.
On Aug 28, 2008, at 5:48 AM, "Perrin Harkins" <[EMAIL PROTECTED]> wrote:
On Wed,
On Wed, Aug 27, 2008 at 8:21 PM, Jose Estuardo Avila <[EMAIL PROTECTED]> wrote:
> Hi, I've been trying to find information on how myisam handles locks. I
> though myisam had locking only on writes and not on reads.
No, readers block writers. This true of any system that only has read
and write lo
Hi, I've been trying to find information on how myisam handles locks.
I though myisam had locking only on writes and not on reads. For some
reason and after a lot of digging i've been seeing that some
queries(albeit bad queries) cause other queries to hang even though
they are selects is th
Thanks!
Nanu
>>> <[EMAIL PROTECTED]> 23/08/2008 09:50:13 >>>
Whatever you name it
Wherever you place it
Mysqldump (options) > filename
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Whatever you name it
Wherever you place it
Mysqldump (options) > filename
--Original Message--
From: Nanu Kalmanovitz
Sender:
To: mysql@lists.mysql.com
Sent: Aug 22, 2008 23:48
Subject: mysqldump questions
Hi!
What is the name dumped file and where it is created?
System is :Nov
Hi!
What is the name dumped file and where it is created?
System is :Novell 6.5 sp6 - Apache 2, MySQL ver. 4.0.26, PHP 5.2.3.
TIA
Nanu
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
VeeJay wrote:
Hi there
I am going to make 2 Webserver at my work going to handle 50 mil hits per
month... They are using Linux already. But being a FreeBSD fan, I have
proposed MySQL and FreeBSD to my Boss convincing him that MySQL and FreeBSD
is more Fast and Secure solution for his needs... An
Hi Chaim
Contents are going to be dynamic...
I will go with Apache 2.2.9 and also PHP with ACP (accelator)
Any suggestions?
Regards
VJ
On Tue, Jul 22, 2008 at 10:18 PM, Chaim Rieger <[EMAIL PROTECTED]>
wrote:
> VeeJay wrote:
>
>> Hi there
>>
>> I am going to make 2 Webserver at my work going
Hi there
I am going to make 2 Webserver at my work going to handle 50 mil hits per
month... They are using Linux already. But being a FreeBSD fan, I have
proposed MySQL and FreeBSD to my Boss convincing him that MySQL and FreeBSD
is more Fast and Secure solution for his needs... And now I want to
1 - 100 of 914 matches
Mail list logo