Agreed. Will do that along with several other possible changes. But
for the moment, I'm still gathering information and coming up with
plausible models.
Will also be turning on general mysql logging on both Master and
Slave, at least briefly, to see what statements are being run on both.
Regard
Yes. Except for a handful of static MyISAM tables. But the tables
that are experiencing the issues are all InnoDB and large (a dozen or
so fields, but lots of records.)
Regards,
- Robert
On Thu, Feb 14, 2013 at 5:59 PM, Singer Wang wrote:
> Are you using all InnoDB?
>
> S
--
MySQL General Ma
On Thu, Feb 14, 2013 at 4:54 PM, Manuel Arostegui wrote:
> 2013/2/13 Robert Citek
>>
>> On Wed, Feb 13, 2013 at 8:59 AM, Robert Citek
>> wrote:
>> > Any other possibilities? Do other scenarios become likely if there
>> > are two or more tables?
>&g
On Thu, Feb 14, 2013 at 5:46 PM, Rick James wrote:
>> Is it in read only mode?
> Furthermore, are all users logging in as non-SUPER users? Note: root
> bypasses the readonly flag!
No. The user that is commonly used does have Super privileges. I am
not sure why, but it does.
Regards,
- Rober
On Wed, Feb 13, 2013 at 8:59 AM, Robert Citek wrote:
> Any other possibilities? Do other scenarios become likely if there
> are two or more tables?
>
> Of those, which are the most likely?
[from off-list responder]:
> Other possibility: The replication is reading from master not
On Thu, Dec 9, 2010 at 9:10 AM, Shawn Green (MySQL)
wrote:
> On 12/8/2010 22:50, Robert Citek wrote:
>>
>> Greetings to all,
>>
>> Can I migrate slave databases between slave servers?
>>
>> Imagine the following scenario: I have one master database server
Greetings to all,
Can I migrate slave databases between slave servers?
Imagine the following scenario: I have one master database server with
10 databases. I also have two slave database servers, one replicating
5 of the 10 databases, the other replicating the other 5 databases.
Can I migrate on
If you are very new, you may want to go through the tutorial at w3shools:
http://www.w3schools.com/SQl/default.asp
Regards,
- Robert
On Wed, Sep 30, 2009 at 11:45 AM, Carlos Williams wrote:
> I am no doubt very new to MySQL and have been studying the on line
> manual however I find it a bit com
It's not clear what exactly you are looking for. Two possible solutions:
1) use a union
2) use a join with another table containing partner and factor fields.
Can you give a short example of what the input looks like and what you
would like the output to look like?
Regards,
- Robert
On Thu, S
On Sep 28, 2005, at 4:03 PM, [EMAIL PROTECTED] wrote:
(1) is almost possible with 5.0. The Federated storage engine
creates the
equivalent of "linked tables" but it is MySQL-to-MySQL only. There are
other restrictions, too. As soon as they work out the kinks for
MySQL-to-ODBC, you will be in
On Sep 28, 2005, at 3:09 PM, Sujay Koduri wrote:
Once you get some "Here's how you do it." about option 1, please
post it in
the lists also. Because we are also looking to do a similar one,
but didn't
find out any good info.
I have been looking through here, but have not found anything
c
On Sep 28, 2005, at 2:37 PM, Sujay Koduri wrote:
I don't know how far this is going to help you. But this is what we
are
following to migrate from Oracle to MySQL.
If we were migrating, that's probably the strategy that we would
use. But we are not, at least not yet. For now we just want
Is there a way to query data where one table is in an Oracle database
and another is in a MySQL database?
We have two projects. One project is entirely in Oracle 9i on an MS
Windows 2000 server and the other is in MySQL 4.1 on Linux. It isn't
worth our time at this point to migrate enti
On Monday, Mar 7, 2005, at 16:04 US/Central, [EMAIL PROTECTED] wrote:
It would be happy to try to help if I worked in or on either of those
platforms (Apache + Java). I am Win32(IIS), ASP (VBScript/JavaScript)
using MyODBC as my connection library.
Is using MyODBC the accepted way to connect to a
On Wednesday, December 3, 2003, at 06:27 PM, Robert Citek wrote:
How can I calculate the mean/median/mode from a set of data using SQL?
After a bit of googling, I found this link:
http://mysql.progen.com.tr/doc/en/Group_by_functions.html
and a few answers in the comments towards the bottom
Hello all,
How does one stop or abort a query?
I was doing some experimenting with MySQL and created a table with
100,000 records. I then did a join like so:
create table foo select foo.name, foo.val from foo, foo x, foo y, foo
z ;
This took a long time. So, I aborted with Ctrl-C (^C) whic
Hello all,
How can I calculate the mean/median/mode from a set of data using SQL?
Mean seems to exist as the average (avg):
select name, avg(value) from table group by name
Is there a way to calculate median and mode with a group by clause?
Median: the value at which 50% of the samples are abo
On Tuesday, November 11, 2003, at 03:06 PM, Roger Baklund wrote:
* Robert Citek
Is there a way to do a self-join and a group by in a single SQL query?
See the max-concat trick, described here:
http://www.mysql.com/doc/en/example-Maximum-column-group-row.html >
Thanks for the tip. It looks l
Hello all,
Is there a way to do a self-join and a group by in a single SQL query?
For example, I have an PurchaseOrder table (see below) and would like
to know what was the most recent order-number for each customer and the
amount of that order. So far, I have been able to do this in two steps
At 10:50 AM 2/24/2003 -0700, Mike Doanh Tran wrote:
>How do i redirect a mysql output to a file from the command line?
>For example, I want to save DESCRIBE test_table > test_table.file
>without doing a MYSQLDUMP.
>From the command line:
$ echo 'describe test_table' | mysql {dbname} > test_ta
Any pointers greatly appreciated.
Regards,
- Robert
sql
-
At 11:38 PM 12/27/2002 -0600, Robert Citek wrote:
>Why can I not create a File DSN using MyODBC 2.50.39 on Windows 2000?
-
Before posting, please check:
Hello all,
Why can I not create a File DSN using MyODBC 2.50.39 on Windows 2000?
I have installed MySQL v3.23.52-max-nt and MyODBC 2.50.39 on a Windows 2000
machine. While I can create both System and User DSNs, I cannot create a
File DSN. When I try I get the error message "File Data Source w
At 12:59 PM 12/11/2002 -0800, blind falcon wrote:
> ... I need to know what the equivalent mysql
>datatypes are for the following MS SQL datatypes:
I'm not familiar with the MS SQL datatypes, but here's a description of
MySQL data types:
http://www.mysql.com/doc/en/Column_types.html
HTH,
- Rob
Hello Richard,
At 05:06 PM 12/10/2002 -0800, Richard Baskett wrote:
>SELECT * FROM `table_name` WHERE Email REGEXP "^[@]";
>But I am doing something wrong, because it's just not working :)
You are searching for an Email field that begins with an @.
Some alternatives:
SELECT * FROM `table_name
Hello Mike,
The short answer: use Perl, Python, Ruby, etc.
You are pressing the boundaries between a query language (SQL) and a
programming/scripting language (Perl, Python, Ruby, etc.). Scripting
languages as these already have those capabilities and can easily connect
to MySQL an many other d
At 05:35 AM 12/10/2002 -0800, tmb wrote:
>1 - On a Linux/Apache box,
>when you create a MySQL db with tables, etc,
>Where does MySQL store the files associated with the
>db?
If the database is named foobar, then usually in /var/lib/mysql/foobar
>2 - On subsiquent db's, does MySQL store those fil
At 05:10 PM 12/9/2002 -0500, Beauford.2003 wrote:
>I mentioned in my previous email that I am using PHP, and I have also tried
>putting quotes around $var (many different ways) with no better results.
>REGEXP just gives a syntax error when I do this.
Below is an example of using PHP and MySQL wit
Try the REGEXP modifier. For example:
mysql> select "Another One" regexp "[[:<:]]One[[:>:]]" ;
mysql> select "Fashioned" regexp "[[:<:]]One[[:>:]]" ;
The format differs from that used in sed, grep, awk, perl, python, etc.
http://www.mysql.com/documentation/mysql/bychapter/manual_Regexp.html#Re
Hello Sergei,
In going through the archives I found this message which is similar to an
issue I am currently having. You mention to "Consult the manual for
details." I've check through the on-line manual:
http://www.mysql.com/doc/en/index.html
specifically,
http://www.mysql.com/doc/en/SHOW_
At 04:41 PM 11/21/2002 -0600, Robert Citek wrote:
>So, now I know that "repair with keycache" is slower than "repair by
>sorting." What can I do about that? That is, how can I make the repair
>use sorting? I would have thought they would be part of the "alter
Hello Jennifer,
Thanks for your reply.
At 02:07 PM 11/21/2002 -0800, Jennifer Goodie wrote:
>http://www.mysql.com/doc/en/SHOW_PROCESSLIST.html
I guess I have an older/different version of the doc's. I was using the
version that came with the Windows install of MySQL. Thanks for the URL.
>Rep
Hello all,
What does it mean to be in the "Repair with keycache" state, and how do I
fix this?
I am running MySQL v3.23.36 on a Red Hat 7.1 machine. One of my tables has
about 21,000,000 (21 Million) records in it. I am trying to index one of
the fields with the alter table command:
mysql> a
Thanks, Jeremy.
At 03:14 PM 11/18/2002 -0800, Jeremy Zawodny wrote:
>mytop -- http://jeremy.zawodny.com/mysql/mytop/
>
>That's what I wrote it for.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manua
Is there a way to get information about current connection to a MySQL
server? Specifically, I would like to know how many users are currently
connected, who they are, from where, what databases are being used, etc.
I've browsed and searched the mysql manual and found the SHOW STATUS
command (htt
At 08:36 PM 11/5/2002 -0800, Phil Straw wrote:
> summary VARCHAR NOT NULL,
Need to specify length:
summary VARCHAR(10) NOT NULL,
http://www.mysql.com/doc/en/CREATE_TABLE.html
- Robert
-
Before posting, please check:
htt
Hello Victor,
At 04:30 PM 10/10/2002 +0100, Victor Kirk wrote:
>>> Can anyone help me? Ideally I would like something that would
>>> be portable to oracle/sql server. Efficiency is not an issue.
>
>> How about ...
>
>>SELECT * FROM teams
>>LEFT JOIN users USING (team_id)
>>WHERE u
Hello Luc,
At 03:13 PM 9/27/2002 -0400, Luc Foisy wrote:
>When I installed Mysql ( whatever the current 3.x series is on RedHat 7.3,
>the service did not start when I restarted. If you have gnome installed,
>you can acess Service Configuration and set MySQL to start when system
>boots. Just
Hello Ozette,
At 05:36 AM 9/27/2002 -0400, Ozette Brown wrote:
>To stop a running query, you'll need to do a 'myqsladmin processlist'
> and once you find the PID for the query, issues a "mysqladmin kill PID".
>This should do the trick.
Is there not a more elegant solution? Would not the above
Hello all,
How do I stop a query once it has started without quitting the MySQL client?
I have a MySQL daemon and client (v3.23.36) running on a RedHat Linux 7.1
box. I ran a query that joined two large tables (>300K rows each) on
columns that I had forgot to index. When I pressed Ctrl-C, thi
Hello all,
I have a table that has a column named foo. It is enumerated with values
("Excellent","Good","Fair","Poor") and is indexed. The table has a few
million records in it. I recently did a select query where I mistakenly
typed "where foo='Goo'" instead of 'Good'. This query took quite
40 matches
Mail list logo
