• How can I see all the open connections in a MySQL database?

    I just administrative permissions on our MySQL database so I need to figure out how I can see all the open connections in that specific database. Can anyone point me the right way here?

    ITKE351,965 pointsBadges:
  • Does the physical size of our MySQL database affect its performance?

    We have a large database that has over 15 million records and takes up about 2 GB. We're worried now that it's going to affect the performance of our MySQL database. Should the physical size of our database matter to the performance? Should we just go in and clear some of the data out? Thank you!

    ITKE351,965 pointsBadges:
  • What’s the best way to store latitude / longitude pairs in a MySQL database?

    I currently have a MySQL database and I'll be doing a bunch of calculations on latitude / longitude pairs. What's the best way to store these in my database? Thanks so much.

    ITKE351,965 pointsBadges:
  • How many rows are too much in a MySQL database?

    We have a MySQL InnoDB that has over a million records. Is that too much to hold? Can my database handle that many records? We're curious because some of our queries are slower with a table that has 1,000,000 rows than one with 100 rows.

    ITKE351,965 pointsBadges:
  • What’s the best MySQL database field type for an URL?

    I've been trying to store an URL in a MySQL database but I'm running into an issue the field. What's the best way to define a field that will hold the URL for an undetermined amount of time. Thanks so much.

    ITKE351,965 pointsBadges:
  • Creating a new database with MySQL WorkBench

    I'm fairly new to the MySQL universe but I've recently installed MySQL Workbench and now I would like to create a database using it. How can this be done? I've noticed several "MySQL Schemas" being displayed in the Overview tab. Are those the existing datatbases? Thanks so much.

    ITKE351,965 pointsBadges:
  • MySQL database: Maximum number of records in a table

    For MySQL database, I was wondering what would be the maximum number of records I could add to a table. I was thinking of adding millions of of records to the table but I was wondering if there's a limit. What's the best way to handle this? Thank you.

    ITKE351,965 pointsBadges:
  • How to find all occurrences of a URL in a MySQL database

    A friend of mine has been having trouble dealing with his MySQL database. He's been trying to locate all occurrences of a URL in the database but he doesn't know where to start. He wants to search all of the tables / fields. Appreciate the help.

    ITKE351,965 pointsBadges:
  • How to duplicate MySQL database

    Would it be possible for me to duplicate my entire MySQL database on a Linux server? I already know I can export / import but the database has over 25 MB so it's not the best solution. Can I use "MySQLdump" or just directly duplicate the database files?

    ITKE351,965 pointsBadges:
  • Security issues for MySQL in a cloud environment?

    Hi everyone! In general, I've been asked by my manager to find out about running a MySQL DB on a cloud -- has anyone done this, and what do you think are the security issues that can come up when doing so? More specifically, IT has questioned me about how auditing would work on a cloud, and what...

    MillyT5 pointsBadges:
  • Available space in a MYSQL database

    I need to find how much space I have available in a MYSQL database. I think the best way to do so is via SHOW TABLE STATUS LIKE 'table_name' When I do that, I get the following: Name | Rows | Avg. Row Length | Data_Length | Index Length ---------- ---- --------------- ----------- ------------...

    ITKE351,965 pointsBadges:
  • How can I store large hashes in MySQL?

    I'm trying to store a bunch of 512-bit SHA-2 hashes into a MySQL table. In an effort to save space, I'm looking to store them in binary form, instead of a string of hex digits. I'm also using ORM so this will inflate them to any object / structure I choose. I know I could split them up using eight...

    ITKE351,965 pointsBadges:
  • MySQL: What’s the downside of storing images in the database?

    I'm looking at using MySQL for my database so I need some opinions on the disadvantages of storing images inside of it. Is it not as efficient as storing images on a server? Does it take longer for the images to download vs. disk storage? Thanks for all the input!

    ITKE351,965 pointsBadges:
  • What factors are there for MySQL database size estimation?

    We have an application database (which includes a table for users). Here's the setup: 1Kbyte of data per user that's based on counting fields * typelength and about 100 things of the same size that belongs to a user (about 0.5 Kbyte). This leads to around 51 Kbytes of data per user. Now, we're...

    ITKE351,965 pointsBadges:
  • SQL TAGS

    Why am failling when am using mysql to create database and am using the exactly tags?

    Abcdefg071541520 pointsBadges:
  • Pass table name to procedure including fields

    I want to do the following with a procedure: I have per user that has the same structure. The only difference is the table name. I need to be able to pass the table name to a procedure and retrieve data for that table. At the moment I have this: sp_getdata(id, givendate datetime,tablename...

    Sonyadba5 pointsBadges:
  • MYSQL database high availability

    I have cent os based LAMP system. My question is that, what is the best way to make mysql database high availability. As per me database clustering is a good option can you please suggest me.

    Chetanm145 pointsBadges:
  • Creating Views in MYSQL via Sysdate

    Hello Guys, I can create simple views for MYSQL Database tables but I am unsure on how to create a view for the following requirement: I want to create a view which restricts staff user access to a specific table between working hours of 13:00 - 14:00. I have been told that this can be implemented...

    Help1235 pointsBadges:
  • MYSQL DATABASE!!!

    Hello everyone! please help me about transfering MYSQL DATABASE from one computer to another..... I am a student and got to show a project on JDBC. I am using Windows 7 os and Mysql server 5.1.. Thank you.

    Shagy5 pointsBadges:
  • Letting users upload pictures MYSQL Database

    What is the easiest way in DW to allow users to upload a picture to my website. I don't know much coding so ...how can it be done using the functionality of DW. I am using a MYSQL database.

    PBen5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following