Re: Replication and user privileges

On 2/26/2019 1:57 PM, Jim wrote: On 2/26/2019 9:44 AM, shawn l.green wrote: Hello Jim, On 2/25/2019 7:29 PM, Jim wrote: On 2/25/2019 5:46 PM, shawn l.green wrote: Hello Jim, On 2/25/2019 5:04 PM, Jim wrote: I have a question about mysql replication. I believe I understand most of it, but

Re: Replication and user privileges

On 2/26/2019 9:44 AM, shawn l.green wrote: Hello Jim, On 2/25/2019 7:29 PM, Jim wrote: On 2/25/2019 5:46 PM, shawn l.green wrote: Hello Jim, On 2/25/2019 5:04 PM, Jim wrote: I have a question about mysql replication. I believe I understand most of it, but have a question about user

Re: Replication and user privileges

On 2/25/2019 5:46 PM, shawn l.green wrote: Hello Jim, On 2/25/2019 5:04 PM, Jim wrote: I have a question about mysql replication. I believe I understand most of it, but have a question about user privileges. I understand on the master, the replication user must have the Repl_slave_priv

Replication and user privileges

rding replicated queries irrelevant on the slave and that is handled all internally via the replication thread with no regard to user privileges? Thank you. Jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Connections from mysql8.0 to mysql5.1 - bad handshake

I'm attempting just isn't going to work? Thanks, Jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: --initialize specified but the data directory has files in it. Aborting.

/CentOS7 because "yum" and the package name, if i would > be him i would just install mariadb which is the default mysql > implementation these days on most linux distributions and hence the > packages are better maintained > > > -Ursprüngliche Nachricht- >> V

--initialize specified but the data directory has files in it. Aborting.

rectory has files in it. Aborting. 2015-11-13T15:54:01.207751Z 0 [ERROR] Aborting can someone help? thank you, Jim

Re: When to create a new user?

On 8/19/2015 9:24 AM, Reindl Harald wrote: Am 19.08.2015 um 15:18 schrieb Jim: On 8/19/2015 8:40 AM, Reindl Harald wrote: Am 19.08.2015 um 14:29 schrieb Richard Reina: I am writing a web application in perl that will create, edit, update and delete data from a MySQL database. I have written

Re: When to create a new user?

to damage control in case of a db related exploit. You'd make this call based on how sensitive and important your data is and how much effort you are willing to put into the planning and design. Jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysq

Re: Sending a fax

What is this “fax” he is speaking of? > On Jun 15, 2015, at 9:28 AM, Jørn Dahl-Stamnes wrote: > > On Monday, June 15, 2015, Trianon 33 wrote: >> All, >> >> Maybe a somewhat weird request: I need to verufy my fax can receive >> foreign faxes. >> >> If someone (one is really enough) send me a (p

Re: inconsistent optimization

innodb On 8/20/2014 1:22 PM, Martin Gainty wrote: Jim/Jaime What engine are you implementing?/ Qual mecanismo de MySQL que você está implementando? Saludos desde Sud America Martín Date: Wed, 20 Aug 2014 13:54:46 -0300 Subject: Re: inconsistent optimization From: edua...@gerencianet.com.br

inconsistent optimization

Without going into specific details on queries... Using mysql 5.1 as provided with CentOS6, I've noticed some queries providing what I can best explain as inconsistent optimization. The database can be quieted to just controlled queries and at times the same query will return very quickly when

fulltext question

Hello all- I have a question on searching via fulltext. I have the following SQL statement: var('SQLResultsID') = 'select *, MATCH (product_id,product_name,product_desc) AGAINST("' + $sqlKeywordSearch + '") AS SCORE from products WHERE MATCH (product_id,product_name,product_desc) AGAI

restore question

Hi everyone- This is probably a no brainer (I'm new to Navicat) but I have a backup of a database from Navicat. I want to be able to see if a certain field has changed since this morning in the backup (We are having problems with an order that somehow "duplicated" the items. I need to see if

Re: weird difference in workbench and CLI query

ing it was version discrepancy as well and I was just sure that wasn't it. Jim McNeely On Feb 13, 2012, at 9:11 AM, Rik Wasmus wrote: >> When I run this query in workbench: >> select c.acc_number 'Accession Number', e.DateExam 'MBI Exam Date', >> s.Exam

Re: UPDATE triggers with REPLACE statements

Not if you are using innoDB tables. For these, you use INSERT and UPDATE triggers. Jim McNeely On Dec 19, 2011, at 11:58 AM, Halász Sándor wrote: >>>>> 2011/12/19 11:30 -0800, Jim McNeely >>>> > In the MySQL documentation, we find this tantalizing statement: &g

Re: UPDATE triggers with REPLACE statements

likely going to be MySQL with either engine, but the processes creating these queries have some limitations. Anyway, I just thought I would share. BTW I experimented, and innoDB does updates and fires off update triggers for REPLACE statements, but MyISAM does delete/inserts. Jim McNeely On D

Re: UPDATE triggers with REPLACE statements

han a possible difference in how the storage engine increments Handler_xxx status variables." Does anyone know what engine this is? I can't seem to find any info via google. If I could live with the choice of engine, I could make this work with no extra programming at all. Thanks, Jim McN

Re: UPDATE triggers with REPLACE statements

Perfect!! This is the answer I was looking for. Thanks! I didn't know about this. Jim McNeely On Dec 18, 2011, at 11:26 AM, Claudio Nanni wrote: > Only if you can change the application you could use INSERTON DUPLICATE > KEY UPDATE instead of REPLACE. > > Check Peter&

UPDATE triggers with REPLACE statements

queue for a system to do something whenever a particular field changes. SO, does anyone have some slick idea how to handle this little dilemma? I have an idea but I have a feeling there is something better out there. Thanks! Jim McNeely -- MySQL General Mailing List For list archives: http

Re: import database

>>> Jessica Bela 10/10/2011 4:47 PM >>> Hi all, how I can import in my PC a database Mysql that has been created in another PC and with other tools? Assuming the source and destination are BOTH mysql databases: mysqldump database > export.sql ...creates a file 'export.sql'. Copy it to th

Re: replication between two tables in same database

Sounds like a job for CREATE TRIGGER to me. :) http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html >>> Tompkins Neil 9/29/2011 12:56 PM >>> Hi I've a Innodb and MyISAM table in the SAME database that I wish to replicate the data between the two because I need to use FULLTEXT searchi

Re: SLOW performance over network

Yeah: # host 72.30.2.43 /* yahoo.com */ 43.2.30.72.in-addr.arpa domain name pointer ir1.fp.vip.sk1.yahoo.com. # host 10.1.20.97 /* my windows box */ 97.20.1.10.in-addr.arpa has no PTR record >>> Todd Lyons 9/29/2011 10:26 AM >>> On Thu, Sep 29, 2011 at 7:12 AM, Jim Moseby

SLOW performance over network

econds' at the bottom). I have many ODBC clients accessing this server as well, they all have slowness problems too. I'm stumped. What could possibly be causing this issue? Thanks for any ideas! Jim CONFIDENTIALITY NOTICE: This message is directed to and is for the use of t

Re: Backup Policy

oking to more convenient ways, as storage and hardware is pretty cheap but time in a critical failure is not cheap. Jim McNeely On Mar 15, 2011, at 1:51 PM, Wm Mussatto wrote: > On Tue, March 15, 2011 12:36, Joerg Bruehe wrote: >> Hi! >> >> >> Adarsh Sharma wrot

Re: MySQL Enterprise support now at Oracle?

Shawn Green works for Oracle and has been very helpful, and I am happy to eat a little bit of shoe leather! Thanks Shawn! Jim On Mar 10, 2011, at 11:11 AM, Jim McNeely wrote: > Wow! We paid for MySQL enterprise plus enterprise support back in the good > old days before ORACLE bought My

MySQL Enterprise support now at Oracle?

HING. Have they dropped all support for MySQL? Is there somewhere else we should go to pay for one on one support for things like my little join query problem? Has anyone else had a good experience with Oracle's MySQL support? Maybe this is a bad dream and I'll wake up soon. Thanks, Jim

Re: Help with slow query

`NameLast` (`NameLast`) This extremely simple join is still massively slow. Jim On Mar 10, 2011, at 10:00 AM, Shawn Green (MySQL) wrote: > On 3/10/2011 12:32, Jim McNeely wrote: >> Rhino, >> >> Thanks for the help and time! Actually, I thought the same thing, but what's &g

Re: Help with slow query

---+-+ But, very good try. I thought this might be it as well. Thanks, Jim McNeely On Mar 10, 2011, at 9:05 AM, Rhino wrote: > > What I'm about to say may be completely out to lunch so don't be afraid to > dismiss it. I'm more a DB2 guy than a MySQL guy and I&

Re: Help with slow query

? On Mar 9, 2011, at 8:34 PM, Shawn Green (MySQL) wrote: > Hi Jim, > > On 3/9/2011 17:57, Jim McNeely wrote: >> I am trying to set up an export query which is executing very slowly, and I >> was hoping I could get some help. Here is the query: >> >> SELEC

Help with slow query

parameters until there was nothing but a join on the patient table, and it was still slow, but when I took that out, the query was extremely fast. What might I be doing wrong? Thanks, Jim McNeely -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: auto_increment by more than 1

This doesn't work, it just sets the starting number, but it will still increment by one unless you set the auto_increment_increment system variable, but this affects all the tables in the DB and not just the particular table. Thanks, Jim McNeely On Feb 23, 2011, at 10:26 AM, Carsten Ped

Re: auto_increment by more than 1

objections to this? The zzk and IdPatient fields have unique validations on them. Thanks, Jim McNeely On Feb 23, 2011, at 12:48 PM, Singer X.J. Wang wrote: > Its theoretically possible, but its a hackish solution.. can you explain why > you want this? > > > > On Wed, Feb

auto_increment by more than 1

Is there a way to set the auto-increment for a particular table to increase by some number more than one, like maybe 10? Thanks in advance, Jim McNeely -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch

Re: Altering database size to add more space

l. This also > explains why it's always 0 for InnoDB tables :-) > > > -- > Bier met grenadyn > Is als mosterd by den wyn > Sy die't drinkt, is eene kwezel > Hy die't drinkt, is ras een ezel > -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Altering database size to add more space

(MB)', > Round( Sum( data_free ) / 1024 / 1024, 3 ) AS 'Free Space (MB)' > FROM information_schema.tables > GROUP BY table_schema ; > > > Thank you. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com > > -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: list rows with no recent updates

27; where prod_id='3069' and > prod_code='a0071'; > Query OK, 1 row affected (0.00 sec) > Rows matched: 1 Changed: 1 Warnings: 0 > > > > > How can I list rows with no recent updates ( or the once where the above > updates were not done) or say wit

Re: Geting current user pasword.

ord is 'cat' you only see '*FD98809C60DD51B6B380DB17B72F9A9E2FE1928F in mysql.user. You could have code that checked a user-supplied password, like: if password(@pwd) = '*FD98809C60DD51B6B380DB17B72F9A9E2FE1928F' but that's it. Jim On Thu, Jun 3, 2010 at 12:12 PM, Guillermo wrote: > > He

Re: Using RAND to get a unique ID that has not been used yet

ll up the table. Jim On Fri, May 28, 2010 at 10:38 AM, Andre Matos wrote: > Hi All, > > I have a table that uses auto_increment to generate the Id automatically > working fine. However, I need to create a new table where the Id must be a > number generated randomly, so I cannot use

Re: Analysis of a weeks worth of general log

CC7F > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com > > -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: How to corrupt a database please???

List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com > > -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: MySQL Slave is almost 1 day behind

ow to > catch the slave back up to the master? The master is not being overloaded, > it is keeping up no problem, and the backup server is 8x the server than > the > application server, so it shoulnd't even be an i/o or cpu issue. > > Please help! :) > > > Thanks in advance > Steven Staples > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com > > -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: MySQL Encryption

Hi Neil. Information (in most cases a string < 100 chars, but that's probably not important) that actually needs to be decrypted, so a hash won't do. Jim On 3/20/2010 5:09 PM, Tompkins Neil wrote: Hi What sort of information are you looking to encrypt ? If it is for user

Re: MySQL Encryption

e security to prevent unauthorised access". Thanks, Jim On 3/19/2010 6:39 AM, John Daisley wrote: Jim, I tend to derive a key based on a separate character string and the contents of the data in the same or a related table. This means each row has a unique encryption key and you never hav

MySQL Encryption

etric encryption capabilities? What are people using in terms of a good solution for encrypting specific columns of table data while providing protection of the key? Thanks, Jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?

Re: Remove - Foreign key constraint in innodb

> Please, Can any one you help me? > > Thank you > > VIKRAM A > > > > The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. > http://in.yahoo.com/ -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Garbage collecting/trimming ibdata1

//www.mit.edu/~y_z/ <http://www.mit.edu/%7Ey_z/> > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com > > -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: max() can't work

d) from > table_name) > >> ? > >> > >> > >> Thanks in advance. > >> > >> -- > >> MySQL General Mailing List > >> For list archives: http://lists.mysql.com/mysql > >> To unsubscribe: > http://lists.mysql.com/mysql?unsub=armand...@gmail.com > >> > >> > >> > > > > > > > > > > The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. > http://in.yahoo.com/ -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: max() can't work

ibe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com > > -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Selecting Dates

gt; ORDER BY order_date; > > or > > SELECT * FROM orders WHERE order_date =>'2010-01-01' AND <= '2010-01-30' > ORDER BY order_date; > > Neither of these work. > > What am I missing? > > -ML > > -- > MySQL General Mailing List > For list

Re: How to purposely corrupt a table

problems, like a corrupt innodb, that weren't marked as crashed, so I now just report any table that gets an error. Jim On Wed, Jan 13, 2010 at 12:07 PM, Matt Carlson wrote: > Hello, > > This is going to be a very odd question. I'm looking for a way to > purposefully corrup

Re: Exporting the result of a Query into excel

ere. On Tue, Jan 5, 2010 at 1:50 PM, Carsten Pedersen wrote: > Is there any particular reason not to use the MySQL ODBC driver to import > the data directly into Excel? > > / Carsten > > Jim Lyons skrev: > > A command to convert the table mytab in database mydb int

Re: Exporting the result of a Query into excel

excel-compatible.html > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql?unsub=ishaq...@yahoo.co.uk > > > > > -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Exporting the result of a Query into excel

do a select on the data you want, redirecting it into an output file. On Tue, Jan 5, 2010 at 7:17 AM, ishaq gbola wrote: > Hi all, > > I would like to know if there is a tool or command in mySQL that allows one > to export the result of query into excel formart > > > &g

Re: Render row without duplicates

ode is not null union select Hospital2Code from tab where Hospital2Code is not null union select Hospital3Code from tab where Hospital3Code is not null order by 1 Jim On Sun, Jan 3, 2010 at 2:50 AM, bharani kumar wrote: > Hi , > > Thanks* > > *SELECT * FROM (SELECT cH

Re: Render row without duplicates

ital3Code from tab where Hospital3Code is not null ) A order by 1 Jim On Sat, Jan 2, 2010 at 6:43 AM, bharani kumar wrote: > Hi > > My fields something like > > hospital1,hospital2,hospital3,patientname, > > > Exact table look like > > PatientName Hospital1C

Re: Aborted_connects is incresing repidly

roblem untili we were able to track down the rogue processes and fix it. Jim On Wed, Dec 30, 2009 at 12:13 AM, Jeetendra Ranjan < jeetendra.ran...@sampatti.com> wrote: > Hi, > > My MySQL server Aborted_connects status is showing 8692 and is rapidly > increasing. > > W

Re: Spatial extensions

Rene: We've easily integrated GIS with MySQL into our sites: http://tenant.com/map-search.php http://yearlyrentals.com http://acnj.com/map.php ... Thanks! Jim Ginn Visit My Work (888) 546-4466 office (609) 226-5709 cell > Awesome, this is what I was trying to find, as you su

Re: Optimization suggestions

derid` (`folderid`), > KEY `threadid` (`threadid`), > KEY `inboxfolderindex` (`folderid`,`toid`,`totype`), > KEY `sentitemsindex` (`fromid`,`fromtype`) > ) ENGINE=MRG_MyISAM DEFAULT CHARSET=latin1 INSERT_METHOD=LAST > UNION=(`messages2009`); > > > > > > > Sudhir NimavatSenior software engineer. > Quick start global PVT LTD. > Baroda - 390007 > Gujarat, India > > Personally I'm always ready to learn, although I do not always like being > taught > > > The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. > http://in.yahoo.com/ -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Are you serious? mySQL 5.0 does NOT have a RENAME DATABASE?

Ken D'Ambrosio wrote: > > > > rename table oldschema.table to newschema.table; > > > > Just to be 100% clear -- I assume you have to first create the > destination > > database, and then do this for all the tables in the source database? > > > > Yep.

Re: error creating table

gspot.com/ > "Peace" is the Ultimate thing we want. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com > > -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Is a view efficient in joins?

garwal, (281)846-8957, http://UnmeteredVPS.net > Host your MySQL driven app on a CentOS VPS for $25/mo > Unmetered bandwidth = no overage charges, 7 day free trial > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:

Re: Rename Database - Why Would This Not Work?

ySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com > > -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Odd select question

Is this or similar syntax in MySQL or is my dotage coming upon me > > > Thanks in advance, > > Bruce > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@

Re: Correct way to start new .MYD & .MYI files

procedure to follow that will > allow me to archive these files and > Then start new ones so I can get my disk space back? > > Thanks in advance. > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com

Re: Anyone using LVM for backing up?

, it takes 10 minutes or so. > > Tim... > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com > > -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Call a routine on mysqld startup

y related options in mysqld --help --verbose. Is there a > way to achieve this, without modifying the startup script ? > > Thanks in advance. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql

Re: MAC address as primary key - BIGINT or CHAR(12)

er. > > I'll be interested in the answer, though, from someone with experience. > > -- Pete Wilson > http://www.pwilson.net/ > > > --- On Thu, 5/14/09, Jim Lyons wrote: > > > From: Jim Lyons > > Subject: Re: MAC address as primary key - BIGINT or CHAR(12) >

Re: MAC address as primary key - BIGINT or CHAR(12)

e: > 1. MAC address defined as BIGINT > 2. MAC address set as primary key > > Should I consider changing it to CHAR(12)? > > Replies will be appreciated. > Ilia > > > > -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Help with mysql query, multiple list

, 2009 at 11:45 AM, Abhishek Pratap wrote: > Hi Jim > > Unfortunately I have thousands of such points. So explicit statement > calling will be very expensive both computationally and in terms of > writing.. > > Thanks, > -Abhi > > > On Fri, May 8, 2009 at 12:37 P

Re: Help with mysql query, multiple list

table_name where start <= ( LIST of time stamps) AND end >=( > list of time stamps). > > Clearly above query accepts only one item in the list. Is there a way to do > this for multiple items in the list ??? I can't think of anything at this > moment. > > > Thanks, > -Abhi > -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: grant user create privilege

x27;; > > If I try logging in as this user though the following happens: > > > > mysql> create database testdb; > ERROR 1044 (42000): Access denied for user 'user'@'localhost' to > database 'testdb' > > Can someone point out the error of

Re: Creation date

rmington Ave. > > Farmington, CT 06032 > > > > 860.674.8796 / FAX: 860.674.8341 > > > > <http://www.the-infoshop.com> www.the-infoshop.com > > > > -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: How to generate unique primary key in MySQL?

t; ... > user_id INT NOT NULL, > current_timestamp TIMESTAMP, > primary key (id) > ); > > I will not use auto_increment > > Is there other way to generate unique primary key in MySQL? > > Thank you > -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: mysqldump syntax - dumping only specific tables starting with a certain character. (e.g. z*)

the mysqldump command. 2009/4/19 Jim Lyons > try something like: > > mysqldump -u(user) -p (db-name) `ls z*` > (filename) > > > 2009/4/19 ChoiSaehoon > > >> Is there a way to dump only specific tables starting with a certain >> character? >> &

Re: mysqldump syntax - dumping only specific tables starting with a certain character. (e.g. z*)

> MSN 메신저의 차세대 버전, Windows Live Messenger! > http://windowslive.msn.co.kr/wlm/messenger/ > -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Cant get TRIM to work?

> Richard > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com > > -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: MySQL replication status plugin

eone has beaten > me to it, but I am so not in the mood to write one! > > > > Any hints, recommendations, and ideas are wholly welcome! > > > > --- > > Kind Regards, > > Mr Gabriel > > > > -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

how can i determine default database within a stored procedure?

cross-schema invocations of sp's and this is the last piece I have to figure out. Thanks, Jim -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: why is this happening?

No, there's only one mysqld process running. Thanks, tho. On Thu, Mar 19, 2009 at 3:56 PM, Claudio Nanni wrote: > I am afraid you have two mysql instances up on the same host. > > ps -ef | grep mysql ? > > > Claudio > > > Jim Lyons wrote: > >> I hav

Re: MySQL versus PostgreSQL for GPS Data

Juan: Still seems excessive but in that case, ignore inserts that have no change in lat / lon ... Jim > Jim Ginn wrote: > >>>Not sure why you you need the trucks location 'every second' ie: >>>31,536,000 rows per year per truck ? >>>doing every 30 seco

why is this happening?

illing up after replication has broken? Thanks -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: how can I make a stored procedure executable by "public"?

great! thanks much. On Wed, Mar 18, 2009 at 1:52 PM, Claudio Nanni wrote: > Ok sorry, I did not understand at first. > > GRANT INSERT on mydb.audit_table to ''@'%'; > > should do the work. > > Cheers > > Claudio > > Jim Lyons wrote: &g

Re: MySQL versus PostgreSQL for GPS Data

ation 'every second' ie: 31,536,000 rows per year per truck ? doing every 30 seconds seems more manageable at 1,051,200 rows per year per truck? Maybe better at 60 seconds? Jim > Juan, > > On Wed, Mar 18, 2009 at 11:14 AM, Juan Pereira > wrote: >> Hello, >>

Re: how can I make a stored procedure executable by "public"?

hin another. On Wed, Mar 18, 2009 at 6:42 AM, Claudio Nanni wrote: > Hello Jim, > > If I unserstand well your needs the steps you need to do are: > > Create one user X with insert privileges on the mydb.audit_table > > Create the stored procedure specifying the user X both in

how can I make a stored procedure executable by "public"?

ege. I guess I could put it in test, but then everyone could do anything with it, which would not be particularly desirable. The table should be "insert only", not readable or updateable by anyone but the owner of "mydb". Is there any way I can do this? Thanks, Jim --

Question about LVM snapshots and innodb tables

resides. We use LVM snapshots to move the data around, since our databases are several terabytes. Does this mean our snapshots are inconsistent? There’s no way we can get all innodb data on a single partition. Thanks, Jim Lyons -- Jim Lyons Web developer / Database administrator http

Re: Finding replicated database

>> -- > >> Baron Schwartz, Director of Consulting, Percona Inc. > >> Our Blog: http://www.mysqlperformanceblog.com/ > >> Our Services: http://www.percona.com/services.html > >> > >> > > > > > > -- > Baron Schwartz, Director of Consulting, Percona Inc. > Our Blog: http://www.mysqlperformanceblog.com/ > Our Services: http://www.percona.com/services.html > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com > > -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: && vs AND

support that syntax? > > > > http://dev.mysql.com/doc/refman/5.0/en/logical-operators.html > > > > > > __ > > This email has been scanned by Netintelligence > > http://www.netintelligence.com/email > -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: catch the error

tabase and > table, I get the same error message. > -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: MySQL log in issues

User='root'; > FLUSH PRIVILEGES; > exit > > When I try to log in now: > # mysql -u root -p > Enter password: > ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using > password: YES) > > Can someone give me a nudge/push/drag me kicking and screaming in the right > direction? > > Thanks everyone :) > > -- > Tim DeBoer > -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: enabling storage engine with RPM install

yes, but how does one add engines to an existing install? Is it possible? I might want/need to add a storage engine that was not in the initial install. On Fri, Feb 20, 2009 at 12:59 AM, Krishna Chandra Prajapati < prajapat...@gmail.com> wrote: > Hi Jim, > > mysql rpm installa

Re: Resend: enabling storage engine with RPM install

a BlackBerry from T-Mobile > > ------ > *From*: Jim Lyons > *Date*: Thu, 19 Feb 2009 23:06:33 -0600 > *To*: > > *Subject*: Re: Resend: enabling storage engine with RPM install > How does one do that in my.cnf? > > It is possible to dis

Re: Resend: enabling storage engine with RPM install

y.cnf. I would love it, if I could, though. On Thu, Feb 19, 2009 at 10:47 PM, wrote: > Perhaps you disabled it via my.cnf > > > Sent via BlackBerry from T-Mobile > > -----Original Message- > From: Jim Lyons > > Date: Thu, 19 Feb 2009 22:45:01 > To: MySQL > S

Re: Resend: enabling storage engine with RPM install

"InnoDB: blah blah", you > have a binary that includes InnoDB, and it's just disabled for some > reason. > > Baron > > On Thu, Feb 19, 2009 at 6:58 PM, Jim Lyons wrote: > > Sorry, but I'm resending because I made a mistake in terminology and want > to > &

Resend: enabling storage engine with RPM install

oes one make the selections in the first place with RPMs? We've always just taken what we got and it was sufficient. Thanks, Jim -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

enabling storage engine with RPM install

age engine once mysql's been installed by an RPM? How does one make the selections in the first place with RPMs? We've always just taken what we got and it was sufficient. Thanks, Jim -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

what is best upgrade plan for large, replicating database?

the time taken should not depend on the size of the database, should it (unless I have to rebuild some indexes)? Thanks, Jim -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

how can trace stored procedure usage?

procedures. Is there a way to do that? Is there a better overall way to track procedure calls? What about function calls? Thanks, Jim -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: How do you backup HUGE tables?

management or LVM" ... I knew there was a way to > use LVM for backups somehow. Maybe a solution for us? > http://www.mysqlperformanceblog.com/?s=backup > > http://www.mysqlperformanceblog.com/2006/08/21/using-lvm-for-mysql-backup-and-replication-setup/ > > Some other backu

  1   2   3   4   5   6   7   8   >