Go Premium for a chance to win a PS4. Enter to Win

x

MySQL Server

46K

Solutions

22K

Contributors

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

Share tech news, updates, or what's on your mind.

Sign up to Post

Dear Experts

We are having SugarCRM enterprise with good hardware very frequently users are getting httpd 500 server error this happens to all users at the same time, once restart the mysql server then works for some time like 30 mins to one hour approx and again the same issue httpd 500 server error just before this occurs very slow experience and then finally ends up with httpd 500 server error,  some times if users reload it works some times I have to restart the mysql service, I am running mysql 5.6.
my.cnf below posted
/etc/opt/rh/rh-mysql56/my.cnf
#
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]

#
# This group is read by the server
#
[mysqld]
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

#
#
#[mysqld]
max_connections=5000
# include all files from the config directory
#
!includedir /etc/opt/rh/rh-mysql56/my.cnf.d
-----------------------------------------------------------------------------------------------end--------------
just added max_connections=5000 as mentioned above but not sure this will resolve can you please suggest best practice performance steps setting up for mysql server , thanks in advance
0
Free Tool: SSL Checker
LVL 11
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

hi,
What is normalization concept


if a table called Student as below with 4 columns and data as below

Student table

StudentName YearOfStudy Subject TeacherName
john                    10thGrade    Maths    Ashley

why it is better to move away Teacher information to separate table as below

Teacher Table

TeacherName TeachingSubject
Ashley                 Maths


what is various types of normalizations?
Please advise
0
Hi EE,

I need help in generating the Unique Number of 4 character length.

Criteria is as follows :
  1. String will always start with alphabet
  2. Another 3 characters will be a combination of alphabets (A-Z) and digits (0-9)
  3. Once the number generated it could not be repeat

Example
A001, A999, ZD01, DA9P, SXS8 etc...

I need to write a logic for the same in my ASP.NET (VB.NET) based web application.

Please provide a direction.

Regards,
D Patel
0
Enroll in this month’s featured course to get 19+ hours of PHP, MySQL, and CakePHP MVC framework training.
1
I'm preparing a user group presentation on database normalization.  I would like to show examples of different challenging 1NF conversions.

Tackling 1NF conversions of unstructured/delimited data is a different animal that I will tackle separately.  What I would like to see from you are different repeated group column names that you've encountered.

Sequential numbering is usually what the students see.  I'd like to show them more challenging examples from your real-world experiences.  Things that come to mind are year and quarter values, week values, month name values, and day name values.  Other challenges might be values that aren't at the end of a column name, capitalization, and no delimiter between the root column name and the serialization values.
0
Hi
i have a hibernate entity class
class task

private tasktemplate

class tasktemplate
private contactinfo

now when i fetch a task.
i do get the tasktemplate object.
but the contactinfo i get as null.

whereas if i fetch the tasktemplate directly then i do get the contactinfo object.
this contactinfo is a custom type which i am storing as json.
what could be the reason for this that when i am fetching it directly i get the proper data and when its inside as a reference a foreign key then i get it as null.
also this is only for custom types
there are other attributes in tasktemplate like normal string etc. they do get fetched.
i am using hibernate here

thanks
0
Thanks for reviewing this.

My server auto updated asp. Net framework and a bunch of other stuff KB4041681.

As. Net 2.0.50727.0 and myself 6.1.3601.17514 throws out errors consistent with client query activity..

Error [HY000] [MySQL] [ODBC 5.1 Driver] [mysqld-5.5.12] Deadlock found when trying to get lock; try restarting transaction

The windows apication error log references the application server and there are no other direct error references, though there are a few windows system errors in the log but it seems best to start with the obvious one.

As a direct or indirect result a legacy app using asp.net but coded over 5 years ago is running up errors in cost report totals other functions seem normal.

The timing of the error is consistence with the windows update.

Any advice or pointers greatly appreciated.. Specifically I'm wondering if it's possible to simply roll back that update, though there had been 3 minor ones since it doesn't necessary guarantee the libraries and other files will be restored to the same state prior to the error, so not sure if other problems might occur unless the specific files updated causing the error can be identified.

Once again thanks for reading..
0
I was wondering if it was possible to sort one particular key in a mutli-dimensional array without disrupting the order of the other keys? I'm going to to be doing a complex "ORDER BY" when selecting my table with the mysql query, however there's a limitation on how much I can do, and want to try to do the rest with the resulting array in PHP without destroying the sort already present. To elaborate, I'm unable to implement a "natural sort" on varchar fields with an "ORDER BY" -  I've scoured the net and tried multiple ideas, but nothing I've tried to apply a natural-sort-equivalent has worked, so I thought that could be the job of PHP.  A snippet of my resulting array from my table looks like this (the real one is quite a bit larger with a lot more keys):

    [1422] => Array
        (
            [pagename] => item000617
            [category] => Promotional Music
            [subcategory] => Compilations
            [subsubcat] => 
            [title] => Warner Music Taiwan - January 1992 
            [country_full] => Taiwan
            [newyear] => 1992
            [format] => CD
        )

    [1423] => Array
        (
            [pagename] => item000898
            [category] => Promotional Music
            [subcategory] => Compilations
            [subsubcat] => 
            [title] => Warner Music Taiwan - September 1999
            [country_full] => Taiwan
            [newyear] => 1999
            [format] => CD
        )

    [1424] => Array
        (
   

Open in new window

0
hi,

in mysql table shows table colums as MySql SQL keys what is MUL vs PRI vs UNI

what is difference between each. what is MUL is it same as foreign key? is it same across all databases?
please advise
0
Hello experts, I have a few DBA questions that I need checking out, and I don't have access to a sample Oracle and SQL/Server Database.

Question 1: Assuming table t1 has the following columns:

userid (primary key), name, phone_num_home, phone_num_work, phone_num_cell, phone_num_pager

Redesign t1, create a table t2 to join to table t1, and normalize the database by eliminating the “repeating group” of phone number columns in t1.

Ans.
  • The goal is to  "Create table t2 and copy the contents of table t1 into table t2 and join table t1 using userid (primary key),       ".
  • This achieved with the use of a SQL "Create table t2 (select * from t1);"
  • Then you will need to maintain referential integrigty by using a SQL "Alter table t2 adding a (t2.userid) Foreign Key from table t2 restraint that references (t1.userid) Primary Key field from table t1.
  • You should will make a backup copy of table t1. Then finally you should do a SQL "Alter table t1 drop (  phone_num_home, phone_num_work, phone_num_cell, phone_num_pager)

Please let me know if steps are correct or if I missed something.
     
Question 2: Assuming a character column named [title] in table t1 with the following values:

The Day Of The Jackal
Sleepless In Seattle
Point Blank
Gone With The Wind

What is the result set of the following SQL statement?

SELECT LOWER(SUBSTR(title,1,7)) FROM t1

Ans.
0
New feature and membership benefit!
LVL 11
New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

hi,

does MySQL has any table Partitioning thing?
0
I'm been working with an windows service to fetch emails (imap) and save them in mysql but every time I save all of them so any one know how get just the doest exist in my database??


any example or how can do this maybe in other way?


Im working with VB.net
0
As a C# developer, I am used to NHibernate and Entity Framework. What can a Node developer use to bring ORM functionality to Node?

In the past, with Node, I have only used SQL command embedded into the code, then executed. I'm am sure, even then, this was a worst practice.

What is the best practice way, using Node.js, to make use of an ORM?

(I am not sure if I am ready for a JSON database like MongoDB unless it helps you answer this question)

Thanks
0
I have a website that runs xenforo forum software. I basically have a donations user group and those users have the ability to download some software. I want to add a login form to my application that checks if that user is in that group and if he / she is then it will open the main form. I want to know how I can make such a login form?
0
hi,

any one use any tools for MySQL or use MySQL built in tools for brute force protection ?
0
I'm wondering if it is possible to populate a junction table with a SQL query from two already populate tables. For Example;

Products

id | name | price
--------------------------
1  |   Foo    |   0
2  |   Bar    |   0
3  |   Tmp  |   0

Packages

id | name
------------------------
1  | Bundle

The above two tables are already populated. Is there a SQL query that would enable me to populate the table below as shown.

Package Products

id | package_id | product_id
-------------------------------------------
1     1                     1
2     1                     2
3     1                     3

Thanks in advance.
0
Source file is "ANSI" in a srcfiles folder, need to get this converted to "UTF8" through Windows batch script. Experts Please help.
I cant use any tool for it. Please help
0
I've read a few tutorials online for sending a blank image in an html email in order to log when the email is opened, but none of them seem to work in my system.  I don't need anymore information than the date/time an email was opened to log in my MySQL database.  Any help would be appreciated!
0
Dear Experts,
I use PHP 7 and mysql database.
I searched on the web how to export data to excel , I found many old codes with mysql_connect...
I need to use mysqli not mysql

Do you recomend me some working code?
0
Hire Technology Freelancers with Gigs
LVL 11
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Hello Experts,
I have the following code:

<?php

for($counter = 1; $counter <= 50; $counter++)

	
			print "AJ00" . "$counter" . "<br>";
		
	
?>

Open in new window


This code will print AJ001. AJ002, AJ003 until AJ0050,

How can I create a folder for each reference, a folder named : AJ001, another folder named AJ002 until I reach the last folder AJ0050...

Thank you
0
I have an existing MSSQL blob field that I would like to "export" to a MySQL database.  I have a script that will display the existing blob field, but I am guessing that I need to "save" the image and then "import" them into the MySQL database.

I tried to use the display script to just insert, but I get a "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2".
If I remove the blob fields from the insert(`STI_Image`&`STI_Large_Image`), it inserts the rest of the information into the table.

Any help would be appreciated.
InsertBlob.php
DisplayImages.php
0
HI All, trying to figure out how to use data from two tables in Domo.

This is what I'm trying and it is not working.

SELECT id, jobsite, status FROM application UNION SELECT client, id, nickname FROM jobsites

Open in new window


It's only showing the first part, however I do not get any errors.

Any help is greatly appreciated.
0
I have a query that pulls meta data currently like:

SELECT order_id, meta_key, meta_value
FROM wp_woocommerce_order_items i
INNER JOIN wp_woocommerce_order_itemmeta im ON i.order_item_id = im.order_item_id
where meta_key like '%Name - %'
or meta_key like '%Job Title - %'
or meta_key like '%Company - %'
or meta_key like '%Email - %'

Open in new window


The output is:
2668 Name - 1 Nathan Riley
2668 Email - 1 nathan@domain.com
2800 Name - 1 John Smith
2800 Email - 1 john@domain2.com
2800 Name - 2 Jane Doe
2800 Email - 2 jane@domain2.com

How can I modify so the output would be:
2668 Nathan Riley nathan@domain.com
2800 John Smith john@domain2.com
2800 Jane Doe jane@domain2.com

Thanks!
0
can't connect to mysql database on godaddy server may be mistake in syntax or understanding environment please help ,and you should know that localhost on pc work good with (appserv 8.6.0) nearby
0
I have a MYSQL database hosted on website
I want to create a standalone program to run on windows PC that will use the MYSQL database to display appropriate data
The standalone program must be able to run external programs that are on PC that the database refers to
Any suggestions on the approach, language etc would be welcome.
0

MySQL Server

46K

Solutions

22K

Contributors

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.