15.02.2013 14:43, Johan De Meersman пишет:
- Original Message -
From: "Alex Keda"
mysql> SELECT SUM(`Amount`*`Cost`*(1-`Discont`)) as `Summ` FROM
`WorksCompliteAgregate` WHERE (`ContractID` = 10369 AND `Month` = 497);
Based off the select you printed, this comes to EX
15.02.2013 15:07, Alex Keda пишет:
OK. But, how about:
mysql> SELECT 365 * 1.67 * ( 1 - 0.10);
+--+
| 365 * 1.67 * ( 1 - 0.10) |
+--+
| 548.5950 |
+--+
1 row in set (0.00 sec)
mysql>
??
sorry, I'
bkp0# mysql h5000_bill
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1643184
Server version: 5.1.68-log FreeBSD port: mysql-server-5.1.68
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracl
On 2012/05/24 07:37, Alex Schaft wrote:
> You are selecting a record based on the value of data_id and
> thold_enabled, but don't have an index on either? Add an index for both.
> If data_id is unique, then you would only need an index on that.
>
> Alex
>
On seco
| thold_data | ALL | NULL | NULL | NULL|
> NULL | 6161 | Using where |
> ++-++--+---+--+-+--+--+-+
> 1 row in set (0.06 sec)
>
> If cache size tuning is not an option ,
> do you think that
index, it can lock the index, read all the data and
write all index keys in one go and then unlock the index.
If you make an omelet, do you fetch your eggs from the fridge one by
one, or all at the same time? :)
HTH,
Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
I suppose an easier way is to have a getrow function, Something like
while ($row = getrow($RS) {
.
.
.
}
function getrow($RS)
{
if ($current_server_is_mysql)
{
return mysql_fetch_assoc($RS);
}
els
On 2/14/2012 10:30 AM, cars...@bitbybit.dk wrote:
On 14.02.2012 10:20, Alex Schaft wrote:
Hi,
I need to update a table along the lines of the following
update table set LastUpdate=now(), UpdateSource='Abc' Where Key1 = 'Def'
and Key2 = 'ghi'
I need to possib
ch of these,
or should I do a batch INSERT with ON DUPLICATE KEY UPDATE?
Going to try both ways now, but was wondering what would be the best
"internally" my instincts tell me the latter.
Thanks,
Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
On 2012/02/09 01:40 PM, Johan De Meersman wrote:
- Original Message -
From: "Alex Schaft"
If I were to do a select count(*) from x where y prior to doing
select * from x where y to get a number of records, how would this impact
performance on the server itself? Would the firs
to do
the most processing, with the second one being faster, or would both
have to do the same amount of work?
Thanks,
Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
On 2011/10/21 10:26 AM, Johan De Meersman wrote:
- Original Message -
From: "Alex Schaft"
Got my app reading in a dump created with extended-inserts off, and
lumping all of the insert statements together. Works like a charm
Just for laughs, would you mind posting the on-di
On 2011/10/20 03:43 PM, Johan De Meersman wrote:
- Original Message -
From: "Alex Schaft"
I realize that, I'm just trying to stop the phone calls saying "I
started a restore, and my pc just froze"
I might just read all the single insert lines, and get a wh
On 2011/10/20 11:54 AM, Johan De Meersman wrote:
- Original Message -
From: "Alex Schaft"
I'm monitoring a mysqldump via stdout, catching the create table
commands prior to flushing them to my own text file. Then on the
restore side, I'm trying to feed these to mysq
On 2011/10/20 10:53 AM, Alex Schaft wrote:
What can I pass to mysqldump to get more sane statement lengths?
+1 for extended-inserts...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
,
but the lines are as much as 16k long in the text file times about 110
of those for one huge insert statement.
What can I pass to mysqldump to get more sane statement lengths?
Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists
On 2011/10/11 02:30 PM, Alex Schaft wrote:
On 2011/10/11 02:22 PM, Rik Wasmus wrote:
Just to clarify having key indexes of (a,b) or (b,a) have no
difference ?
They DO.
See it as lookup table which starts with 'a' in the first case, and
'b' in the
second one. Looki
On 2011/10/11 02:22 PM, Rik Wasmus wrote:
Just to clarify having key indexes of (a,b) or (b,a) have no difference ?
They DO.
See it as lookup table which starts with 'a' in the first case, and 'b' in the
second one. Looking for anything that matches 'b' for an index (a,b) requires
a full scan
If you have a table with columns A & B, and might do a where on A or B,
or an order by A, B, would single column indexes on A and B suffice or
would performance on the order by query be improved by an index on A,B?
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.co
the field to be cleared if the server loses the connection to
the client. How would I do this, or is there an alternative?
Thanks,
Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
On 2011/07/19 09:52 PM, andrewmchor...@cox.net wrote:
Hello
I am about to create a database in mysql. I would like to be able to import
some dbase3 (.dbf) files into the tables I will be defining. What is the
easiest way to import the table. Is there software that can be downloaded that
will
ize already, but I don't think it affects the current query.
What can I generally do to actually make this perform?
Thanks,
Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Unfortunately the decision to run 32-bit libs on 64-bit systems is outside
of my control. Given that it *should* work I'm more interested in
diagnosing whether this is a bug of some sort in libmysqlclient or a bug in
my code/build procedure.
Alex
On Sat, Jun 4, 2011 at 10:06 AM, walter
int n_fields = mysql_num_fields(result);
MYSQL_FIELD *fields = mysql_fetch_fields(result);
int i;
for (i = 0; i < n_fields; i++) {
printf("%s: %d\n", fields[i].name, fields[i].type);
}
mysql_free_result(result);
mysql_close(conn);
}
second
query to the get the record id, but how would I easily reposition the
browse listing back in date order on the record found in the second query?
Thanks,
Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
you might be interested in this:
http://simplegeo.ksikes.net
https://github.com/alexksikes/simplegeo
On Mon, Feb 7, 2011 at 7:29 AM, Sander de Bruijne wrote:
>
> http://www.geonames.org/
>
> http://download.geonames.org/export/dump/?C=S;O=D
>
>
> On 02/02/2011 11:30 AM, viraj wrote:
>>
>> dear l
i type
bzr branch lp:mysql-server
and now 986582KB downloaded
What size of repo i must download with this command ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Please check out http://q4m.31tools.com/*. *It is a message queue storage
engine with sql interface. Havent used it in a production setup though we
did some tests.
--
Thanks
Alex
http://alexlurthu.wordpress.com
Hi,
I noticed that the 6.11 branch is not available for download anymore. Did
they rename it to 5.4?
Thanks,
-Alex
Anyone knows where I can download the 6.0.11 gziped source from?
> DECLARE divide_by_zero CONDITION FOR SQLSTATE '22012';
> IF divisor = 0 THEN
> SIGNAL divide_by_zero;
> END IF;
> END
>
> Methinks someone forgot to include this feature in the release!
>
>
> -Original Message-
> From: Alex Katebi [mailto:alex.
Hi Folks,
I am getting syntax error with the mysql signal. I have a trigger
that needs a signal for raising an error condition if a row with
specific value is removed.
CREATE TRIGGER my_trig BEFORE DELETE ON my_tbl
FOR EACH ROW BEGIN
DECLARE mysig CONDITION FOR SQLSTATE '45000';
e_name=NULL
ELSEIF STRCMP(NEW.Variable_name, 'ASN') != 0 THEN
set NEW.Value=CONVERT(CONVERT(NEW.Value, UNSIGNED), CHAR);
ELSEIF STRCMP(NEW.Variable_name, 'RouterId') != 0 THEN
set NEW.Value=INET_NTOA(INET_ATON(NEW.Value));
ENDIF
END
Thanks in advance!
Alex
u can load data infile into table without specifying the schema
of this table but it does not look like you can do load data infile
into a temporary table.
Thank you,
Alex
2009/5/19 Janek Bogucki :
> Hi,
>
> mysql> create temporary table t(i int);
>
> mysql> \! echo 1 > /t
Hello,
Would anyone know how to load data infile into a temporary table?
Thank you,
Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Hello Martin,
This sounds great! I am not sure if plugins are supported for the
embedded mysql applications. Meaning that my application is linked with the
libmysqld not libmysql. Do you know the answer?
Thanks,
Alex
On Mon, May 18, 2009 at 10:17 AM, Martin Gainty wrote:
> yes if
an application
C/C++ function from mysql stored procedures?
Thanks in andvance!
Alex
On Tue, Apr 7, 2009 at 11:17 AM, Martijn Tonies wrote:
> Alex,
>
> Please respond to the list instead of my personal address.
sorry I thought i was.
>
>
>
> Nevertheless, if MYSQL_TYPE_LONG is the datatype for a table field,
> it would always -have- to be the same size,
is the error code?
Thanks,
-Alex
Hi,
What is the size of MYSQL_TYPE_LONG in a 64bit machine? I am trying to save
pointers. If this type is 4 bytes on a 32bit machine and 8 bytes on a 64bit
machine will make it much easier.
Thanks,
-Alex
In mysql embedded server 6.09 built from source for Linux 2.6.27.11
kernel.
First create a connection (mysql_real_connect) then close the connection in
a different thread.
This causes a SIGSEGV crash in THD:store_globals ( ). My mysql embedded
library is thread-safe.
Thanks in advance,
-Alex
Anyone knows how to figure out the mysql basedir string using Autoconf and
then pass it to Automake for an embedded application?
Thanks in advance,
-Alex
For embedded server do I need to configure
--with-embedded-privilege-control?
It looks like stored procedure is looking for mysql.proc table.
Thanks.
L PROTECTED]>:
> can u please show me the explain plan for this sql and also the table
> structure
>
> explain select statement
>
> desc table_name
>
>
> On 11/10/08, Alex K <[EMAIL PROTECTED]> wrote:
>>
>> Hi Ananda,
>>
>> Indexes are pr
Hi Ananda,
Indexes are present. I'm passing no more 10 values.
Alex
2008/11/10 Ananda Kumar <[EMAIL PROTECTED]>:
> it should not cause any issues, unless your passing too many values in "id
> in(1,2,...n).
> Are the indexes present.
>
>
> On 11/10/08
Hello,
It seems to me that the statement "id in (id1, id2 ... idn)" is much
slower than "id=id1 or id=id2 ... or id=idn" or I am doing something
wrong?
Thank you,
Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:ht
Any information on how to run the test scripts for the embedded client.
Thanks,
-Alex
That seems like a nice trick. I suppose the flag would just be an int
and not an enum in this case.
2008/10/3 Mr. Shawn H. Corey <[EMAIL PROTECTED]>:
> On Fri, 2008-10-03 at 09:58 -0700, Rob Wultsch wrote:
>> On Fri, Oct 3, 2008 at 9:49 AM, Alex K <[EMAIL PROTECTED]&
2) is probably cleaner but a hassle as well because one needs to make
sure all user_ids are also in this new table.
2008/10/3 Alex K <[EMAIL PROTECTED]>:
> Hello,
>
> I have a table of a 1 million users. I want to add a flag called
> delete if a user wants to delete his accou
es a lot of unnecessary space.
2) Should I create a new table user_id, flag already prefilled with
all user_ids.
3) Should I create a new table called deleted_users that has a user_id
if this user wants to be deleted.
>> it's hassle to update but takes into consideration the spareness of the d
screen?
Thanks,
-Alex
statements against
some database tables in the server.
What are the ramifications of the above model within the MySql Server.
Thanks,
-Alex
Linux root user is the only user that can start and stop the server. Is
this fact correct?
Thanks,
-Alex
Hello,
Is there any documentation on how to start the mysqld server.
I have installed version 6.0 server and client. But I don't know how to
start the server correctly.
Thanks,
-Alex
ould destroy this mail.
> Information or opinions in this message shall not be treated as neither
> given nor endorsed by the company. Neither the company nor the sender
> accepts any responsibility for viruses or other destructive elements and it
> is your responsibility to scan any attachments.
--
Thanks
Alex
http://alexlurthu.wordpress.com
ps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
> sda 88.47 782.20 998.77 9046888130 11551757459
>
> The new server, which is just trying to handle replication
>
> Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
> sda 77.83 1367.55 2914.72 358474084 764029986
>
> Thanks,
&
also how often do you issue a commit. batching the inserts inside a
transaction might help.
On Fri, Jun 13, 2008 at 6:53 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
> check for iostat to see if the disk is heavly used.
>
> On 6/13/08, Ian Simpson <[EMAIL PROTECTED]>
s in this message shall not be treated as neither
> given nor endorsed by the company. Neither the company nor the sender
> accepts any responsibility for viruses or other destructive elements and it
> is your responsibility to scan any attachments.
--
Thanks
Alex
http://alexlurthu.wordpress.com
database is being used?
I know I can use mysqhotcopy or mysqldump but I'm just curious if it's
possible to perform a backup by simply copying the files over in the
conditions described above.
Thank you so much,
Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.co
Cool it's good to know thank you.
On 25/01/2008, Jay Pipes <[EMAIL PROTECTED]> wrote:
> Nope, no difference, AFAIK.
>
> Alex K wrote:
> > Any ideas pertaining this newbie question?
> >
> > Thank you so much,
> >
> >> Hi Guys,
> >>
Any ideas pertaining this newbie question?
Thank you so much,
> Hi Guys,
>
> Is there a performance hit when joining across multiple databases as
> opposed to joining multiples tables in one database? Suppose the same
> tables are available across all databases.
>
>
Hi Brent,
ahh of course :) thank you so much for answering though.
Alex
On 20/01/2008, Brent Baisley <[EMAIL PROTECTED]> wrote:
> When you establish a connection, it's a connection to a server, not a
> specific DB. You can set a default db so that you don't always have
&g
to
otherdb and then querying. I'm using webware DBUtils for connection
pooling. Would these connections also be taken into account?
Thank you so much,
Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Guys,
Is there a performance hit when joining across multiple databases as
opposed to joining multiples tables in one database? Suppose the same
tables are available across all databases.
Thank you,
Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
e the company basic information, description and personalized
options. These updates may happen sporadically though. Once every 3
minutes these fields are selected again in order to update the search
engine index.
Thank you,
Alex
On 18/01/2008, Kevin Hunter <[EMAIL PROTECTED]> wrote:
> At 1
would hold each the fields under each comment
together with a company_id? The first way of doing it is easier to
update because I would not have to update all the other linked tables.
But the other way of doing seems cleaner.
To summarize one table vs. many tables with one to one relations?
Thank y
Office Number: 040-66489771
> Mob: 9912924044
> URL: ed-ventures-online.com
> Email-id: [EMAIL PROTECTED]
>
--
Thanks
Alex
http://alexlurthu.wordpress.com
storage engine is. How do
> > > I get it to tell me? Or I guess a broader more helpful question would
> > > be, "What are all the ways to determine a table's storage engine
> > > type?"
> > >
> > > Thanks,
> > > --
> &
ql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
Sent from Gmail for mobile | mobile.google.com
Thanks
Alex
http://alexlurthu.wordpress.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-++-+
>
> MySQL version is 4.1.20
> What is the bottleneck in my server? How could I improve MySQL server
> performance?
>
> Thank you!
>
> --
> Alexander Bespalov
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
Sent from Gmail for mobile | mobile.google.com
Thanks
Alex
http://alexlurthu.wordpress.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
gt;
> - Id
>
> - Name
>
> - Visited
>
>
>
> Visited is numeric.
>
>
--
Thanks
Alex
http://alexlurthu.wordpress.com
uld be replaced by the "in" .
--
Thanks
Alex
http://alexlurthu.wordpress.com
RROR: Error in Log_event::read_log_event(): 'read error', data_len:
> 81904,
> event_type: 2
> Could not read entry at offset 138164107:Error in log format or read error
> -
>
>
> -RG
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
Thanks
Alex
http://alexlurthu.wordpress.com
.
--
Thanks
Alex
http://alexlurthu.wordpress.com
On 9/5/07, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
>
> 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)
&
I am not sure whether you are talking about innodb_thread_concurrency. If so
please check out
http://www.mysqlperformanceblog.com/2006/06/05/innodb-thread-concurrency for
more details. Innodb_thread_concurrency works on linux.
Thanks
Alex
On 8/29/07, Andrew Braithwaite <[EMAIL PROTECTED]>
of the performance implications.
--
Alex
http://alexlurthu.wordpress.com/
On 8/29/07, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
>
> Hi All,
>
> Is there is any script or tool that generate the report and send an email
> for changes done in the databases;
>
re helpful.
--
Alex
http://alexlurthu.wordpress.com
On 8/29/07, Ananda Kumar <[EMAIL PROTECTED]> wrote:
>
> Hi Friends,
>
> When i do "SHOW INNODB STATUS\G". It gives me details of transaction
> happening on INNODB engine.
>
> Please let me know what all information i
Car Toper wrote:
> More info...
>
> I am able to login with the account via phpMyAdmin on the server.
> Also, I am trying to use phpMyAdmin to change the permissions, but I
> cannot figure out the syntax:
>
> GRANT ON ppsntracker.* TO [EMAIL PROTECTED] WITH GRANT OPTION;
>
> Cartoper
>
> On 8/21/07
ing used in the where clause. But doing 'LIKE' operation with the
pattern beginning with '%' it renders the index use less.
If you use MyISAM you can always use full text search on a text field for
such use cases.
--
Thanks
Alex
http://alexlurthu.wordpress.com
Hi Ace,
If you cant affort downtime and if you are using innodb try removing auto
extend on the current data file and create a datafile in a different
partition and put autoextend on the same. If you are using MyISAM , you can
move few tables to different disk use symlinks.
--
Thanks
Alex
http
.
--
Thanks
Alex
http://blog.360.yahoo.com/alex.lurthu
On 7/9/07, Ananda Kumar <[EMAIL PROTECTED]> wrote:
Hi Alex,
Thanks a lot,
I missed on taking the "exe_master_log position" value.
If i start from Read_Master_Log_Pos: 106683511, will it cause any harm.
regards
anandkl
On 7/9/07,
P.S: Make sure you setup the hostnames in the change master command
appropriately.
--
Thanks
Alex
http://blog.360.yahoo.com/alex.lurthu
server
needs to maintain due to the dump.
Thanks
Alex
On 7/6/07, Ananda Kumar <[EMAIL PROTECTED]> wrote:
Hi All,
I am planning to take mysqldump on slave running innodb engine.
I going to use the below command
/usr/bin/mysqldump --user=root --password= --flush-logs
--all-databases
--
ebuilt recently. You can try rebuilding the tables.
How is the overrall system load on both machines. Is one overloaded than the
other ? The machine which takes longer to excute the query might be busy
serving some other process other than MySQL.
Thanks
Alex
S=311",
You need to use the positions specified in the mysqldump since when u
restore using the data, you will get data only till the snapshot specified
in the dump.
Thanks
Alex
ebuilt recently. You can try rebuilding the tables.
How is the overrall system load on both machines. Is one overloaded than the
other ? The machine which takes longer to excute the query might be busy
serving some other process other than MySQL.
Thanks
Alex
Hi,
Run explain plan on both the machines and post the same.
~Alex
On 7/4/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hello Ananda,
yes, the testmachine has the same data.
Regards,
Spiker
--
GMX FreeMail: 1 GB Postfach, 5 E-Mail-Adressen, 10 Free SMS.
Alle Infos und kost
Chris,
Did you check if there are any user level MAX_USER_CONNECTIONS restriction
set while granting access ?
Thanks
Alex
On 7/4/07, Chris Faust <[EMAIL PROTECTED]> wrote:
Folks,
I'm wondering is someone could help us in trying to resolve the above
error,
we have read through w
6 Query INSERT INTO results VALUES
(NULL,8,now(),0.7762,28130)
6 Query INSERT INTO results VALUES
(NULL,9,now(),0.0348,4217)
-- Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
for
column 'P_LAST_SOLD_DATE' at row 921888
An extremely quick and dirty solution:
mysqldump -uusername -p -t --skip-opt database_name dats_tem | grep
INSERT | head -921888 | tail -1
replacing username with your username and database_name with your
database name, of course.
-- Alex
--
M
Ratheesh,
If you still want to place you blob data in the database, seperate out the
blob storage to a seperate table. This will help you alleviate few of your
performance and maintenance problems.
~Alex
On 6/22/07, Steve Edberg <[EMAIL PROTECTED]> wrote:
At 12:11 PM +0530 6/22/07, Ra
ltiple key
buffers, the memory allocated will belong to the same process and the
limitation is at the process level.
~Alex
On 5/15/07, Ananda Kumar <[EMAIL PROTECTED]> wrote:
Hi Alex,
Thanks for the info,
For the second question, do you mean i should restore the entire backup or
just that one file from my backup.
All the files should be from the same backup. AFAIK, MySQL doesnt have an
option to recover on
if you are using a mysql 32bit build, then you
will not be able to use more than 4GB theoretically.
Using 64bit OS and 64bit build of mysql will enable you to use memory
greater than 4GB effectively.
~Alex
re. Else it will be highly unlikely.
~Alex
the ask lies in expire_logs_days. If you set this to optimal number of days,
logs older than the configured days will get purged.
~Alex
On 5/15/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> One question about this, is it safe to turn of log_bin?
i think, you can. the log is
check if you are seeing any access denied errors in the mysql error log.
~Alex
On 5/14/07, richard <[EMAIL PROTECTED]> wrote:
Ian P. Christian wrote:
> richard wrote:
>
>> as far as I can see, these commands select which db's to replicate on
>> the slave that
techincally yes you can have. replication is all about the queries that are
getting executed on the master will be executed on the slave. So , if the
database that exists on the master exists on the slave , then you should
have no problems.
Thanks
Alex
On 5/14/07, richard <[EMAIL PROTEC
server. By spreading the data around, you are
reducing the risk if the one mega-machine were to become unavailable,
and also reducing resource contention (on the disks, CPU, RAM etc.).
-- Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscri
alhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
Try:
./mysqladmin password testpw
-- Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
1 - 100 of 421 matches
Mail list logo
