Jerome Macaranas schrieb:
im trying to setup mysql slave but the things is it wont start because of
this errror:
-- ERROR 1200 (HY000): The server is not configured as slave; fix in config
file or with CHANGE MASTER TO
after some testing.. i saw the server-id = 0
through show
Hi List,
I am working for a messaging company, sending sms to enterprise customers.
In a mysql table data is being continuously inserted by user. Most of the
time we have 5 to 10 millions of data in this table.
Table name : alt_send_sms engine myisam
From this table, i need to select data
On Tue, 19 Jan 2010, Tompkins Neil wrote:
I can enforce that the user can't use the same password as the previous four
- when they change their password. However, the user can manipulate this by
changing the password four times and then resetting back to there original
password. How would I
Hi Krishna,
As table is using MyISAM engine and it acquires a table level lock, the
queries will be executed one after one .
By converting it into Innodb as it acquires a row level lock, doing a select
and delete based on primary key will be faster and the concurrency
increases.
--
Thanks
Suresh
Hi Suresh,
my question is how i can run concurrent connection with the above work load.
Thanks,
Krishna
On Thu, Jan 21, 2010 at 4:46 PM, Suresh Kuna sureshkumar...@gmail.comwrote:
Hi Krishna,
As table is using MyISAM engine and it acquires a table level lock, the
queries will be executed
On 21/01/2010 11:07, Lucio Chiappetti wrote:
On Tue, 19 Jan 2010, Tompkins Neil wrote:
I can enforce that the user can't use the same password as the
previous four
- when they change their password. However, the user can manipulate
this by
changing the password four times and then resetting
Innodb contains multi-version property, so it can handle more concurrent
queries from user connections.
On Thu, Jan 21, 2010 at 5:07 PM, Krishna Chandra Prajapati
prajapat...@gmail.com wrote:
Hi Suresh,
my question is how i can run concurrent connection with the above work
load.
Thanks,
On Thu, Jan 21, 2010 at 5:18 PM, Suresh Kuna sureshkumar...@gmail.comwrote:
Innodb contains multi-version property, so it can handle more concurrent
queries from user connections.
On Thu, Jan 21, 2010 at 5:07 PM, Krishna Chandra Prajapati
prajapat...@gmail.com wrote:
Hi Suresh,
my
Hi Abhishek.
insert, select and delete are in the same proportion.
1. Inserted data into a table A by user.
2. Selecting data from table A inserting data to table B after applying some
rules(update).
3. Deleting data from table A.
4. Selecting data from table B using some conditions (SELECT
Hi list,
I want to insert 1 records/sec into table. There can be n number of
tables with unique data in each. What are the possible ways to do ?
Thanks,
Krishna
On Thu, Jan 21, 2010 at 7:15 AM, Krishna Chandra Prajapati
prajapat...@gmail.com wrote:
1. Inserted data into a table A by user.
2. Selecting data from table A inserting data to table B after applying some
rules(update).
3. Deleting data from table A.
4. Selecting data from table B using some
Hi list,
Out of the below load balancer which is the best one. Is there any other
load balancer available.
1 mysql proxy (Still alpha)
2 ultramonkey.
3 haproxy
Thanks,
Krishna
Krishna Chandra Prajapati wrote:
Hi List,
I am working for a messaging company, sending sms to enterprise customers.
In a mysql table data is being continuously inserted by user. Most of the
time we have 5 to 10 millions of data in this table.
Table name : alt_send_sms engine myisam
From
Krishna Chandra Prajapati wrote:
Hi list,
I want to insert 1 records/sec into table. There can be n number of
tables with unique data in each. What are the possible ways to do ?
Thanks,
Krishna
The manual is your friend. It doesn't hurt to consult it.
INSERT ...
On 1/19/2010 7:49 AM, Mark Goodge wrote:
On 19/01/2010 14:44, Tompkins Neil wrote:
Hi All,
Following on from my earlier email - I've the following question now :
I can enforce that the user can't use the same password as the
previous four
- when they change their password. However, the user
that's exactly how i do it.
On 1/19/10 3:57 PM, Intell! Soft h.ba...@intelli-soft.at wrote:
Thanks! - I found a Insert Into on your tip:
Insert Into Lieferanten (Lieferant)
select distinct
a.lieferant
from artikelstamm a
left join lieferanten b on
a.lieferant = b.lieferant
I want to find rows that contain a word that matches a term, accent
insensitive: I am using utf8-general collation everywhere.
attempt 1:
SELECT * FROM t WHERE txt LIKE '%que%'
Matches que qué, but also matches 'queue'
attempt 1.5:
SELECT * FROM t WHERE txt LIKE '% que %' OR LIKE 'que %' OR
At 06:15 AM 1/21/2010, Krishna Chandra Prajapati wrote:
Hi Abhishek.
insert, select and delete are in the same proportion.
1. Inserted data into a table A by user.
2. Selecting data from table A inserting data to table B after applying some
rules(update).
3. Deleting data from table A.
4.
I have a two databases, one in a production environment (let's call it db_prod)
and the other in a testing environments (Let's call it db_test).
What is the best way to synchronize the database schemas? db_test has had a
few indexes and constraints added to several tables and I need to
The best way is to keep track of all individual changes to your
staging environment, including fire-and-forget style scripts; and
apply those to your production environment as needed. This is part of
the process of change management, and generally a very good idea :-)
Lacking that, there are
On Jan 21, 2010, at 9:27 AM, John Campbell wrote:
I want to find rows that contain a word that matches a term, accent
insensitive: I am using utf8-general collation everywhere.
attempt 1:
SELECT * FROM t WHERE txt LIKE '%que%'
Matches que qué, but also matches 'queue'
attempt 1.5:
On 1/21/10 10:27 AM, John Campbell jcampbe...@gmail.com wrote:
I want to find rows that contain a word that matches a term, accent
insensitive: I am using utf8-general collation everywhere.
attempt 1:
SELECT * FROM t WHERE txt LIKE '%que%'
Matches que qué, but also matches 'queue'
Exactly what Johan said.
I keep structure like so:
develo...@mypse /var/www/dart2/UPDATES $ ll
-rw-rw-rw- 1 developer developer 551097 2009-12-22 23:16
airports_city_country.sql
drwxrwxrwx 2 developer developer 4096 2010-01-21 04:51 CVS
-rw-rw-rw- 1 developer developer 3063 2009-07-15 01:40
As an auditor once told me,
If you can do your job, then I'm not doing my job.
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
--
MySQL General Mailing List
For list
I have the following update procedure that update mySQL DB over the
internet between source Linux Centos (local machine on my net behind a
DMZ with real IP A.B.C.D) and target Linux fedora (web server
www.myweb.com) every day on a specific time 18:00 through a crontab on
my source linux server
25 matches
Mail list logo
